Required information The following information applies to the questions displayed below.) Part 2 of 2 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 Light coil Heavy coil Units 51,000 31,000 Price $ 210 310 Raw-material prices and inventory levels: Expected Inventories, January 1, 20x0 29,000 lb. 26,000 lb. 5, 100 units Raw Material Sheet metal Copper wire Platform Desired Inventories, December 31, 20x0 33,000 lb. 29,000 lb 6,100 units Anticipated P urchase Price $ 18 Use of raw material: Tad nn mit Use of raw material: Raw Material Sheet metal Copper wire Platform Amount Used per Unit Light Coil Heavy Coil 4 lb. 5 lb. 2 lb. 3 lb. 1 unit Part 2 of 2 Direct-labor requirements and rates: Hours per Unit Product Light coil Heavy coil Rate per Hour $ 15 20 Finished-goods inventories (in units): Product Light coil Heavy coil Expected January Desired December 1, 20x0 31, 20x0 16,000 21,000 9,000 10,000 Production overhead: Overhead Cost Item Activity-Based Budget Rate Production overhead: Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Activity-Based Budget Rate $0.70 per pound of sheet metal and copper wire purchased $6.00 per coil produced (either type) $2.00 per coil shipped (either type) $4.00 per direct-labor hour Part 2 of 2 2. 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)