Navigate to the tab titled $$Hosp A Operating Budget$.$ The cells in this sheet are locked except the

cells outlined in red. Your goal is to determine what changes can be reasonably and prudently made to

the budget to meet the governing board$$s targeted net income of $$3\mathrm{.}75$ million. You may change any of

the cells highlighted in red.

For each change made, record that change in the worksheet titled $$Ops Budget Action Plan$$ along

with the other requested information as outlined in the $$Ops Budget Action Plan$$ worksheet. Operating Budget $-$ Hospital A $120$ Beds

NOTE: ONLY ENTER OR ADJUST NUMBERS IN RED OUTLINED CELLS!

Volume Statistics

Admissions

$\%$ Increase vs$.$ PY

Surgeries

$\%$ Increase vs$.$ PY

Prices $($Chargemaster$)$

Gross Revenue$/$admission

Gross Revenue$/$surgery

Deductions

Contractual Allowances

$\%$ of Gross Revenue

Charity

$\%$ of Gross Revenue

Bad Debt

$\%$ of Gross Revenue

Net Revenue

Expenses

Salaries, Wages, Benefits $($SWB$)$

Supplies

Repair & Maintenance

Contract Services

Rents & Leases

Utilities

Other Operating Expenses

Total Operating Expenses

EBITDA $($Earnings Before Interest, Taxes, Depreciation, Amortization$)$

Total Gross Revenue $(\text{'}000$s$)$