Question

Vista Electronics, Inc. manufactures two different types of coils used in electric motors. In the fall of the current year, Erica Becker, the controller, compiled the following data.

Sales forecast for 20x0 (all units to be shipped in 20x0):

Product	Units			Price
Light coil		60,000		$	120
Heavy coil		40,000			170

Raw-material prices and inventory levels:

Raw Material	Expected Inventories, January 1, 20x0				Desired Inventories, December 31, 20x0				Anticipated Purchase Price
Sheet metal		32,000	lb.			36,000	lb.		$	8
Copper wire		29,000	lb.			32,000	lb.			5
Platform		6,000	units			7,000	units			3

Use of raw material:

	Amount Used per Unit
Raw Material	Light Coil				Heavy Coil
Sheet metal		4	lb.			5	lb.
Copper wire		2	lb.			3	lb.
Platform						1	unit

Direct-labor requirements and rates:

Product	Hours per Unit				Rate per Hour
Light coil		2			$	15
Heavy coil		3				20

Finished-goods inventories (in units):

Product	Expected January 1, 20x0				Desired December 31, 20x0
Light coil		20,000				25,000
Heavy coil		8,000				9,000

Production overhead:

Overhead Cost Item	Activity-Based Budget Rate
Purchasing and material handling	$	0.25	per pound of sheet metal and copper wire purchased
Depreciation, utilities, and inspection	$	4.00	per coil produced (either type)
Shipping	$	1.00	per coil shipped (either type)
General production overhead	$	3.00	per direct-labor hour

Problem 9-39 Part 2

Prepare the production budget (in units) for 20x0.

Answer 1