Activity Based Costing for RAD Radiology Center
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
Admin $40,000
Maintenance $240,000
Sanitation $200,000
Utilities $120,000
Total
#of procedures 400 4,500 3,000 2,500
Cost per procedure
Additional information
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
Administartion $40,000
Maintenance $240,000
Sanitation $200,000
Utilities $120,000
Total
# of procedures
Cost per procedure
Please show work..
Purchase this Solution
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 ...
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"
Purchase this Solution
Free BrainMass Quizzes
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.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.