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 66,000 $ 360 Heavy coil 46,000 460 Raw-material prices and inventory levels: Raw Material Sheet metal Expected Inventories, January 1, 20x0 Copper wire Platform 44,000 lb. 41,000 lb. 6,600 units Use of raw material: Raw Material Sheet metal Copper wire Platform Amount Used per Unit Light Coil 3 lb. 1 lb. Heavy Coil 4 lb. 2 lb. 2 unit Direct-labor requirements and rates: Desired Inventories, December 31, 20x0 48,000 lb. 44,000 lb. 7,600 units Product Light coil Hours per Unit 3 Heavy coil 5 Rate per Hour $ 15 20 Finished-goods inventories (in units): Product Light coil Heavy coil Expected Desired January 1, 20x0 December 31, 20x0 31,000 9,500 36,000 10,500 Anticipated Purchase Price $ 16 10 6 Production overhead: Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Activity-Based Budget Rate $0.40 per pound of sheet metal and copper wire purchased $9.00 per coil produced (either type) $1.00 per coil shipped (either type) $7.00 per 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 0 0 0 Add: Desired inventories, December 31, 20x0 48,000 44,000 7,600 Total requirements Less: Expected inventories, January 1, 20x0 44,000 41,000 6,600 Purchase requirements (units) 4. Prepare the raw material purchases budget (in dollars) for 20x0. Raw Material Purchases Budget for 20x0 Raw Material Sheet metal Copper wire Platforms Total Raw Material Required (units) Anticipated Purchase Price 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 place Production Overhead Budget for 20x0 Cost Driver Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Total production overhead Quantity lb. coils coils Cost Driver Rate Budgeted Cost hr. $ 0