Activity-based costing for a service company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity The activity usage information associated with the two patients is as follows: Activity Rate Room and meals Radiology $280 per day $195 per image Pharmacy $50 Chemistry lab $110 per physician order per test Operating room $1,030 per operating room hour Abel Putin Cheryl Umit Number of days 9 days 5 days Number of images 5 images 4 Images Number of physician orders 6 orders 4 orders Number of tests 7 tests 4 tests Number of operating room hours 9 hours 4 hours This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Determine the activity cost associated with each patient. Abel Putin Cheryl Umit b. Why is the total activity cost different for the two patients? apparently had a different condition that required more extensive treatment. Thus, the activity cost to is more than the activity cost of the other patient. File Home Insert Draw Page Layout Formulas Data Review View Help Editin Arial 10 A A B I U H ab C26 x fx A B D E G 1 2 Activity-based costing for a service company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: 3 4 5 DATA 6 Activity Activity Rate 7 Room and meals 8 Radiology 9 Pharmacy 10 Chemistry lab 11 Operating room 12 3456782222 13 $280 per day $195 per image $50 order $110 per test $1,030 room hour The activity usage information associated with the two patients is as follows: 14 15 16 DATA Abel Putin 17 Number of days 18 Number of images 19 Number of physician orders 20 Number of tests 9 days 5 images 6 orders 7 tests 21 Number of operating room hours 9 hours Cheryl Umit 5 days 4 images 4 orders 4 tests 4 hours Using formulas and cell references, perform the required analysis, and input your answers into Activity Cost column. Transfer the numeric results for the green entry cells (C26:C27) into the 23 appropriate fields in CNOWv2 for grading. 24 25 a. 26 Abel Putin 27 Cheryl Umit 28 29 Activity Cost Formulas