Member Months: Enrolment Dates, Months Covered per Member & the Plan's Exposure
This lesson is part of the course
In this lesson
You count the months each member was covered in 2026 from enrolment dates with YEAR and MONTH, clip enrolments that start before or end after the year, total the plan's member months and count the members on the books at year end.
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