Plan Dashboard: Actual vs Budget PMPM, Traffic Lights & a Category Chart
This lesson is part of the course
In this lesson
You compare actual PMPM with a fictional budget per category and for the whole plan, flag the categories above budget with a formula rule and chart actual against budget PMPM.
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