Filimenav Ine has the following information related to purchases and sales of one of its irventory itema: Refer to the information for Filimonov Inc, and assume that the company uses a perpefuat inventory system. This information has been collected in the Microsof Excel Online file. Open the spreadsheet, perform the required analysis, and input your ansuers in the qutsage beico. Open spreadsheet Required: Calculate the cost of goods sold and the cost of ending irventory using the LFo inventory costing method