Need help with master budget in managerial accounting

Sales forecast for 20x0 (all units to be shipped in 20x0) Product Units Price Light coil 63,00 330 Heavy coil 43,000 43 Raw-material prices and inventory levels: Expected Inventories, January 1, 20x8 Desired Inventories, December 31, 20xe Anticipated Purchase Price Raw Material Sheet metal Copper wire 41,000 lb. 38,000 1b. 45,000 1b. 41,000 1b. 16 10 Platform 6,300 units 7,300 units . Use of raw material: Amount Used per Unit Raw Material Light Coil Heavy Coil 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 Unit 4 Rate per Hour $ 18 15 6 Finished-goods inventories (in units) Expected January Desired December 31, Produc Light coil Heavy coil t1, 20x0 28,000 8,000 20x0 33,000 9,000 . Production overhead Activity-Based Budget Rat Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overead $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 6. Prepare the production-overhead budget (in dollars) for 20x0. (Round "Cost Driver Rate" to 2 decimal places.) Production Overhead Budget for 20x0 Cost Driver Cost Driver Budgeted Quantit Rate Cost Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Total production overhead lb Depreciation, utlities, and inspection coll coils hr