In: Accounting
. Alpha Ltd has appointed you as a manager in the budgeting department. The company has provided the following information to prepare a cash flow budget for the six months from the 1 January 2021 to 30 June 2021.
viii Fixed costs of production are £100 per month, payable in the month
| Cash Budget | Jan | Feb | Mar | Apr | May | June | Total | 
| 1.Opening balance | 1000 | 1400 | 1800 | 4400 | 7900 | 11300 | 1000 | 
| 2.Sales revenue | 4000 | 4000 | 6000 | 7500 | 7500 | 7500 | 36500 | 
| 3.Total cash available(1+2) | 5000 | 5400 | 7800 | 11900 | 15400 | 18800 | 37500 | 
| Less: Payments for: | |||||||
| 4.Direct material & labor | 500 | 500 | 500 | 500 | 500 | 500 | 3000 | 
| 5.Fixed costs of production | 100 | 100 | 100 | 100 | 100 | 100 | 600 | 
| 6.Insurance costs | 200 | 200 | 200 | 600 | |||
| 7.Bonus to employees | 1000 | 800 | 800 | 1200 | 1500 | 1500 | 6800 | 
| 8.OH costs | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 12000 | 
| 9.Total payments(sum 4 to 8) | 3600 | 3600 | 3400 | 4000 | 4100 | 4300 | 23000 | 
| 10.Ending balance(3-9) | 1400 | 1800 | 4400 | 7900 | 11300 | 14500 | 14500 | 
| Ending cash balance as at Jun 30= | 14500 | 
| Workings: | |||||||
| Jan | Feb | Mar | Apr | May | June | Total | |
| 1.Sales units | 2000 | 2000 | 2000 | 2500 | 2500 | 2500 | 13500 | 
| 2.Selling price/unit | 2 | 2 | 3 | 3 | 3 | 3 | |
| 3.Sales $(1*2) | 4000 | 4000 | 6000 | 7500 | 7500 | 7500 | 36500 | 
| 4.Bonus to employees(Prev.3*20%) | 1000 | 800 | 800 | 1200 | 1500 | 1500 | 6800 |