Exercise 2 Department and activity-cost rates service sector. Raynham's Radiology Center (RRC) performs 1. X-rays, 2. ultrasounds, 3. computer tomography (CT) scans, and 4. 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?" Raynham's Radiology Center Budgeted Information for the Year Ended May 31, 2014 X-rays Ultrasound CT Scan MRI Total Technician labor $ 62,000 $101.000 S155,000 S 103,000 S 421,000 Depreciation 42,240 256,000 424,960 876,800 1,600,000 Materials 22,600 16,400 23,600 31,500 94,100 Administration 20,000 Maintenance 250,000 Sanitation 252,500 Utilities 151,100 $126,840 $373,400 S603,560 $1,011,300 S2,788,700 Number of procedures 3,842 4,352 2,924 2,482 Minutes to clean after each procedure 5 5 15 35 Minutes for each procedure 5 15 25 40 RRC operates at capacity. The proposed allocation bases for overhead are: Administration Maintenance (including parts) Number of procedures Capital cost of the equipment (use Depreciation) Total cleaning minutes Total procedure minutes Sanitation Utilities Required: 1. Calculate the (total) budgeted cost per procedure) service for X-rays, ultrasounds, CT scans, and MRI using direct technician labor costs as the allocation basis.(simple costing system) 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, 1. BUDGETED MOH BMOHR REQUIREMENT 1 MOH ALLOCATED TO 1. X-rays JOB 1.6 X S62000 = $99,200 2. ULTRASOUND 3. CT SCAN 4. MRI Ultrasound CT scan MRI Total REQUIREMENT 1 Technician labor Depreciation Materials X-rays $ 62,000 42,240 22,600 99,200 Allocated overhead Total budgeted costs of job Budgeted number of procedures TIMES OF SERVICES $226,040 = 3.842 $58.83 Budgeted cost per service Total REQUIREMENT 2. Budgeted Information (TOTAL QUANTITIES OF THE BASE) X-rays Ultrasound CT scan MRI Number of procedures 3,842 Cleaning minutes per procedure X5 Total cleaning minutes 19.210 Number of procedures Minutes for each procedure Total procedure minutes 3,842 x5 19,210 65,280 73.100 99.280 256,870 Units of Cost Driver Activity Rate (3) (4) =() + (3) 13.600 $1.47059 per procedure Activity Budgeted Cost Cost Driver (1) (2) Administration $ 20.000 Total number of procedures Maintenance Total dollars of depreciation Sanitation Total cleaning minutes Utilities Total procedure minutes REQUIREMENT 2 Ultrasound CT Scan MRI Total Technician labor X-rays $ 62,000 42,240 Depreciation Materials 22,600 Allocated activity costs: Administration $1.47059 X ( 3842 4,352 : 2,924 ; 2,482) 5,650 6,400 4,300 3,650 20,000 Maintenance Sanitation Utilities $178,640 $490,200 $781,760 $1,338,100 $2,788,700 Total budgeted cost Baigeted number of procedures Budgeted cost per service + 3.842 $ 46.50 REQUIREMENT 3. Using the disaggregated activity-based costing data, managers can see that the MRI actually costs substantially more and x-rays, ultrasounds, and CT scans substantially less than the traditional system indicated. In particular, the MRI activity generates a lot of maintenance activity and Sanitation activity. Managers should examine the use of these two activities to search for ways to reduce the activity consumption and ultimately its cost. ACCT200