Inventory Costing: LIFO Filimonov Inc. has the following information related to purchases and sales of one of its inventory items: Date Description Units Purchased at Cost Units Sold at Retail June 1 Beginning inventory 180 units @ $13 = $2,340 9 Purchase 1 200 units @ $17 = $3,400 14 Sale 1 290 units @ $25 22 Purchase 2 300 units @ $19 = $5,700 29 Sale 2 285 units @ $25 Refer to the information for Filimonov Inc. and assume that the company uses a perpetual inventory system. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Required: Calculate the cost of goods sold and the cost of

Inventory Costing: LIFO Filimonov Inc. has the following information related to purchases and sales of one of its inventory items: Refer to the information for Filimonov Inc. and assume that the company uses a perpetual inventory system. Open spreadsheet Required: Calculate the cost of goods sold and the cost of ending inventory using the LIFO inventory costing method. Refer to the information for Filimonov Inc. and assume that the company uses a perpetual inventory system. REQUIRED: Calculate the cost of goods sold and the cost of ending inventory using the LIFO inventory costing method. Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv2 for grading