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?

(b)	What is the net operating income (loss) in Year 2 under absorption costing?

(c)	What is the net operating income (loss) in Year 1 under variable costing?

(d)	What is the net operating income (loss) in Year 2 under variable costing?

Chapter 6: Applying Excel 2 3 Data 4 Selling price per unit 5 Manufacturing costs 6 Variable per unit produced 7 Direct materials 8Direct labor 9Variable manufacturing overhead 10 Fixed manufacturing overhead per year 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year $331 $150 $56 $33 $93,600 $4 $52,000 Year 1 Year 2 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year 19 2,600 2,100 1,800 2,100