2. Change all of the numbers in the data area of your worksheet so that it looks like this: B B 1 Chapter 6: Applying Excel 2 4 375 149 $ $ 57 $ 37 10 3 Data Selling price per unit 5 Manufacturing costs: 6 Variable per unit produced: 7 Direct materials 8 Direct labor 9 Variable manufacturing overhead Fixed manufacturing overhead per year 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year 14 15 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year $ 116,000 s 8 $ 59,000 Year 2 Year 1 0 2,900 2,400 2,000 2,400 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the net operating income (loss) in Year 1 under absorption costing? Answer is complete and correct. Net operating income $ 142,600 (b) What is the net operating income (loss) in Year 2 under absorption costing? Answer is complete but not entirely correct. Net operating income $ 99,400