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.

The blue check mark means that this solution has been answered and checked by an expert. This guarantees that the final answer is accurate.
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)

Related Answered Questions