We can use the analysis in Exhibit 11.6 , starting with Administration:
Panel A: Proportions |
|
|
||||
Service Department |
Department’s Direct Costs |
Information Systems |
Administration |
Hilltop Mine |
Pacific Mine |
Total |
Administration |
$5,000,000 |
20% |
–0–% |
50% |
30% |
100% |
Information Systems |
800,000 |
–0– |
–0– |
20 |
80 |
100 |
|
$5,800,000 |
|
|
|
|
|
Panel B: Step Method Allocation |
||||
|
Cost Allocation to |
|||
From |
Information Systems |
Administration |
Hilltop Mine |
Pacific Mine |
Direct costs |
$ 800,000 |
$5,000,000 |
$ –0– |
$ –0– |
Administration |
1,000,000 |
(5,000,000) |
2,500,000 |
1,500,000 |
Information Systems |
(1,800,000) |
–0– |
360,000 |
1,440,000 |
Total |
$ –0– |
$ –0– |
$2,860,000 |
$2,940,000 |
Exhibit 11.6 Service Department Cost Allocation Computations: Step Method—Carlyle Coal Company
|
A |
B |
C |
D |
E |
F |
G |
|
||||||||||||
1 |
|
Service Department |
|
|
|
|||||||||||||||
2 |
|
Information Systems (S1) |
Administration (S2) |
|
|
|
||||||||||||||
3 |
|
Usage |
Percent |
Usage |
Percent |
|
|
|
||||||||||||
4 |
Departments |
(hours) |
of Total |
(employees) |
of Total |
|
|
|
||||||||||||
5 |
Administration |
100,000 |
50% |
–0– |
0% |
|
|
|
||||||||||||
6 |
Information Systems |
–0– |
0 |
2,000 |
20 |
|
|
|
||||||||||||
7 |
Hilltop Mine (P1) |
20,000 |
10 |
5,000 |
50 |
|
|
|
||||||||||||
8 |
Pacific Mine (P2) |
80,000 |
40 |
3,000 |
30 |
|
|
|
||||||||||||
9 |
Total usage |
200,000 |
100% |
10,000 |
100% |
|
|
|
||||||||||||
10 |
|
|
|
|
|
|
|
|
||||||||||||
11 |
|
|
|
|
|
|
|
|
||||||||||||
12 |
Step Method: |
|
Percent Allocable to |
|
|
|||||||||||||||
13 |
|
Department |
Information |
|
Hilltop |
Pacific |
|
|
||||||||||||
14 |
|
Direct Cost |
Systems |
Administration |
Mine |
Mine |
Total |
|
||||||||||||
15 |
Service Department |
|
|
|
|
|
|
|
||||||||||||
16 |
Information Systems (S1) |
$ |
800,000 |
0.0% |
50.0% |
10.0% |
40.0% |
100.0% |
|
|||||||||||
17 |
Administration (S2) |
5,000,000 |
0.0% |
0.0% |
62.5% |
37.5% |
100.0% |
|
||||||||||||
18 |
|
$ 5,800,000 |
|
|
|
|
|
|
||||||||||||
19 |
|
|
|
|
|
|
|
|
||||||||||||
20 |
|
|
Amount Allocable to |
|
|
|||||||||||||||
21 |
|
|
Information |
|
Hilltop |
Pacific |
|
|
||||||||||||
22 |
|
|
Systems |
Administration |
Mine |
Mine |
|
|
||||||||||||
23 |
From |
|
|
|
|
|
|
|
||||||||||||
24 |
Direct department costs |
|
$ 800,000 |
$ 5,000,000 |
$ –0– |
$ |
–0– |
|
|
|||||||||||
25 |
Information Systems (S1) |
|
(800,000) |
400,000 |
80,000 |
320,000 |
|
|
||||||||||||
26 |
Administration (S2) |
|
–0– |
(5,400,000) |
3,375,000 |
2,025,000 |
|
|
||||||||||||
27 |
Total |
|
|
$ –0– |
$ –0– |
$3,455,000 |
$ 2,345,000 |
|
|
|||||||||||
28 |
|
|
|
|
|
|
|
|
|
|||||||||||
|
|
|
|
|
|
|
|
|
||||||||||||