*Please compute the weighted average cost per unit, ending inventory at April 30, and cost of goods sold*

*Please show formulas*

Student Work Area BE8.4 - Using Excel to Determine Inventory Costs PROBLEM Amsterdam Company uses a periodic inventory system. For April, the following information is available. Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or to the work area if applicable. Units 250 April 1 inventory April 15 purchase April 23 purchase Unit Cost $ 10 12 Total Cost $ 2,500 4,800 4,550 $ 11,850 Compute the April 30 inventory and the April cost of goods sold using the average-cost method. 400 350 13 1,000 Weighted average cost per unit Units sold during April 600 Ending inventory at April 30 Cost of goods sold