Insert Page Layout Data View Home Formulas Review A. Month Medical Supplies costs Number of procedures Number of patient-hours $106,000 320 2,000 230,000 500 3,900 3 1,900 4,100 3 84,000 240 4 4 238,000 520 193,000 240 3,400 3,700 180,000 340 210,000 420 3,100 92,000 360 1,200 10 3,000 9 222,000 78,000 320 10 180 1,300 11 2,800 11 127,000 440 12 12 225,000 380 3,800 13 Regression 1: Medical supplies costs = a + (b x Number of procedures) %3! Variable Coefficient Standard Error t-Value $56,504.86 $ 152.93 $36,939.77 Constant 0.65 $ 361.91 Independent variable: No. of procedures 2.37 2 = 0.36; Durbin-Watson statistic = 2.48 a + (b x Number of patient-hours) Regression 2: Medical supplies costs Variable Coefficient Standard Error t-Value $3,654.86 $ 56.76 $23,569.51 0.16 Constant 7.82 Independent variable: No. of patient-hours 2 = 0.84; Durbin-Watson statistic 7.25 1.91
Regression; choosing among models. Apollo Hospital specializes in outpatient surgeries for relatively minor procedures. Apollo is a nonprofit institution and places great emphasis on controlling costs in order to provide services to the community in an efficient manner.
Apollo’s CFO, Julie Chen, has been concerned of late about the hospital’s consumption of medical supplies. To better understand the behavior of this cost, Julie consults with Rhett Bratt, the person responsible for Apollo’s cost system. After some discussion, Julie and Rhett conclude that there are two potential cost drivers for the hospital’s medical supplies costs. The first driver is the total number of procedures performed. The second is the number of patient-hours generated by Apollo. Julie and Rhett view the latter as a potentially better cost driver because the hospital does perform a variety of procedures, some more complex than others.
Rhett provides the following data relating to the past year to Julie.
Estimate the regression equation for (a) medical supplies costs and number of procedures and (b) medical supplies costs and number of patient-hours. You should obtain the following results:
- On different graphs plot the data and the regression lines for each of the following cost functions:
- Medical supplies costs =a+ (bX Number of procedures)
- Medical supplies costs =a+ (bX Number of patient-hours)
- Evaluate the regression models for “Number of procedures” and “Number of patient-hours” as the cost driver according to the format of Exhibit 10-18 (page 404).
- Based on your analysis, which cost driver should Julie Chen adopt for Apollo Hospital? Explain your answer.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
