Unit 4 IP HCM410 – Healthcare Benchmarking And Quality Analysis
You are a staff member in the finance department at Nouveau Health, whose sole responsibility is to advance the success of the organization through assisting in planning, forecasting, and finance management.
The budget from Unit 1 (now Unit 4 budget spreadsheet); did not take into account the growth of the new facility. The CEO has asked that you expand that budget and provide a finalized budget that will take into account the new services offered. The CEO has stated that there is $3 million that you can incorporate into the budget for additional staffing, services, maintenance, and so forth.
Complete the following 2 part assignment:
- Part I: Complete the Operational budget spreadsheet (see attachment Unit 4 HCM410_Budget)
- Disperse million dollars amongst budget rows with no dollar amount in the ‘Revised 2022’ Column. – See the example below
- Part II: Prepare next year’s financial plan narrative 2-3 pgs.
- Explain why the specified dollar amount was allocated to the corresponding budget line. How that money will be spent and how it will benefit the new facility. – See the example below
Ex. (Part I) Original 2022 Inpatient Budget 27,500,000/ Revised 2022 Inpatient Budget 28,255,000.
Ex. (Part II) The reason/logic for the increase in the inpatient budget is due to orthopedic surgery department improvements.
2021
KRONA HOSPITAL OPERATING BUDGET FOR 2022
Revenues
Inpatient $ 25,000,000
Outpatient 15,000,000
Emergency Room 10,000,000
Laboratory 5,000,000
Pharmacy 1,500,000
Home Health and Hospice 1,500,000
Ambulance Services 950,000
Substance Abuse 250,000
Other 850,000
Subtotal $ 60,050,000
Less Chartiy Care 18,000,000
Net Revenues $ 42,050,000
Expenses
Payroll (including nursing salaries) $ 12,500,000
Benefits 3,000,000
Contract Labor 100,000
Insurance 300,000
General Services (laundary, security, etc) 3,000,000
Depreciation 1,500,000
Interest Expense 300,000
Professional Services 10,000,000
Total Operating Expenses $ 30,700,000
Net Income $ 11,350,000
2022
KRONA HOSPITAL OPERATING BUDGET 2021 2022 Revised 2022
Revenues Disperse three million dollars amongst budget rows with no dollar amount in the ‘Revised 2022’ Column. In Part II of this assignment explain why specified dollar amount was allocated to the corresponding budget line. Ex. (Part I) Original 2022 Inpatient Budget 27,500,000/ Revised 2022 Inpatient Budget 28,255,000. (Part II) Reason/logic for increase is due to orthopedic surgery department improvements.
Inpatient $ 25,000,000 $27,500,000
Outpatient 15,000,000 $17,250,000
Emergency Room 10,000,000 10,000,000
Laboratory 5,000,000 5,000,000
Pharmacy 1,500,000 1575000
Home Health and Hospice 1,500,000 1725000
Ambulance Services 950,000 950,000 950,000
Substance Abuse 250,000 250,000 250,000
Other 850,000 850,000 850,000
Subtotal $ 60,050,000 $65,100,000 $2,050,000
Less Chartiy Care 18,000,000 18,000,000 18,000,000
Net Revenues $ 42,050,000 $47,100,000 -$15,950,000
Expenses
Payroll (including nursing salaries) $ 12,500,000 $13,750,000
Benefits 3,000,000 3,000,000
Contract Labor 100,000 100,000
Insurance 300,000 300,000
General Services (laundary, security, etc) 3,000,000 3,000,000
Depreciation 1,500,000 1,500,000
Interest Expense 300,000 300,000 300,000
Professional Services 10,000,000 10,000,000
Total Operating Expenses $ 30,700,000 $31,950,000 $300,000
Net Income $ 11,350,000 $15,150,000 -$16,250,000
Sheet3