Interactive model · Excel decision-support system
💰 Hospital Profit Simulator
The same formulas as the Excel DSS, running live. Pick a state, drag any input, and watch revenue flow down to net income. For Ohio, the presets replay the three plans that cleared the $850K target.
Formulas: revenue = volume × unit rate · bed revenue = beds × cost per bed × hospitals · deductions 5% · salaries $16,000 + 1.5 × beds × hospitals · benefits 12% · supplies $210 + 8.5% of revenue · fees $2,200 · depreciation $1,250 (per 1,000 population).
Net income
–
Gap to $850K target
–
Total revenue
–
Profit margin
–
net income ÷ total revenue
From revenue to net income
Each step adds or subtracts. Bars animate when an input changes.
Which lever moves net income most?
Change in net income if each input rises 10% from its current value