Page 50 - Erlanger Health System
P. 50
ACTUARIAL
Plug and play: contribution modeling sample
Plug and Play: Contribution Modeling Sample
Sample client
Overall Change
By Plan X Net Cost Neutral Option
By Plan & Band OFF
By Plan & Tier Select BASE Plan
By Plan/ Band/Tier CS PPO Monitor impact to employees
$ or % or Cost Share change? %
CURRENT CONTRIBUTIONS FINAL CONTRIBUTIONS PERCENT CHANGE COST SHARE
HSA Core HSA Core HSA Core HSA Core
HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete
EE $ 79.32 $ 120.99 3.0% 3.0% $ 82.95 $ 124.62 4.6% 3.0% 12.4% 18.7%
ES $ 214.16 $ 255.83 3.0% 3.0% $ 221.83 $ 263.50 3.6% 3.0% 15.9% 18.9%
EE+ Child(ren) $ 175.40 $ 217.07 3.0% 3.0% $ 181.91 $ 223.58 3.7% 3.0% 15.7% 19.3%
Family $ 307.97 $ 349.64 3.0% 3.0% $ 318.46 $ 360.13 3.4% 3.0% 16.1% 18.3%
HSA Plus HSA Plus HSA Plus HSA Plus
HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete
EE $ 125.28 $ 166.95 3.0% 3.0% $ 130.29 $ 171.96 4.0% 3.0% 18.7% 24.7%
ES $ 320.84 $ 362.51 3.0% 3.0% $ 331.72 $ 373.39 3.4% 3.0% 22.7% 25.6%
EE+ Child(ren) $ 262.78 $ 304.45 3.0% 3.0% $ 271.91 $ 313.58 3.5% 3.0% 22.6% 26.1%
Family $ 461.40 $ 503.07 3.0% 3.0% $ 476.49 $ 518.16 3.3% 3.0% 22.9% 24.9%
PPO PPO PPO PPO
HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete
EE $ 229.20 $ 270.87 3.0% 3.0% $ 237.33 $ 279.00 3.5% 3.0% 32.9% 38.7%
ES $ 548.50 $ 590.17 3.0% 3.0% $ 566.21 $ 607.88 3.2% 3.0% 37.4% 40.1%
EE+ Child(ren) $ 449.25 $ 490.92 3.0% 3.0% $ 463.98 $ 505.65 3.3% 3.0% 37.4% 40.8%
Family $ 788.80 $ 830.47 3.0% 3.0% $ 813.71 $ 855.38 3.2% 3.0% 37.4% 39.3%
Total Total Total Total
HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete
EE $ 39,755.52 $ - $ 41,301.96 $ - 3.9% 21.1%
ES $ 30,486.50 $ - $ 31,492.35 $ - 3.3% 29.3%
EE+ Child(ren) $ 16,445.77 $ - $ 17,006.65 $ - 3.4% 26.2%
Family $ 51,132.18 $ - $ 52,788.66 $ - 3.2% 25.9%
5
50 Lockton Companies
Plug and play: contribution modeling sample
Plug and Play: Contribution Modeling Sample
Sample client
Overall Change
By Plan X Net Cost Neutral Option
By Plan & Band OFF
By Plan & Tier Select BASE Plan
By Plan/ Band/Tier CS PPO Monitor impact to employees
$ or % or Cost Share change? %
CURRENT CONTRIBUTIONS FINAL CONTRIBUTIONS PERCENT CHANGE COST SHARE
HSA Core HSA Core HSA Core HSA Core
HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete
EE $ 79.32 $ 120.99 3.0% 3.0% $ 82.95 $ 124.62 4.6% 3.0% 12.4% 18.7%
ES $ 214.16 $ 255.83 3.0% 3.0% $ 221.83 $ 263.50 3.6% 3.0% 15.9% 18.9%
EE+ Child(ren) $ 175.40 $ 217.07 3.0% 3.0% $ 181.91 $ 223.58 3.7% 3.0% 15.7% 19.3%
Family $ 307.97 $ 349.64 3.0% 3.0% $ 318.46 $ 360.13 3.4% 3.0% 16.1% 18.3%
HSA Plus HSA Plus HSA Plus HSA Plus
HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete
EE $ 125.28 $ 166.95 3.0% 3.0% $ 130.29 $ 171.96 4.0% 3.0% 18.7% 24.7%
ES $ 320.84 $ 362.51 3.0% 3.0% $ 331.72 $ 373.39 3.4% 3.0% 22.7% 25.6%
EE+ Child(ren) $ 262.78 $ 304.45 3.0% 3.0% $ 271.91 $ 313.58 3.5% 3.0% 22.6% 26.1%
Family $ 461.40 $ 503.07 3.0% 3.0% $ 476.49 $ 518.16 3.3% 3.0% 22.9% 24.9%
PPO PPO PPO PPO
HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete
EE $ 229.20 $ 270.87 3.0% 3.0% $ 237.33 $ 279.00 3.5% 3.0% 32.9% 38.7%
ES $ 548.50 $ 590.17 3.0% 3.0% $ 566.21 $ 607.88 3.2% 3.0% 37.4% 40.1%
EE+ Child(ren) $ 449.25 $ 490.92 3.0% 3.0% $ 463.98 $ 505.65 3.3% 3.0% 37.4% 40.8%
Family $ 788.80 $ 830.47 3.0% 3.0% $ 813.71 $ 855.38 3.2% 3.0% 37.4% 39.3%
Total Total Total Total
HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete HRA Complete HRA Not Complete
EE $ 39,755.52 $ - $ 41,301.96 $ - 3.9% 21.1%
ES $ 30,486.50 $ - $ 31,492.35 $ - 3.3% 29.3%
EE+ Child(ren) $ 16,445.77 $ - $ 17,006.65 $ - 3.4% 26.2%
Family $ 51,132.18 $ - $ 52,788.66 $ - 3.2% 25.9%
5
50 Lockton Companies
