This is what i have so far i hope this helps

1. Sales Budget ul September Total October Budgeted sales in units x Price per unit 10000 $14.00 $140,000.00 25000 $14.00 $350,000.00 50000 $14.00 $700,000.00 15000 Projected sales revenue $210,000.00 2. Production Budget September 25000 Budgeted product sales in units +Desired product units in ending inventory -Total product units needed 10000 3750 13750 4000 9750 27250 3750 23500 15000 1875 16875 2250 50000 1875 51875 4000 47875 Product units in beginning inventory Product units to produce 3. Material Purchases Budget ul September Total 9750 23500 14625 47875 Units to produce x Material needed per unit - Material needed for units to produce +Desired units of material in ending inventory = Total units of material needed 143625 70500 8775 79275 43875 9000 9000 43250 8000 35250 Units of material in beginning inventory 8775 8000 Units of material to purchase 65175 44100 144625 4. Cash Payments for Material Purchases July September Material purchases (sheets) x Cost per unit = Total cost 35350 65175 144625 $2.00 $289.250.00 $70,700.00 $130,350.00 $88,200.00 Payables from June July purchases August purchases September purchases Total S24,200.00 S45,955.00 $24.200.00 $24.745.00 $45,622.50 $57,330.00 $282,580.00 $24.745.00 $84,727.00 $45,622.50 Accounts Pavable $30,870.00 $98.903.00 payments in month 70,5.00 $109.472.50 $102,952.50