Applying Integrated Excel: Perpetual: Inventory costing methods FIFO and LIFO Your Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. Date Activities Units Acquired at Cost Units sold at Retail January 1 Beginning inventory 150 units @ $ 7.50 = $ 1,125 January 9 Sales 110 units @ $ 16.50 January 19 Purchase 80 units @ $ 6.50 = 520 January 25 Sales 90 units @ $ 16.50 January 30 Purchase 200 units @ $ 6.00 = 1,200 Totals 430 units $ 2,845 200 units Required: Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Navigation: Use the Open Excel in New Tab button to launch this question. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.