Jaden Osborne is the Chief Operating Officer at Strong Hospital in Boulder, Colorado. He is analyzing the hospital's overhead costs but is not sure whether nursing hours or the number of patient days would be the best cost driver to use for predicting the hospital's overhead. He has gathered the following information for the last six months of the most recent year: (Click the icon to view the information.) Read the requirements. i Data Table Requirements al's overhead cost per nursing hour and Hospital Month Overhead Costs July .......... $ 472,000 August ..... $ 520,000 September .. 419,000 October ..... $ 456,000 November ... $ 562,000 December ... $ 450.000 GA GA Nursing Hours 22,000 27,500 18,000 20,000 29,000 19.000 Number of Overhead Cost Overhead Cost Patient Days per Nursing Hour per Patient Day 3,680 $ 21.45 $ 128.26 4.380 $ 18.91 $ 118.72 4,240 $ 23.28 $ 98.82 3,430 $ 22.80 $ 132.94 5,620 $ 19.38 $ 100.00 3,220 $ 23.68 $ 139.75 1. Are the hospital's overhead costs fixed, variable, or mixed? Explain 2. Graph the hospital's overhead costs against nursing hours. 3. Graph the hospital's overhead costs against the number of patient days. 4. Do the data appear to be sound or do you see any potential data problems? Explain. 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 22,500 nursing hours are predicted for the month. 6. Osborne 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: Click the icon to view the regression analysis.) If 22,500 nursing hours are predicted for the month, what is the total predicted hospital overhead? 7. Osborne then ran the regression analysis using number of patient days as the cost driver. The Excel output from the regression is shown here: (Click the icon to view the regression analysis.) If 3,800 patient days are predicted for the month, what is the total predicted hospital overhead? 8. Which regression analysis (using nursing hours or using number of patient days as the cost driver) produces the best cost equation? Explain your answer. Print Done Click to select your answer(s) and then click Check Answer. Print Done 10 parts Clear All remaining Check Answer Jaden Osborne is the Chief Operating Officer at Strong Hospital in Boulder, Colorado. He is analyzing the hospital's overhead costs but is not sure whether nursing hours or the number of patient days would be the best cost driver to use for predicting the hospital's overhead. He has gathered the following information for the last six months of the most recent year: (Click the icon to view the information.) Read the requirements. i Data Table Requirements al's overhead cost per nursing hour and Hospital Month Overhead Costs July .......... $ 472,000 August ..... $ 520,000 September .. 419,000 October ..... $ 456,000 November ... $ 562,000 December ... $ 450.000 GA GA Nursing Hours 22,000 27,500 18,000 20,000 29,000 19.000 Number of Overhead Cost Overhead Cost Patient Days per Nursing Hour per Patient Day 3,680 $ 21.45 $ 128.26 4.380 $ 18.91 $ 118.72 4,240 $ 23.28 $ 98.82 3,430 $ 22.80 $ 132.94 5,620 $ 19.38 $ 100.00 3,220 $ 23.68 $ 139.75 1. Are the hospital's overhead costs fixed, variable, or mixed? Explain 2. Graph the hospital's overhead costs against nursing hours. 3. Graph the hospital's overhead costs against the number of patient days. 4. Do the data appear to be sound or do you see any potential data problems? Explain. 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 22,500 nursing hours are predicted for the month. 6. Osborne 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: Click the icon to view the regression analysis.) If 22,500 nursing hours are predicted for the month, what is the total predicted hospital overhead? 7. Osborne then ran the regression analysis using number of patient days as the cost driver. The Excel output from the regression is shown here: (Click the icon to view the regression analysis.) If 3,800 patient days are predicted for the month, what is the total predicted hospital overhead? 8. Which regression analysis (using nursing hours or using number of patient days as the cost driver) produces the best cost equation? Explain your answer. Print Done Click to select your answer(s) and then click Check Answer. Print Done 10 parts Clear All remaining Check