Statistical Profile — MERCY IOWA CITY REHABILITATION HOSPI
CCN 163026 | JOHNSON, IA | 0 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
40
Beds
$8.3M
Net Revenue
-26.2%
Op Margin
29.7%
Occupancy
0
Outlier Flags
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 | 40 | 63 | 25 | -0.51σ | P36 | P71 |
| Net Patient Revenue | $8.3M | $59.7M | $36.8M | -0.45σ | P6 ▼ | P2 ▼ |
| Operating Expenses | $10.5M | $62.7M | $38.8M | -0.44σ | P6 ▼ | P3 ▼ |
| Net Income | $-2.2M | $-2.1M | $-3.0M | +0.07σ | P49 | P60 |
| Gross Patient Revenue | $17.4M | $186.6M | $73.9M | -0.46σ | P7 ▼ | P4 ▼ |
| Total Patient Days | 4,342 | 12,073 | 2,364 | -0.53σ | P30 | P70 |
| Medicare Day % | 61.6% | 30.9% | 53.5% | +1.38σ | P89 | P71 |
| Operating Margin | -26.2% | -4.8% | -8.2% | -0.98σ | P15 | P5 ▼ |
| Revenue per Bed | 208,491 | $1.2M | $1.3M | -0.66σ | P5 ▼ | P2 ▼ |
| Occupancy Rate | 29.7% | 53.7% | 26.6% | -0.87σ | P24 | P55 |
| Commercial Payer % | 38.4% | 61.2% | 41.3% | -1.01σ | P16 | P35 |
| Net-to-Gross Ratio | 48.0% | 33.3% | 50.8% | +0.46σ | P72 | P43 |
| Expense per Bed | 263,052 | $1.2M | $1.4M | -0.54σ | P7 ▼ | P2 ▼ |
| Revenue per Patient Day | 1,921 | 7,054 | 16,230 | -0.07σ | P17 | P4 ▼ |
| Payer Diversity Index | 0.473 | 0.473 | 0.488 | +0.26σ | P50 | P37 |
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% | $8.3M | nan | +nanσ |
| Operating Margin | 2.1% | -0.2617 | nan | +nanσ |
| Occupancy Rate | 44.3% | 0.2974 | nan | +nanσ |
| Revenue Per Bed | 2.6% | 208,491 | nan | +nanσ |
| Net To Gross Ratio | 22.4% | 0.4804 | nan | +nanσ |