can you please show the excel formulas. Thank you

1 Paragraph 4 2. The Thrifty Computer Company is trying to decide which of several lot-sizing procedures to use for its MRP system. The following information pertains to one of the typical component parts: (Chapter 9 Advanced MRP) Setup cost = $120/order. Inventory holding cost = $1.25/unit/week. Current inventory balance - 10 units. Week 1 2 3 5 6 7 8 Demand Forecast 65 2x 35 11025 85 X Apply the a) EOQ (only integer multiples of the EOQ can be ordered) procedure b) POQ procedure c) PPB lot-sizing procedure d) Show the total cost resulting from each procedure. Calculate inventory carrying cost based on the average inventory on hand at the end of each period. Assume orders are received into the beginning inventory. (40 points) X=35 I 1 Paragraph 4 2. The Thrifty Computer Company is trying to decide which of several lot-sizing procedures to use for its MRP system. The following information pertains to one of the typical component parts: (Chapter 9 Advanced MRP) Setup cost = $120/order. Inventory holding cost = $1.25/unit/week. Current inventory balance - 10 units. Week 1 2 3 5 6 7 8 Demand Forecast 65 2x 35 11025 85 X Apply the a) EOQ (only integer multiples of the EOQ can be ordered) procedure b) POQ procedure c) PPB lot-sizing procedure d) Show the total cost resulting from each procedure. Calculate inventory carrying cost based on the average inventory on hand at the end of each period. Assume orders are received into the beginning inventory. (40 points) X=35