In: Accounting
Sales Budget | |||||
Particulars | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total |
Sales units | 67,200 | 80,640 | 1,00,800 | 87,360 | 3,36,000 |
Add. Increase (25%) | 16,800 | 20,160 | 25,200 | 21,840 | 84,000 |
Projected sales in Units | 84,000 | 1,00,800 | 1,26,000 | 1,09,200 | 4,20,000 |
Sales price per unit | $ 8.00 | $ 8.00 | $ 8.00 | $ 8.00 | |
Sales amount | $ 6,72,000 | $ 8,06,400 | $ 10,08,000 | $ 8,73,600 | $ 3360000 |
Production Budget | |||||
Particulars | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total |
Sales units | 84,000 | 1,00,800 | 1,26,000 | 1,09,200 | 4,20,000 |
Add : Closing Stock Required (10% of next quarter sales) | 10,080 | 12,600 | 10,920 | 9000 | |
Total Goods Required | 94,080 | 1,13,400 | 1,36,920 | 1,18,200 | 4,62,600 |
Less : Opening Stock (For Quarter 1 - considered 10% of estimated sales) |
8,400 | 10,080 | 12,600 | 10,920 | |
Production Required (units) | 85,680 | 1,03,320 | 1,24,320 | 1,07,280 | 4,20,600 |