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 370 units from the January 30 purchase, 5 units from the January 20 purchase, and 15 units from beginning inventory. Units sold at Retail Units Acquired at Cost 220 units @ $ 14.50 = $ 3,190 170 units @ $ 23.50 Date January 1 January 10 January 20 January 25 January 30 Activities Beginning inventory Sales Purchase Sales Purchase Totals 170 units @ $ 13.50 = 2,295 200 units $ 23.50 @ $ 13.00 = 370 units 760 units 4,810 $ 10, 295 370 units Required: 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. 4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Complete this question by entering your answers in the tabs below. Specific Id Weighted Average FIFO LIFO Complete this question by entering your answers in the tabs below. Specific Id Weighted Average FIFO LIFO Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. Specific Identification Cost of Goods Sold Available for Sale Ending Inventory Purchase Date Activity # of units Cost Per Unit # of units sold Cost Per Unit COGS Ending Inventory- Units Cost Per Unit Ending Inventory- Cost 220 January 1 January 20 January 30 Beginning inventory Purchase 170 Purchase 370 760 0 $ 0 0 $ 0 Specific Id Weighted Average FIFO LIFO LIFO Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. (Round cost per unit to 2 decimal places.) Weighted Average - Perpetual: Cost of Goods Sold Goods Purchased Inventory Balance Date # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance January 1 220 at $ 14.50 = $ 3,190.00 January 10 January 20 Average cost January 20 January 25 January 30 Totals Perpetual FIFO: Cost of Goods Sold # of units Cost per Cost of Goods sold unit Sold Inventory Balance Goods Purchased Cost per # of units unit Date Cost per # of units unit Inventory Balance January 1 220 at $ 14.50 = $ 3,190.00 January 10 January 20 Total January 20 January 25 Total January 25 January 30 Totals Goods Purchased Perpetual LIFO: Cost of Goods Sold # of units Cost per Cost of Goods sold unit Sold Date Cost per Inventory Balance Cost per unit Inventory Balance # of units unit # of units January 1 220 at $14.50 = $ 3,190.00 January 10 January 20 Total January 20 January 25 Total January 25 January 30 Totals