Intermediate: Preparation of cash budgets The following data and estimates are available for ABC Limited for June, July and August.

Notes:
1. 10% of sales are for cash, the balance is received the following month. The amount received in June for May’s sales is £29 500.
2. Wages are paid in the month they are incurred.
3. Overheads include £1500 per month for depreciation. Overheads are settled the month following. £6500 is to be paid in June for May’s overheads.
4. Purchases of direct materials are paid for in the month purchased.
5. The opening cash balance in June is £11 750.
6. A tax bill of £25 000 is to be paid in July.
Required:

(a) Calculate the amount of direct material purchases in each of the months of June, July and August. (3 marks)

(b) Prepare cash budgets for June, July and August. (9 marks)

(c) Describe briefly the advantages of preparing cash budgets. (3 marks)
(Total marks 15) CIMA Stage 1 Cost Accounting

Transcribed Image Text:

June July August () () () Sales Wages Overheads 45 000 50000 60000 12000 13 000 14500 8500 9500 9000