Statistical Profile — MERCY HOSPITAL AURORA
CCN 261316 | LAWRENCE, MO | 0 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
25
Beds
$28.5M
Net Revenue
19.3%
Op Margin
36.1%
Occupancy
0
Outlier Flags
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and MO (n=138) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | MO Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 25 | 63 | 60 | -0.59σ | P16 | P10 |
| Net Patient Revenue | $28.5M | $59.7M | $64.4M | -0.41σ | P32 | P30 |
| Operating Expenses | $23.0M | $62.7M | $68.5M | -0.42σ | P24 | P19 |
| Net Income | $5.5M | $-2.1M | $-1.9M | +0.13σ | P80 | P80 |
| Gross Patient Revenue | $82.2M | $186.6M | $182.7M | -0.42σ | P35 | P34 |
| Total Patient Days | 3,291 | 12,073 | 12,943 | -0.55σ | P25 | P25 |
| Medicare Day % | 23.8% | 30.9% | 30.6% | -0.51σ | P32 | P27 |
| Medicaid Day % | 5.5% | 5.1% | 7.7% | -0.31σ | P53 | P33 |
| Operating Margin | 19.3% | -4.8% | -6.2% | +1.28σ | P92 ▲ | P93 ▲ |
| Revenue per Bed | $1.1M | $1.2M | $1.2M | -0.18σ | P48 | P47 |
| Occupancy Rate | 36.1% | 53.7% | 50.1% | -0.62σ | P30 | P29 |
| Commercial Payer % | 70.7% | 61.2% | 59.9% | +0.57σ | P71 | P83 |
| Net-to-Gross Ratio | 34.7% | 33.3% | 33.2% | -0.18σ | P53 | P54 |
| Expense per Bed | 920,220 | $1.2M | $1.2M | -0.27σ | P37 | P35 |
| Revenue per Patient Day | 8,660 | 7,054 | 7,649 | -0.04σ | P59 | P57 |
| Payer Diversity Index | 0.440 | 0.473 | 0.518 | +0.02σ | P38 | P22 |
Multi-Variable Regression Residuals
For each key metric, the national regression model predicts a value. The residual shows how much this hospital over/under-performs after controlling for all other variables.
| Target | Model R² | Actual | Predicted | Residual |
|---|---|---|---|---|
| Net Patient Revenue | 74.0% | $28.5M | $-1.0M | +0.12σ |
| Operating Margin | 2.1% | 0.1928 | -0.0504 | +1.28σ |
| Occupancy Rate | 44.3% | 0.3607 | 0.5367 | -0.96σ |
| Revenue Per Bed | 2.6% | $1.1M | $1.6M | -0.25σ |
| Net To Gross Ratio | 22.4% | 0.3466 | 0.3484 | -0.01σ |