I need help with the excel formulas for the cells highlighted in pink

DATA INPUT Beginning inventory 600, 132 units Ending inventory = O units # Orders per year = 2.47 orders Carrying cost / unit $0.3195 per year Fixed order cost = $5,200 per order Average Inventory cost per unit = $95.28 per unit NOTE: Cells shaded in YELLOW are the cells you must provide the calculations or analysis. Avg. Inventory Total required in 1year (a) What is the total carrying cost? (Aund's the nearest weblalag. $95,871 300066 (b) What is the restocking cost? Aud'do the nearestohle dolar. leg. 1.234 $12,844 (c) What is the total cost of their inventory policy? Axund'do the nearest whole dakarley. 2.23411 (d) Calculate the 2021 economic order quantity. Aundur answer the neareste number of usleg. 123407 0 (e) Calculate the number of orders per year that would be required if the EOQ Inventory Policy vere implemented in 2021. Rund wu answer 102ecimal places. leg. 32 1511 (f) What would the E00 Inventory Balance in colars:/ be in 2021 if the firm switched to the EOQ Inventory Policy? (Do not include the car sin// Fund's the nearest wiele leg. 1.234) This value rill automatically be transferred as your "E0Q Inventory" value on your PRO FORHA CORRECTIONS rorksheet. EOQ Inventory Balance = EOQ units per order x Average inventory value per unit