Statistical Profile — FRANKLIN COUNTY MEMORIAL HOSPITAL
CCN 281311 | FRANKLIN, NE | 3 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
14
Beds
$6.1M
Net Revenue
-7.7%
Op Margin
2.5%
Occupancy
3
Outlier Flags
Statistical Outliers (3)
Metrics where this hospital is >2 standard deviations from the national mean. Investigate in diligence — could signal operational issues or data quality problems.
- Medicare Day %: +2.7σ above national mean
- Commercial Payer %: -2.4σ below national mean
- Net-to-Gross Ratio: +2.8σ above national mean
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and NE (n=98) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | NE Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 14 | 63 | 23 | -0.65σ | P4 ▼ | P9 ▼ |
| Net Patient Revenue | $6.1M | $59.7M | $30.3M | -0.46σ | P4 ▼ | P4 ▼ |
| Operating Expenses | $6.6M | $62.7M | $31.1M | -0.45σ | P3 ▼ | P4 ▼ |
| Net Income | -473,729 | $-2.1M | $-1.3M | +0.08σ | P60 | P65 |
| Gross Patient Revenue | $6.4M | $186.6M | $46.5M | -0.46σ | P2 ▼ | P3 ▼ |
| Total Patient Days | 129 | 12,073 | 1,684 | -0.61σ | P1 ▼ | P0 ▼ |
| Medicare Day % | 88.4% | 30.9% | 59.9% | +2.72σ | P99 ▲ | P96 ▲ |
| Medicaid Day % | 0.8% | 5.1% | 3.5% | -0.69σ | P12 | P18 |
| Operating Margin | -7.7% | -4.8% | -6.3% | -0.06σ | P43 | P46 |
| Revenue per Bed | 437,895 | $1.2M | $1.4M | -0.54σ | P19 | P8 ▼ |
| Occupancy Rate | 2.5% | 53.7% | 22.8% | -1.94σ | P1 ▼ | P0 ▼ |
| Commercial Payer % | 10.9% | 61.2% | 35.0% | -2.35σ | P1 ▼ | P4 ▼ |
| Net-to-Gross Ratio | 96.1% | 33.3% | 66.0% | +2.75σ | P98 ▲ | P94 ▲ |
| Expense per Bed | 471,732 | $1.2M | $1.4M | -0.45σ | P20 | P7 ▼ |
| Revenue per Patient Day | 47,523 | 7,054 | 16,039 | +0.10σ | P97 ▲ | P95 ▲ |
| Payer Diversity Index | 0.207 | 0.473 | 0.459 | -1.60σ | P9 ▼ | P4 ▼ |
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% | $6.1M | $9.8M | -0.01σ |
| Operating Margin | 2.1% | -0.0773 | -0.0909 | +0.07σ |
| Occupancy Rate | 44.3% | 0.0252 | 0.2238 | -1.09σ |
| Revenue Per Bed | 2.6% | 437,895 | $1.4M | -0.50σ |
| Net To Gross Ratio | 22.4% | 0.9613 | 0.5974 | +2.10σ |