description: tuv columns are the proposed numbers qoh to the right are current numbers 0 is dead stock analyze and recalculate the 4 items. create a chart to reflect this data analyze the data and write 1 page proposal regarding the return on investment with the proposed inventory and data compared to the current qoh. the data is under the optimization worksheet. some pointers from the guy who made the spreadsheet and had some sort of expectation when i got assigned this part… its definitely open to interpretation if you have some other ideas but what i was generally thinking generally was: 1. compare what we’re pro posing as far as 1. eoq, 2. safety stock, 3. rop, 4. total cost to those same measures that is happening at lac now – all using those calcs we did several weeks back for an assignment (i think it was the midterm). maybe just compare t/c for proposal to t/c of current lac holdings 2. see what the $$ amount effect is on working capital – like the cost outlay of current inventory in stock versus how much inventory we’re proposing to stock. basically the questions: if you owned a distributor and someone proposed these changes to you, what would you ask that person. 3. for roi – i think that calc would be gross margin/(total cost + cogs), it would be nice if we could come up with one final number to say ”this is your return on investment” this is flexible. not set in stone. the proposed info can be adjusted and interpreted however your comfortable. the writing just needs to be thorough.

description: tuv columns are the proposed numbers qoh to the right are current numbers 0 is dead stock analyze and recalculate the 4 items. create a chart to reflect this data analyze the data and write 1 page proposal regarding the return on investment with the proposed inventory and data compared to the current qoh. the data is under the optimization worksheet. some pointers from the guy who made the spreadsheet and had some sort of expectation when i got assigned this part… its definitely open to interpretation if you have some other ideas but what i was generally thinking generally was: 1. compare what we’re pro posing as far as 1. eoq, 2. safety stock, 3. rop, 4. total cost to those same measures that is happening at lac now – all using those calcs we did several weeks back for an assignment (i think it was the midterm). maybe just compare t/c for proposal to t/c of current lac holdings 2. see what the $$ amount effect is on working capital – like the cost outlay of current inventory in stock versus how much inventory we’re proposing to stock. basically the questions: if you owned a distributor and someone proposed these changes to you, what would you ask that person. 3. for roi – i think that calc would be gross margin/(total cost + cogs), it would be nice if we could come up with one final number to say ”this is your return on investment” this is flexible. not set in stone. the proposed info can be adjusted and interpreted however your comfortable. the writing just needs to be thorough.