# Question

Billie Gable is the Chief Operating Officer at Fremont Hospital in Roseville, Minnesota. She 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. She has gathered the following information for the last six months of the most recent year:

Requirements

1. Are the hospital’s overhead costs fixed, variable, or mixed? Explain.

2. Graph the hospital’s overhead costs against nursing hours. Use Excel or graph by hand.

3. Graph the hospital’s overhead costs against the number of patient days. Use Excel or graph by hand.

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 24,500 nursing hours are predicted for the month.

6. Gable 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:

If 24,500 nursing hours are predicted for the month, what is the total predicted hospi-tal overhead?

7. Gable then ran the regression analysis using number of patient days as the cost driver. The Excel output from the regression is as follows:

If 3,640 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 youranswer.

Requirements

1. Are the hospital’s overhead costs fixed, variable, or mixed? Explain.

2. Graph the hospital’s overhead costs against nursing hours. Use Excel or graph by hand.

3. Graph the hospital’s overhead costs against the number of patient days. Use Excel or graph by hand.

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 24,500 nursing hours are predicted for the month.

6. Gable 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:

If 24,500 nursing hours are predicted for the month, what is the total predicted hospi-tal overhead?

7. Gable then ran the regression analysis using number of patient days as the cost driver. The Excel output from the regression is as follows:

If 3,640 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 youranswer.

## Answer to relevant Questions

Carmichael Industries is in the process of analyzing its manufacturing overhead costs. Carmichael Industries is not sure if the number of units produced or the number of direct labor (DL) hours is the best cost driver to use ...Choose a company with which you are familiar that manufactures a product or provides a service. In this activity, you will be making reasonable estimates of the costs and activities associated with this company; companies do ...Use the information from the Crystal Cruiseline Data Set. Draw a graph of Crystal Cruise-line’s CVP relationships. Include the sales revenue line, the fixed expense line, and the to-tal expense line. Label the axes, the ...Sally has an online poster business. Suppose Sally expects to sell 1,500 posters. Her average sales price per poster is $ 45 and her average cost per poster is $ 25. Her fixed expenses total $ 15,000. Compute her margin of ...Refer to Happy Noodles in E7- 21A. Soo did franchise her restaurant concept. Because of Happy Noodles’ success, Value Noodles has come on the scene as a competitor. To maintain its market share, Happy Noodles will have to ...Post your question

0