Intermediate: Preparation of cash budgets A redundant manager who received compensation of £80000 decides to commence business on 4 January, manufacturing a product for which he knows there is a ready market. He intends to employ some of his former workers who were also made redundant but they will not all commence on 4 January. Suitable premises have been found to rent and second-hand machinery costing £60 000 has been bought out of the £80000. This machinery has an estimated life of five years from January and no residual value.

Other data 1. Production will begin on 4 January and 25% of the following month’s sales will be manu¬ factured in January. Each month thereafter the production will consist of 75% of the current month’s sales and 25% of the following month’s sales.

2. Estimated sales are

4. Raw material stocks costing £10000 have been purchased (out of the manager’s £80000) to enable production to commence and it is intended to buy, each month, 50% of the materials required for the following month’s production requirements. The other 50% will be purchased in the month of production. Payment will be made 30 days after purchase.

5. Direct workers have agreed to have their wages paid into bank accounts on the seventh working day of each month in respect of the previous month’s earnings.
6. Variable production overhead: 60% is to be paid in the month following the month it was incurred and 40% is to be paid one month later.
7. Fixed overheads are £4000 per month. One quarter of this is paid in the month incurred, one half in the following month, and the remainder represents depreciation on the second-hand machinery.
8. Amounts receivable: a 5% cash discount is allowed for payment in the current month and 20% of each month’s sales qualify for this discount. 50% of each month’s sales are received in the following month, 20% in the third month and 8% in the fourth month. The balance of 2% represents anticipated bad debts.
You are required to:

(a) (i) prepare a cash budget for each of the first four months, assuming that overdraft facilities will be available, (17 marks)
(ii) state the amount receivable from cus¬ tomers in May; (4 marks)

(b) describe briefly the benefits to cash budgeting from the use of a particular type of software package. (4 marks)
(Total 25 marks)
CIMA Stage 2 Cost Accounting 2

Transcribed Image Text:

(units) () January Nil Nil February 3200 80000 March 3600 90 000 April 4000 100 000 May 4000 100 000 3. Variable production cost per unit () Direct materials 7 Direct wages Variable overhead 6 15 22