Week 5 Part II & Part III Rough Draft
Part II – Forecasting
Forecasting is becoming more and more common in healthcare facilities. Although forecasting may appear similar to predicting the future, forecasting is completed by considering many different external and internal factors that affect a healthcare facility.
Below you will find historical data and current data, as well as a future forecast for a local medical center of total patients seen. After analyzing the data answer the following questions:
(Note: * next to any number represents a forecasted value)
Quarter One |
Quarter Two |
Quarter Three |
Quarter Four |
Total |
|
Previous Year (Actual) |
Jan – 59 Feb – 63 Mar – 27 |
Apr – 70 May – 88 Jun – 95 |
Jul – 97 Aug – 110 Sep – 125 |
Oct – 70 Nov – 50 Dec – 35 |
889 |
Current Year |
Jan – 68 Feb – 60 Mar – 65 |
Apr – 70 May – 90 Jun – 90 |
Jul – 95 Aug – 125 Sep – 120 |
Oct – 65 Nov – *50 Dec – *25 |
923 |
Next Year |
Jan – *64 Feb – *62 Mar – *48 |
Apr – *72 May – *88 Jun – *90 |
July – *100 Aug – *115 Sep – *125 |
Oct – *68 Nov – *50 Dec – *30 |
912 |
Part III – Budgeting in Healthcare
Please respond to the following items regarding budgets in healthcare facilities.
Explain how the four types of budgets are interrelated.
Estimating revenues and cash flow is an important part of a break-even analysis. Changing fee structures will have an impact on budgeting. The following table contains the weighted encounters for the four quarters of the past year for a particular facility; use this information to answer the questions that follow:
Commercial |
Quarter 1 |
Quarter 2 |
Quarter 3 |
Quarter 4 |
Admissions |
1562 |
1670 |
1250 |
1345 |
Follow-Up |
1050 |
900 |
850 |
750 |
Medicare |
||||
Admissions |
1750 |
1230 |
1525 |
1800 |
Follow-Up |
750 |
600 |
955 |
1250 |
Calculate the facilities Commercial Quarter 1 Gross Revenues with the admission fee as $55 and the follow-up fee as $35.
Calculate the facilities Medicare Quarter 1 and 3 Gross Revenues with the admission fee as $55 and the follow-up fee as $35. o Calculate the Net Revenue if the discount for Medicare were 70 percent.
WhatsApp us