A hospital is analyzing its overhead costs It is not clear whether the number of patient days or nursing hours would be the best cost driver to use in predicting the hospitals overhead The latest information on the hospital is as follows Month Hospital Nursing No of Overhead Overhead Cost Overhead Hours Patient Cost Per Per Patient Costs Days Nursing Hr Day July $950,000 50,000 7,900 $19 00 $120 25 August $1,070,000 52,000 8,900 $20 58 $120 22 September $825,000 40,000 8,700 $20 63 $ 94 83 October $922,500 43,500 6,900 $21 21 $133 70 November $1,150,000 64,000 11,900 $17 97 $ 96 64 December $890,000 41,500 6,750 $21 45 $131 85 Required Graph the hospitals overhead costs against the number of patient days Note This is for your benefit so that you can answer Question 3 you do not need to submit this graph as part of the assignment Graph the hospitals overhead costs against nursing hours Note This is for your benefit so that you can answer Question 3 you do not need to submit this graph as part of the assignment Based on the graphs that you drew, do the data appear to be straight forward or do you see any potential problems with the data (i e, do the data points form straight lines) Please explain Using the high low method, determine the hospitals variable cost per nursing hour, rounded to two decimal places Now that you have calculated both the variable and fixed portions hospital overhead costs, write out the equation for hospital overhead costs using the high low method Using the cost equation that you just wrote, predict hospital overhead costs if 49,000 nursing hours are expended in a month The hospital ran a regression analysis using nursing hours as the cost driver to predict total hospital overhead costs The regression analysis produced the following data Intercept 346245 Slope 12 81796 RSQ 0 909311 Round the variable portion of the regression equation formula to two decimal places Based on the regression equation formula, what will the predicted total hospital overhead costs be if 49,000 nursing hours are expended during a month The hospital then ran a regression analysis using number of patient days as cost driver The regression analysis produced the following data Intercept 559764 Slope 47 970926 RSQ 0 563496482 Again, round the variable portion of the regression equation to two decimal places If 8,500 patient days are predicted for a month, what is the total predicted hospital overhead costs using the regression equation Which regression equation, the one using nursing hours as the cost driver or the one using patient days as the cost driver, produces the most accurate correlation (best explanation of) the predicted hospital overhead costs How do you know that your answer is correct In other words, justify your answer

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 18, 2024

A hospital is analyzing its overhead costs. It is not clear whether the number of patient days or nursing hours would be the best cost

A hospital is analyzing its overhead costs. It is not clear whether the number of patient days or nursing hours would be the best cost driver to use in predicting the hospitals overhead. The latest information on the hospital is as follows:

Month Hospital Nursing No. of Overhead Overhead Cost

Overhead Hours Patient Cost Per Per Patient

Costs Days Nursing Hr. Day

July $950,000 50,000 7,900 $19.00 $120.25

August $1,070,000 52,000 8,900 $20.58 $120.22

September $825,000 40,000 8,700 $20.63 $ 94.83

October $922,500 43,500 6,900 $21.21 $133.70

November $1,150,000 64,000 11,900 $17.97 $ 96.64

December $890,000 41,500 6,750 $21.45 $131.85

Required:

Graph the hospitals overhead costs against the number of patient days. Note: This is for your benefit so that you can answer Question 3; you do not need to submit this graph as part of the assignment.

Graph the hospitals overhead costs against nursing hours. Note: This is for your benefit so that you can answer Question 3; you do not need to submit this graph as part of the assignment.

Based on the graphs that you drew, do the data appear to be straight forward or do you see any potential problems with the data (i.e, do the data points form straight lines)? Please explain.

Using the high-low method, determine the hospitals variable cost per nursing hour, rounded to two decimal places.

Now that you have calculated both the variable and fixed portions hospital overhead costs, write out the equation for hospital overhead costs using the high-low method.

Using the cost equation that you just wrote, predict hospital overhead costs if 49,000 nursing hours are expended in a month.

The hospital ran a regression analysis using nursing hours as the cost driver to predict total hospital overhead costs. The regression analysis produced the following data:

Intercept	346245
Slope	12.81796
RSQ	0.909311

Round the variable portion of the regression equation formula to two decimal places. Based on the regression equation formula, what will the predicted total hospital overhead costs be if 49,000 nursing hours are expended during a month?

The hospital then ran a regression analysis using number of patient days as cost driver. The regression analysis produced the following data:

Intercept	559764
Slope	47.970926
RSQ	0.563496482

Again, round the variable portion of the regression equation to two decimal places. If 8,500 patient days are predicted for a month, what is the total predicted hospital overhead costs using the regression equation?

Which regression equation, the one using nursing hours as the cost driver or the one using patient days as the cost driver, produces the most accurate correlation (best explanation of) the predicted hospital overhead costs. How do you know that your answer is correct? In other words, justify your answer.