Statistical Profile — THE MERCY HOSPITAL
CCN 220066 | HAMPDEN, MA | 0 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
150
Beds
$276.4M
Net Revenue
-12.5%
Op Margin
61.1%
Occupancy
0
Outlier Flags
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and MA (n=99) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | MA Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 150 | 63 | 125 | +0.09σ | P72 | P58 |
| Net Patient Revenue | $276.4M | $59.7M | $149.8M | +0.12σ | P78 | P65 |
| Operating Expenses | $311.0M | $62.7M | $150.2M | +0.17σ | P81 | P68 |
| Net Income | $-34.7M | $-2.1M | $-15.4M | -0.15σ | P14 | P29 |
| Gross Patient Revenue | $648.3M | $186.6M | $360.1M | -0.13σ | P69 | P64 |
| Total Patient Days | 33,452 | 12,073 | 32,860 | +0.04σ | P72 | P50 |
| Medicare Day % | 25.9% | 30.9% | 33.5% | -0.41σ | P37 | P30 |
| Medicaid Day % | 5.4% | 5.1% | 9.4% | -0.32σ | P52 | P25 |
| Operating Margin | -12.5% | -4.8% | -12.2% | -0.30σ | P32 | P46 |
| Revenue per Bed | $1.8M | $1.2M | $1.4M | +0.19σ | P73 | P68 |
| Occupancy Rate | 61.1% | 53.7% | 70.6% | +0.36σ | P60 | P30 |
| Commercial Payer % | 68.7% | 61.2% | 53.7% | +0.47σ | P67 | P78 |
| Net-to-Gross Ratio | 42.6% | 33.3% | 43.6% | +0.20σ | P66 | P45 |
| Expense per Bed | $2.1M | $1.2M | $1.5M | +0.21σ | P77 | P71 |
| Revenue per Patient Day | 8,262 | 7,054 | 5,549 | -0.04σ | P57 | P77 |
| Payer Diversity Index | 0.458 | 0.473 | 0.530 | +0.15σ | P44 | P26 |
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% | $276.4M | $235.1M | +0.16σ |
| Operating Margin | 2.1% | -0.1255 | -0.0491 | -0.40σ |
| Occupancy Rate | 44.3% | 0.6110 | 0.5420 | +0.38σ |
| Revenue Per Bed | 2.6% | $1.8M | $1.6M | +0.14σ |
| Net To Gross Ratio | 22.4% | 0.4263 | 0.3173 | +0.63σ |