Assignment Instructions: Use the following budget assumptions that include both inpatient and outpatient revenue and expense. The assumptions are as follows, and you will use them to calculate and develop the As Budgeted, the Actual Budget, and the Static Budget Variance. Assess the impact of the variances in revenues and expenses.

Initial budget:

• The budget anticipated 45,000 inpatient days this year at an average of $725 revenue per day.
• Inpatient expenses were budgeted at $625 per patient day.
• The budget anticipated 13,000 outpatient visits this year at an average of $425 revenue per visit.
• Outpatient expenses were budgeted at $400 per visit.

Actual results:

• Assume that only 92 percent of the inpatient days are going to actually be achieved for the year.
• The average revenue of $675 per day will be achieved for these inpatient days.
• The outpatient visits will actually amount to 113 percent for the year.
• The average revenue of $405 per visit will be achieved for these visits.
• Further assume that, due to the heroic efforts of the hospital employees working with the finance department, the actual inpatient expenses were decreased to 94% of budget and the actual outpatient expenses were decreased to 85% of budget.

The format required: A chart with columns that say "As Budgeted, Actual, Static Budget Variance." Then, Evaluate and discuss the results of your calculation as to what created the variances in revenue, expenses, and excess of revenue over expenses. Did the actual results have a positive or negative effect? Determine what caused this effect.