nventory valuation under absorption costing and variable costing At the end of the first year of operations, 19,200 units remained in the finished goods inventory. The unit manufacturing costs during the year were This information has been collected in the Microsoft Excel Online fle. Open the spreadsheet, perform the required analysis, and input your answers it Open spreadsheet Determine the cost of the finished goods inventory reported on the balance sheet under (a) the absorption costing concept and (b) the variable costing a. Cost of the finished goods inventory under the absorption costing: b. Cost of the finished goods invertory under the variable costing: Inventory valuation under absorption costing and variable costing At the end of the first year of operations, the number of units and the unit manufacturing costs were as follows: Using formulas and cell references, perform the required analysis, and input your answers into the Cost of Finishec numeric results for the green entry cells (C15:C16) into the appropriate fields in CNOWV2 for grading