Item B1County off Monroe
ELj »moo
� i G�,
�
BOARD OF COUNTY COMMISSIONERS
/� ri � ��
Mayor George Neugent, District 2
The Florida. Ke Sew',
y
i
Mayor Pro Tern David Rice, District 4
; -== :'„ j y
Danny L. Kolhage, District I
Heather Carruthers, District 3
Sylvia J. Murphy, District 5
County Commission Meeting
July 25, 2017
Agenda Item Number: B.1
Agenda Item Summary #3206
BULK ITEM: No DEPARTMENT: Employee Services
TIME APPROXIMATE: STAFF CONTACT: Maria Fernandez -Gonzalez (305)
292-4448
n/a
AGENDA ITEM WORDING: Discussion and possible new direction to staff related to
reconsideration of motions related to the County Health Plan by the Board of County Commissioners
on June 20, 2017
ITEM BACKGROUND: On June 20, 2017, the Board of County Commissioners considered 40
options related to changes that could be made to improve the Health Insurance Fund to address a
projected $3.3 Million shortfall expected to occur in 2018, which would bring the fund balance to
less than 6 months reserve (the current minimum fund balance based on Board budget policy).
One of the motions made by the commission on June 20, 2017 phased out the subsidy provided to
retirees hired prior to 10/1/2001 (commonly known as the "rule of 70 employees") who are pre-65
over a 5 year period (20% per year). Currently, the subsidy allows this group to obtain County
health insurance for the cost of the statutory health insurance subsidy provided by FRS. The health
insurance subsidy is equal to $5 for each year of creditable service, with a minimum of 10 years and
a maximum of 30 years.
Commissioner Rice requested the Board reconsider the motion on 7/19/17. The Board voted to
reconsider all of the motions made on 7/25/17 at the budget hearing.
Attached are options developed based on various input from administrative staff or commissioners
since 7/19/17.
As a reminder, the Health Plan Advisory Committee (HPAC) voted for options: 2, 2A, 29, 30, 31,
18, 28, 9, 11, 32, 13, 15, 19, and 35. The recommendations the HPAC made equated to $2,375,558
of the requested $3,300,000 needed to balance the fund. The HPAC then voted to request the Board
fund the remaining amount of $958,558 needed from Ad Valorem tax, Non -Ad Valorem, Enterprise,
or Internal Funds.
PREVIOUS RELEVANT BOCC ACTION:
5/10/17: BOCC considered the HPAC recommended changes for Health Plan and gave direction for
consideration of Options.
6/20/17: BOCC voted on Options.
7/19/17: BOCC voted to reconsider Options from 6/20/17.
CONTRACT/AGREEMENT CHANGES:
N/A
STAFF RECOMMENDATION:
DOCUMENTATION:
Exhibits with BOCC Changes from June 20 mtng Final
REVISED BOCC Decision Options for 7-25-17 Final (MinuteTrac)
FINANCIAL IMPACT:
Effective Date: N/A
Expiration Date: N/A
Total Dollar Value of Contract: N/A
Total Cost to County:
Current Year Portion:
Budgeted:
Source of Funds:
CPI:
Indirect Costs:
Estimated Ongoing Costs Not Included in above dollar amounts:
Revenue Producing:
Grant:
County Match:
Insurance Required:
Additional Details:
N/A
If yes, amount:
REVIEWED BY:
Christine Hurley
Skipped
07/20/2017 5:16 PM
Budget and Finance
Completed
07/20/2017 5:17 PM
Cynthia Hall
Completed
07/20/2017 5:19 PM
Maria Slavik
Skipped
07/20/2017 5:17 PM
Kathy Peters
Pending
Board of County Commissioners
Pending
07/25/2017 10:00 AM
Monroe County Board of County Commissioners
Illustrative Impact of Adding a Low Option Plan Effective January 1, 2018
Reflects All Changes to Current Plan That Were Voted For by a Majority of Commissioners on June 20, 2017
Feature
Network I Non Networki
Networkl
Non Networki
Network
NonNetwork'
Deductible''- Individual
Deductible''- Family ''
$400 $400
$800 $800
$400
' $400
$2000
$4000
$4,000'SS
$8,000';,'
$800 ''
$800
Mail Order Pharmacy Copays
Generic
$25
$37.50
(After Deductible for'HSA)
Preferred Brand
$125
$150
Nun Preferred Brand
$225
$250
In addition to changes shown, 2018 plans would both include the following pharmacy changes: Select formulary
Exclude OTC drugs
Exclude CVS pharmacies
Board also approved $75 smoker surcharge, dependent eligibility audit, and exploring a change in Medicare eligible retiree pharmacy coverage from RDS to EGWP
Board approved $250 monthly stipend to Medicare eligible retirees who satisfy Rule of 70, phasing out subsidy for pre -Medicare retirees over 5 years, and phasing out subsidy for dependents
of retirees over 3 years
Exhibits with BOCC Changes from June 20 mtng Final
Monroe County Board of County Commissioners OPTION 13 With All Plan i Modifications Approved by BOCC on 6/2012017'
Illustrative Impact of Adding HSA Option Effective January 1, 2018
Assumes Current Plan with All Modifications remains in place at increased employee/retiree contribution rates
Assumes HSA option added at employee contribution rates 10% below current with retiree rates based on revised Board Subsidies
1. Illustrative 2017118 Contribution Rates and Enrollment
Migration
Employee
Retiree - <65 Retiree - 65+
Dependent
Blended
Relative Values
Current Plan
100%
100% 100%
100%
100%
1.000
High Option
60% 85%
79%
0.948
Low Option
20%
40% 15%
20%
21 %
0.795
Total
100%
100% 100%
100%
100%
0.924
of Buy -Up Cost Paid by Employee 50%
Assumed Turnover 1 15%
Assumed Selection Factor for HSA Migration 1 0.80
Exhibits with BOCC Changes from June 20 mtng Final
Monroe County Board of County Commissioners OPTION 13 With All Plan i Modifications Approved by BOCC on 6/2012017'
Illustrative Impact of Adding HSA Option Effective January 1, 2018
2. Illustrative Impact for 2017118 Fiscal Year
Baseline Dual Option
Projected
Projected
Projected
Projected
2016117
2017118
2017118
Change
I. Total Net Incurred Claims (1)
$
17,165,215
$ 18,264,281
$ 17,227,306
$ (1,036,975)
II. Fixed Costs (2)
a. BCBSFL
872,727
873,459
873,459
$
b. Envision
69,627
69,686
69,686
$
c. Internal Expenses
278,662
278,662
278,662
$
d. PPACA - PCOR Fee
5,621
5,621
5,621
$
e. PPACA - Transitional Reinsurance Fee
16,263
16,263
16,263
$
f. Other (GBS, Life, AD&D, EAP)
321,000
342,000
342,000
$
Total Fixed Costs
1,563,901
1,585,691
1,585,691
$
III. Total Incurred Plan Costs (2)
$
18,729,116
$ 19,849,972
$ 18,812,997
$ (1,036,975)
IV. Revenue at Current and Adopted Level
a. Contributions (4)
$
17,685,480
17,685,480
18,984,092
1,298,612
b. Interest (3)
$
35,086
35,086
35,086
-
c. Other (3)
$
332,040
332,040
332,040
-
Total Revenue
$
18,052,606
18,052,606
19,351,218
1,298,612
V. Surplus/(Deficit)
$
(676,510)
$ (1,797,366)
$ 538,221
$ 2,335,587
VI. Employee/Retiree Contributions
$ 2,917,296
$ 4,215,908
$ 1,298,612
VII. Net County Cost
$ 16,932,676
$ 14,597,089
$ (2,335,587)
Exhibits with BOCC Changes from June 20 mtng Final
Monroe County Board of County Commissioners
Illustrative Impact of Adding HSA Option Effective January 1, 2018
Development of Actuarial Rates
PEPM Cost Excluding Internal Expenses, Life, AD&D, EAP, and GBS Fees
PEPY Cost Excluding Internal Expenses, Life, AD&D, EAP, and GBS Fees
Current
OPTION 13 With All Plan i Modifications Approved by BOCC on 6/2012017'
2017/18
$985.39
$11,825
Enrollment
Current
After
Actuarial
Pricing
Funding
Funding
plan (Modified under dual option)
Migration
Weight
Weight
Annual
Monthly
Employees Paying $25 Premium
725
493
1.00
1.00
$8,976
$748
Recent Hires Pay $50 mo prem
448
445
1.00
1.00
$8,976
$748
EMPLOYEE DEPENDENTS ONLY:
Spouse Only
110
88
1.90
1.35
$12,117
$1,010
Spouse + 1 child
37
30
2.50
1.95
$17,502
$1,459
Spouse + 2 or more children
33
26
3.40
2.85
$25,581
$2,132
One child only
120
96
0.60
0.60
$5,385
$449
Two children only
80
64
1.20
1.20
$10,771
$898
Three children only
15
12
1.80
1.80
$16,156
$1,346
Four children only
3
2
2.40
2.40
$21,541
$1,795
Five+ children only
1
1
3.00
3.00
$26,927
$2,244
RETIREES ONLY:
10+ YRS <65
117
70
1.75
1.00
$8,976
$748
10+ YRS >65
296
252
0.90
0.90
$8,078
$673
Non Rule of 70 < 65
2
2
1.75
1.00
$8,976
$748
Non Rule of 70 65+
3
3
0.90
0.90
$8,078
$673
Surviving Spouse < 65
3
2
1.75
1.35
$12,117
$1,010
Surviving Spouse >65
6
5
0.90
0.90
$8,078
$673
RETIREE DEPENDENTS ONLY:
Spouse Only <65
34
20
1.90
1.35
$12,117
$1,010
Spouse only <65 + 1 child
2
1
2.50
1.95
$17,502
$1,459
Spouse only <65 + 2 or more children
1
1
3.40
2.85
$25,581
$2,132
Spouse Only >65
18
15
0.90
0.90
$8,078
$673
One child only
5
3
0.60
0.60
$5,385
$449
Two children only
4
2
1.20
1.20
$10,771
$898
Three children only
2
1
1.80
1.80
$16,156
$1,346
Four children only
0
0
2.40
2.40
$21,541
$1,795
Five+ children only
0
0
3.00
3.00
$26,927
$2,244
COBRA
0
0
1.50
1.50
$13,463
$1,122
Exhibits with BOCC Changes from June 20 mtng Final
Monroe County Board of County Commissioners OPTION 13 With All Plan i Modifications Approved by BOCC on 6/2012017'
Illustrative Impact of Adding HSA Option Effective January 1, 2018
Development of Actuarial Rates
HDHP wi
Enrollment
Current
After
Actuarial
Pricing
Funding
Funding
th HSA
Migration
Weight
Weight
Annual
Monthly
Employees Paying $25 Premium
0
123
0.84
0.84
$7,527
$627
Recent Hires Pay $50 mo prem
0
111
0.84
0.84
$7,527
$627
EMPLOYEE DEPENDENTS ONLY:
Spouse Only
0
22
1.59
1.13
$10,161
$847
Spouse + 1 child
0
7
2.10
1.64
$14,677
$1,223
Spouse + 2 or more children
0
7
2.85
2.39
$21,451
$1,788
One child only
0
24
0.50
0.50
$4,516
$376
Two children only
0
16
1.01
1.01
$9,032
$753
Three children only
0
3
1.51
1.51
$13,548
$1,129
Four children only
0
1
2.01
2.01
$18,064
$1,505
Five+ children only
0
0
2.52
2.52
$22,580
$1,882
RETIREES ONLY:
10+YRS <65
0
47
1.47
0.84
$7,527
$627
10+YRS>65
0
44
0.75
0.75
$6,774
$565
Non Rule of 70 < 65
0
0
1.47
0.84
$7,527
$627
Non Rule of 70 65+
0
0
0.75
0.75
$6,774
$565
Surviving Spouse < 65
0
1
1.47
1.13
$10,161
$847
Surviving Spouse 65+
0
1
0.75
0.75
$6,774
$565
RETIREE DEPENDENTS ONLY:
Spouse Only <65
0
14
1.59
1.13
$10,161
$847
Spouse only <65 + 1 child
0
1
2.10
1.64
$14,677
$1,223
Spouse only <65 + 2 or more children
0
0
2.85
2.39
$21,451
$1,788
Spouse Only >65
0
3
0.75
0.75
$6,774
$565
One child only
0
2
0.50
0.50
$4,516
$376
Two children only
0
2
1.01
1.01
$9,032
$753
Three children only
0
1
1.51
1.51
$13,548
$1,129
Four children only
0
0
2.01
2.01
$18,064
$1,505
Five+ children only
0
0
2.52
2.52
$22,580
$1,882
COBRA
0
0
1.26
1.26
$11,290
$941
Resulting Annual Premiums 1 1 1,5911 1 1.317 1 $18,812,997 1$1,567,750
Exhibits with BOCC Changes from June 20 mtng Final
FY 2018 Forecasts with Changes Approved by BOCC on June 20, 2017
Impact of
Baseline FY 18
Illustrative
Revised FY 18
Forecast
Changes
Forecast
Projected Starting Fund Balance
$7,595,391
$0
$7,595,391'
Projected Revenue at Current Funding
$18,052,606
$1,671,000
$19,723,606
Projected Claims
$18,264,281
($1,233,000)
$17,031,281
Projected Fixed Costs
$1,585,691
$0
$1,585,691
Projected Expenses
$19,849,972
($1,233,000)
$18,616,972
Projected Gain/(Loss)
($1,797,366)
$2,904,000
$1,106,634
Projected Closing Fund Balance
Projected Target Fund Balance
$5,798,025
$9,132,140
$2904,000
($616,500)
$8,702,025'
$8,515,640'
Projected Excess/(Shortfall
$3,334,116
$3,520,500
$186,384
Impact of Illustrative Changes
Change in Claims
Change in
Revenue
Implement Dual', Option and Plan Changes
($1,037,000)
$243,000'
Dependent Eligibility Audit
($196,000)
Smoker Surcharge ($75)
$123,000'
EGWP/PBM Improvements
$0
$250,000'
,Increase > Retiree Premiums
$0
$1,055,000
Total All Changes
($1,233,000)
$1,671,000
Exhibits with BOCC Changes from June 20 mtng Final 6
Current
Option 1
Comparison of Premiums, HSA Contributions, and Deductible Exposure
Based on Rates Based on All Changes Voted for by Board on June 20, 2017
Active Employees
(Hired
Prior to 5/1/2012/Hired
5/1/2012 and
Later)
Retirees
with Option
7Implemented
Pre-65 Retirees
with Option
7 A Implemented
Retirees
with Option
7 A MODIFIED
Implemented
Employee +
KUIGo
ueo
on KUIGo
on Rule o
ueo
ueo
Kulao
Kulao
Kulao
ueo
ueo lu
Employee +
Employee +
Employee + 2
Spouse + 2
Pre-65
Post-65
70 Pre-65
70 Post-65
With 25+
W/ 20-24
W/ 10-19
Non Rule
With 25+
W/ 20-24
W/ 15-19
W/ 10-14
Non Rule of
Employee Only
Spouse
Child
Children
Children
Retirees
Retirees
Retirees
Retirees
YOS
YOS
YOS
of 70
YOS
YOS
YOS
YOS
70
2017 Premium
$25/$50
$357/$382
$173/$198
$320/$345
$726/$751
$50-$150
$50-$150
$125-$150
$100-$120
$50-$95
$125-$150
$100-$120
$75-$95
$50-$70
Average
$115
$88
$1,035
$621
$139
$111
$78
$1,035
$139
$111
$87
$58
$1,035
rermum or urren an
$50/$75
$430/$455
$219/$244
$388/$413
$853/$878
$263
$423
$748
$673
$139
$187
$374
$748
$139
$187
$374
$561
$748
2018 Premium forHDHPwith HSA
$0
$299
$133
$266
$631
$142
$315
$627
$565
$78
$157
$314
$627
$78
$157
$314
$470
$627
Monthly Premium Differenced. weer
Current Plan and HDHP with HSA
$50/$75
$131/$156
7$86/$111
$122/$147
$2221$247
$121
$109
$121
7$109
7$60
7$30
$60
$121
$60
$30
$60
$91
$121
Annual Premium Difference Between
Current Plan and HDHP with HSA
00 900
$157 1878
$103 1335
146911769'.
2665 2965
$1,449
$1,304
$1,449
$1 304
724
$362
$725
$1 449
$724
362
725
$1.087
$1.449'.
Annual Count Contribution to HSA
$500
$1,000
$1,000
$1,000
$1,000
$500
$0
$500
$0
$500
$500
$500
$500
$500
$500
$500
$500
$500
o nua as van ge m
with HSA
$1,100/$1,400
$25781$2878
$2935/$2335
'.$2469f$2769
$3665/$3965
$1,949
$1 04
$1,949
$1,304
$1,224
$862
$1,225
$1,949
$1,224
$862
$1,225
$1,587
$1,949
Current Plan Deductible
$400
$800
$800
$800
$800
$400
$400
$400
$400
$400
$400
$400
$400
$400
$400
$400
$400
$400
HDHP Deductible
$2,000
$4,000
$4,000
$4,000
$4,000
$2,000
$2,000
$2,000
$2,000
$2,000
$2,000
$2,000
$2,000
$2,000
$2,000
$2,000
$2,000
$2,000
Increase in Deductible Exposure
$1,600
$3,200
$3,200
$3,200
$3,200
$1,600
$1,600
$1,600
$1,600
$1,600
$1,600
$1,600
$1,600
$1,600
$1,600
$1,600
$1,600
$1,600
HDHP Annual Cash Advantage -
Difference in Deductibles
-$500/-$200
-$622/-$322
-$1,165/-$865
-$731/-$431
$465/$765
$349
't:
$349
$349
"":"_
"'.'
".'»,
'.':'
$349
Current Plan Max Out of Pocket
$7,150
$14,300
$14,300
$14,300
$14,300
$7,150
$7,150
$7,150
$7,150
$7,150
$7,150
$7,150
$7,150
$7,150
$7,150
$7,150
$7,150
$7,150
HDH P Max Out of Pocket
$6650
$13300
$13300
$13300
$13300
$6650
$6650
$6650
$6650
$6650
$6650
$6650
$6650
$6650
$6650
$6650
$6650
$6650
Chan a in Max Out of Pocket Exposure
"""°
""°
:'
': °"
"'°
'•°"'
HDHP Annual Cash Advantage -
1
Difference in Max Out of Pocket
$1600/$1900
$3578/$3878
$3035/$3335
$3469/$3769
$4665/$4965
$2,449
$1,804
$2,449
$1,804
$1,724
$1,362
$1,725
$2,449
$1,724
$1,362
$1,725
$2,087
$2,449
Difference Reflects $250 subsidy
($673-$423) =250
a
W
0
N
M
v
LL
C
�c+
E
0
N
N
C
7
7
E
O
L
CD
0
t
U
U
U
O
m
t
r
to
r
t
x
w
r
c
m
E
c�
r
r
Q
Exhibitswith BOCC Changesfrom June 20 mtng Final
Development of County Retiree Subsidies
Projected 2016/17 Annual Expense 1 $18,729,116
CY 2017 Rates
Future County Retiree Subsidies
Employee
Enrollees Tier Weight
Actuarial Rate
Contribution
County Subsidy
CY 2018
CY 2019
CY 2020
CY 2021
CY 2022
Employees Paying $25 Premium
616
1.00
$721.54
$25
$696.54
Recent Hires Pay $50 mo prem
556
1.00
$721.54
$50
$671.54
EMPLOYEE DEPENDENTS ONLY:
Spouse Only
110
1.35
$974.08
$332
$642.08
Spouse + 1 child
37
1.95
$1,407.00
$480
$927.00
Spouse + 2 or more children
33
2.85
$2,056.38
$701
$1,355.38
One child only
120
0.60
$432.92
$148
$284.92
Two children only
80
1.20
$865.85
$295
$570.85
Three children only
15
1.80
$1,298.77
$443
$855.77
Four children only
3
2.40
$1,731.69
$591
$1,140.69
RETIREES ONLY:
10+ YRS <65 (1)
117
1.00
$721.54
$115
$606.54
$485.23
$363.92
$242.62
$121.31
$0.00
10+ YRS >65
296
0.90
$649.38
$88
$561.38
$250.00
$250.00
$250.00
$250.00
$250.00
Non Rule of 70 Retirees < 65
2
1.00
$721.54
$1,035
($313.46)
$0.00
$0.00
$0.00
$0.00
$0.00
Non Rule of 70 Retirees 65+
3
0.90
$649.38
$621
$28.38
$0.00
$0.00
$0.00
$0.00
$0.00
Surviving Spouse < 65 (2)
3
1.35
$974.08
$332
$642.08
$417.35
$192.62
$0.00
$0.00
$0.00
Surviving Spouse 65+
6
0.90
$649.38
$559
$90.38
$0.00
$0.00
$0.00
$0.00
$0.00
RETIREE DEPENDENTS ONLY:
Spouse Only <65 (2)
34
1.35
$974.08
$332
$642.08
$417.35
$192.62
$0.00
$0.00
$0.00
Spouse only <65 + 1 child (2)
2
1.95
$1,407.00
$480
$927.00
$602.55
$278.10
$0.00
$0.00
$0.00
Spouse only <65 + 2 or more children (2)
1
2.85
$2,056.38
$701
$1,355.38
$881.00
$406.61
$0.00
$0.00
$0.00
Spouse Only >65
18
0.90
$649.38
$559
$90.38
$0.00
$0.00
$0.00
$0.00
$0.00
One child only (2)
5
0.60
$432.92
$148
$284.92
$185.20
$85.48
$0.00
$0.00
$0.00
Two children only (2)
1 4
1 1.20
$865.85
1 $295
1 $570.851
$371.05
1 $171.26
1 $0.00
1 $0.00
1 $0.00
Total Exposure 2,163
Rate per Unit of Exposure $721.54
Total Annual Funding $18,729,127 $2,917,296
Annual Active Funding $14,623,299 $2,044,692
Annual Retiree Funding $4,105,828 $872,604
(1) Subsidy for Pre-65 retirees is reduced by 20% per year
(2) Subsidy for dependents of retirees decreased by 35%, in 2018, 70% in 2019, and eliminated in 2020
$15,811,831
$12,578,60-1
WINKI&I
Exhibits with BOCC Changes from June 20 mtng Final
Development of Projected Retiree Premiums
2018 Retiree Premium Development
Note: Retirees who satisfy the Rule of 70 but leave the plan prior to being Medicare eligible are still eligible to receive the $250 monthly subsidy when they become eligible for Medicare
Current Retiree
Projected Retirees
Actuarial Rate
County Subsidy
Retiree
Premium
Modified
HDHP with
Modified
HDHP with
Modified
HDHP with
Modified
HDHP with
Contribution
Current Plan
HSA
Current Plan
HSA
Current Plan
HSA
Current Plan
HSA
RETIREES ONLY:
10+ YRS <65 (Average rate)
$115
70
47
$747.97
$627.23
$485.23
$485.23
$262.74
$142.00
10+ YRS >65 (Average rate)
$88
252
44
$673.17
$564.51
$250.00
$250.00
$423.17
$314.51
Non Rule of 70 Retirees < 65
$1,035
2
0
$747.97
$627.23
$0.00
$0.00
$747.97
$627.23
Non Rule of 70 Retirees 65+
$621
3
0
$673.17
$564.51
$0.00
$0.00
$673.17
$564.51
Surviving Spouse < 65
$332
2
1
$1,009.76
$846.76
$417.35
$417.35
$592.41
$429.41
Surviving Spouse 65+
$559
5
1
$673.17
$564.51
$0.00
$0.00
$673.17
$564.51
RETIREE DEPENDENTS ONLY:
Spouse Only <65
$332
20
14
$1,009.76
$846.76
$417.35
$417.35
$592.41
$429.41
Spouse only <65 + 1 child
$480
1
1
$1,458.54
$1,223.10
$602.55
$602.55
$855.99
$620.55
Spouse only <65 + 2 or more children
$701
1
0
$2,131.71
$1,787.60
$881.00
$881.00
$1,250.71
$906.60
Spouse Only >65
$559
15
3
$673.17
$564.51
$0.00
$0.00
$673.17
$564.51
One child only
$148
3
2
$448.78
$376.34
$185.20
$185.20
$263.58
$191.14
Two children onll
1 $295
2
2
$897.56
1 $752.67
$371.05
1 $371.05
$526.51
$381.62
Total
$872,604
$4,088,171 $1,808,522
$2,279,649
Retiree Increase
$1,407,045
9-Month Increase
$1,055,284
2019 Retiree Premium Development
Assumed Premium Rate Increase 1 7.0%
Projected Retirees
2018 Retiree Contributions
2019 Actuarial Rate
2019 Cou ty Subsidy
2019 Retiree Premium
Modified
HDHP with
Modified
HDHP with
Modified
HDHP with
Modified
HDHP with
Modified
HDHP with
Current Retiree
Contribution
Current Plan
HSA
Current Plan
HSA
Current Plan
HSA
Current Plan
HSA
Current Plan
HSA
RETIREES ONLY:
10+ YRS <65
$115
70
47
$262.74
$142.00
$800.33
$671.13
$363.92
$363.92
$436.41
$307.21
10+ YRS >65
$88
252
44
$423.17
$314.51
$720.29
$604.02
$250.00
$250.00
$470.29
$354.02
Non Rule of 70 Retirees < 65
$1,035
2
0
$747.97
$627.23
$800.33
$671.13
$0.00
$0.00
$800.33
$671.13
Non Rule of 70 Retirees 65+
$621
3
0
$673.17
$564.51
$720.29
$604.02
$0.00
$0.00
$720.29
$604.02
Surviving Spouse < 65
$332
2
1
$592.41
$429.41
$1,080.44
$906.03
$192.62
$192.62
$887.82
$713.41
Surviving Spouse 65+
$559
5
1
$673.17
$564.51
$720.29
$604.02
$0.00
$0.00
$720.29
$604.02
RETIREE DEPENDENTS ONLY:
Spouse Only <65
$332
20
14
$592.41
$429.41
$1,080.44
$906.03
$192.62
$192.62
$887.82
$713.41
Spouse only <65 + 1 child
$480
1
1
$855.99
$620.55
$1,560.64
$1,308.71
$278.10
$278.10
$1,282.54
$1,030.61
Spouse only <65 + 2 or more children
$701
1
0
$1,250.71
$906.60
$2,280.93
$1,912.73
$406.61
$406.61
$1,874.32
$1,506.12
Spouse Only >65
$559
15
3
$673.17
$564.51
$720.29
$604.02
$0.00
$0.00
$720.29
$604.02
One child only
$148
3
2
$263.58
$191.14
$480.20
$402.68
$85.48
$85.48
$394.72
$317.20
Two children only
$295
2
2
$526.51
$381.62
$960.39
$805.36
$171.26
$171.26
$789.13
$634.10
Total
$872,604
$2,279,649 $4,374,329 $1,509,370
$2,864,959
Retiree Increase
$1,992,355
Exhibits with BOCC Changes from June 20 mtng Final
Development of Projected Retiree Premiums
2020 Retiree Premium Development
Assumed Premium Rate Increase 7.0%
11
Current Retiree
Projected Retirees
2019 Retiree Contributions
2020 Actuarial Rate
2020 Cou ty Subsidy
2020 Retiree Premium
Contribution
High Option
Low Option
High Option
Low Option
High Option
Low Option
High Option
Low Option
High Option
Low Option
RETIREES ONLY:
10+ YRS <65
$115
70
47
$436.41
$307.21
$856.35
$718.11
$242.62
$242.62
$613.73
$475.49
10+ YRS >65
$88
252
44
$470.29
$354.02
$770.71
$646.30
$250.00
$250.00
$520.71
$396.30
Non Rule of 70 Retirees < 65
$1,035
2
0
$800.33
$671.13
$856.35
$718.11
$0.00
$0.00
$856.35
$718.11
Non Rule of 70 Retirees 65+
$621
3
0
$720.29
$604.02
$770.71
$646.30
$0.00
$0.00
$770.71
$646.30
Surviving Spouse < 65
$332
2
1
$887.82
$713.41
$1,156.07
$969.45
$0.00
$0.00
$1,156.07
$969.45
Surviving Spouse 65+
$559
5
1
$720.29
$604.02
$770.71
$646.30
$0.00
$0.00
$770.71
$646.30
RETIREE DEPENDENTS ONLY:
Spouse Only <65
$332
20
14
$887.82
$713.41
$1,156.07
$969.45
$0.00
$0.00
$1,156.07
$969.45
Spouse only <65+ 1 child
$480
1
1
$1,282.54
$1,030.61
$1,669.88
$1,400.32
$0.00
$0.00
$1,669.88
$1,400.32
Spouse only <65 + 2 or more children
$701
1
0
$1,874.32
$1,506.12
$2,440.60
$2,046.62
$0.00
$0.00
$2,440.60
$2,046.62
Spouse Only >65
$559
15
3
$720.29
$604.02
$770.71
$646.30
$0.00
$0.00
$770.71
$646.30
One child only
$148
3
2
$394.72
$317.20
$513.81
$430.87
$0.00
$0.00
$513.81
$430.87
Two children only
$295
2
2
$789.13
$634.10
$1,027.62
$861.74
$0.00
$0.00
$1,027.62
$861.74
Total
$872,604
$2,864,959 $4,680,528 $1,228,638
$3,451,890
Retiree Increase
$2,579,286
2021 Retiree Premium Development
Assumed Premium Rate Increase 1 7.0%
Current Retiree
Projected Retirees
2020 Retiree Contributions
2021 Actuarial Rate
2021 Cou ty Subsidy
2021 Retiree Premium
Contribution
High Option
Low Option
High Option
Low Option
High Option
Low Option
High Option
Low Option
High Option
Low Option
RETIREES ONLY:
10+ YRS <65
$115
70
47
$613.73
$475.49
$916.29
$768.38
$121.31
$121.31
$794.98
$647.07
10+ YRS >65
$88
252
44
$520.71
$396.30
$824.66
$691.54
$250.00
$250.00
$574.66
$441.54
Non Rule of 70 Retirees < 65
$1,035
2
0
$856.35
$718.11
$916.29
$768.38
$0.00
$0.00
$916.29
$768.38
Non Rule of 70 Retirees 65+
$621
3
0
$770.71
$646.30
$824.66
$691.54
$0.00
$0.00
$824.66
$691.54
Surviving Spouse < 65
$332
2
1
$1,156.07
$969.45
$1,236.99
$1,037.31
$0.00
$0.00
$1,236.99
$1,037.31
Surviving Spouse 65+
$559
5
1
$770.71
$646.30
$824.66
$691.54
$0.00
$0.00
$824.66
$691.54
RETIREE DEPENDENTS ONLY:
Spouse Only <65
$332
20
14
$1,156.07
$969.45
$1,236.99
$1,037.31
$0.00
$0.00
$1,236.99
$1,037.31
Spouse only <65+ 1 child
$480
1
1
$1,669.88
$1,400.32
$1,786.77
$1,498.34
$0.00
$0.00
$1,786.77
$1,498.34
Spouse only <65 + 2 or more children
$701
1
0
$2,440.60
$2,046.62
$2,611.44
$2,189.88
$0.00
$0.00
$2,611.44
$2,189.88
Spouse Only >65
$559
15
3
$770.71
$646.30
$824.66
$691.54
$0.00
$0.00
$824.66
$691.54
One child only
$148
3
2
$513.81
$430.87
$549.78
$461.03
$0.00
$0.00
$549.78
$461.03
Two children only
$295
2
2
$1,027.62
$861.74
$1,099.55
$922.06
$0.00
$0.00
$1,099.55
$922.06
Total
$872,604
$3,451,890 $5,008,161 $1,058,319
$3,949,842
Retiree Increase
$3,077,238
Exhibits with BOCC Changes from June 20 mtng Final 10
Development of Projected Retiree Premiums
2022 Retiree Premium Development
Assumed Premium Rate Increase 7.0%
11
Current Retiree
Projected Retirees
2021 Retiree Contributions
2022 Actuarial Rate
2022 Cou ty Subsidy
2022 Retiree Premium
Contribution
High Option
Low Option
High Option
Low Option
High Option
Low Option
High Option
Low Option
High Option
Low Option
RETIREES ONLY:
10+ YRS <65
$115
70
47
$794.98
$647.07
$980.43
$822.17
$0.00
$0.00
$980.43
$822.17
10+ YRS >65
$88
252
44
$574.66
$441.54
$882.39
$739.95
$250.00
$250.00
$632.39
$489.95
Non Rule of 70 Retirees < 65
$1,035
2
0
$916.29
$768.38
$980.43
$822.17
$0.00
$0.00
$980.43
$822.17
Non Rule of 70 Retirees 65+
$621
3
0
$824.66
$691.54
$882.39
$739.95
$0.00
$0.00
$882.39
$739.95
Surviving Spouse < 65
$332
2
1
$1,236.99
$1,037.31
$1,323.58
$1,109.92
$0.00
$0.00
$1,323.58
$1,109.92
Surviving Spouse 65+
$559
5
1
$824.66
$691.54
$882.39
$739.95
$0.00
$0.00
$882.39
$739.95
RETIREE DEPENDENTS ONLY:
Spouse Only <65
$332
20
14
$1,236.99
$1,037.31
$1,323.58
$1,109.92
$0.00
$0.00
$1,323.58
$1,109.92
Spouse only <65+ 1 child
$480
1
1
$1,786.77
$1,498.34
$1,911.84
$1,603.22
$0.00
$0.00
$1,911.84
$1,603.22
Spouse only <65 + 2 or more children
$701
1
0
$2,611.44
$2,189.88
$2,794.24
$2,343.17
$0.00
$0.00
$2,794.24
$2,343.17
Spouse Only >65
$559
15
3
$824.66
$691.54
$882.39
$739.95
$0.00
$0.00
$882.39
$739.95
One child only
$148
3
2
$549.78
$461.03
$588.26
$493.30
$0.00
$0.00
$588.26
$493.30
Two children only
$295
2
2
$1,099.55
$922.06
$1,176.52
$986.60
$0.00
$0.00
$1,176.52
$986.60
Total
$872,604
$3,949,842 $5,358,747 $888,000
$4,470,747
Retiree Increase
1 $3,598,143
Exhibits with BOCC Changes from June 20 mtng Final 11
Option 7A - Scaled Subsidy for Rule of 70 Retirees Based on Years of Service - Current Plan
Pre 65'
Enrollees 117'
FY 18 Actuarial Rate $748
25% Actuarial Rate $187 '
50%Actuarial Rate $374
Option 7A Modified - Scaled Subsidy for Rule of 70 Retirees Based on Years of Service with 4 Service Bands For Current Plan
Pre 65'
Enrollees 117'
FY 18 Actuarial Rate $748
25%Actuarial Rate $187
50%Actuarial Rate $374
75%Actuarial Rate $561
9-Month
Exhibits with BOCC Changes from June 20 mtng Final 12
Options naand 7c'Current Retiree Premium Formula with Contributions Increased for Inflation for Current Plan
Option 7B - Retiree Premiums Increase by 3% per Year
Current
Retirees
2017 Retiree
Contribution
2018 Retiree
Contribution
2019 Retiree
Contribution
2020 Retiree
Contribution
2021 Retiree
Contribution
2022 Retiree
Contribution
RETIREES ONLY:
Option 7C - Retiree Premiums Increase by 8% per Year
Current
Retirees
2017 Retiree
Contribution
2018 Retiree
Contribution
2019 Retiree
Contribution
2020 Retiree
Contribution
2021 Retiree
Contribution
2021 Retiree
Contribution
RETIREES ONLY:
Exhibits with BOCC Changes from June 2OmtngFinal 13
Monroe County Board of County Commissioners
2018
Option 7
Pre-65 Retiree Pay Actuarial Rate'
Adjusted Total Annual Contributions * $161,460 $1,130,220 $827,976 $317,029 $265,956
Increase in Retiree Contributions $968.760 $666.516 T155.569 $104.496
2019
10+YRS <65 Current
117
$115'
117
$1,035
117 $800''
117
$436
70
$436
HDHP
47
$307
1
Total Monthly EE Contributions
$13,455
$121,095
$93,639
1
$51,060
$44,988
Total Annual EE Contributions
$161,460
$1,453,140
$1,123,663
$612,720
$539,851
Increase in Retiree Contributions
$1,291,680
$962,203
$451,260
$378,391
2020
10+YRS <65 Current
117
$115''
117
$1,035
117
$856'>s
117
$614
70
$614
HDHP
47
$475
1
Total Monthly EE Contributions
$13,455
$121,095
$100,193
$71,806
$65,309
Total Annual EE Contributions
$161,460
$1,453,140
$1,202,315
$861,677
$783,710
Increase in Retiree Contributions
1,291,680
$1,040,855
$700,217
$622,250
2021
10+YRS <65 Current
117
$115
117
$1,035
117
916a
117
795
70
795
HDHP
47
$647
1
Total Monthly EE Contributions
$13,455
$121,095
$107,206
1
$93,013
$86,061
Total Annual EE Contributions
$161,460
$1,453,140
$1,286,471
$1,116,152
$1,032,731
Increase in Retiree Contributions
$1,291,680
$1,125,011
$954,692
$871,271
2022
10+YRS <65 Current
117
$115'
- 117
$1,035
117
$980>
117
$980
70
$980
HDHP
47
$822
1
Total Monthly EE Contributions
$13,455
$121,095
$114,710
$114,710
$107,272
Total Annual EE Contributions
$161,460
$1,453,140
$1,376,524
$1,376,524
$1,287,265
Increase in Retiree Contributions
1,291,680
$1,215,064
$1,215,064
$1,125,805
Exhibits with BOCC Changes from June 20 mtng Final 14
cn
rNNNbrNNN
�C7Z0
�C
CD CD
CD CD CD 0
w t� w w
s9 s9 s9 s9 s9 s9 s9 s9
s9 s9 s9 s9 s9 s9 s9 s9 s9 s9 s9 s9
s9 s9 s9 s9 s9 s9 s9 s9 s9 s9 s9 s9
coJ�oco
wcoJ�J�c�,c�,tuc�,wcoot��o�ocoJJo�c�,�oo��wco�o�oc�,�o�oo�oJ�o
�
wcococ�,
c�,w���c�,o�owt�owo�coc�,wo�coc�,�o�o��o��o�wt�o�c�,c�,co�ot�o�J
�.
wcot�o���
se se se se
��oo��o��o�wt�wo�oowoi���
���oo����ococo�oo�cococo�
JJo�c�,
�w�t�cot�o�wJ�o�JcncoJc�,JJ'—'c�,t�t�c�,J�Jo�co�ooJwcow��:�
t�oo�J
�o�owoJwoJt�wco�,wco�cococo�o�
n �,wwot�ot�t�jWX
cJl Ip � 1--
o w o
. C� J t� w �o J �
o J � � ,c cc o co ,c ,c w
C, w C� J ice, w cp tj . '0
co -
co �,c
t�j c-h J c-h w �,c co
co w c-h — �,c cc N N o t-h w
o �c 00 0 N �c 00 C1 CO w �c 0
co � J w J O J
J J J co N w w X C�
� �c � o� N� N w� c-h �c
�o0000J
�00C�C�
J
oo
t�jt�jJ
�,ot�jw
t�jo�XItj �--4C�
— oo�wJJc-,
�wwcoJJ�
NIC-1=
'. wcoo�o
,00i�i�w���o���,o�-,A'00
'�o�o�co�ww—�,cX
�oo��,��o .�c�c oo�
I'o — coop
-3C
o00XW o�oo�Jw
wwwc -k- ,c
co —w-
roc-,co
t�j ��Ic�o�wo�t�jo��Icot�jo�
--4
Attachment: Exhibits with BOCC Changes from June 20 mtng Final (3206 e Discussion on the County's Group Health A Prescription Plan
II Monroe County Board of County Commissioners
Analysis of Historical Medical Claims by Enrollment Category
Tier I Item 1 2013/14 2014/15 2015/161 Totals
Employees
Enrollees
1,603
1,593
1,581
4,777
Claims
$ 6,561,414
1
$ 6,921,075
$ 7,666,159
$ 21,148,648
PEPM
$ 341.10
$ 362.06
$ 404.08
$ 368.93
Spouses
Enrollees
325
329
341
995
Claims
$ 2,173,991
$ 3,159,472
$ 3,216,021
$ 8,549,484
PEPM
$ 557.43
$ 800.27
$ 785.93
$ 716.04
Children
Enrollees
442
452
470
1,364
Claims
$ 933,266
1
$ 811,289
$ 1,693,130
$ 3,437,685
PEPM
$ 175.96
$ 149.57
$ 300.20
$ 210.02
Total
Enrollees
2,370
2,374
2,392
7,136
Claims
$ 9,668,671
1
$ 10,891,836
$ 12,575,310
$ 33,135,817
PEPM
$ 339.97
$ 382.33
$ 438.10
$ 386.96
Tier Factors
Employee
1.003
0.947
0.922
0.953
Spouse
1.640
2.093
1
1.794
1.850
Children
0.518
0.391
0.685
0.543
Exhibits with BOCC Changes from June 20 mtng Final 16
Benefit and Contribution Changes OPTIONS FOR
FY 2018
%
c,
E
E 2
< 0
>
0
>
0
>
0
R
0
>
0
0
>0
1W On
A�
0
0
U)
LLI
<
LLI
(9
<
Y
z
LLI
LLI
z
<
C)
0
0
61 C)
0
0
ITEMS APPROVED BY BOCC ON 6-ZO-17
Outstanding Items Not Valued
39. Request Clerk audit claims processing (Kolhage requested Madlok do this)
42. Retain expert assistance for assisting medicare eligible retirees to find subsidies and to assist employees w benefit choices
related to High Deductible vs. High Ben Ian
18A. All Spouses of employees or retirees access to coverage through his/her own employer are me igi e or County
Insurance
ZA, Increase U,gent Care c.pay from $ZS 1. $50
3A. Add $100 har.a deductible limited to Wo per famil y
De
19. Conduct pendent Elfg1bilitV Audift (estimated 4% of Dependent cl. Irms)
22, Increase brand drug copays FROM $50/$90 W $605100 (30 day) and $150/$250 NU day)
29, Change PCP, Behavioral Health and Pre/Post Natal Cam CopaiV FROM $25 to $30
30, Add $10 copay for Independent Clinical Lab (Quest)
31. Increase Generic Drug CGPaV to $15
34. Adopt'..Envision select Formulary
36. Exclude Drugs available Over-the-COUnter (OTC)
40. Exclude EVS from network for all prescriptions
Subtotal - Impact of Projected Claim Costs
$1,233,10100
$1,722,000
$1,843,101010
$1,972,000
$2,110,101010
$2,101,116
4A, Provide . Flat $250 Subsidy to Medicare Eligible Retirees ($697 $2S0 = $447)
$850,000
$1,297,000
$1,471,000
$1,658,000
$1,858,000
$1,251,116
6. Reduce subsidy for Dependents of Any Retirees over 3 years
$105,000
$320,000
I$485,000
$543,000
$606,000
$1,146,116
7. Reduce subsidy for Rule of 70 Pre-65 Retirees by 20% each year, over 5 years
$104,000
$378,000
$622,000
$871,000
$1,126,000
$1,042,116
11 Dual Option HSA with LOW option (employees and retirees paying $D); (dependents pay len) HIGH option (employees and
retirees pay MORE monthly to stay on rich plan)
$244,000
I
$490,000
$668,000
I
$858,000
$1,061,000
$798,116
15. Change Medicare Retiree Drug Coverage from RIDS to EGWP
$250,000
$250,000
$250,000
$250,000
$250,000
$548,116
28. Add $75 per month smoker surcharge
$123,000
$164,000
$164,000
$164,000
$164,000
$425,116
41. Establish Acturial Sound Retiree Rate for insurance after retirement instead of retiree paying department rate
$1,000
$4,000
$8,000
$429,116
Subtotal -Impact of Employee/Retiree Funding Changes
$1,672,000
$2,097,000
$3,661,000
$4,340,000
$5,073,000
1
Combined Impact of All Benefit and Revenue Changes
$2,905,000
$4,619,000
$5,504,000
$6,320,000
$7,183,000
$429,116
Combined impact of All Benefit and Revenue Changes plus benefit of increased impact on surplus
$3,521,500
$5,480,000
$6,425,500
$7,306,000
$8,238,000
Alternatives to Option 7 1 Pre-65 Retirees Only)
7A �5c 374;led Subsidy to, R. [a of 7D Retiree, (FIRS - v 25 yos; 25% actuarial rate w ZD-Z4 ym $187; 50% actuarial rate w - 1D-19 yas
$1(35,000
$154,000
$170,000
$187,000
$205,000
1
7A ,,,,, ,IFC�14,cl =$187; 50% .15-19Ys = $374,75A � 10-
t, us = ,71� Icalel sul,d, for 111, 11711 lialinee, (F11 � 11 , 1111.01
$121000
,
$178,000
$195,000
$214,000
$234,000
1
7B Reduce subsidy for Rule af70 Retirees by 3% per year
$3,000
$10,000
$15,000
$21,000
$27,000
1
Attachment. REVISED DODO Decision Options for 7-25-17 Final (MinuteTraq) (3206. Discussion on the County' s Group Health & Prescription
7C Reduce'subsdy for Rule cfeby 8%per year
RULEDITEMS 70 Retires .- 1 -17
$9,000
$2T,000
'.$42,000
$59,000'.
$77,000
13A, Dual Option HSA11,111OW option (employees and rethees pay!ng$0); hdepandents paylessj HIGH option (employees,
retirees,
etirees and dependentsa SAME rates monihl [o staY on doh Ian
$464,120
$648,144
'.$693,514
3. Add$100 pharmacy deductible per individual
$162,366
$215,947
$218,106
37. All amployass pay the same ($75/month)
$402,300
$536,400
$536,400
38. Charge $200 monthly premium for each employee, retiree, and dependent
$1,850,787
$2,467,716
$2,467,716
38A. Charge greater of current premium and $200 monthly premium for each employee, retiree, and dependent
$2,149,695
$2,866,260
$2,866,260
613No subsidy for Dependents ofAny Retirees lrule of 70 retiree dependents and non rule of 70.retiree dependents) (with the
exception of Rule of 70 retirees who retired prior to I/1/18 whose spouses will remain subsidized at the overall dependent
subsidy rate)
$55,674
$109,152
$154,620
6A 40%I Subsidy for Dependents of Retirees l Excluded Medicare Eligibles c ses)
$134,325
$187,585
r.$200,716
6C 40% subsidy for Dependents of AnyR trees (rule of 70 retiree dependents and non -rule of 70 retiree dependents) (with the
aexception of Rule of 70 retirees who retired prior to 11/ 1 /18 whose spouses will remain subsidized at 60% dependent subsidy
te)
$39,366
$75 708
'.$107,988
18 Spouses of Retirees pay 10051 of Actuarial Rate if Spouse has Access to Coverage Through His/Her Own Employer.
$13,662
$18216
'$18,216
7 Nosu6sdymrPre55.Retirass
$1,311728
$1881,827
$1,960055
7A Scaled Subsidy for Rule of 70 Retreas {$141 w25 yns, $2D0 w2D 24 yns, $40uw 1D 19 yns)
$772119
$1128,572
$1,221540
8 Pre 6S ReL rees Pay 50%of Actuar al'.Rate
1
$621 033
$867,272
'.$927,981
'48,Provitlea$200 Subsidy to Medicare Eligible Retirees ($697- $20D= $497)
$979,743
$1,494,972
$1,695,532 '.
1. Increase Deductible from$400/$800 to$600/$1200
$282,831
$376,165
$381,808
2. Increase Specialist copay from $25 to $50
$84,849
$112,849
$113,978
23. Increase specialty drug copay to 25% to maximum of$300
$16,438
$22,955
$24,562
5 Reset Dependent Contributions ibutions from 40%to 50%of Actuarial Rate at Current Hgher Costs
$373,230
$521 216
$557 701
10 Reset Dependent Coitrbutons from 40%to 60% of Actuaral Rates
$599,868
$837716
$896356
9. Active Employees Pay $5D/75 for Employae Coverage
$263,025
$349,823
;$349,823
24, Increase active EEcontributmn3from $PSy$50 toS65/$95 Ila% of actuarlsl value)
$442,440
$617,867
<$661,118
4. Charge Full Annual amount of Health Insurance to Medicare Eligible Retirees 1$697)
$1,312,500
$1,750XID
$1,750,D00 '..
11. set Premium for Retiree Only Cnveraga to a Flat$2DO for Rule of 70 Retirees '..
$272,025
$361,793
'..$361,793
17, Increase Retiree Contributions to a flat$150 for Rule of 70 Retirees
$204,750
$273,000
'..$273,000
25, Increase Retiree Contributions to 20%of Actuarial Value for Role of70 Retirees {$207<65,$1396511
$124,96+3
$174,510
'..$186,726
26, Change Retiree Contributions to $150 for 10 20 YOS and $50 fdr 20+ YOS for Rule of 7D Retirees
$4W,870
$64,997
'.. $64,997
16, Di-Mmue Dependent Subsidy for employees hired after10/1117
$139,209
$590,866
I$997,202
32, Reduce Dependent Subsidy for Future Hl2s tp 50%
$36,706
$155,795
',$262,934
12, Dual Option H5A
$729,734
$1,Dl9,D73
$1,D90,08
14, Dual Option like MCSB
$573,964
$801,541
$857,649
33, Dual Option with HRA{Assume same plan design as HSA optionl12)
$760,335
$1,D61,08
$1,136,135
20, Mandatory Generic Pharmacy Benefit
$24,709
$34,506
$36,921
21. Expanded Mandatory Step Therapy
$16 473
$23,004
$24 614
35, Mandatory 90-day Scripts for Maintenance with Narrower 90-day Retail Network (Walgreens only)
$142,920
$199,587
$213,559
Attachment. REVISED BODO Decision Options for 7-2 -17 Final (MinuteTrag) (3206. Discussion on the County's Group Health & Prescription
FY 2018 Forecasts with Changes Approved by BOCC on June 20, 2017
With Option 6
Forecast Assuming HPAC Recommendations with the following additional Options.
Eliminate Option 11
Add Option 7A over 5 years
Add Options 4A, 41, 28 @ $100, 34, 36, 18A
Impact o
Baseline FY 18
Illustrative
Revised FY 18
Forecast
Changes
Forecast
Projected Starting Fund Balance
$7,595,391
$0
$7,595,391
Projected Revenue at Current Funding
$18,052,606
$1,773,000
$19,825,606
Projected Claims
$18,264,281
($1,135,000)
$17,129,281
Projected Fixed Costs
$1,585,691
$0
$1,585,691
Projected Expenses
$19,849,972
$1,135,000
$18,714,972
Projected Gain/(Loss)(
$1,797,366
$2,908,000
$1,110,634
Projected Closing Fund Balance
Projected Target Fund Balance
$5,798,025
$9,132,140
$2,908,000
$567,500
$8,706,025
$8,564,640
Projected Excess/(Shortfall)(
$3,334,116
$3,475,500
$141,384
Pre 65- Rule of 70 Retiree Rates With Option 7A Phased in Over 5 Years
Without Option 6
mpact o
Baseline FY 18
Illustrative
Revised FY 18
Forecast
Changes
Forecast
$7,595,391
$0
$7,595,391
$18,052,606
$1,640,561
$19,693,167
$18,264,281
($1,135,000)
$17,129,281
$1,585,691
$0
$1,585,691
$19,849,972
$1,135,000
$18,714,972
$1,797,366
$2,775,561 1
$978,195
$5,798,025
$9,132,140
$2,775,561
$567,500
$8,573,586
$8,564,640
$3,334,116
$3,343,061
$8,945
20171
2018
2019
2020
2021
2022
25+ YOS
$139
$139
$139
$139
$139
$139
20-24 YOS
$111
$127
$147
$174
$206
$246
10-19 YOS
$78
$137
$207
$290
$384
$493
Projected FY with HPAC modified 2018 July 25 2017.xlsx 13 7/25/2017