2. Change all of the numbers in the data area of your worksheet so that it looks like this 1Chapter 6: Applying Excel 2 3 Data 4 Selling price per unit 5 Manufacturing costs 6 Variable per unit produced 361 Direct materials Direct labor Variable manufacturing overhead 136 67 31 $ 184,800 10Fixed manufacturing overhead per year 11 Selling and administrative expenses 12Variable per unit sold 13Fixed per year 14 15 $ 109,000 Year 1 Year 2 16Units in beginning inventory 17 0 3,300 3,000 Units produced during the year 2,800 3,000 18 LUnits sold during the year 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? Net operating income (b) What is the net operating income (loss) in Year 2 under absorption costing? Net operating income (c) What is the net operating income (loss) in Year 1 under variable costing? et operating income (d) What is the net operating income (loss) in Year 2 under variable costing? et operating income 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 $150,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 5,600 units (b) What is the net operating income (loss) in Year 2 under absorption costing? et operating income