Ian Sharp is a sole trader who buys and sells electrical goods. The following data are forecast for the six-month period between 1 January and 30 June 2017:
|
Purchases (£) |
Sales ID |
|
|
Jan |
1,200 |
4,500 |
|
Feb |
1,400 |
4,800 |
|
Mar |
1,300 |
6,000 |
|
Apr |
1,400 |
6,200 |
|
May |
1,500 |
7,000 |
|
June |
1,800 |
8,000 |
Other information relating to cash flow is as follows:
•Sharp employs a part-time assistant whom he pays £500 each month.
•Overhead expenses are £800 per month and are paid when they are incurred.
•Sales are all on credit and customers take one month’s credit.
•Half of the purchases are cash purchases and the other half are paid for one month later.
•A replacement van is to be purchased for £8,000 in March. A customer has been found for the old van, who will pay £1,500 for it in April.
•The balance at the bank on 1 January 2017 was £1,000 overdrawn.
Based on these data, the cash budget for the six-month period would be.