Need help with master budget in managerial accounting

Product Light coil 63,000 330 Heavy coil 43,000 430 Units Price - Raw-material prices and inventory levels: Expected Inventories, January 1, 20xe 41,000 1b 38,000 1b. Desired Inventories, December 31, 20xe 45,000 1b. 41,000 lb Anticipated Purchase Price Raw Material Sheet metal Copper wire Platform $ 16 10 6 6,300 units 7,300 units - Use of raw material: Amount Used per Uni Light Coil Heavy Coil Raw Material Sheet metal Coppen wire Platform 5 1b. 3 1b. 1 unit 2 1b. . Direct-labor requirements and rates: Rate per Hour S 10 15 Hours per Un it Product Light coil Heavy coil 4 6 Finished-goods inventories (in units) Expected January Desired December 31 Product Light coil Heavy coil 1, 20xe 28,000 8,000 20x0 33,000 9,000 Production overhead: Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead ity-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 3. Prepare the raw material purchases budget (in quantities) for 20x0 Answer is not complete. Raw Material Purchases Budget (in Quantities) for 20x0 Raw Material Sheet Metal Copper Wire Platform Light coils Heavy coils Production requirements Add: Desired inventories, December 31, 20x0 Total requirements Less Expected inventories, January 1, 20x0 Purchase requirements (units) Desired Inventories December 31, 20:0