(Appendix 6B) Inventory Costing Methods: Periodic Average Cost 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 190 units @ $14 = $2,660 9 Purchase 1 210 units @ $18 = $3,780 14 Sale 1 300 units @ $25 22 Purchase 2 200 units @ $19 = $3,800 29 Sale 2 205 units @ $25 Refer to the information for Filimonov Inc. and assume that the company uses a periodic 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 X Open spreadsheet Required: Calculate the cost of goods sold and the cost of ending inventory using the average cost method. (Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.) Cost of goods sold Cost of ending inventory $ $