In: Accounting
Ridge's Radiology Center (RRC) performs X-rays, ultrasounds, computer tomography (CT) scans, and magnetic resonance imaging (MRI). RRC has developed a reputation as a top radiology center in the state. RRC has achieved this status because it constantly reexamines its processes and procedures. RRC has been using a single, facility-wide overhead allocation rate. The vice president of finance believes that RRC can make better process improvements if it uses more disaggregated cost information. She says, "We have state-of-the-art medical imaging technology. Can't we have state-of-the-art accounting technology?"
1. |
Calculate the budgeted cost per service for X-rays, ultrasounds, CT scans, and MRI using direct technician labor costs as the allocation basis. |
2. |
Calculate the budgeted cost per service of X-rays, ultrasounds, CT scans, and MRI if RRC allocated overhead costs using activity-based costing. |
3. |
Explain how the disaggregation of information could be helpful to RRC's intention to continuously improve its services. |
Ridge's Radiology Center Budgeted Information for the year Ended May 31, 2017 X-rays Ultrasound CT scan MRI Total Technician labor $ 117,450 $ 154,000 $ 169,000 $ 156,000 $ 596,450 Depreciation 106,800 201,000 300,200 692,000 1,300,000 Materials 21,800 16,300 23,700 31,000 92,800 Administration 18,620 Maintenance 260,000 Sanitation 271,425 Utilities 106,050 Total $ 246,050 $ 371,300 $ 492,900 $ 879,000 $ 2,645,345 Number of procedures 2,555 4,760 3,290 2,695 Minutes to clean after each procedure 10 10 20 40 Minutes for each procedure 5 20 15 40
RRC operates at capacity. The proposed allocation bases for overhead are:
Administration |
Number of procedures |
Maintenance (including parts) |
Capital cost of the equipment (use Depreciation) |
Sanitation |
Total cleaning minutes |
Utilities |
Total procedure minutes |
1 | Budgeted overhead rate=Total indirect costs/Total techinician labor cost | |||||||||
Total indirect costs: | ||||||||||
$ | ||||||||||
Administration | 18620 | |||||||||
Maintenance | 260000 | |||||||||
Sanitation | 271425 | |||||||||
Utilities | 106050 | |||||||||
Total | 656095 | |||||||||
Budgeted overhead rate=656095/596450=$1.10 per DL $ | ||||||||||
X-rays | Ultrasound | CT scan | MRI | |||||||
Technician labor | a | 1,17,450 | 1,54,000 | 1,69,000 | 1,56,000 | |||||
Depreciation | 1,06,800 | 2,01,000 | 3,00,200 | 6,92,000 | ||||||
Materials | 21,800 | 16,300 | 23,700 | 31,000 | ||||||
Indirect costs | a*1.10 | 1,29,195 | 1,69,400 | 1,85,900 | 1,71,600 | |||||
Total budgeted costs | b | 3,75,245 | 5,40,700 | 6,78,800 | 10,50,600 | |||||
Number of procedures | c | 2,555 | 4,760 | 3,290 | 2,695 | |||||
Budgeted cost per service | b/c | 146.87 | 113.59 | 206.32 | 389.83 | |||||
2 | (4). Cost | (5). Total quantity of cost driver | Cost driver rate | |||||||
a | b | a/b | ||||||||
Administration | 18620 | Number of procedures | 13300 | 1.4 | Per procedure | |||||
(2555+4760+3290+2695) | ||||||||||
Maintenance | 260000 | Depreciation | 1300000 | 0.20 | Per $ of depreciation | |||||
Sanitation | 271425 | Total cleaning minutes | (Note:1) | 246750 | 1.10 | Per cleaning minute | ||||
Utilities | 106050 | Total procedure minutes | (Note:2) | 265125 | 0.40 | Per procedure minute | ||||
Note:1 | ||||||||||
Total cleaning minutes: | ||||||||||
X-rays | Ultrasound | CT scan | MRI | Total | ||||||
Number of procedures | a | 2,555 | 4,760 | 3,290 | 2,695 | |||||
Minutes to clean after each procedure | b | 10 | 10 | 20 | 40 | |||||
Total cleaning minutes | a*b | 25550 | 47600 | 65800 | 107800 | 246750 | ||||
Note:2 | ||||||||||
Total procedure minutes | ||||||||||
X-rays | Ultrasound | CT scan | MRI | Total | ||||||
Number of procedures | a | 2,555 | 4,760 | 3,290 | 2,695 | |||||
Minutes for each procedure | b | 5 | 20 | 15 | 40 | |||||
Total procedure minutes | a*b | 12775 | 95200 | 49350 | 107800 | 265125 | ||||
X-rays | Ultrasound | CT scan | MRI | |||||||
Technician labor | 1,17,450 | 1,54,000 | 1,69,000 | 1,56,000 | ||||||
Depreciation | 1,06,800 | 2,01,000 | 3,00,200 | 6,92,000 | ||||||
Materials | 21,800 | 16,300 | 23,700 | 31,000 | ||||||
Administration | 3,577 | 6,664 | 4,606 | 3,773 | ||||||
(No.of procedures*cost driver rate) | (2555*1.4) | (4760*1.4) | (3290*1.4) | (2695*1.4) |