In: Accounting
Clean Tube Laboratories (CTL) contracts with area hospitals to perform various lab tests for outpatients. CTL is organized into four departments – two support departments (Maintenance and Administration) and two patient departments (Traditional Tests and DNA Tests). The traditional tests department tends to be more labor-intensive, while the DNA Tests department is equipment intensive.
As a part of a push to convert to a responsibility accounting system, management wants to determine the total costs to operate the Traditional Tests and DNA Tests departments. Management wants to allocate, to the two patient departments, the Maintenance department costs based on the depreciation dollars and the Administration department costs on the basis of labor hours recorded by employees in each department.
The following data (with dollar amounts in thousands) appear in the organization’s records for the current period:
Department | Total Costs | Labor Hours |
Depreciation $ (included in total cost) |
Maintenance | $10,000 | 1,000 | $1,000 |
Administration | $15,000 | 2,000 | $2,000 |
DNA Tests | $30,000 | 3,000 | $8,000 |
Traditional Tests | $40,000 | 4,000 | $5,000 |
Total | $95,000 | 10,000 | $16,000 |
1. Allocate the support department costs to the patient departments using the direct method.
2. Allocate the support department costs to the patient departments using the step-down method and starting with the Maintenance Department
3. Allocate the support department costs to the patient departments using the reciprocal method (Hint: As an alternative to developing and directly solving for variables in four cost equations via substitution method, the reciprocal solution can be easily accomplished by creating a four-by-four matrix using the Excel "Minverse" command to obtain solution parameters for the four variables. The four-by-four inverted matrix can then be multiplied by the one-by-four cost matrix using the Excel "Mmult" command to obtain the final allocations in dollars.)
4. What would be the next steps to put the new cost information to use?
Direct method | |||||
Allocation ratio | |||||
DNA | Trational | ||||
Maintenance | 0.615384615 | 0.384615385 | |||
=8000/13000 | =5000/13000 | ||||
Administartion | 0.428571429 | 0.571428571 | |||
=3000/7000 | =4000/7000 | ||||
Direct method apportionment | |||||
Maintenance | Adminitartion | DNA Tests | Traditional tests | Total | |
Total costs | 10000 | 15000 | 30000 | 40000 | 95000 |
Maintenance allocation | -10000 | 6153.85 | 3846.15 | 0 | |
=10000*0.615385 | =10000*0.384615 | ||||
Adminitration alloctaion | -15000 | 6428.57 | 8571.43 | 0 | |
=15000*0.428571 | =15000*0.571429 | ||||
Total costs | 0 | 0 | 42582.42 | 52417.58 | 95000 |
Labor hours | 3000 | 4000 | |||
Depreciation | 8000 | 5000 | |||
Per unit cost | 5.32 | 13.10 |
Step-down method allocation | |||||
Administration cost is allocated first based on value | |||||
Maintenance | DNA | Traditional | |||
Administration | 0.222222222 | 0.333333333 | 0.444444444 | ||
=2000/9000 | =3000/9000 | =4000/9000 | |||
Maintenance | 0.615384615 | 0.384615385 | |||
=8000/13000 | =5000/13000 | ||||
Step-down cost apportionment | |||||
Maintenance | Adminitartion | DNA Tests | Traditional tests | Total | |
Total costs | 10000 | 15000 | 30000 | 40000 | 95000 |
Maintenance allocation | -13333.33 | 8205.13 | 5128.20 | 0.00 | |
=13333.33*0.615385 | =13333.33*0.384615 | ||||
Adminitration alloctaion | 3333.33 | -15000.00 | 5000.00 | 6666.67 | 0 |
=15000*0.2222 | =15000*0.33333 | =15000*0.44444 | |||
Total costs | 0.000333333 | 0 | 43205.13 | 51794.87 | 95000 |
Labor hours | 3000 | 4000 | |||
Depreciation | 8000 | 5000 | |||
Per unit cost | 5.40 | 12.95 |
Reciprocal method | |||||
Allocation | |||||
Maintenance | Adminitartion | DNA Tests | Traditional tests | Total | |
Administartion | 0.125 | 0.375 | 0.5 | ||
Labor hours | =1000/8000 | =3000/8000 | =4000/8000 | 0 | |
Maintenance | 0.133333333 | 0.533333333 | 0.333333333 | ||
Depreciation | =2000/15000 | =8000/15000 | =5000/15000 | 0 | |
Administartion | =Administration costs+0.133333Maintenance costs | ||||
Maintenance costs | =Maintenance costs+0.125 administartion costs | ||||
M | =10000+0.125(Administartion costs+0.133333maintenance costs) | ||||
M | =10000+0.125(15000+0.133333maintenance costs) | ||||
M | =10000+1875+0.016666625M | ||||
M-0.016666625M | 11875 | ||||
0.983333375M | 11875 | ||||
M | 12076.27 | ||||
12076 | |||||
A | =15000+0.133333(12076) | ||||
16610.12931 | |||||
16610 | rounded off |
Maintenance | Adminitartion | DNA Tests | Traditional tests | Total | |
Total costs | 10000.00 | 15000.00 | 30000.00 | 40000.00 | 95000.00 |
Maintenance allocation | 2076.27 | -16610.13 | 6228.80 | 8305.07 | 0.00 |
=16610*0.125 | =16610*0.375 | =16610*0.5 | |||
Adminitration alloctaion | -12076.27 | 1610.17 | 6440.68 | 4025.42 | 0.00 |
=12076.27*0.133333 | =12076*0.533333 | =12076*0.33333 | |||
Total costs | 0.00 | 0.04 | 42669.48 | 52330.49 | 95000.00 |
Labor hours | 3000 | 4000 | |||
Related SolutionsOwl-Eye Radiologists (OR) does various types of diagnostic imaging. Radiologists perform tests using sophisticated equipment. OR's...
Owl-Eye Radiologists (OR) does various types of diagnostic imaging.
Radiologists perform tests using sophisticated equipment. OR's
management wants to compute the costs of performing tests for two
different types of patients: those who are hospitalized (including
those in emergency rooms) and those who are not hospitalized but
are referred by physicians. The data for June for the two
categories of patients follow:
Hospital Patients
Other Patients
Total
Units (i.e., procedures) produced
700
840
1,540
Equipment-hours used
240
130
370
Direct...
Owl-Eye Radiologists (OR) does various types of diagnostic imaging. Radiologists perform tests using sophisticated equipment. OR's...Owl-Eye Radiologists (OR) does various types of diagnostic
imaging. Radiologists perform tests using sophisticated equipment.
OR's management wants to compute the costs of performing tests for
two different types of patients: those who are hospitalized
(including those in emergency rooms) and those who are not
hospitalized but are referred by physicians. The data for June for
the two categories of patients follow.
Hospital Patients
Other Patients
Total
Units (i.e., procedures) produced
660
830
1,490
Equipment-hours used
230
120
350
Direct...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|