File Home Insert Draw Formulas Data: Review View Help Editing Calibn BA Number E22 Jx A C D G H I K L M N 0 1 3 2 Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual Inventory system. For specific identification, ending inventory consists of 180 units from the January 30 purchase, 5 units from the Specific identification Data 4 January 20 purchase, and 15 units from beginning inventory. 180 5 15 5 6 Date 7 1-Jan B 10-Jan Activities Beginning inventory Sales Units Acquired at Cost Units sold at Retail 140 units $6.00 $840 100 units @ $15 9 20-Jan Purchase 60 units @ $5.00 . 300 10 25-Jan Sales 80 units . $15 31 30-Jan 12 Purchase Totals 180 units $4.50 810 380 units $1,950 180 units 13 14 Required: 151 Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. 16 17 (Use cells A2 to 112 from the given information to complete this question.) 18 19 Specific Identification 20 Available for Sale Cost of Goods Sold Ending inventory Ending Ending B Graded Worksheet Wanbok +