please

need tonight

CSIC 16. Excel Help Save & Edit Suomi Check my work 2 2. Change all of the numbers in the data area of your worksheet so that it looks like this 1 C 5 ook 5 240 Beferences A 1 Chapter 6: Applying Excel 2 3 Data 4 Selling price per un 5 Maturing 6 Variable per unit produced 7 Direct materials 8 Direct labor 9 Variable manufacturing overhead 10 Faxed manufacturing overhead per year 11 Selling and administive expenses 12 Variabile per un sold 13 Fixed per year 14 15 16 units in beginning inventory 17 Units produced during the yer 18 Uni od during the year $ 5 $ $ 102 60 21 110.000 5 5 50.000 Yeart You 2 2.500 2.300 2.200 2100 Check my work Required information If your formulas are correct, you should get the correct answers to the following questions ta) What is the net operating income foss) in Year under absorption costing? Net operating loss oncen b) What is the net operating income foss) in Year 2 under absorption costing? Net operating loss Check my work 2 Required information 75 points (c) What is the net operating Income (loss) in Year 1 under variable costing? Net operating loss Book Print References (d) What is the net operating income foss) in Year 2 under variable costing? Net operating loss Check my werk 2 Required information 75 points (e) The net operating income foss) under absorption costing is less than the net operating income foss) under variable costing in Year 2 because: (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any bones left with a question mark will be automatically graded as incorrect) wok Priet unts were of over from the previous you. The com of goods sold is always les under variable costing than onder absorption costing Ses exceeded production so some of the feed manufacturing overhead of the period was released from invenies under nbiorption costing 3. Make a note of the absorption costing net operating income foss) 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 4,400 units (s) Would this change result in a bonus being paid to the CEO? Yes No