Conduct a Budgeting Evaluation

“You are an administrator at Jiranna Healthcare. You have been asked to conduct a budget variance analysis: analyzing performance by comparing budgeted workload, revenue, and expenses for a range of different service lines, with actual workload, revenue, and expenses for those service lines.
Open the document “Variance Analysis Case Study,” where you will find data on the expenses, revenue, and inpatient product lines at Jiranna Healthcare.
Analyze the data and prepare a 3- to 4-page report. In your report, address each of the five following questions. In each case, show the calculations that you conducted to answer the question. Then, explain your conclusion and how your calculations support your reasoning.

-What was the hospital’s original profit forecast (assume away any issues with depreciation, taxes, etc.)? Halfway through the fiscal year, what is the hospital’s revised projection for FY11 profits?
-Which inpatient service lines are over budget? Which inpatient service lines are over budget after accounting for workload increases?
-What two actions would you recommend be taken at the mid-year point if you oversaw a fee-for-service hospital? In other words, where are the problem areas on which you would focus your attention, and who might provide ideas for “”best practices”” based on their performance?
-What two actions would you recommend be taken at the mid-year point if you oversaw a capitated hospital? In this case, the revenue spreadsheet would be replaced with an overall budget of $50 million with which to operate (rather than being able to bill for each episode of patient care). Federal, state, county, and city hospitals normally operate under a capped budget. Additionally, many HMOs also operate under a fixed per member, per month (PMPM) capitated process.”