Question

XYZ Company has the following data from its costing system regarding its two product lines, A1 and B1:

	A1	B1
Selling price per unit	$140	$99
Direct materials per unit	$72	$53
Direct labor per unit	$24	$12
Direct labor hours per unit	2.0 DL Hrs	1.0 DL Hrs
Estimated annual production and sales	20,000 units	80,000 units

Using a traditional system, the company would apply manufacturing overhead to the units based on direct labor-hours for the upcoming period as follows:

Estimated total manufacturing overhead	$1,980,000
Estimated total direct labor-hours	120,000 DL Hrs

Using an activity-based costing system, the company would assign manufacturing overhead to the following four activity cost pools. The "Other" cost pool includes organization-sustaining costs and idle capacity costs.

	Estimated Overhead Cost	A1 Expected Activity Level	B1 Expected Activity Level	Total Expected Activity Level
Supporting direct labor (direct labor hours)	$783,600	40,000	80,000	120,000
Batch setups (setups)	$495,000	200	100	300
Product sustaining (number of products)	$602,400	1	1	2
Other	$99,000	NA	NA	NA
Total manufacturing overhead cost	$1,980,000

1. (8 points) Compute Product Margins for the A1 and B1 products using the traditional costing system (present your margins in an income statement format similar to Exhibit 6-13 in the textbook).

2. (12 points) Compute Product Margins for the A1 and B1 products using the activity-based costing system (present your margins in an income statement format similar to Exhibit 6-11 in the textbook).

3. (4 points) Based on your analysis above, estimate how much manufacturing overhead was allocated under the traditional costing system to (i) batch setups, and (ii) product sustaining activities for A1 and B1.

Please provide your answers to the questions above on an Excel spreadsheet or Word document and upload using the upload controls.

Answer 1

A)	Traditional approach
	Product		A1		B1
a	Selling price per unit		$140		$99
b	Direct materials per unit		$72		$53
c	Direct labor per unit		$24		$12
d	Contribution per unit(a-b-c)		$44		$34
e	Number of unit		20000.00		80000.00
f	Total contribution(d*e)		880000		2720000
g	fixed cost
	(Estimated total manufacturing overhead/Estimated total direct labor-hours)*Direct labour hours for total number of units		660000		1320000
h	MARGIN(f-g)		220000		1400000
i	MARGIN PER UNIT(h/e)		11		17.5
J	Margin %(i/a)		8%		18%
B)	ABC
	Product		A1		B1
a	Selling price per unit		$140		$99
b	Direct materials per unit		$72		$53
c	Direct labor per unit		$24		$12
d	Contribution per unit(a-b-c)		$44		$34
e	Number of unit		20000.00		80000.00
f	Total contribution(d*e)		880000		2720000
g	Supporting direct labor (direct labor hours)-(expected activity level *overhead cost per unit of driver)		261200		522400
h	Batch setups (setups)-(expected activity level *overhead cost per unit of driver)		330000		165000
i	Product sustaining (number of products)-(expected activity level *overhead cost per unit of driver)		301200		301200
j	Margin(f-g-h-i)		-12400		1731400
h	Margin per unit		-0.62		21.6425
i	Margin %(i/a)		-0.44%		22%
	Activity(1)	Estimated Overhead Cost(2)	Cost driver(3)	Total Expected Activity Level(4)	overhead cost/driver		A1 Expected Activity Level	B1 Expected Activity Level
	Supporting direct labor (direct labor hours)	$783,600	Direct labour hour	120,000	7		40,000	80,000
	Batch setups (setups)	$495,000	(setups)	300	1,650		200	100
	Product sustaining (number of products)	$602,400	Number of products	2	301,200		1	1
c		Estimated Overhead Cost	Direct labour hour	Cost per labour hour	A1(total labour hour*cost per labour hour)	B1(total labour hour*cost per labour hour)
	Batch setups	$495,000	120,000	4.13	165,000.00	330,000.00
	Product sustaining	$602,400	120,000	5.02	200,800.00	401,600.00