Chapter 6 Applying Excel (A) Help Save Saved Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Ret 2 The Chapter 6 Form worksheet is to be used to create your own worksheet version ot the Review Problem in the text. 2. Change all of the numbers in the data area of your worksheet so that it looks like this: Part 2 of 2 A B C 10 Chapter 6: Applying Excel 1 points Data Selling price per unit S 377 Manufacturing costs: Variable per unit produced: Direct materials 144 Direct labor 62 Variable manufacturing overhead 37 $ 160,000 10 Fixed manufacturing overhead per year 11 Selling and administrative expenses: Variable per unit sold 12 4 13 Fixed per year 83.000 14 Year 1 Year 2 15 16 Units in beginning inventory 0 Units produced during the year 17 3,200 2.500 18 Units sold during the year 2,800 2,800 10 If your formulas are correct, you should get the correct answers to the following questions. points (a) What is the net operating income (loss) in Year 1 under absorption costing? Answer is complete and correct. Net operating income $ 141,000 (b) What is the net operating income (loss) in Year 2 under absorption costing? X Answer is complete but not entirely correct. $ 101,800X Net operating income (b) What is the net operating income (loss) in Year 2 under absorption costing? X Answer is complete but not entirely correct. Net operating income $ 107,400X