2. Change all of the numbers in the data area of your worksheet so that it looks like this: 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? (Loss amounts should be indicated with a minus sign.) (c) What is the net operating income (loss) in Year 1 under variable costing? (Loss amounts should be indicated with a minus sign.) (d) What is the net operating income (loss) in Year 2 under variable costing? (Loss amounts should be indicated with a minus sign.) 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 $30,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 3,800 units. (a) Would this change result in a bonus being paid to the CEO? Yes No (b) What is the net operating income (loss) in Year 2 under absorption costing? (Loss amounts should be indicated with a minus sign.) (c) Would this doubling of production in Year 2 be in the best interests of the company if sales are expected to continue to be 2,200 units per year