The Rosrock Housing Association has two types of housing estate in the Rosburgh area (A and B). The following information is available:
(i) The association has its own squad of painters who carry out painting and decorating work on the housing estates. The estimated cost for each house in which the work will be done in 2013 is as follows:
Painting
(£)
(a) Direct material cost 75
(b) Direct labour cost 270
(c) In 2013 overhead cost is absorbed at 20 per cent on direct material cost plus 100 per cent on direct labour cost. Only 30 per cent of material related overhead and 331/3 per cent of labour related overhead is variable, the remainder is fixed overhead and the absorption rate is arrived at using the budgeted number of houses which require painting and decorating each year.
(d) Fixed overhead may be analyzed into:
1 Items avoidable on cessation of the service 30%
2 Depreciation of equipment and premises 20%
3 Apportionment of head office costs 50%
(e) Direct material and direct labour cost are wholly variable.
(ii) The total number of houses of each type and the percentage requiring painting and decorating each year is as follow:
a) Creditors for materials: £2100. Credit purchases are 90 per cent of purchases, the remainder being cash purchases. The credit purchases outstanding at a year end are estimated at 10 per cent of the annual materials purchased on credit. There are no materials on hand on 31 December 2012.
(b) Labour costs accrued: £2800. Labour costs outstanding at a year end are estimated at 4 per cent of the annual total earnings for the year.
(c) Creditors for variable overheads: £600. Variable overheads are paid 60 per cent in the month of incidence and 40 per cent in the month following. Variable overheads are deemed to accrue evenly each month throughout the year.
(d) Fixed overheads are paid in twelve equal amounts with no accruals or prepayments.
(a) Prepare a cash budget for the existing painting and decorating function for the period 1 January 2013 to 31
December 2015 which shows the cash flows for each of the years 2013, 2014 and 2015. (Calculations should be rounded to the nearest whole £.) (14 marks)
(b) An outside company has offered to undertake all painting and decorating work for a three year period 2013 to 2015 for a fixed fee of £135 000 per annum.
(i) Calculate whether the offer should be accepted on financial grounds using the information available in the question.
(ii) List and comment upon other factors which should be taken into account by Rosrock Housing Association management when considering this offer.