please show the steps in excel along with the formulas, thank you!

The Thrify Conspoter Company is trying so decide which of several lot-wring provetures Ao use for its MRP system. The following information pertuins to one of the typical componat parts: Setup cont =$100 ionter Inventory cost =$1,50 unit weck Curreat inventory balance =0 inits. Apply the EOQ. (only integer inultiples of the EOQ can be ordered). POQ, and PPB lot-sizing procedures and show the total eost resulting from each peocedure. Calculate imcotory carrying: cont based on the average inventory on hand at the end of each period. Assume orders are received ialg the beginning imventory The Thrify Conspoter Company is trying so decide which of several lot-wring provetures Ao use for its MRP system. The following information pertuins to one of the typical componat parts: Setup cont =$100 ionter Inventory cost =$1,50 unit weck Curreat inventory balance =0 inits. Apply the EOQ. (only integer inultiples of the EOQ can be ordered). POQ, and PPB lot-sizing procedures and show the total eost resulting from each peocedure. Calculate imcotory carrying: cont based on the average inventory on hand at the end of each period. Assume orders are received ialg the beginning imventory