Budget assumptions for this exercise include both inpatient and outpatient reven

Question

Budget assumptions for this exercise include both inpatient and outpatient revenue and expense. Assumptions are as follows: As to the initial budget: The budget anticipated 30,000 inpatient days this year at an average of $650 revenue per day. The inpatient expenses were budgeted at $600 per patient day. The budget anticipated 10,000 outpatient visits this year at an average of $400 revenue per visit. Outpatient expenses were budgeted at $380 per visit As to the actual results: Assume that only 27,000 or 90% of the inpatient days are going to actually be achieved for the year. The average revenue of $650 per day will be achieved for these 270,000 inpatient days. The outpatient visits will actually amount to 110%, or 11,000 for the year. The average revenue of $400 per visit will be achieved for these 11,000 visits. Further assume that, due to the heroic efforts of the Chief Financial Officer, the actual inpatient expenses will amount to $11,600,000 and the actual outpatient expenses will amount to $4,000,000 REQUIRED: 1. Set up three worksheets that follow the format of those in Example 15A. However, in each of your worksheets make two lines for revenue; label one as Revenue-Inpatient and the other Revenue--Outpatient. Add a Revenue Subtotal line. Likewise, make two lines for expense; label one as Expense--Inpatient and the other Expense--Outpatient. Add an Expense Subtotal line. 2. Using the new assumptions, complete the first worksheet for "As Budgeted." 3. Using the new assumptions, complete the second worksheet for "Actual." 4. Using the new assumptions, complete the third worksheet for "Static Budget Variance." Complete the excess of revenue over expenses for actual, budget, and static budget variance.

Explanation / Answer

Static Budget Variance   Details Budget Cost Formula per day/visit Static Budget Actual Result Static Budget Variance Fav/UnFav Rate Amt $/Days/Visists No Of Inpatient Days               30,000.0              27,000.0 Budgeted outpatient Visists               10,000.0              11,000.0 Revenue And Cost details Inpatient revenue           650.0          19,500,000                650.0      17,550,000.0    1,950,000 Unfav Outpatient Revenue           400.0         4,000,000.0                400.0        4,400,000.0        400,000 Fav Total revenue       23,500,000.0      21,950,000.0    1,550,000 Unfav Expenses Inpatient Expenses           600.0       18,000,000.0                429.6      11,600,000.0    6,400,000 Fav Outpatient expenses           380.0         3,800,000.0                363.6        4,000,000.0        200,000 Unfav Total Expenses       21,800,000.0      15,600,000.0    6,200,000 Fav Surplus of Revenue over Expense         1,700,000.0        6,350,000.0    4,650,000 Fav

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.