$($Chapter $3$: The Logistics$/$Supply Chain Product$)$ Davis Steel Distributors is planning to set up an additional

warehouse in its distribution network. Analysis of item$-$sales data for its other warehouses shows that $30$ percent of the items

represent $75$ percent of the sales volume. The company also has an inventory policy that varies with the items in the warehouse.

That is$,$ the first $20$ percent of the items are the A items and are to be stocked with an inventory turnover ratio of $10.$ The next $30$

percent of the items, or B items, are to have a turnover ratio of $8.$ The remaining C items are to have a turnover ratio of $6.$ There

are to be $20$ products held in the warehouse with sales on the warehouse forecasted to be $$3$ million annually. What dollar value

of average inventory would you estimate for the warehouse? $($Hint: This problem is similar to the class example of $80-20$ curve$.$

It is most convenient for you to work on this in Excel. Your final completed work should look like the excel on Module$2$Ch$03$Slide

$3-8.$ You can simply turn in your excel file.$)$