51 / 63
USE 2017 Contribution Strategy
Suggested Funding - Max + Fixed Costs
Total
Enrollment
September
2016
Non-
Wellness
Enrollment
2016
2016 Total
Budget/Mo
2016 ER
Budget
2016 ER % 2016 EE
Cost
2016 EE
Non-
Wellness
Penalty
Non-
Wellness
Enrollment
2017
2017 Total
Budget/Mo
2017 ER
Budget
2016 ER % 2017 ER % 2017 EE
Cost
EE Bi-
weekly
Wellness
2017 EE
Non-
Wellness
Penalty
EE Bi-
weekly Non
Wellness
Increase/
Decrease in
EE
Contribution
PPO
Employee
23
0 $603.61 $463.04
77% $140.57
$55.00
8 $552.02 $411.45
75% 75% $140.57
$64.88
$55.00
$90.26
$0.00
Employee/Spouse
8
0 $1,124.75 $776.83
69% $347.92 $110.00
5 $1,028.61 $680.69
66% 66% $347.92 $160.58 $110.00 $211.35
$0.00
Employee/Child(ren)
9
0 $1,068.52 $737.97
69% $330.55
$55.00
3 $977.17 $646.62
66% 66% $330.55 $152.56
$55.00 $177.95
$0.00
Family
25
2 $1,799.62 $1,268.48
70% $531.14 $110.00
9 $1,654.79 $1,123.65
68% 68% $531.14 $245.14 $110.00 $295.91
$0.00
Totals
65
2 $929,859 $662,619
71% $267,239
$2,640
25 $853,075 $585,836
69%
69% $267,239
$25,740
QHDHP
0%
Employee
48
1 $448.83 $448.83
100% $0.00
$55.00
8 $411.94 $411.94
100% 100% $0.00
$0.00
$55.00
$25.38
$0.00
Employee/Spouse
15
3 $880.18 $754.34
86% $125.84 $110.00
5 $807.28 $681.44
84% 84% $125.84
$58.08 $110.00 $108.85
$0.00
Employee/Child(ren)
6
0 $836.17 $716.66
86% $119.51
$55.00
2 $766.90 $647.39
84% 84% $119.51
$55.16
$55.00
$80.54
$0.00
Family
48
1 $1,408.28 $1,232.56
88% $175.72 $110.00
6 $1,291.64 $1,115.92
86% 86% $175.72
$81.10 $110.00 $131.87
$0.00
Totals
117
5 $1,288,332 $1,155,861
90% $132,471
$5,940
21 $1,181,789 $1,049,319
89% $132,471
$21,120
ER HSA Seed
$99,750
$131,400
Totals
182
7 $2,317,941 $1,909,651
82% $408,290
$8,580
46 $2,166,265 $1,719,695
79% $446,570
$46,860
Changes
39 -$151,676 -$189,956
$38,280
$38,280
H S A
Employee
48
$600 $28,800
EE/SP
15
$1,000 $15,000
EE/CH
6
$1,000
$6,000
Family
48
$1,700 $81,600
Total
$131,400
51