Statistical Profile — MERCY MEDICAL CENTER
CCN 351334 | WILLIAMS, ND | 0 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
25
Beds
$85.2M
Net Revenue
-14.2%
Op Margin
53.1%
Occupancy
0
Outlier Flags
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and ND (n=52) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | ND Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 25 | 63 | 25 | -0.59σ | P16 | P38 |
| Net Patient Revenue | $85.2M | $59.7M | $15.3M | -0.29σ | P57 | P86 |
| Operating Expenses | $97.3M | $62.7M | $16.6M | -0.27σ | P59 | P87 |
| Net Income | $-12.1M | $-2.1M | $-1.7M | +0.00σ | P25 | P19 |
| Gross Patient Revenue | $198.1M | $186.6M | $23.1M | -0.36σ | P51 | P86 |
| Total Patient Days | 4,846 | 12,073 | 2,584 | -0.52σ | P33 | P63 |
| Medicare Day % | 26.9% | 30.9% | 48.6% | -0.35σ | P40 | P23 |
| Medicaid Day % | 6.1% | 5.1% | 6.8% | -0.26σ | P56 | P45 |
| Operating Margin | -14.2% | -4.8% | -9.3% | -0.39σ | P29 | P31 |
| Revenue per Bed | $3.4M | $1.2M | 642,170 | +0.99σ | P94 ▲ | P96 ▲ |
| Occupancy Rate | 53.1% | 53.7% | 34.1% | +0.05σ | P49 | P65 |
| Commercial Payer % | 67.0% | 61.2% | 38.3% | +0.38σ | P63 | P85 |
| Net-to-Gross Ratio | 43.0% | 33.3% | 71.0% | +0.22σ | P66 | P22 |
| Expense per Bed | $3.9M | $1.2M | 739,987 | +0.96σ | P96 ▲ | P96 ▲ |
| Revenue per Patient Day | 17,574 | 7,054 | 9,099 | -0.01σ | P85 | P88 |
| Payer Diversity Index | 0.475 | 0.473 | 0.472 | +0.27σ | P51 | P50 |
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% | $85.2M | $16.6M | +0.27σ |
| Operating Margin | 2.1% | -0.1422 | -0.0529 | -0.47σ |
| Occupancy Rate | 44.3% | 0.5311 | 0.5361 | -0.03σ |
| Revenue Per Bed | 2.6% | $3.4M | $1.6M | +0.92σ |
| Net To Gross Ratio | 22.4% | 0.4300 | 0.3668 | +0.36σ |