logo

MA Plan ROI Dashboard — Standalone

Synthetic CMS-like data • Benefit & care-mgmt scenarios • Export CSV

Program assumptions

30 $/PMPM
12 $/PMPM
$150,000
0 members

Tips: Use benefit increase to simulate richer benefits (expect enrollment lift). Care mgmt reduces cost PMPM and often gives high ROI.
Top ROI plans (ranked)
Sorted by composite ROI score.
KPIs (top filtered)
Total Annual Margin (top)
$0
Total Underprice Loss (annual)
$0
Projected ΔMargin from benefits (annual)
$0
Projected ΔMargin from care mgmt (one-time adj)
$0
Scatter: Bid gap to break-even (PMPM) vs ROI Score
Detailed table (top filtered)
PlanCountyEnrollBenchmarkBidTrueCostAnnualMarginROI BenefitsROI CareROI Score

Complete Documentation of Calculations and Variables

1. Annual Margin

Formula: Annual Margin = (Benchmark − Bid) × Rebate% × Members × 12

Shows yearly surplus or deficit relative to CMS county benchmarks.

2. Overpriced / Underpriced

PMPM Difference: Benchmark − Bid

Total Annual Impact: (Benchmark − Bid) × Members × 12

Positive → underpriced, Negative → overpriced.

3. ROI – Benefit Enrichment

Formula: ROI_benefits = (Incremental Revenue − Cost of Benefit Enrichment) ÷ Cost of Benefit Enrichment

4. ROI – Care Management

Formula: ROI_care = (Medical Cost Savings − Program Cost) ÷ Program Cost

5. Composite ROI Score

Formula: Composite ROI = w1 × ROI_benefits + w2 × ROI_care

Weighted score to rank plans based on overall improvement potential.

6. Other Variables

7. Interpretation

Positive margins and ROI indicate improvement opportunity; negative values indicate potential loss or overpricing.

ROI Benefits Formula:

ROI_benefits = (Incremental Revenue − Cost of Benefit Enrichment) ÷ Cost of Benefit Enrichment

This measures the return on investment from enriching plan benefits: