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. 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. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. 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. 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. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect