Finished-goods inventories (in units): Product Light coil Heavy coil Expected January 1, 20x0 25,000 6,500 Desired December 31, 20x0 30,000 7,500 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 1. Prepare the sales budget (in dollars) for 20x0. Sales Budget for 20x0 Total Light coils Heavy coils Projected sales $ 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. Platform Raw Material Purchases Budget (in Quantities) for 20x0 Raw Material Sheet Metal Copper Wire Light coils Heavy coils Production requirements 0 0 Total requirements Purchase requirements (units) 4. Prepare the raw material purchases budget (in dollars) for 20x0. Raw Material Purchases Budget for 20x0 Raw Material Anticipated Raw Required Purchase Material Total (units) Price Sheet metal Copper wire Platforms Total 5. Prepare the direct-labor budget (in dollars) for 20x0. Direct-Labor Budget for 20x0 Hours Projected Production (units) per Unit Total Rate Total Cost Hours Light coils Heavy coils Total 6. Prepare the production-overhead budget (in dollars) for 20x0. (Round "Cost Driver Rate" to 2 decimal places.) Budgeted Cost Ib. Production Overhead Budget for 20x0 Cost Driver Cost Driver Quantity Rate Purchasing and material handling Depreciation, utilities, and inspection coils Shipping coils General production overhead Total production overhead nr. Finished-goods inventories (in units): Product Light coil Heavy coil Expected January 1, 20x0 25,000 6,500 Desired December 31, 20x0 30,000 7,500 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 1. Prepare the sales budget (in dollars) for 20x0. Sales Budget for 20x0 Total Light coils Heavy coils Projected sales $ 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. Platform Raw Material Purchases Budget (in Quantities) for 20x0 Raw Material Sheet Metal Copper Wire Light coils Heavy coils Production requirements 0 0 Total requirements Purchase requirements (units) 4. Prepare the raw material purchases budget (in dollars) for 20x0. Raw Material Purchases Budget for 20x0 Raw Material Anticipated Raw Required Purchase Material Total (units) Price Sheet metal Copper wire Platforms Total 5. Prepare the direct-labor budget (in dollars) for 20x0. Direct-Labor Budget for 20x0 Hours Projected Production (units) per Unit Total Rate Total Cost Hours Light coils Heavy coils Total 6. Prepare the production-overhead budget (in dollars) for 20x0. (Round "Cost Driver Rate" to 2 decimal places.) Budgeted Cost Ib. Production Overhead Budget for 20x0 Cost Driver Cost Driver Quantity Rate Purchasing and material handling Depreciation, utilities, and inspection coils Shipping coils General production overhead Total production overhead nr
