Prolog Ltd is a small wholesaler of high-powered computers for scientific research. It has in recent months been selling 50 machines a month at a price of £2,000 each. These machines cost £1,600 each. A new model has just been launched and this is expected to offer greatly enhanced performance. Its selling price and cost will be the same as for the old model. From the beginning of January, sales are planned to increase at a rate of 20 machines each month until the end of June, when sales will amount to 170 units a month. They are planned to continue at that level thereafter. Operating costs including depreciation of £2,000 a month are planned as follows:

January February March April May June Operating costs (£000) 6 8 10 12 12 12 Prolog expects to receive no credit for operating costs. Additional shelving for storage will be bought, installed and paid for in April, costing £12,000. Corporation tax of £25,000 is due at the end of March. Prolog anticipates that trade receivables will amount to two months’ sales revenue. To give its customers a good level of service, Prolog plans to hold enough inventories at the end of each month to fulfil anticipated demand from customers in the following month.

The computer manufacturer, however, grants one month’s credit to Prolog. Prolog Ltd’s balance sheet appears below.

12.7 467 CHAPTER 12 BUDGETING Balance sheet at 31 December

£000 £000 Non-current assets 80 Current assets Inventories 112 Trade receivables 200 Cash – 312 Total assets 392 Equity Share capital (25p ordinary shares) 10 Retained profit 177 187 Current liabilities Trade payables 112 Taxation 25 Overdraft 68 205 Total equity and liabilities 392 Required:

(a) Prepare a cash budget for Prolog Ltd showing the cash balance or required overdraft for the six months ending 30 June.