i I want to know the step by step>

how the numbers come from

please use excel

Score: 0.21 of 2 pts 2 of 5 (2 complete) HW Score: 21.73%, 2.17 of 10 %x P5-36 (similar to) s Question Help Riddick'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?" (Click the icon to view the budgeted information.) (Click the icon to view additional information.) Data Table Read the requirements Requirement 1. Calculate the budgeted cost per service for X-rays, ultrasounds, CT scans, and MRI using direct technician labor costs Riddick's Radiology Center Budgeted Information for the year Ended May 31, 2017 Start by calculating the budgeted overhead rate for total indirect costs based on total labor. First select the formula, then enter the applica cost, DL = Direct labor, $ = dollar.) X-rays Ultrasound CT scan MRI Total Technician labor $ 117,450 $ 169,000 $ 156,000 $ 596,450 Total indirect costs Total technician labor cost Budgeted overhead rate $ 1.10 per DL $ 154,000 $ 201,000 Depreciation 106,800 300,200 1,300,000 $ 656,095 $ 596,450 692,000 30,700 Materials 22,000 16,100 24,100 92,900 Now calculate the total budgeted costs for each service and the budgeted cost per each service using direct technician labor costs as the Administration 18,620 CT scan MRI Maintenance 260,000 X-rays 117,450 $ Ultrasound 154,000 $ Technician labor $ 169,000 $ Sanitation 156,000 692,000 271,425 106,050 Depreciation 106,800 Utilities Materials 201,000 16,100 169,400 300,200 24,100 185,900 30,700 $ 246,250 $ 22,000 129,195 371,100 $ 493,300 $ 878,700 $ 2,645,445 Total 171,600 Indirect costs 2,555 4,760 3,290 2,695 $ 375,445 $ 540,500 $ 679,200 $ 1,050,300 Total budgeted costs Number of procedures Minutes to clean after each procedure Minutes for each procedure 10 10 20 40 $ 146.95 $ 113.55 $ 206.44 $ 389.72 5 20 15 40 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 usi Print Done This question is complete Move your cursor over or tap on the red arrows to see incorrect answers Homework: Chapter 5 Homework Save Score: 0.21 of 2 pts 2 of 5 (2 complete) HW Score: 21.73%, 2.17 of 10 pt %x P5-36 (similar to) s Question Help Riddick'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?" E: (Click the icon to view the budgeted information.) (Click the icon to view additional information.) Data Table Read the requirements Begin by calculating the cost driver rate per activity. (Round the answers to five decimal places, "X.XXXXX".) Cost Cost driver rate Administration $ 18,620 Total quantity of cost driver 13,300 = 1,300,000 = $ Total Maintenance 260,000 $ 1.40 per procedure 0.20 per $ of depreciation 1.10 per cleaning minute 0.40 per procedure minute Riddick's Radiology Center Budgeted Information for the year Ended May 31, 2017 X-rays Ultrasound CT scan MRI Technician labor $ 117,450 $ 154,000 $ 169,000 $ 156,000 $ Depreciation 106,800 201,000 300,200 692,000 Materials 22,000 16,100 24,100 30,700 596,450 Sanitation 271,425 246,750 = $ 1,300,000 Utility 106,050 265,125 $ 92,900 Administration Now calculate the budgeted cost for each service and the budgeted cost per service using activity-based costing. (Round costs to the ne 18,620 260,000 Maintenance CT scan MRI Sanitation X-rays Ultrasound 117,450 $ 154,000 $ 271,425 106,050 Technician labor $ 169,000 $ 156,000 Utilities Depreciation 106,800 201,000 300,200 692,000 $ 246,250 $ 371,100 $ 493,300 $ 878,700 $ 2,645,445 Total Materials 22,000 16,100 6,664 24,100 4,606 30,700 3,773 2,555 4,760 3,290 2,695 Administration 3,577 Number of procedures Minutes to clean after each procedure Minutes for each procedure 10 10 20 40 Maintenance 21,360 5 20 15 40 Sanitation 28,105 5,110 40,200 52,360 38,080 60,040 72,380 19.740 138,400 118,580 43, 120 Utilities Print Done This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers. All parts showing Similar Question Homework: Chapter 5 Homework Save Score: 0.21 of 2 pts 2 of 5 (2 complete) HW Score: 21.73%, 2.17 of 10 pts %x P5-36 (similar to) Question Help Riddick'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?" E: (Click the icon to view the budgeted information.) (Click the icon to view additional information.) Data Table Read the requirements Materials 22.000 16,100 24,100 30.700 Administration 3,577 6,664 4,606 3,773 21,360 Maintenance 40,200 60,040 138,400 Total Riddick's Radiology Center Budgeted Information for the year Ended May 31, 2017 X-rays Ultrasound CT scan MRI Technician labor $ 117,450 $ 154,000 $ 169,000 $ 156,000 $ Depreciation 106,800 201,000 300,200 692,000 Materials 22,000 16,100 24,100 30,700 Sanitation 596,450 28,105 5,110 52,360 38,080 72,380 19,740 118,580 43,120 1,300,000 Utilities $ 304,402 $ 508,404 $ 650,066 $ 1,182,573 Total budgeted costs Administration 92,900 18,620 260,000 $ 119.14 $ 106.81 $ 197.59 $ 438.80 Budgeted cost per service Maintenance Requirement 3. Explain how the disaggregation of information could be helpful to RRC's intention to continuously improve its services. Sanitation 271,425 106,050 Using the disaggregated activity-based costing data, Utilities $ 246,250 $ 371,100 $ 493,300 $ 878,700 $ 2,645,445 Total 2,555 4,760 3,290 2,695 O A. Managers can see that the X-ray actually costs substantially more than the MRI, ultrasounds, and CT scans. This is why the num B. Managers can see that the CT scans are extremely more costly than the x-rays, ultrasounds, or MRI's. This causes managers to C. Managers can see that the MRI actually costs substantially more and x-rays, ultrasounds, and CT scans substantially less than th ways to reduce the activity costs. OD. Managers can see that the ultrasounds actually cost the same as the other group of activities. Managers should feel indifferent in Number of procedures Minutes to clean after each procedure Minutes for each procedure 10 10 20 40 5 20 15 40 Print Done This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers. All parts showing Similar Question Score: 0.21 of 2 pts 2 of 5 (2 complete) HW Score: 21.73%, 2.17 of 10 %x P5-36 (similar to) s Question Help Riddick'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?" (Click the icon to view the budgeted information.) (Click the icon to view additional information.) Data Table Read the requirements Requirement 1. Calculate the budgeted cost per service for X-rays, ultrasounds, CT scans, and MRI using direct technician labor costs Riddick's Radiology Center Budgeted Information for the year Ended May 31, 2017 Start by calculating the budgeted overhead rate for total indirect costs based on total labor. First select the formula, then enter the applica cost, DL = Direct labor, $ = dollar.) X-rays Ultrasound CT scan MRI Total Technician labor $ 117,450 $ 169,000 $ 156,000 $ 596,450 Total indirect costs Total technician labor cost Budgeted overhead rate $ 1.10 per DL $ 154,000 $ 201,000 Depreciation 106,800 300,200 1,300,000 $ 656,095 $ 596,450 692,000 30,700 Materials 22,000 16,100 24,100 92,900 Now calculate the total budgeted costs for each service and the budgeted cost per each service using direct technician labor costs as the Administration 18,620 CT scan MRI Maintenance 260,000 X-rays 117,450 $ Ultrasound 154,000 $ Technician labor $ 169,000 $ Sanitation 156,000 692,000 271,425 106,050 Depreciation 106,800 Utilities Materials 201,000 16,100 169,400 300,200 24,100 185,900 30,700 $ 246,250 $ 22,000 129,195 371,100 $ 493,300 $ 878,700 $ 2,645,445 Total 171,600 Indirect costs 2,555 4,760 3,290 2,695 $ 375,445 $ 540,500 $ 679,200 $ 1,050,300 Total budgeted costs Number of procedures Minutes to clean after each procedure Minutes for each procedure 10 10 20 40 $ 146.95 $ 113.55 $ 206.44 $ 389.72 5 20 15 40 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 usi Print Done This question is complete Move your cursor over or tap on the red arrows to see incorrect answers Homework: Chapter 5 Homework Save Score: 0.21 of 2 pts 2 of 5 (2 complete) HW Score: 21.73%, 2.17 of 10 pt %x P5-36 (similar to) s Question Help Riddick'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?" E: (Click the icon to view the budgeted information.) (Click the icon to view additional information.) Data Table Read the requirements Begin by calculating the cost driver rate per activity. (Round the answers to five decimal places, "X.XXXXX".) Cost Cost driver rate Administration $ 18,620 Total quantity of cost driver 13,300 = 1,300,000 = $ Total Maintenance 260,000 $ 1.40 per procedure 0.20 per $ of depreciation 1.10 per cleaning minute 0.40 per procedure minute Riddick's Radiology Center Budgeted Information for the year Ended May 31, 2017 X-rays Ultrasound CT scan MRI Technician labor $ 117,450 $ 154,000 $ 169,000 $ 156,000 $ Depreciation 106,800 201,000 300,200 692,000 Materials 22,000 16,100 24,100 30,700 596,450 Sanitation 271,425 246,750 = $ 1,300,000 Utility 106,050 265,125 $ 92,900 Administration Now calculate the budgeted cost for each service and the budgeted cost per service using activity-based costing. (Round costs to the ne 18,620 260,000 Maintenance CT scan MRI Sanitation X-rays Ultrasound 117,450 $ 154,000 $ 271,425 106,050 Technician labor $ 169,000 $ 156,000 Utilities Depreciation 106,800 201,000 300,200 692,000 $ 246,250 $ 371,100 $ 493,300 $ 878,700 $ 2,645,445 Total Materials 22,000 16,100 6,664 24,100 4,606 30,700 3,773 2,555 4,760 3,290 2,695 Administration 3,577 Number of procedures Minutes to clean after each procedure Minutes for each procedure 10 10 20 40 Maintenance 21,360 5 20 15 40 Sanitation 28,105 5,110 40,200 52,360 38,080 60,040 72,380 19.740 138,400 118,580 43, 120 Utilities Print Done This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers. All parts showing Similar Question Homework: Chapter 5 Homework Save Score: 0.21 of 2 pts 2 of 5 (2 complete) HW Score: 21.73%, 2.17 of 10 pts %x P5-36 (similar to) Question Help Riddick'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?" E: (Click the icon to view the budgeted information.) (Click the icon to view additional information.) Data Table Read the requirements Materials 22.000 16,100 24,100 30.700 Administration 3,577 6,664 4,606 3,773 21,360 Maintenance 40,200 60,040 138,400 Total Riddick's Radiology Center Budgeted Information for the year Ended May 31, 2017 X-rays Ultrasound CT scan MRI Technician labor $ 117,450 $ 154,000 $ 169,000 $ 156,000 $ Depreciation 106,800 201,000 300,200 692,000 Materials 22,000 16,100 24,100 30,700 Sanitation 596,450 28,105 5,110 52,360 38,080 72,380 19,740 118,580 43,120 1,300,000 Utilities $ 304,402 $ 508,404 $ 650,066 $ 1,182,573 Total budgeted costs Administration 92,900 18,620 260,000 $ 119.14 $ 106.81 $ 197.59 $ 438.80 Budgeted cost per service Maintenance Requirement 3. Explain how the disaggregation of information could be helpful to RRC's intention to continuously improve its services. Sanitation 271,425 106,050 Using the disaggregated activity-based costing data, Utilities $ 246,250 $ 371,100 $ 493,300 $ 878,700 $ 2,645,445 Total 2,555 4,760 3,290 2,695 O A. Managers can see that the X-ray actually costs substantially more than the MRI, ultrasounds, and CT scans. This is why the num B. Managers can see that the CT scans are extremely more costly than the x-rays, ultrasounds, or MRI's. This causes managers to C. Managers can see that the MRI actually costs substantially more and x-rays, ultrasounds, and CT scans substantially less than th ways to reduce the activity costs. OD. Managers can see that the ultrasounds actually cost the same as the other group of activities. Managers should feel indifferent in Number of procedures Minutes to clean after each procedure Minutes for each procedure 10 10 20 40 5 20 15 40 Print Done This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers. All parts showing Similar