The following plans were prepared for the business some months earlier:

May June July Aug Sept Oct Nov

£000 £000 £000 £000 £000 £000 £000 Sales revenue 180 230 320 250 140 120 110 Purchases 135 180 142 94 75 66 57 Administration expenses 52 55 56 53 48 46 45 Selling expenses 22 24 28 26 21 19 18 Taxation payment 22 Finance payments 5 5 5 5 5 5 5 Shop refurbishment – – 14 18 6 – –

Notes:

(i) The inventories level at 1 June was £112,000. The business believes it is preferable to maintain a minimum inventories level of £40,000 of goods over the period to 30 November.

(ii) Suppliers allow one month’s credit. The first three months’ purchases are subject to a contractual agreement, which must be honoured.

(iii) The gross profit margin is 40 per cent.

12.6 466 EXERCISES

(iv) All sales proceeds are received in the month of sale. However, 50 per cent of customers pay with a credit card. The charge made by the credit card business to Newtake Records Ltd is 3 per cent of the sales revenue value. These charges are in addition to the selling expenses identified above. The credit card business pays Newtake Records Ltd in the month of sale.

(v) The business has a bank loan, which it is paying off in monthly instalments of £5,000. The interest element represents 20 per cent of each instalment.

(vi) Administration expenses are paid when incurred. This item includes a charge of £15,000 each month in respect of depreciation.

(vii) Selling expenses are payable in the following month.

Required (working to the nearest £1,000):

(a) Prepare a cash budget for the six months ending 30 November which shows the cash balance at the end of each month.