Statistical Profile — MERCY MEDICAL CENTER-DES MOINES
CCN 160083 | POLK, IA | 2 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
556
Beds
$635.8M
Net Revenue
-5.7%
Op Margin
73.2%
Occupancy
2
Outlier Flags
Statistical Outliers (2)
Metrics where this hospital is >2 standard deviations from the national mean. Investigate in diligence — could signal operational issues or data quality problems.
- Beds: +2.3σ above national mean
- Total Patient Days: +2.2σ above national mean
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and IA (n=124) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | IA Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 556 | 63 | 25 | +2.31σ | P96 ▲ | P98 ▲ |
| Net Patient Revenue | $635.8M | $59.7M | $36.8M | +0.89σ | P91 ▲ | P98 ▲ |
| Operating Expenses | $671.9M | $62.7M | $38.8M | +0.92σ | P92 ▲ | P98 ▲ |
| Net Income | $-36.2M | $-2.1M | $-3.0M | -0.16σ | P13 | P6 ▼ |
| Gross Patient Revenue | $3.23B | $186.6M | $73.9M | +1.23σ | P93 ▲ | P98 ▲ |
| Total Patient Days | 143,393 | 12,073 | 2,364 | +2.17σ | P96 ▲ | P98 ▲ |
| Medicare Day % | 25.1% | 30.9% | 53.5% | -0.44σ | P36 | P7 ▼ |
| Medicaid Day % | 7.4% | 5.1% | 3.2% | -0.16σ | P63 | P73 |
| Operating Margin | -5.7% | -4.8% | -8.2% | +0.04σ | P48 | P65 |
| Revenue per Bed | $1.1M | $1.2M | $1.3M | -0.18σ | P48 | P42 |
| Occupancy Rate | 73.2% | 53.7% | 26.6% | +0.84σ | P76 | P96 ▲ |
| Commercial Payer % | 67.5% | 61.2% | 41.3% | +0.41σ | P64 | P89 |
| Net-to-Gross Ratio | 19.7% | 33.3% | 50.8% | -0.90σ | P17 | P2 ▼ |
| Expense per Bed | $1.2M | $1.2M | $1.4M | -0.15σ | P49 | P39 |
| Revenue per Patient Day | 4,434 | 7,054 | 16,230 | -0.06σ | P28 | P7 ▼ |
| Payer Diversity Index | 0.476 | 0.473 | 0.488 | +0.28σ | P51 | P38 |
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% | $635.8M | $1.11B | -1.86σ |
| Operating Margin | 2.1% | -0.0569 | -0.0393 | -0.09σ |
| Occupancy Rate | 44.3% | 0.7317 | 0.7329 | -0.01σ |
| Revenue Per Bed | 2.6% | $1.1M | $1.8M | -0.34σ |
| Net To Gross Ratio | 22.4% | 0.1967 | 0.2360 | -0.23σ |