please show steps on what specifically needs to be done for this

4 B G H N 1 Function: ROUND: Formula: Add, Multiply. Divide: Cell Referencing 3 Using Excel to Cost Inventory Student Work Area PROBLEM Required. Provide input into cells shaded in yellow in this 5 In its first month of operations, McLanie Company made three template Use only mathematical formulas with cell references to 6 purchases. Information concerning these purchases and units on compute the unit cost and the cost of ending inventory 7 hand are B 9 Units Cost per Unit Compute the cost of the ending inventory under the average cost 10 300 $ 6.00 method in a periodic inventory system 11 400 8.00 12 500 9.00 Weighted-average unit cost 13 14 Units on hand at period end 200 Round unit cost to 3 decimals using the 15 ROUND function 16 Purchases of merchandise were made in the sequence listed above 17 Cost of ending inventory 18