This article looks at the various methods of re-apportioning service cost centre costs
When calculating unit costs under absorption costing principles each cost unit is charged with its direct costs and an appropriate share of the organisation’s total overheads (indirect costs). An appropriate share means an amount that reflects the time and effort that has gone into producing the cost unit.
Service cost centres are those that exist to provide services to other cost centres in the organisation. They do not work directly on producing the final product. Consequently, their costs must be re-apportioned to production cost centres so that their overheads can be absorbed into the final product. This article looks at the various methods of re-apportioning service cost centre costs.
This is the simplest method and is ideal to use when service cost centres provide services to production cost centres, but not to each other. Example 1 considers such a situation.
Example 1
A company’s overheads have been allocated and apportioned to its five cost centres as shown below.
| Prod. cost centre A | Prod. cost centre B | Prod. cost centre C | Prod. cost centre D | Prod. cost centre E |
|
|---|---|---|---|---|---|
| Apportioned and Allocated overhead ($) | 80,000 | 100,000 | 10,000 | 20,000 | 4,000 |
Usage of service cost centres is as follows:
| Cost centre | A | B |
|---|---|---|
| Use of C's services | 40% | 60% |
| Use of D's services | 75% | 25% |
| Use of E's services | 30% | 70% |
In this situation, service cost centre overheads are simply ‘shared out’ on the basis of usage. For example, production cost centre A should be charged with 40%, 75% and 30% respectively of cost centre C and D and E’s overhead costs. This would result in the following re-apportionment.
| Prod. cost centre A | Prod. cost centre B | Service cost centre C | Service cost centre D | Service cost centre E |
|
|---|---|---|---|---|---|
| Apportioned and Allocated overhead ($) | 80,000 | 100,000 | 10,000 | 20,000 | 4,000 |
| Cost centre C re-apportionment ($) | 4,000 | 6,000 | (10,000) | ||
| Cost centre D re-apportionment ($) | 15,000 | 5,000 | (20,000) | ||
| Cost centre E re-apportionment ($) | 1,200 | 2,800 | (4,000) | ||
| TOTAL OVERHEADS | 100,200 | 113,800 | nil | nil | nil |
Tip: To check that you have not made any arithmetic errors, check that overhead ‘going in’ ($80,000 + $100,000+ $10,000 + $20,000 +$4,000 = $214,000) equals overhead ‘going out’ ($100,200 + $113,800 =$214,000)
This approach is best used where some service cost centres provide services to other service cost centres, but these services are not reciprocated. Example 2 considers this situation. Cost centre C serves centres D and E, but D and E do not reciprocate by serving C. In these circumstances the costs of the service cost centre that serves most other service cost centres should be reapportioned first. We then ‘step down’ to the service cost centre that provides the second most service, and so on.
Example 2
Data as Example 1 apart from usage of C, D and E’s services has changed.
Usage of service cost centres is as follows:
| Cost centre | A | B | C | D | E | |
|---|---|---|---|---|---|---|
| Use of C's services | 40% | 50% | nil | 8% | 2% | |
| Use of D's services | 75% | 20% | nil | nil | 5% | |
| Use of E's services | 30% | 70% | nil | nil | nil |
| Prod. cost centre A | Prod. cost centre B | Service cost centre C | Service cost centre D | Service cost centre E |
|
|---|---|---|---|---|---|
| Apportioned and Allocated overhead ($) | 80,000 | 100,000 | 10,000 | 20,000 | 4,000 |
| Cost centre C re-apportionment ($) | 4,000 | 5,000 | (10,000) | 800 | 200 |
| Cost centre D re-apportionment ($) | 15,600 | 4,160 | (20,800) | 1,040 | |
| Cost centre E re-apportionment ($) | 1,572 | 3,668 | 5,240 | ||
| TOTAL OVERHEADS ($) | 101,172 | 112,828 | nil | nil | nil |
This approach is used where some service cost centres provide services to other service cost centres, and the service is reciprocated. In Example 3, cost centre C serves centre D, and vice versa. In reality, an organisation may choose to ignore this reciprocal service and re-apportion overheads by using the direct or step down approach. In Example 3, the direct approach would involve re-apportioning C’s overhead on the basis of 40/90 and 50/90 to A and B respectively and ignoring the reciprocal service to D. D’s overheads would be similarly reapportioned on the basis of 75/95 and 20/95.
However, if we choose to fully reflect the reciprocal services between C and D, one of two methods are possible – the repeated distribution approach or the algebraic approach. Both are methods of solving a simultaneous equation and should give the same result. Example 3 demonstrates both methods. In the exam, the examiner will indicate that he wants you to use one or either of these methods by asking for a method that ‘fully reflects the reciprocal services involved’. Practically in the FMA/MA exam, where this topic would be examined by two-mark questions, the focus will be on the algebraic approach as repeated distribution would be too time consuming.
Example 3
Data as Example 1 apart from usage of C and D’s services has again changed.
Usage of service cost centres is as follows:
| Cost centre | A | B | C | D | E | |
|---|---|---|---|---|---|---|
| Use of C's services | 40% | 50% | nil | 10% | nil | |
| Use of D's services | 75% | 20% | 5% | nil | nil | |
| Use of E's services | 30% | 70% | nil | nil | nil |
| Prod. cost centre A | Prod. cost centre B | Service cost centre C | Service cost centre D | Service cost centre E |
|
|---|---|---|---|---|---|
| Apportioned and Allocated overhead ($) | 80,000 | 100,000 | 10,000 | 20,000 | 4,000 |
| Cost centre E re-apportionment ($) (note 1) | 1,200 | 2,800 | (4,000) | ||
| Cost centre C re-apportionment ($) (note 2) | 4,000 | 5,000 | (10,000) | 1,000 | |
| Cost centre D re-apportionment ($) | 15,750 | 4,200 | 1,050 | (21,000) | |
| Cost centre C re-apportionment ($) | 420 | 525 | (1,050) | 105 | |
| Cost centre D re-apportionment (note 3) | 83 | 22 | nil | (105) | |
| TOTAL OVERHEADS ($) | 101,453 | 112,547 | nil | nil | nil |
Note 1 E’s costs are apportioned directly as no reciprocal service is involved.
Note 2 It doesn’t really matter which of the two remaining cost centres you start with.
Note 3 On the last reapportionment, D’s overheads are apportioned on the basis of 75/95 to A and 20/95 to B. The reciprocal service to C is ignored as, by now, it is not material.
Firstly, we can setup the overhead re-apportionment process as a set of equations.
Let:
A = the total overhead $ apportioned to department A
B = the total overhead $ apportioned to department B, etc
Then:
A = 80,000 + 0.40 C + 0.75 D + 0.30 E
B = 100,000 + 0.50 C + 0.20 D + 0.70 E
C = 10,000 + 0.05 D
D = 20,000 + 0.10 C
E = 4,000
If you remember your school maths, you will note that the equations for C and D are simultaneous – ie C is a function of D, and D is a function of C. These two equations must be solved first. Various approaches are possible to solve simultaneous equations but substitution is probably quickest.
Substituting the D equation into the C equation:
C = 10,000 + 0.05 (20,000 + 0.10 C)
Multiplying out the bracket:
C = 10,000 + 1000 + 0.005 C
Collecting terms:
0.995 C = 11,000
C = 11,055.3
Substituting into the D equation:
D = 20,000 + 0.10 × 11,055.3
D = 21,105.5
Finally, plugging these values into the equations for A and B, the total overhead apportioned to each of the production cost centres is:
A = 80,000 + 0.40 × 11,055.3 + 0.75 × 21,105.5 + 0.3 × 4,000
A = 101,451.2
B = 100,000 + 0.50 × 11,055.3 + 0.20 × 21,105.5 + 0.7 × 4,000
B = 112, 548.8
These results, as they should be, are quite close to the repeated distribution approach.
The following question is representative of questions on this topic that you might experience in the FMA/MA exam.
A company has two production cost centres (V and W) and two service cost centres (X and Y). The following overheads have been apportioned and allocated to the four cost centres.
| Cost centre | V | W | X | Y |
|---|---|---|---|---|
| Apportioned and Allocated overhead ($) | 6,000 | 8,000 | 4,000 | 10,000 |
The company has calculated the following usage of X and Y’s services.
| Cost centre | V | W | X | Y |
|---|---|---|---|---|
| Use of X's services | 60% | 30% | nil | 10% |
| Cost of Y's services | 80% | 20% | nil | nil |
How much would cost centre V’s total overhead cost be if the company used the step-down approach to re-apportion service cost centre overhead?
A $10,400
B $10,720
C $16,400
D $16,720
The correct answer is D ($6,000 + $4,000 × 0.6 + 0.8 × ($10,000 + 0.1 × $4,000))
Written by a member of the management accounting examining team