The Company reported the following January purchases and sales data for its only product. The company uses a perpetual inventory system. st 4 5 6 7 8 REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. 3 Units purchased Cost per Total Cost Units Sold Selling Total unit of Price per Sales Purchase unit 9 Date 10 Jan. 1 Beginning inventory 560 $14 $7,840 11 Jan. 11 Sales 450 $40 $18,000 12 Jan. 15 Purchase 840 17 14,280 13 Jan. 17 Sales 670 $40 26.800 14 Jan. 21 Purchase 890 19 16.910 15 Jan. 23 Sales 800 $40 32,000 16 Totals 2,290 $39,030 1,920 $76,800 17 18 19 Cost of Goods Sold - Perpetual FIFO: Calculate cost of goods sold for the 21 January 11 sale of 450 units. 20 20 23 24 25 27 28 29 Units Sold @ Cost per unit || Cost of Goods Sold