Statistical Profile — MCHS-RED CEDAR
CCN 521340 | DUNN, WI | 0 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
25
Beds
$123.4M
Net Revenue
16.8%
Op Margin
64.8%
Occupancy
0
Outlier Flags
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and WI (n=150) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | WI Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 25 | 63 | 36 | -0.59σ | P16 | P17 |
| Net Patient Revenue | $123.4M | $59.7M | $79.3M | -0.21σ | P64 | P69 |
| Operating Expenses | $102.7M | $62.7M | $77.8M | -0.26σ | P60 | P58 |
| Net Income | $20.7M | $-2.1M | 98,676 | +0.23σ | P90 ▲ | P85 |
| Gross Patient Revenue | $261.2M | $186.6M | $186.6M | -0.33σ | P56 | P60 |
| Total Patient Days | 5,912 | 12,073 | 5,437 | -0.50σ | P37 | P52 |
| Medicare Day % | 57.3% | 30.9% | 33.4% | +1.17σ | P86 | P91 ▲ |
| Medicaid Day % | 9.2% | 5.1% | 4.9% | -0.02σ | P69 | P84 |
| Operating Margin | 16.8% | -4.8% | 0.4% | +1.16σ | P90 ▲ | P88 |
| Revenue per Bed | $4.9M | $1.2M | $1.9M | +1.78σ | P98 ▲ | P95 ▲ |
| Occupancy Rate | 64.8% | 53.7% | 45.7% | +0.51σ | P65 | P83 |
| Commercial Payer % | 33.6% | 61.2% | 59.8% | -1.25σ | P12 | P4 ▼ |
| Net-to-Gross Ratio | 47.3% | 33.3% | 39.0% | +0.42σ | P72 | P67 |
| Expense per Bed | $4.1M | $1.2M | $1.8M | +1.05σ | P96 ▲ | P90 |
| Revenue per Patient Day | 20,877 | 7,054 | 12,920 | +0.00σ | P89 | P73 |
| Payer Diversity Index | 0.551 | 0.473 | 0.492 | +0.80σ | P84 | P87 |
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% | $123.4M | $52.8M | +0.28σ |
| Operating Margin | 2.1% | 0.1680 | -0.0775 | +1.29σ |
| Occupancy Rate | 44.3% | 0.6479 | 0.4110 | +1.30σ |
| Revenue Per Bed | 2.6% | $4.9M | $1.6M | +1.77σ |
| Net To Gross Ratio | 22.4% | 0.4726 | 0.4975 | -0.14σ |