Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Need help solving Requirement 6 where "the total predicted hospital overhead, when $25000 nursing hours are predicted for the month is...?"
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Reporting And Analysis

Authors: Earl K. Stice, James D. Stice

7th Edition

0324227329, 978-0324227321

More Books

Students also viewed these Accounting questions