Health Care Finance (ETEXTBOOK), Baker, 4e, ISBN: 9781284061727

Select an organization; either Metropolis Health System from the Chapter 28 Case Study or one of the organizations presented in either Chapter 27 or one of the three MiniCase Studies in Chapters 29-31. 1. Using the organization selected, make a budget for the next fiscal year. Set out the details of all assumptions you needed in order to build this budget. Use the Checklist for Building a Budget (Exhibit 15-2) and critique your own budget. In short, you will submit an excel sheet for your budget (as shown at the bottom of these examples) with "Actual", "Budget", and "Variance". In addition, provided a list of any assumptions that were made or found. Assignment: Budgeting Select an organization; either Metropolis Health System from the Chapter 28 Case Study or one of the organizations presented in either Chapter 27 or one of the three Mini-Case Studies in Chapters 29-31. 1. Using the organization selected, create a budget for the next fiscal year. Set out the details of all assumptions you needed in order to build this budget. Use the Checklist for Building a Budget (Exhibit 15-2) and critique your own budget. In short, you will submit an excel sheet for your budget (as shown at the bottom of these examples) with "Actuar". "Budget", and "Variance". In addition, provided a list of any assumptions that were made or found. Below is an example: 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. - 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 pervisit. - As to the actual results: - Assume that only 27.000, or 90 percent, 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 27.000 inpatient days. - The outpatient visits will actually amount to 110 percent, or 11.000 for the year. - The average revenue of $400 per visit will be achieved for these 1,100 visits. - Further assume that, due to the heroic efforts of the Chief Financial Otficer, the actual inpatient expenses will amount to $16,100,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 13A. 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." SOLUTION: Your initial budget assumptions were as follows: Assume the budget anticipated 30,000 inpatient days this year at an average of $650 revenue per day, or $19,500,000. Further assume that inpatient expenses were budgeted at $600 per patient day, or $18,000,000. Also assume the budget anticipated 10.000 outpatient visits this year at an average of $400 revenue per visit, or $4,000.000. Further assume that outpatient expenses were budgeted at $380 per visit, or $3,800,000. The budget worksheet would look like this: Now assume that only 27,000 , or 90 percent, of the putient days are coing to actually be achieved for the year, The average revenue of $650 per day will be achieved for these 27.000 days (thus 27.000 times 650 equals 17.550.000 ). Also assume thst outpatient visits will actually amount to 110 percent or 11.000 for the year. The average revenue of $400 per visit will be achieved for these 11.000 visits (thus 11.000 times 400 equals 4.400.000. Further assume that. due to the heroic efforts of the Chief Firiancial Oificer, the actual inpatent expenses will amount to $16,100,000 and the actuat outpatient expenses will amount to $4,000,000. The actual results would look like this: Since the budgeted revenues and expenses still reflect the original expectations of 30,000 irpatient days and 10,000 outpatient visits, the budket report would look like this: Note: The negative effect of the $1,550,000 net drep in revenue" is offet by the greater effect of the $1,700,000 net drop in expenses. + resulting in a positive net effect of 5150.000. Select an organization; either Metropolis Health System from the Chapter 28 Case Study or one of the organizations presented in either Chapter 27 or one of the three MiniCase Studies in Chapters 29-31. 1. Using the organization selected, make a budget for the next fiscal year. Set out the details of all assumptions you needed in order to build this budget. Use the Checklist for Building a Budget (Exhibit 15-2) and critique your own budget. In short, you will submit an excel sheet for your budget (as shown at the bottom of these examples) with "Actual", "Budget", and "Variance". In addition, provided a list of any assumptions that were made or found. Assignment: Budgeting Select an organization; either Metropolis Health System from the Chapter 28 Case Study or one of the organizations presented in either Chapter 27 or one of the three Mini-Case Studies in Chapters 29-31. 1. Using the organization selected, create a budget for the next fiscal year. Set out the details of all assumptions you needed in order to build this budget. Use the Checklist for Building a Budget (Exhibit 15-2) and critique your own budget. In short, you will submit an excel sheet for your budget (as shown at the bottom of these examples) with "Actuar". "Budget", and "Variance". In addition, provided a list of any assumptions that were made or found. Below is an example: 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. - 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 pervisit. - As to the actual results: - Assume that only 27.000, or 90 percent, 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 27.000 inpatient days. - The outpatient visits will actually amount to 110 percent, or 11.000 for the year. - The average revenue of $400 per visit will be achieved for these 1,100 visits. - Further assume that, due to the heroic efforts of the Chief Financial Otficer, the actual inpatient expenses will amount to $16,100,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 13A. 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." SOLUTION: Your initial budget assumptions were as follows: Assume the budget anticipated 30,000 inpatient days this year at an average of $650 revenue per day, or $19,500,000. Further assume that inpatient expenses were budgeted at $600 per patient day, or $18,000,000. Also assume the budget anticipated 10.000 outpatient visits this year at an average of $400 revenue per visit, or $4,000.000. Further assume that outpatient expenses were budgeted at $380 per visit, or $3,800,000. The budget worksheet would look like this: Now assume that only 27,000 , or 90 percent, of the putient days are coing to actually be achieved for the year, The average revenue of $650 per day will be achieved for these 27.000 days (thus 27.000 times 650 equals 17.550.000 ). Also assume thst outpatient visits will actually amount to 110 percent or 11.000 for the year. The average revenue of $400 per visit will be achieved for these 11.000 visits (thus 11.000 times 400 equals 4.400.000. Further assume that. due to the heroic efforts of the Chief Firiancial Oificer, the actual inpatent expenses will amount to $16,100,000 and the actuat outpatient expenses will amount to $4,000,000. The actual results would look like this: Since the budgeted revenues and expenses still reflect the original expectations of 30,000 irpatient days and 10,000 outpatient visits, the budket report would look like this: Note: The negative effect of the $1,550,000 net drep in revenue" is offet by the greater effect of the $1,700,000 net drop in expenses. + resulting in a positive net effect of 5150.000