1 Name: 2 Your score: 16% 3 4 5 6 7 8 9 10 11 12 13 14 15 16 56789 17 18 19 Keara McGinn The Keara Mcginn Company reported the following January purchases and sales data for its only product. The company uses a perpetual inventory system. REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. Date Jan. 1 Beginning inventory Jan. 11 Sales Jan. 15 Purchase Jan. 17 Sales Jan. 21 Purchase Jan. 23 Sales Totals Instructions Ready Accessibility: Investigate Units Cost per purchased unit Cost of Goods Sold - Perpetual LIFO: FIFO LIFO Typo horo to search 400 600 650 1,650 $10 F! 12 14 Units Sold + Total Cost Units Sold of Purchase $4,000 7,200 W 9,100 $20,300 320 480 590 1,390 H Cost per Selling Total Sales Price per unit $30 $30 $30 $9,600 14,400 17,700 $41,700 Cost of CN