Monthly Financial Data and Break-Even Analysis
Classified in Mathematics
Written on in
English with a size of 3.32 KB
Monthly Financial Data
| 900 | 1000 | 1250 | 1400 | 1500 | 750 | |
|---|---|---|---|---|---|---|
| July | August | September | October | November | December | |
| Sales per Unit (£50) | 45000 | 50000 | 62500 | 70000 | 75000 | 37500 |
| Purchases per Unit (£24) | 21600 | 24000 | 30000 | 33600 | 36000 | 18000 |
Receipts | ||||||
| Opening Balance | 10000 | (1650) | 2100 | 5650 | 12500 | 21250 |
| Cost of Sales (40%) | 18000 | 20000 | 25000 | 28000 | 30000 | 15000 |
| Credit Sales (60%) | 27000 | 30000 | 37500 | 42000 | 45000 | |
| Total Receipts | 28000 | 45350 | 57100 | 71150 | 84500 | 81250 |
Payments | ||||||
| Purchases Cash (50%) | 10800 | 12000 | 15000 | 16800 | 18000 | 9000 |
| Purchases Credit (50%) | 10800 | 12000 | 15000 | 16800 | 18000 | |
| Direct Labour per Unit (£13) | 11700 | 13000 | 16250 | 18200 | 19500 | 9750 |
| Variable Overheads per Unit (£3) | 2700 | 3000 | 3750 | 4200 | 4500 | 2250 |
| Selling and Distribution Costs | 800 | 800 | 800 | 800 | 800 | 800 |
| Supervisor Salary | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 |
| Fixed Production Costs | 1850 | 1850 | 1850 | 1850 | 1850 | 1850 |
| Total Payments | 29650 | 43250 | 51450 | 58650 | 63250 | 43450 |
| Closing | ||||||