# Week 5 Part II & Part III Rough Draft Part II – Forecasting, health and medicine homework help

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
• Evaluate the forecasted values on the table. Explain in detail why you agree or disagree with the projected values.
• Identify and explain possible reasons for the change in total patients seen over the three years in the table.
• Forecast how the projected numbers for the three years would affect revenues for the medical center. Explain how these numbers allow the practice manager to estimate the cash flow for the facility.

Part III – Budgeting in Healthcare

Please respond to the following items regarding budgets in healthcare facilities.

• Identify and describe:
• The four types of budgets that are developed by a healthcare facility.
• The components included in a break-even analysis. Evaluate the importance of the break-even analysis and each of its components in managing a healthcare facility.
• Calculate the facilities Commercial Quarter 1 Gross Revenues with the admission fee as \$55 and the follow-up fee as \$35.

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.