I have the answers for the data as it is currently, I need the answers for question 3 where the units produced are changed to $4,200.

2 Change all of the numbers in the data area of your worksheet so that it looks like this: A B S 350 1 Chapter 6: Applying Excel 2 3 Data 4 Selling price per unit 5 Manufacturing costs: 6 Variable per unit produced: 7 Direct materials Direct labor 8 9 Variable manufacturing overhead Fixed manufacturing overhead per year 10 Selling and administrative expenses 11 Variable per unit sold 12 Fixed per year 13 S 145 S 65 S 22 $ 105,000 9 S S 42.000 14 Year 1 Year 2 0 15 Units in beginning inventory 16 Units produced during the year 17 Units sold during the year 18 2,500 2,200 2,100 2.200 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 $140.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.200 units. (a) Would this change result in a bonus being paid to the CEO? O Yes O No (b) What is the net operating Income (loss) in Year 2 under absorption costing? (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? Yes O No