Vista Electronics, Incorporated, 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 xall units to be shipped in x:
Product Units Price
Light coil $
Heavy coil
Rawmaterial prices and inventory levels:
Raw Material Expected Inventories, January x Desired Inventories, December x Anticipated Purchase Price
Sheet metal Pound Pound $
Copper wire Pound Pound
Platform units units
Use of raw material:
Raw Material Amount Used per Unit
Light Coil Heavy Coil
Sheet metal Pound Pound
Copper wire Pound Pound
Platform unit
Directlabor requirements and rates:
Product Hours per Unit Rate per Hour
Light coil $
Heavy coil
Finishedgoods inventories in units:
Product Expected January x Desired December x
Light coil
Heavy coil
Production overhead:
Overhead Cost Item ActivityBased Budget Rate
Purchasing and material handling $ per pound of sheet metal and copper wire purchased
Depreciation, utilities, and inspection $ per coil produced either type
Shipping $ per coil shipped either type
General production overhead $ per directlabor hourPrepare the production budget in units for