Could Someone Help me answer this question?

Carlas Caf

Carla has inherited a small caf in the centre of town, worth 250,000 and plans to run it selling lunches and snacks.

It has kitchen fixtures and fittings worth 100,000 and furniture etc valued at 4,000.

She has savings of 5,000 which she will deposit into a business bank account in January and is in discussion with her bank to get a loan.

They have asked her to prepare a business plan, including a cash budget for the coming six months.

Carla expects the caf to draw customers straight away. Most customers will pay cash immediately, but Carla intends to offer to sell on credit terms to local professional offices (accountants, solicitors etc) for staff lunches, meetings etc

She reckons that her sales for the coming six months will be:

		% credit sales
	6,000	0%
February	6,500	5%
March	7,000	5%
April	7,500	10%
May	7,500	10%
June	8,000	10%

The credit sales will be paid up in the month following sale.

Carla will buy ingredients immediately before using them and the cost will be 50% of monthly sales. There will be negligible inventory on hand. (For example, in January, ingredients costs will be 6,000 * 50% =3,000)

Carla will employ a part-time assistant for the busiest times of the day and on Saturdays and he will be paid 750 per month.

She will need to buy a small delivery vehicle and has seen one advertised for 4,900. She will buy it in February.

Some of the furniture needs replacement and she thinks she will budget 800 for that in January.

Repairs, redecorating will be undertaken in January and February and be paid for in March. This will cost 2,000.

Utility costs, including electricity, other utility bills etc are budgeted to be 1,800 a month.

Business rates are 2,000 for the six months from April and are payable in April.

Required:

Prepare a cash budget for Carla for the six months to 30^th June.