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 Specific Identification Data the January 20 purchase, and 15 units from beginning inventory. 180 5 15 5 5 Date Activities Units Acquired at Cost Units sold at Retail 2 1-Jan Beginning inventory 140 units $6.00 3 $840 8 10-Jan Sales 100 units @ $15 9 20-Jan Purchase 60 units e $5.00 " 300 25-Jan Sales 80 units $15 11 30-Jan 12 Purchase Totals 180 units 380 units e $4.50 .. 810 $1,950 180 units 13 14 Required: 15 1. 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 of Cost Per # of units Cost Per 21 Purchase Date Activity units Unit sold Unit COGS Ending Inventory Units Ending Cost Per Inventory Unit Cost 22 1-Jan Beginning inventory 140 $6.00 100 $6.00 $100 40 $6.00 $240 23 20-Jan Purchase 60 $5.00 $5.00 $5.00 24 30-Jan Purchase 180 $4.50 $4.50 $4.50 25 380 26