The Enrolment Snapshot: Plans, Coverage Tiers & Waivers
This lesson is part of the course
In this lesson
You turn an open-enrolment list into a plan × tier grid with COUNTIFS, measure the waived share and the enrolled headcount of a department, and see which plan most people pick: the counts every benefits budget is built on.
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
- The Enrolment Snapshot: Plans, Coverage Tiers & Waivers Locked
- Premium Tables: Monthly Rates by Plan & Tier Locked
- Who Pays What: Employer Contribution Strategies Locked
- Renewal Scenarios: Rate Increases & Plan Migration Locked
- Flexible Allowances: Credits, Take-Up & the Expected Spend Locked
- Retirement Matching: Tiered Match Formulas & Participation Locked
- Total Benefits Cost: Per Head, % of Payroll & New-Hire Proration Locked
- Capstone: The Benefits Budget Dashboard Locked