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 57,000 $ 270 Heavy coil 37,000 370 Raw-material prices and inventory levels: Raw Material Expected Inventories, January 1, 20x0 Desired Inventories, December 31, 20x0 Anticipated Purchase Price Sheet metal 35,000 lb. 39,000 lb. $ 16 Copper wire 32,000 lb. 35,000 lb. 10 Platform 5,700 units 6,700 units 6 Use of raw material: Amount Used per Unit Raw Material Light Coil Heavy Coil Sheet metal 3 lb. 4 lb. Copper wire 1 lb. 2 lb. Platform 1 unit Direct-labor requirements and rates: Product Hours per Unit Rate per Hour Light coil 4 $ 10 Heavy coil 6 15 Finished-goods inventories (in units): Product Expected January 1, 20x0 Desired December 31, 20x0 Light coil 22,000 27,000 Heavy coil 9,000 10,000 Production overhead: Overhead Cost Item Activity-Based Budget Rate Purchasing and material handling $ 0.70 per pound of sheet metal and copper wire purchased Depreciation, utilities, and inspection $ 6.00 per coil produced (either type) Shipping $ 1.00 per coil shipped (either type) General production overhead $ 4.00 per direct-labor hour Sales Budget for 20x0 Total Light coils $15,390,000selected answer correct Heavy coils 13,690,000selected answer correct Projected sales $29,080,000 Problem 9-39 Part 2 2. Prepare the production budget (in units) for 20x0. Production Budget (in units) for 20x0 Light Coils Heavy Coils Projected sales 57,000selected answer correct 37,000selected answer correct Add: Desired inventories, December 31, 20x0selected answer correct 27,000selected answer correct 10,000selected answer correct Total requirements 84,000selected answer correct 47,000selected answer correct Less: Expected inventories, January 1, 20x0selected answer correct 22,000selected answer correct 9,000selected answer correct Production required (units) 62,000selected answer correct 38,000selected answer correct 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 0 0 0 Add: Desired inventories, December 31, 20x0 Total requirements Less: Expected inventories, January 1, 20x0 Purchase requirements (units) 4. Prepare the raw material purchases budget (in dollars) for 20x0. Raw Material Purchases Budget for 20x0 Raw Material Raw Material Required (units) Anticipated Purchase Price Total Sheet metal Copper wire Platforms Total $0 5. Prepare the direct-labor budget (in dollars) for 20x0. Direct-Labor Budget for 20x0 Projected Production (units) Hours per Unit Total Hours Rate Total Cost Light coils Heavy coils Total $0 6. Prepare the production-overhead budget (in dollars) for 20x0. (Round "Cost Driver Rate" to 2 decimal places.) Production Overhead Budget for 20x0 Cost Driver Quantity Cost Driver Rate Budgeted Cost Purchasing and material handling lb. Depreciation, utilities, and inspection coils Shipping coils General production overhead hr. Total production overhead $0