Question

Problem 9-62 and 9-63 (Algo)

Cain Components manufactures and distributes various plumbing products used in homes and other buildings. Over time, the production staff has noticed that products they considered easy to make were difficult to sell at margins considered reasonable, while products that seemed to take a lot of staff time were selling well despite recent price increases. A summer intern has suggested that the cost system might be providing misleading information.

The controller decided that a good summer project for the intern would be to develop, in one self-contained area of the plant, an alternative cost system with which to compare the current system. The intern identified the following cost pools and, after discussion with some plant personnel, appropriate cost drivers for each pool. There were:

Cost Pools		Costs	Activity Drivers
Receiving	$	600,000	Direct material cost
Manufacturing		5,500,000	Machine-hours
Machine setup		900,000	Production runs
Shipping		1,000,000	Units shipped

In this particular area, Cain produces two of its many products: Standard and Deluxe. The following are data for production for the latest full year of operations.

	Products
	Standard			Deluxe
Total direct material costs	$	150,000		$	250,000
Total direct labor costs	$	650,000		$	440,000
Total machine-hours		112,000			138,000
Total number of setups		170			30
Total pounds of material		8,500			18,500
Total direct labor-hours		6,950			4,700
Number of units produced and shipped		19,000			6,000

Problem 9-63 (Algo) Activity-Based Costing and Predetermined Overhead Rates (LO 9-3, 5, 6)

The intern decides to look more closely at the manufacturing activity and determines that it can be broken down into two activities: production and engineering. Production covers the costs of ongoing manufacturing while engineering includes those activities dealing with engineering changes, design modifications, and so on.

The costs attributed to production are $10,526,400 and the costs attributed to engineering are $10,092,000. After discussion with plant engineers, the intern decides that the best cost driver for engineering is setups, because most of the work arises from changes in the way the product is run.

A. Compute the totals of the cost driver rates shown below. (Round intermediate calculations and "Manufacturing" answer to 2 decimal places.)

Receiving	_____	% of material dollars
Production	_____	Per Machine-Hour
Engineering	_____	Pet Setup
Machine Setup	_____	Per Setup
Shipping	_____	Per Unit

B. What unit product costs will be reported for the two products if the revised ABC system is used? (Round "Unit cost" answers to 2 decimal places.)

	Standard	Deluxe
Direct Cost	$	$
OVERHEAD:
Receiving	$	$
Production	$	$
Engineering	$	$
Machine Setup	$	$
Shipping	$	$
TOTAL COSTS	$	$
Number of Units	#	#
Unit Costs	$	$

Answer 1

A.

Receiving ($600,000/$400,000)	$1.5 of material dollars (or) 150%
Manufacturing ($5,500,000/250,000)	22
Engineering ($10,092,000/200)	50,460
Machine setup ($900,000/200)	4,500
Shipping ($1,000,000/25,000)	40

B.

	Standard	Deluxe
Direct cost	$800,000 ($150,000+650,000)	$690,000 ($250,000+440,000)
Overhead:
Receiving	225,000 (150,000*1.5)	375,000 (250,000*1.5)
Manufacturing	2,464,000 (112,000*$22)	3,036,000 (138,000*$22)
Machine setup	765,000 (170*$4,500)	135,000 (30*$4,500)
Shipping	760,000 (19,000*$40)	240,000 (6,000*$40)
Total cost	5,014,000	4,476,000
Number of units	19,000	6,000
Unit cost	$263.89	$746