90.2K

Verified Solution

Link Copied!

Need help solving Requirement 6 where "the total predicted hospital overhead, when $25000 nursing hours are predicted for the month is...?"

Regression analysis using nursing hours SUMMARY OUTPUT - Nursing hours as cost driver Regression Statistics Multiple R 0984895 R Square 0.970018 Adjusted R Square 0.962523 Standard Error 9,883.836352 Observations ANOVA SS MS Regression 12,642,572 449 12,642,572,449 Residual 390 760,884 97 690 221 Total 13,033,333,333 129.414926 Significance F 0.000341 Standard t Stat Coefficients 131,004 69 14 26 Error 30,448 454 1 253 Lower 95% 46.466 228 10.777 Intercept X Variable 1 Upper 95% 215,543.149 17.735 P-value 0.013 0.000 4,303 11.376 Print Done * Data Table - X Month July August September October November December Hospital Overhead Costs 476,000 512,000 424,000 448.000 555,000 431,000 Nursing Hours 24,000 26,000 20,000 22,500 30,000 22.000 Number of Overhead Cost Overhead Cost Patient Days per Nursing Hour per Patient Day 3,720 $ 12796 4.320 S 10.00 $ 118 52 4.220 S 21.20 $ 100 47 3.470 $ 1001S 129. 11 18.50 $ 97 54 3210 S 1959 S 134 27 5 690 S Print Done Requirement 5. Use the high-low method to determine the hospital's cost equation using nursing hours as the cost driver Predict total overhead costs if 25,000 nursing hours are predicted for the month Use the high-low method to determine the hospital's cost equation using nursing hours as the cost driver (Round the variable cost to the nearest cont) y = $ 1310 +$ 162.000 Predict total overhead costsit 25.000 nursing hours are predicted for the month The total predicted overhead costs for the month is $ 480,500 Requirement 6. McKnight runs a regression analysis using nursing hours as the cost driver to predict total hospital overhead costs. The Excel output from the regression analysis is as follows m (Click the icon to view the regression s ) 125,000 nursing hours are predicted for the month, what is the total predicted hospital overhead? (Round your answer to the nearest cent) The total predicted hospital overhead when 25.000 nursing hours are predicted for the month iss Enter any number in the edt fields and then click Check

Answer & Explanation Solved by verified expert

See Answer