2. Change all of the numbers in the data area of your worksheet so that it looks like this: A 1 Chapter 6: Applying Excel 2 3 Data 4 Selling price per unit 5 Manufacturing costs: 6 Variable per unit produced: Direct materials B C S 327 8 769 932 10 Direct labor Variable manufacturing overhead Fixed manufacturing overhead per year Selling and administrative expenses: Variable per unit sold $ 101 $ 72 S 20 $ 144,000 + 11 $ 6 12 Fixed per year $ 73,000 13 14 Year 1 Year 2 15 Units in beginning inventory 0 16 Units produced during the year 3,000 2,400 17 Units sold during the year 2,600 2,600 18 (b) What is the net operating income (loss) in Year 2 under absorption costing? Answer is complete but not entirely correct. Net operating income $ 103,800 3. Make a note of the absorption costing net operating Income (loss) in Year 2. At the end of Year 1, the company's board of directors set a target for Year 2 of net operating income of $180,000 under absorption costing. If this target is met, a hefty bonus would be paid to the CEO of the company Keeping everything else the same from part (2) above, change the units produced in Year 2 to 4,800 units. (e) Would this change result in a bonus being paid to the CEO? Yes O No (b) What is the net operating income (loss) in Year 2 under absorbtion costing? Answer is not complete. Net operating income e