ESTABLISHING THE CURRENT INVENTORY PLAN (25 points) Question No. 1.- What average inventory for each part number in pieces and dollars should the company have with current ordering practices (lot-size inventory) and planned buffer stock levels? How much total average planned inventory should the company have on these three, part numbers? Fill in missing figures in table to calculate. Unit Price Order Qty (Weekly Requirements) in Pieces Average Inventory in Pieces Average Inventory in Dollars Current Planned Safety Stock in Pieces Current Planned Safety Stock in Dollars Average Planned Inventory in Pieces Average Planned Inventory in Dollars PART NO. 1A1 $500 17500 02500/2)7591 PART NO. CCC PART NO. 282 $25 $1800 120,000 5000 60,000 2.500 1,500,000 4,500,000 1000 pcs 50,000 pcs (1000S 500S 00 1,500,000 120,000 pcs 3,000K 18,750x5500) 5,375,000 154.395K-550015487 1,000 pcs 1,800,000 3.500 pes 6.300K Tips Total Avg. Planned Inventory (Pes) 133,250 pcs Total Avg. Planned Inventory (S) 14,175K TAC RoGrande Valley For this study case consider the Age ecocesocoolest Average Planned anventory age Total Average Planned Invereory in dates +351 20