Radhika'sRadiology 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?"

Data Table

Radhika's Radiology Center Budgeted Information for the year Ended May 31, 2017
	X-rays	Ultrasound	CT scan	MRI	Total
Technician labor	$80,000	$111,000	$164,000	$113,200	$468,200
Depreciation	42,240	256,000	424,960	876,800	1,600,000
Materials	22,100	16,900	23,800	31,100	93,900
Administration					20,800
Maintenance					272,000
Sanitation					252,300
Utilities					157,200
	$144,340	$383,900	$612,760	$1,021,100	$2,864,400
Number of procedures	2,900	4,400	3,100	2,600
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	Number of procedures
Maintenance (including parts)	Capital cost of the equipment (use Depreciation)
Sanitation	Total cleaning minutes
Utilities	Total procedure minutes

Requirement 1. Calculate the budgeted cost per service for X-rays, ultrasounds, CT scans, and MRI using direct technician labor costs as the allocation basis.

Start by calculating the budgeted overhead rate for total indirect costs based on total labor. First select the formula, then enter the applicable amounts and calculate the rate. (Round your answer to two decimal places, X.XX. Abbreviations used: DC = Direct cost, DL = Direct labor, $ = dollar.)

	/		=	Budgeted overhead rate
	/		=

Now calculate the total budgeted costs for each service and the budgeted cost per each service using direct technician labor costs as the allocation basis. (Round the budgeted cost per service to the nearest cent.)

	X-rays
Technician labor
Depreciation
Materials
Indirect costs
Total budgeted costs
Budgeted cost per service

Ultrasound

CT scan

MRI

Requirement 2. Calculate the budgeted cost per service of X-rays, ultrasounds, CT scans, and MRI if RRC allocated overhead costs using activity-based costing.

Begin by calculating the cost driver rate per activity. (Round the answers to five decimal places, "X.XXXXX".)

		/		=	Cost driver rate
Administration		/		=

Maintenance

/

=

Sanitation

/

=

Utility

/

=

Now calculate the budgeted cost for each service and the budgeted cost per service using activity-based costing. (Round costs to the nearest whole dollar. Then round the cost per service to the nearest cent.)

	X-rays
Technician labor
Depreciation
Materials
Administration
Maintenance
Sanitation
Utilities
Total budgeted costs
Budgeted cost per service

Ultrasound

CT scan

MRI

Requirement 3. Explain how the disaggregation of information could be helpful to RRC's intention to continuously improve its services.

Using the disaggregated activity-based costing data,

A.

Managers can see that the X-ray actually costs substantially more than the MRI, ultrasounds, and CT scans. This is why the number of procedures for this method of activity is the lowest for each group of activity.

B.

Managers can see that the CT scans are extremely more costly than the x-rays, ultrasounds, or MRI's. This causes managers to focus on ways of reducing the number of procedures so costs can stay at a minimum.

C.

Managers can see that the MRI actually costs substantially more and x-rays, ultrasounds, and CT scans substantially less than the traditional system indicated. Managers should examine the use of maintenance and sanitation activities to search for ways to reduce the activity costs.

D.

Managers can see that the ultrasounds actually cost the same as the other group of activities. Managers should feel indifferent in trying to obtain ways to continuously improve in this area.

plz using computer writing, not hand writing

Requirement 1. Calculate the budgeted cost per service for X-rays, ultrasounds, CT scans, and MRI using direct technician labor costs as the allocation basis. Start by calculating the budgeted overhead rate for total indirect costs based on total labor. First select the formula, then enter the applicable amounts and calculate the rate. (Round your answer to two decimal places, X.XX. Abbreviations used: DC = Direct cost, DL = Direct labor, $ = = dollar.) Budgeted overhead rate = Now calculate the total budgeted costs for each service and the budgeted cost per each service using direct technician labor costs as the allocation basis. (Round the budgeted cost per service to the nearest cent.) X-rays Ultrasound CT scan MRI Technician labor Depreciation Materials Indirect costs Total budgeted costs Budgeted cost per service Requirement 2. Calculate the budgeted cost per service of X-rays, ultrasounds, CT scans, and MRI if RRC allocated overhead costs using activity-based costing. Begin by calculating the cost driver rate per activity. (Round the answers to five decimal places, "X.XXXXX".) Cost driver rate Administration Maintenance II Sanitation Utility Now calculate the budgeted cost for each service and the budgeted cost per service using activity-based nearest whole dollar. Then round the cost per service to the nearest cent.) X-rays Ultrasound CT scan MRI per $ of depreciation per cleaning minute per procedure per procedure minute Technician labor Depreciation Materials Administration Maintenance Sanitation Utilities Total budgeted costs Budgeted cost per service