Part 1
Peyton Approved
Sales Budgets
July, August, and September 2014
Budgeted Units Budgeted Unit Price Budgeted Total Dollars
7/14/2015 18,000 $18.00 $324,000
8/14/2015 22,000 $18.00 $396,000
9/14/2015 20,000 $18.00 $360,000
Total for the first quarter 60,000 $1,080,000
Part 2
Peyton Approved
Production Budget
July, August, and September 2014
July August Sept. Total
Next month’s budgeted sales 18,000 22,000 20,000 60000
Ratio of inventory to future sales 70% 70% 70%
Budgeted ending inventory 15,400 14,000 16,800
Add budgeted sales
Required units to be produced 33,400 36,000 36,800 106,200
Deduct beginning inventory 16,800 15,400 14,000 46,200
Units to be produced 16,600 20,600 22,800 60,000
Part 3
Peyton Approved
Raw Materials Budget
July, August, and September 2014
July August Sept. Total
Production budget (units) 16,600 20,600 22,800 60,000
Materials requirement per unit 0.5 0.5 0.5 0.5
Materials needed for production 8,300 10,300 11,400 30,000
Add budgeted ending inventory 2,060 2,280 1,980
Total materials requirements (units) 10,360 12,580 13,380 36,320...