Per Member Per Month Calculator

Enter costs, members, and months for clear monthly PMPM outputs. Compare targets and trend variance. Export clean reports for planning, audits, and pricing decisions.

Calculator Inputs

Formula Used

Gross Cost = Claims Cost + Pharmacy Cost + Administrative Cost + Quality Cost + Other Cost + Fixed Fees

Recoveries = Rebates + Stop Loss Recoveries + Other Recoveries

Net Cost = Gross Cost - Recoveries

Member Months = Manual Member Months, or Average Members × Months

Average Members = (Starting Members + Ending Members) ÷ 2

PMPM = Net Cost ÷ Member Months

Target Variance = Final PMPM - Target PMPM

Variance Percent = Target Variance ÷ Target PMPM × 100

How to Use This Calculator

  1. Enter all cost categories that apply to your report.
  2. Enter rebates, refunds, and recoveries as positive values.
  3. Select the member month method.
  4. Use average members when only starting and ending members are known.
  5. Use manual member months when your source report already provides them.
  6. Add target PMPM and prior PMPM for variance checks.
  7. Press the calculate button.
  8. Download the CSV or PDF report for records.

Example Data Table

Scenario Net Cost Member Months PMPM Target PMPM Status
Base Plan $315,500 26,100 $12.09 $12.50 Below target
High Claim Month $385,000 26,100 $14.75 $12.50 Above target
Improved Recovery $298,000 26,100 $11.42 $12.50 Below target

Per Member Per Month Calculation Guide

Per member per month, often called PMPM, is a simple ratio with powerful use. It converts many costs into one monthly member value. Teams use it for health plans, memberships, subscriptions, employee benefits, service contracts, and budget planning.

Why PMPM Matters

Raw totals can hide the real cost pattern. A plan with more members may spend more money, yet still perform better per member. PMPM solves this problem. It divides net eligible cost by member months. The result shows a clean unit cost. It helps managers compare periods, vendors, products, and groups.

Main Cost Parts

Start with all allowed costs. These may include claims, service costs, administration, pharmacy, support, quality programs, and other fixed fees. Then subtract recoveries. Examples include rebates, stop loss credits, refunds, discounts, or shared savings. The remaining value is the net cost used in the final PMPM calculation.

Member Months Explained

Member months measure coverage time. If 100 members stay active for 12 months, the plan has 1,200 member months. When membership changes, use average members times months. You can also enter manual member months when your report already contains that figure. Accurate member months make the final result more reliable.

Using PMPM for Decisions

A PMPM result can support pricing, reserves, contract review, and trend checks. Compare the calculated PMPM with a target value. A positive variance means the cost is above target. A negative variance means the cost is below target. Prior PMPM comparison also shows whether performance improved or worsened.

Best Practices

Keep cost categories consistent between periods. Do not mix gross and net values without notes. Confirm that recoveries relate to the same period. Use the same member month method for every comparison. Review unusual changes before making decisions. Export the result for records, meetings, and audit trails. Clear inputs also reduce review time. Shared definitions help teams explain results, defend budgets, and spot problems before costs grow too quickly each cycle.

Final Thoughts

PMPM is not a full financial model by itself. It is a clear starting point. When combined with trend, risk, utilization, and contract terms, it becomes a useful management measure. This calculator gives a structured way to create that measure quickly.

FAQs

What does PMPM mean?

PMPM means per member per month. It divides net cost by total member months. The result shows the monthly cost for one member.

What is a member month?

A member month is one member covered for one month. For example, 500 members covered for 6 months equal 3,000 member months.

Should rebates be entered as negative numbers?

No. Enter rebates as positive values. The calculator subtracts rebates and other recoveries from gross cost to produce net cost.

When should I use manual member months?

Use manual member months when your source report already provides the exact figure. This is often more accurate than estimating average members.

What is target variance?

Target variance compares calculated PMPM with your target PMPM. A positive value is above target. A negative value is below target.

Can this calculator compare different plans?

Yes. Calculate each plan separately. Then compare PMPM, gross PMPM, recovery PMPM, and variance values using the exported reports.

Why is annualized PMPM included?

Annualized PMPM shows the monthly member value over twelve months. It helps with planning, pricing, budgeting, and yearly comparisons.

Does PMPM replace detailed financial analysis?

No. PMPM is a helpful summary measure. Use it with trend, risk, utilization, contract terms, and operational review for better decisions.

Related Calculators

Paver Sand Bedding Calculator (depth-based)Paver Edge Restraint Length & Cost CalculatorPaver Sealer Quantity & Cost CalculatorExcavation Hauling Loads Calculator (truck loads)Soil Disposal Fee CalculatorSite Leveling Cost CalculatorCompaction Passes Time & Cost CalculatorPlate Compactor Rental Cost CalculatorGravel Volume Calculator (yards/tons)Gravel Weight Calculator (by material type)

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.