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 54,000 $240

Heavy coil 34,000 340

• Raw-material prices and inventory levels:

Raw Material Expected Inventories, Desired Inventories, Anticipated

January 1, 20x0 December 31, 20x0 Purchase Price

Sheet metal 32,000lb. 36,000lb. $16

Copper wire 29,000lb. 32,000lb. 10

Platform 5,400units 6,400units 6

• Use of raw material:

Amount Used per Unit

Raw Material Light Coil Heavy Coil

Sheet metal 3lb. 4lb.

Copper wire 1lb. 2lb.

Platform 2unit

• Direct-labor requirements and rates:

Product Hours per Unit Rate per Hour

Light coil 3 $15

Heavy coil 5 20

• Finished-goods inventories (in units):

Product Expected January Desired December

1, 20x0 31, 20x0

Light coil 19,000 24,000

Heavy coil 7,500 8,500

• Production overhead:

Overhead Cost Item Activity-Based Budget Rate

Purchasing and material handling $0.40per pound of sheet metal and copper wire purchased

Depreciation, utilities, and inspection $9.00per coil produced (either type)

Shipping $1.00per coil shipped (either type)

General production overhead $7.00per direct-labor hour

3. Prepare the raw material purchases budget (In quantities) for 20x0. Raw Material Purchases Budget (in Quantities) for 20x0 Raw Material Sheet Metal Copper Wire Platform Light coils Heavy coils Production requirements Total requirements Purchase requirements (units)4. Prepare the raw material purchases budget (In dollars) for 20x0. Raw Material Purchases Budget for 20x0 Raw Raw Material Anticipated Material Required Purchase Total (units) Price Sheet metal Copper wire Platforms Total5. Prepare the direct-labor budget (In dollars) for 20x0. Direct-Labor Budget for 20x0 Projected Hours Total Production (units) per Unit Hours Rate Total Cost Light coils Heavy coils Total 5 06. Prepare the production-overhead budget (In dollars) for 20*0. (Round "Cost Driver Rate" to 2 decimal places.) Production Overhead Budget for 20x0 Cost Driver Cost Driver Budgeted Quantity Rate Cost Purchasing and material handling b. Depreciation, utilities, and inspection coils Shipping coils General production overhead hr. Total production overhead2. Prepare the production budget (In units) for 20x0. Production Budget (in units) for 20x0 Light Coils | Heavy Coils Projected sales Total requirements Production required (units)1. Prepare the sales budget (In dollars) for 20x0. Sales Budget for 20x0 Total Light coils Heavy coils Projected sales