6. Timothy, SA., uses a flexible budget for overhead costs. The company expects to produce 40,000 units
of the product it manufactures. Each unit requires 0.40 direct labour hours. The cost formulas for each
of the four overhead items (where X is measured in direct labour hours) is as follows:
Required:
Prepare an overhead budget for the expected activity level for the coming year.
Prepare an overhead budget that reflects production that is 25 per cent lower than
expected.
Power (£0.40 40,000 0.4)
Maintenance [£15,000 + (£0.60 40,000 0.4)]
Indirect labour [£18,000 + (£2.50 40,000 0.4)]
Power (£0.40 30,000 0.40)
Maintenance [£15,000 + (£0.60 30,000 0.40)]
Indirect labour [£18,000 + (£2.50 30,000 0.40)]
(20,000 units/2) 0.75 hours =
Overhead budget:
Power [£1,000 + (£0.25 12,500)]
Maintenance [£5,000 + (£0.40 12,500)]
Indirect labour [£8,000 + (£2 12,500)]
Rent
Total overhead
High activity level: 12,500 1.10 = 13,750
Overhead budget:
Power [£1,000 + (£0.25 13,750)]
Maintenance [£5,000 + (£0.40 13,750)]
Indirect labour [£8,000 + (£2 13,750)]
Rent
Total overhead