Cost per Member per Month: Paid Claims by Category & by Month
This lesson is part of the course
In this lesson
You total six months of paid claims by service category with SUMIFS, divide them by the member months of the same period to get PMPM by category and for the whole plan, and calculate PMPM month by month.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Member Months: Enrolment Dates, Months Covered per Member & the Plan's Exposure Locked
- Cost per Member per Month: Paid Claims by Category & by Month Locked
- Utilisation per 1,000 & Unit Cost: Splitting PMPM into How Often and How Much Locked
- High-Cost Claimants: Cost per Member, Top-Member Share & a Pareto Chart Locked
- Cost Trend: PMPM Year over Year, Utilisation Trend vs Unit-Cost Trend Locked
- Paid vs Incurred: Months of Development, Completion Factors & Claims Still to Come Locked
- Benefit Design Effects: Co-Pays, Deductibles, Out-of-Pocket Maximums & Plan PMPM Locked
- Plan Dashboard: Actual vs Budget PMPM, Traffic Lights & a Category Chart Locked