Simon intends to start his own business selling specialist wines. Some of his sales will be for cash from a shop that he intends to rent. He also plans to sell some wine on credit to local restaurants and hotels. The details of his business plan are as follows:

1. He will rent a shop for 14,000 per annum payable quarterly in advance. The landlord also requires a deposit of 5,000 to be paid when the rental starts in June.

1. He will invest 13,000 from his own savings and his father will loan him 7,000. His father will charge interest at a rate of 2.5% per annum payable annually after an interest free period of 6 months.

1. Simon will purchase and pay for 13,000 of wine in June. Thereafter, to maintain the same level of inventory, he will purchase wine to replace what is sold.

1. Suppliers will allow one month's credit and credit customers will expect one month's credit.

1. Sales levels are predicted to be:

	Total sales	Cash sales	Credit sales
June	6,000	3,000	3,000
July	6,500	3,000	3,500
August	7,000	3,000	4,000
September	8,000	3,500	4,500
October	9,500	4,500	5,000
November	12,000	5,000	7,000

1. Wine will be sold at a gross profit margin of 20%.

1. Simon intends to withdraw 400 per month for his own use and will employ a part- time assistant whom he will pay 300 per month.

1. Simon will need to purchase and install shelving that will be delivered and paid for at the beginning of June at a cost of 2,900. He will also lease a van at a cost of 500 per month.

1. Other anticipated costs are:

June 600

July 280

August 500

September 700

October 670

November 560

REQUIRED:

1. Create a cash budget for Simon for his first 6 months' trading to 30 November.
2. What size overdraft facility should Simon request from his bank?
3. Why a cash budget is required for Simon's business?