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

A

B

C

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

Chapter 4: Applying Excel
Data
Selling price per unit	$334
Manufacturing costs:
Variable per unit produced:
Direct materials	$135
Direct labor	$54
Variable manufacturing overhead	$26
Fixed manufacturing overhead per year	$119,600
Selling and administrative expenses:
Variable per unit sold	$4
Fixed per year	$58,000
	Year 1	Year 2
Units in beginning inventory	0
Units produced during the year	2,600	2,300
Units sold during the year	2,400	2,400

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