Question 3.6: You can use the following short example to practise the tech...
You can use the following short example to practise the techniques which we have covered so far in this chapter.
The information given below relates to the forthcoming period for a manufacturer’s operation. There are four cost centres of which two are involved in production and two are service cost centres.
Production depts | Service depts | ||||
Total | A | B | Canteen | Stores | |
£ | £ | £ | £ | £ | |
Allocated costs | 70,022 | 21,328 | 29,928 | 8,437 | 10,329 |
Other costs: | |||||
Rent and rates | 4,641 | ||||
Buildings insurance | 3,713 | ||||
Electricity and gas | 6,800 | ||||
Plant depreciation | 28,390 | ||||
Plant insurance | 8,517 | ||||
122,083 | |||||
Area occupied (square metres) | 7,735 | 6,188 | 1,547 | 3,094 | |
Plant at cost (£000) | 1,845 | 852 | __ | 142 | |
Number of employees | 600 | 300 | 30 | 70 | |
Machine hours | 27,200 | 800 | __ | __ | |
Direct labour hours | 6,800 | 18,000 | __ | __ | |
Number of stores requisitions | 27,400 | 3,400 | __ | __ |
Use this information to calculate a production overhead absorption rate for departments A and B.
Learn more on how we answer questions.
The first step is to prepare an overhead analysis sheet which shows the apportionment of the overheads, using the most appropriate basis for each.
Overhead item | Basis of apportionment | Total | Dept A | Dept B | Canteen | Stores |
£ | £ | £ | £ | £ | ||
Allocated costs | 70,022 | 21,328 | 29,928 | 8,437 | 10,329 | |
Rent and rates 1 | Area | 4,641 | 1,934 | 1,547 | 387 | 773 |
Buildings insurance | Area | 3,713 | 1,547 | 1,238 | 309 | 619 |
Electricity and gas | Area | 6,800 | 2,833 | 2,267 | 567 | 1,133 |
Depreciation | Plant cost | 28,390 | 18,450 | 8,520 | _ | 1,420 |
Insurance | Plant cost | 8,517 | 5,535 | 2,556 | __–___ | 426 |
122,083 | 51,627 | 46,056 | 9,700 | 14,700 | ||
Canteen | Employees | – | 6,000 | 3,000 | (9700) | 700 |
Stores 3 | Requisitions | – | 13,700 | 1,700 | __–___ | (15,400) |
122,083 | 71,327 | 50,756 | __–__ | __–___ |
Notes
1. The rent and rates cost is apportioned as follows. Total area occupied is 18,564 square metres. Therefore, rent and rates cost £4,641/18,564 = £0.25 per square metre.
All of the other apportionments are calculated in the same way.
2. Since the canteen serves all other departments, its costs must be apportioned first, over the 970 employees in the other departments
3. Once the stores have received a charge from the canteen, the total stores costs can be apportioned to the production departments.
Looking at the data for machine hours and direct labour hours in each of the departments, it appears that the most appropriate absorption base for department A is machine hours and for department B is direct labour hours. The absorption rates can now be calculated.
Production department A = £71,327/27,200 = £2.62 per machine hour
Production department B = £50,756/18,000 = £2.82 per direct labour hour
We can now extend the example a little further to practise using the calculated absorption rates. What is the total production cost of the following job ?
Job 847
Direct material cost £487
Direct labour cost £317
Machine hours in department A 195
Direct labour hours in department B 102
The overhead absorption rates can be applied as follows:
Job 847
£
Direct material cost * 487.00
Direct labour cost * 317.00
Prime cost 804.00
Production overhead:
Department A 195 hours ×£2.62 510.90
Department B 102 hours × £2.82 287.64
Total production cost 1602.54
Remember that direct costs are not affected by the overhead absorption rate selected.
See if you can calculate the under- or over-absorbed overhead in each of the departments using the following data. The actual overhead incurred would have been determined by the allocation and apportionment of the actual overhead costs.
Department A Department B
Actual results
Overhead incurred £70,483 £52,874
Direct labour hours 6,740 18,300
Machine hours 27,900 850
The first step is to calculate how much overhead would have been absorbed, based on the actual hours and the predetermined overhead absorption rate for each department. This total can then be compared with the actual overhead incurred
Department A Department B
£ £
Overhead absorbed
27,900 × £2.62 73,098
18,300 × £2.82 51,606
Overhead incurred 70,483 52,874
(Under-)/over-absorption 2,615 (1,268)