Blog · Board and management reporting · Healthcare
Medicare Advantage analytics compares aggregate cost and utilization summaries on a consistent enrollment base. Work through PMPM, service rates and an exact cost bridge before assigning a financial follow-up.
Medicare Advantage analytics compares aggregate cost and utilization summaries after putting both periods on the same enrollment basis. Use cost per member per month, service rates within each category and an exact reconciliation of the change. The result should identify a financial or reporting question for its owner to investigate.
Start with an approved file containing period, service category, service units and cost. Add a separate enrollment file with member-months for the same covered population. Do not duplicate enrollment across service categories when calculating the overall denominator.
Define cost before comparing it. A paid-cost report and an incurred-cost report answer different questions. If the supplied summary includes estimates for unpaid services, retain those estimates and their valuation date in the report notes. Both periods need a comparable basis and maturity of reporting.
CMS publishes Medicare Advantage contract and enrollment data, including monthly enrollment by contract and plan. Those public files offer enrollment context; use the approved denominator for the exact population and period in your internal cost summary rather than assuming a public count matches it.
The analysis below is financial and operational reporting. It does not price insurance, optimize risk scores, judge medical necessity or process individual claims. For the related provider-business question, see medical practice analytics.
Cost PMPM = Period cost / Period member-months
Utilization per 1,000 member-months = Service units / Member-months × 1,000
Average cost per service unit = Category cost / Category service units
Member-months are the sum of covered membership across the months in the period. Utilization here is explicitly per member-month, not an annualized rate per member-year. Label the time basis wherever the measure appears.
Keep unlike units separate. An office visit and an inpatient admission cannot be added into a meaningful total service count. Costs can be summed across nonoverlapping categories, while each utilization rate keeps its own service definition.
An illustrative US plan supplies comparable summaries for two quarters. Each cost figure uses the same approved incurred-cost definition, and the categories below make up the full scope of this example. They are not presented as the plan's total medical spending.
| Enrollment input | Prior quarter | Current quarter |
|---|---|---|
| Member-months | 12,000 | 13,200 |
Enrollment exposure increased by 13,200 / 12,000 − 1 = 10.0%. The financial summary contains these rows:
| Category | Prior units | Current units | Prior cost (USD) | Current cost (USD) |
|---|---|---|---|---|
| Office visits | 9,600 | 11,220 | 1,440,000 | 1,795,200 |
| Inpatient admissions | 240 | 264 | 2,400,000 | 2,904,000 |
| Cost total | — | — | 3,840,000 | 4,699,200 |
The cost increase is 4,699,200 − 3,840,000 = $859,200, or 22.4%, rounded to one decimal. That exceeds enrollment growth, but the total alone does not tell the team why.
| Category | Prior utilization per 1,000 member-months | Current utilization per 1,000 member-months | Prior cost per unit (USD) | Current cost per unit (USD) | Prior PMPM (USD) | Current PMPM (USD) |
|---|---|---|---|---|---|---|
| Office visits | 800 | 850 | 150 | 160 | 120 | 136 |
| Inpatient admissions | 20 | 20 | 10,000 | 11,000 | 200 | 220 |
| Cost PMPM total | — | — | — | — | 320 | 356 |
For office visits, current utilization is 11,220 / 13,200 × 1,000 = 850. Current cost per unit is 1,795,200 / 11,220 = $160. Multiplying 850 / 1,000 × 160 gives $136 PMPM, which matches 1,795,200 / 13,200.
Overall PMPM increased by 356 − 320 = $36, or 356 / 320 − 1 = 11.25%. The dollar total and PMPM tell different parts of the story: more enrollment and higher spending for each member-month.
Use a fixed order: enrollment first, utilization second, average unit cost last. This order assigns the interactions consistently, so the effects add exactly to the reported change. The general approach is explained in cost variance.
For each category:
Enrollment effect = Change in member-months × Prior category PMPM
Utilization effect = Change in units per member-month × Current member-months × Prior cost per unit
Unit cost effect = Current service units × Change in average cost per unit
| Category | Enrollment effect (USD) | Utilization effect (USD) | Unit cost effect (USD) | Total change (USD) |
|---|---|---|---|---|
| Office visits | 144,000 | 99,000 | 112,200 | 355,200 |
| Inpatient admissions | 240,000 | 0 | 264,000 | 504,000 |
| Total | 384,000 | 99,000 | 376,200 | 859,200 |
The office utilization effect is (850 − 800) / 1,000 × 13,200 × 150 = $99,000. Its unit cost effect is 11,220 × (160 − 150) = $112,200. Enrollment contributes (13,200 − 12,000) × 120 = $144,000.
The final proof is 384,000 + 99,000 + 376,200 = 859,200, exactly the change in total cost. Also check 320 × 12,000 = 3,840,000 and 356 × 13,200 = 4,699,200. Never average category unit costs with different units; weighted averages require an appropriate common basis.
Finance owns the cost-to-ledger reconciliation. Enrollment operations validates member-months. The service reporting owner checks unit definitions, category boundaries and cutoff completeness. Together they can decide whether a difference needs a corrected report or a deeper business review.
The unit cost effect is a change in average cost, not proof of a contract rate increase. A different mix of admissions can move the average even when individual contractual rates have not changed. Similarly, unchanged admissions per member-month does not establish unchanged clinical need.
Keep this management view separate from regulatory reporting. CMS describes Medicare Advantage medical loss ratio as a contract-level percentage of revenue under specified reporting requirements. This cost bridge contains neither the required revenue denominator nor the full reporting adjustments. It cannot establish MLR compliance.
Bring your approved aggregate service cost and utilization summary with its matching member-month file to Covirage. Covirage maps the columns, its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring a sample of your own data.
See Covirage for healthcare teams for the supporting industry context.
PMPM means per member per month. Divide a period's cost by the member-months covered by that cost summary. Member-months add the monthly enrollment counts across the period, so they accommodate enrollment changes that a single quarter-end membership figure would miss.
Yes. A cost and utilization review can use totals by period and service category, plus a separate enrollment summary. The files need consistent coverage, service definitions and accounting cutoffs. Member-level claims are unnecessary for the reconciliations and period comparisons in this example.
No. Cost PMPM divides a defined cost total by member-months. Medicare Advantage medical loss ratio is a separately specified reporting measure involving revenue and defined expense treatment. An internal cost comparison does not establish regulatory MLR or replace its reporting instructions.
No. A higher service rate only shows that the recorded frequency increased on the chosen enrollment base. Population mix, service classification and reporting completeness can affect it. Financial analysts should identify the movement and refer interpretation to the responsible teams without drawing clinical conclusions.