$2.$ Change all of the numbers in the data area of your worksheet so that it looks like this:

Chapter $6$: Applying Excel

Data

Selling price per unit $$340$

Manufacturing costs:

Variable per unit produced:

Direct materials $$159$

Direct labor $$74$

Variable manufacturing overhead $$24$

Fixed manufacturing overhead per year $$106,400$

Selling and administrative expenses:

Variable per unit sold $$6$

Fixed per year $$42,000$

Year $1$ Year $2$

Units in beginning inventory $0$

Units produced during the year $2,8001,900$

Units sold during the year $2,3002,300$

$($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?