Formula: Multiply, Divide, Subtract; Cell Referencing - 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. Unit Cost $ 10 April 1 inventory April 15 purchase April 23 purchase Units 250 400 350 Compute the April 30 inventory and the April cost of goods sold using the average-cost method. 12 Total Cost $ 2,500 4,800 4,550 $ 11,850 13 1,000 Weighted average cost per unit Units sold during April 600 Ending inventory at April 30 Cost of goods sold