Total Benefits Cost: Per Head, % of Payroll & New-Hire Proration
This lesson is part of the course
In this lesson
You total the benefits cost per department with SUMIFS, express it per head and as a share of payroll, and prorate a new hire whose coverage starts on the first of the next month with EOMONTH and DAYS.
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