Prior medical-plan amount
Give me the comparable monthly medical-plan amount from the prior period.
Group Health Renewal Check
Give me the prior and renewal medical-plan amounts and the enrolled employee count for both periods. I will show you how much of the movement follows enrollment and what remains in average cost per enrolled employee.
I will work through the numbers first, then show you what I would verify before drawing a conclusion about the renewal.
The total can rise because more employees are enrolled, because average cost per enrolled employee changed, or because both moved. I start by separating those pieces before I ask what caused them.
You only need the renewal figures and enrollment counts you already have.
Give me the comparable monthly medical-plan amount from the prior period.
Give me the comparable monthly amount at renewal.
Give me enrolled employees for both periods.
I will show you the total movement, the enrollment change, the prior average applied to today's enrollment, and the movement that remains in average cost per enrolled employee.