In: Accounting
Q4Y4 | Q1Y5 | Q2Y5 | Q3Y5 | Q4Y5 | Total | |
Budgeted Sales (Actual for Q4Y4) | 10000 | 11000 | 14000 | 15000 | 17000 | 57000 |
Selling Price/per unit | 9 | 9 | 9 | 9 | 9 | 9 |
Sale Collection | ||||||
In quarter of sale | 0.8 | |||||
In following quarter | 0.2 | |||||
Desired ending finished goods inventory | 2500 | 2200 | 2400 | 2100 | 2100 | |
Raw Materials/per unit | 5 | 5 | 5 | 5 | 5 | 5 |
Desired Ending raw material inventory Inventory | 5000 | 8000 | 7000 | 6000 | 5000 | 5000 |
Raw material price/per unit | 2 | 2 | 2 | 2 | 2 | 2 |
Accounts payable | ||||||
In quarter of purchase | 0.7 | |||||
In following quarter | 0.3 | |||||
Q4Y4 raw material cost | 100000 |
REQUIRED:
Sale Budget | Year 5 Quarters | |||||
1 | 2 | 3 | 4 |
Year |
Production Budget |
Material Budget |
Cash Receipts |
Cash Payments |
Sales budget
Q4Y4 | Q1Y5 | Q2Y5 | Q3Y5 | Q4Y5 | |
Budgeted sales units | 10000 | 11000 | 14000 | 15000 | 17000 |
Selling price per unit | 9 | 9 | 9 | 9 | 9 |
Estimated sales revenue (currency) | 90000 | 99000 | 126000 | 135000 | 153000 |
Production Budget
Q4Y4 | Q1Y5 | Q2Y5 | Q3Y5 | Q4Y5 | |
Budgtd sales units | 10000 | 11000 | 14000 | 15000 | 17000 |
Add: desired finished goods inventory | 2500 | 2200 | 2400 | 2100 | 2100 |
12500 | 13200 | 16400 | 17100 | 19100 | |
Less: Opening F.G inventory | 0 | 2500 | 2200 | 2400 | 2100 |
Estimated units to be produced | 12500 | 10700 | 14200 | 14700 | 17000 |
Materials Budget
Q4Y4 | Q1y5 | Q2Y5 | Q3Y5 | Q4Y5 | |
Estimated F.G production units | 12500 | 10700 | 14200 | 14700 | 17000 |
Raw materials per F.G. Unit | 5 | 5 | 5 | 5 | 5 |
Total raw materials required (units) | 62500 | 53500 | 71000 | 73500 | 85000 |
Add: desired ending R.M. Inventory | 5000 | 8000 | 7000 | 6000 | 5000 |
67500 | 61500 | 78000 | 79500 | 90000 | |
Less: Opening R.M. Inventory | 0 | 5000 | 8000 | 7000 | 6000 |
Raw materials to be purchased | 67500 | 56500 | 70000 | 72500 | 84000 |
Cash receipts budget
Q4Y4 | Q1y5 | Q2y5 | Q3y5 | Q4y5 | |
Estimated sales revenue | 90000 | 99000 | 126000 | 135000 | 153000 |
Cash collection in same qtr (80%) | 72000 | 79200 | 100800 | 108000 | 122400 |
Cash collection in following qtr (20%) | 18000 | 19800 | 25200 | 27000 | |
Total cash collection in the quarter | 72000 | 97200 | 120600 | 133200 | 149400 |
Cash payments budget:
Q4y4 | Q1y5 | Q2y5 | Q3y5 | Q4y5 | |
Raw material units reqd | 67500 | 56500 | 70000 | 72500 | 84000 |
R.M. Price per unit | 2 | 2 | 2 | 2 | 2 |
Total raw material cost | 135000 | 113000 | 140000 | 145000 | 168000 |
Acnts payable in same qtr (70%) | 94500 | 79100 | 98000 | 101500 | 117600 |
Acnts payable in next qtr (30%) | 40500 | 33900 | 42000 | 43500 | |
Total estimated cash payments | 94500 | 119600 | 131900 | 143500 | 161100 |