A private college has two teaching departments: languages and science. The college also has a library and a staff refectory, both of which provide services to the teaching departments. The library staff also eat in the refectory. The college administrator feels that the benefits of the staff refectory are best measured in proportion to the number of staff in each department. The benefits of the library are best measured in proportion to the number of students in each department. The overhead costs of each department, and other relevant details, are as follows:
|
|
Languages |
Science |
Library |
Refectory |
Total |
|
Overhead costs allocated (£) |
20,000 |
15,000 |
12,000 |
10,000 |
57,000 |
|
Number of staff |
4 |
4 |
2 |
2 |
|
|
Number of students |
400 |
300 |
– |
– |
|
Required
(1) Prepare a cost apportionment of overhead costs using the step method.
(2) Use a computer based spreadsheet to calculate the apportionment of overheads using the repeated distribution method.