There is an attachment of the Case File -----> But I cannot attach it to this document....Email me if you are interested in answering the question for

Hint: Because of the large number of variances involved, this case can quickly become unmanageable. The best way to deal with this problem is to focus on the variance structure provided in Exhibit 7.5 of the casebook. The spreadsheet model for this case uses this structure, which divides the variances into two general categories: revenue variances and cost variances. Most of the analysis focuses on costs, and the variance definitions used in the model are such that a negative variance means costs are greater than expected.

1. What is the aggregate profit (total) variance for 2009 for the business as a whole? Interpret your results.

2. Now focus on the management variances. Note that the case does not contain data related to supplies costs or fixed costs, so the management variances are, in reality, staffing variances. Break down the staffing variances into rate and efficiency variances both for each product line and, within each product line, by inpatient and outpatient services. Interpret your results.

3. Summarize the results of your variance analysis. In this summary, focus on the underlying meaning of the numbers as opposed to the numbers themselves.

4. What are your recommendations for management action to counter the adverse financial trends experienced in 2009?