Premium Tables: Monthly Rates by Plan & Tier
This lesson is part of the course
In this lesson
You look up an employee's premium in a plan × tier rate table with a two-way lookup, multiply a rate grid by an enrolment grid with SUMPRODUCT, and find the average premium per head and the tier that drives the bill.
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