BE8.4 - Using Excel to Determine Inventory Costs PROBLEM Amsterdam Company uses a periodic inventory system. For April, the following information is available. Student Work Area 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. April 1 inventory April 15 purchase April 23 purchase Units 250 400 350 1,000 Unit Cost $ 10 12 13 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. Weighted average cost per unit Units sold during April 600 Ending inventory at April 30 Cost of goods sold