Prolog Ltd is a small wholesaler of high-specification personal computers. 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. Sales are planned to continue at that level thereafter. Operating costs including depreciation of ?2,000 a month are planned as follows:

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. 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 statement of financial position is:

Required:(a) Prepare a cash budget for Prolog Ltd showing the cash balance or required overdraft for the six months ending 30 June.(b) State briefly what further information a banker would require from Prolog Ltd before granting additional overdraft facilities for the anticipated expansion of sales.

Transcribed Image Text:

April 12 May January February March June Operating costs (£000) 10 12 12 Statement of financial position at 31 December ASSETS £000 Non-current assets 80 Current assets Inventories 112 Trade receivables 200 Cash 312 Total assets 392