Purchase Solution

Not what you're looking for?

RAD Radiology Center performs X-Rays, Ultrasounds, CT Scans, and MRI,s. They can track the direct labor and materials for each procedure fairly easily but they are having difficulties allocating the costs associated with the administration, maintenance, sanitation, and utilities. They currently divide the overhead evenlt between the procedures.

Complete the table below and calculate the cost per procedure using the current method of dividing costs evenly.

X-Rays Ultra CT Scan MRI Total
Technician Labor \$60,000 \$110,000 \$95,000 \$110,000
Depreciation \$30,000 \$280,000 \$450,000 \$900,000
Materials \$20,000 \$25,000 \$25,000 \$30,000
Maintenance \$240,000
Sanitation \$200,000
Utilities \$120,000
Total
#of procedures 400 4,500 3,000 2,500
Cost per procedure

x-rays ultra Ct Scan MRI
Mins to clean after each procedure 5 5 15 35
Mins for each procedure 5 15 20 45

Complete the table using the number of procedures to allocate Administration Costs, depreciation costs to allocate maintenance costs, total cleaning time to allocate sanitaion and total procedure minutes to allocate utilities

x-rays Ultra Ct Scan MRI total
Technician Labor \$60,000 \$110,000 \$95,000 \$110,000
Depreciation \$30,000 \$280,000 \$450,000 \$900,000
Materials \$20,000 \$15,000 \$25,000 \$30,000
Maintenance \$240,000
Sanitation \$200,000
Utilities \$120,000
Total
# of procedures
Cost per procedure

##### Solution Summary

Your tutorial is in Excel so you have a template for future problems like this. The yellow cells are computations and so you can click in the cells and see the calculations. I have shown the "rates" for each allocated pool but there was rounding so I didn't use the rates seen (just let Excel compute the actual amounts without rounding).

##### Solution Preview

Your tutorial is in Excel so you have a template for future problems like this. The ...

Solution provided by:
###### Education
• BSc, University of Virginia
• MSc, University of Virginia
• PhD, Georgia State University
###### Recent Feedback
• "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
• "Thank, this is more clear to me now."
• "Awesome job! "
• "ty"
• "Great Analysis, thank you so much"

##### Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

##### Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.