Please solve accurately. Thanks.

Required information [The following information applies to the questions displayed below.] 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) Units Price 60, 000 $ 120 40, 000 170 Pr Light coil Heavy coil . Raw-material prices and inventory levels Expected Inventories, Desi red Inventories, January 1, 20x0Decembe: 31. 2020 Raw Material Sheet metal Copper wire Platform Pucchase Price 32,000 lb 29,000 1b 36. 000 1b 32 000 1b 000 nt 7.0 6,000 units . Use of raw material: unt Used per Unit Raw Material Light Coil Heavy Coi Sheet metal Copper wire Platform 4 lb. 2 1b. 5 1b. 3 lb. 1 unit . Direct-labor requirements and rates: Product Light coil Heavy coil Hours per UnitRate per Hour s 15 20 2 . Finished-goods inventories (in units): Expected January Desire 31. 20x0 5, 000 9, 000 1, 20x0 20,000 8,000 Product Light coil Heavy coil . Production overhead Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection shipping General production overhead $0.25 per pound of sheet metal and copper wire purchased $4.00 per coil produced (either type) $1.00 per coil shipped (either type) $3.00 per direct-labor hour 3. Prepare the raw material purchases budget (in quantities) for 20x0. Material Purchases Budget (in Quantities) for 20x0 Sheet Metal Copper Wire Platform Heavy coils Production 0 requirements (units) . Production overhead: Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead $0.25 per pound of sheet metal and copper wire purchase $4.00 per coil produced (either type) $1.00 per coil shipped (either type) $3.00 per direct-labor hour 4. Prepare the raw material purchases budget (in dollars) for 20x0O Raw Material Purchases Budget for 20x0 Raw Material Anticipated Raw Material Total Required (units) Purchase Price Copper wire Total . Production overhead: verhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Activity-Based Budget Rate $0.25 per pound of sheet metal and copper wire purchased $4.00 per coil produced (either type) $1.00 per coil shipped (either type) $3.00 per direct-labor hour 5. Prepare the direct-labor budget (in dollars) for 20xO. Direct-Labor Budget for 20x0 Projected Hours perTotal HoursRate Total Cost ction (units) Unit Light coils Heavy coils Total . Production overhead: erhead Cost It Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead $0.25 per pound of sheet metal and copper wire purchased $4.00 per coil produced [either type) $1.00 per coil shipped (either type) $3.00 per direct-labor hour 6. Prepare the production-overhead budget (in dollars) for 20xO. (Round "Cost Driver Rate" to 2 decimal places.) Production Overhead Budget for 20x0 Cost Driver Cost Driver Budgeted Cost Rate Quanti lb coils coils Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Total production overhead