Required information Problem 9-39 Sales, Production, and Purchases Budgets; Activity-Based Overhead Budget (LO 9-3, 9-4, 9-5, 9-6) [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): Product Light coil Heavy coil Units 58,000 38,000 Price $ 280 380 Raw-material prices and inventory levels: Raw Material Sheet metal Copper wire Platform Expected Inventories, January 1, 20x0 36,000 lb. 33,000 lb. 5,800 units Desired Inventories, December 31, 20x0 40,000 lb. 36,000 lb. 6,800 units Anticipated Purchase Price $ 15 8 4 00+ 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. 2 unit Direct-labor requirements and rates: Product Light coil Heavy coil Hours per Unit 3 5 Rate per Hour $ 15 20 Finished-goods inventories (in units): Product Light coil Heavy coil Expected January 1, 20x0 23,000 9,500 Desired December 31, 20x0 28,000 10,500 Production overhead: Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Activity-Based Budget Rate $0.80 per pound of sheet metal and copper wire purchased $7.00 per coil produced (either type) $2.00 per coil shipped (either type) $5.00 per direct-labor hour Problem 9-39 Part 1 Required: 1. Prepare the sales budget (in dollars) for 20x0. Sales Budget for 20x0 Total Light coils Heavy coils Projected sales 0 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 Total requirements Production required (units) 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 Total requirements Purchase requirements (units) Problem 9-39 Part 4 4. Prepare the raw material purchases budget (in dollars) for 20x0. Raw Material Purchases Budget for 20x0 Raw Material Anticipated Required (units) Purchase Price Raw Material Total Sheet metal Copper wire Platforms Total 0 Problem 9-39 Part 5 5. Prepare the direct-labor budget (in dollars) for 20x0. Direct-Labor Budget for 20x0 Projected Hours per Production (units) Unit Total Hours Rate Total Cost Light coils Heavy coils Total $ 0 Problem 9-39 Part 6 6. Prepare the production-overhead budget (in dollars) for 20x0. (Round "Cost Driver Rate" to 2 decimal places.) Cost Driver Budgeted Cost Rate Production Overhead Budget for 20x0 Cost Driver Quantity Purchasing and material handling Ib. Depreciation, utilities, and inspection coils Shipping coils General production overhead hr. Total production overhead $ 0
