Examples
Examples
Try the starting example
- Benefit plans: name, eligible people, employer cost $/enrollee/period, periods in modeled year
- Health,100,50,12 Gym,80,20,12
- Scenario rows: scenario, benefit plan, enrolled people; every plan once per scenario
- Base,Health,50 Base,Gym,20 High,Health,80 High,Gym,40
- Annual employer cost by scenario/plan ($)
- Base/Health: 30000.00; Base/Gym: 4800.00; High/Health: 48000.00; High/Gym: 9600.00
- Total modeled annual cost by scenario ($)
- Base: 34800.00; High: 57600.00
- Enrollment/eligible people by scenario/plan (%)
- Base/Health: 50; Base/Gym: 25; High/Health: 80; High/Gym: 50
- Largest less smallest supplied scenario cost ($)
- $22,800.00
Try another scenario
- Benefit plans: name, eligible people, employer cost $/enrollee/period, periods in modeled year
- Health,100,50,12 Gym,80,10,12
- Scenario rows: scenario, benefit plan, enrolled people; every plan once per scenario
- Base,Health,50 Base,Gym,20 High,Health,80 High,Gym,40
- Annual employer cost by scenario/plan ($)
- Base/Health: 30000.00; Base/Gym: 2400.00; High/Health: 48000.00; High/Gym: 4800.00
- Total modeled annual cost by scenario ($)
- Base: 32400.00; High: 52800.00
- Enrollment/eligible people by scenario/plan (%)
- Base/Health: 50; Base/Gym: 25; High/Health: 80; High/Gym: 50
- Largest less smallest supplied scenario cost ($)
- $20,400.00
Calculation method
Calculation method
Annual employer cost by scenario/plan ($)
Enrolled people×supplied unit-period cost×supplied modeled periods.
Total modeled annual cost by scenario ($)
Sum plan costs; plans may overlap people but not duplicate costs.
Enrollment/eligible people by scenario/plan (%)
Use each plan’s separate eligible denominator; zero eligibility has an undefined rate.
Largest less smallest supplied scenario cost ($)
Compare total costs across supplied scenarios, not a probability forecast.
Symbols and units
- a
- Benefit plans: name, eligible people, employer cost $/enrollee/period, periods in modeled year
- b
- Scenario rows: scenario, benefit plan, enrolled people; every plan once per scenario
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A supplied annual-period benefit-cost scenario, not actual enrollment, insurance advice or a prediction of uptake. Period counts, tax treatment, eligibility and unit costs are not fetched or inferred.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
ILO: supplied workforce records and full-time-equivalent measurement background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.