R-2020-0320 - 11/12/2020RESOLUTION NO. R-2020-0320
WHEREAS, the Finance Department has submitted a proposed budget for the Self -
Funded Health Insurance Fund for fiscal year 2020-2021, Now Therefore
BE IT RESOLVED BY THE COUNCIL OF THE CITY OF ROUND ROCK,
TEXAS,
That the budget submitted by the Finance Department for the Self -Funded Health
Insurance Fund for fiscal year 2020-2021, attached hereto as Exhibit "A", is hereby approved.
The City Council hereby finds and declares that written notice of the date, hour, place
and subject of the meeting at which this Resolution was adopted was posted and that such
meeting was open to the public as required by law at all times during which this Resolution and
the subject matter hereof were discussed, considered and formally acted upon, all as required by
the Open Meetings Act, Chapter 5 51, Texas Government Code, as amended.
RESOLVED this 12th day of November, 2020.
CRA MO X
N. Mayor
City of Rou Rock, Texas
ATTEST:
SARA L. WHITE, City Clerk
01 12.20202; 00458747
EXHIBIT
City of Round Rock
Self -Funded Health Insurance Fund
2020-2021 Budget
Beginning Fund Balance
$ 7,916,426
$ 8,711,023
$ 8,778,286
11,386,570
REVENUES:
Stop Loss Reimbursements
808,856
350,000
8777217
6031000
COBRA/Retiree Contributions
266,318
240,000
281,997
240,000
Interest Income & Inc/Dec Fair Value
193,600
1001000
126,413
108,000
Rx Rebates- Seton ACO Risk Share Reimbursement
194,339
200,000
162,716
325,000
City Contributions - General Fund
8,445,244
8,889,600
87710,694
9,193,000
City Contributions - Utility Fund
1,642,020
1,7087104
1,468,460
1,648,000
City Contributions - Hotel Fund
37,683
35,120
44,367
507000
City Contributions - Sports Complex
1247983
1137340
89,103
127,000
City Contributions - Multi Purpose
637282
737332
691954
897000
City Contributions - Stormwater
287,124
2517496
2337600
2767000
Total Employee Contributions
3,174,043
3,295,262
37330,714
3,560,000
Total Revenues
15,237,492
15,2569254
15,395,235
16,219,000
EXPENDITURES:
Wellness Programs
59,949
80,000
591673
80,000
Health Clinic
7651103
750,000
690,286
750,000
Janitorial Services
9,620
10,000
9,932
10,000
R&M - Building
6,611
12,300
6,598
13,000
Power & Light
6,674
7,000
6,769
7,000
Office Supplies
4,144
1,000
17804
17000
Professional Services
72,000
72,000
721000
72,000
Employee Recognition Program
397000
Administrative Fees
440,374
5407000
270,204
5407000
Vision Premiums
117,270
120,000
1207663
120,000
Stop Loss/Reinsurance Fees
1,443,191
17724,100
1,612,111
1,7717000
Health Claims
8,218,311
7,7707420
6,372,628
7,771,000
Dental Claims
5737143
622,230
5051046
6237000
Prescription Claims
27503,487
2,868,075
279007957
3,038,000
Long Term Disability
81,234
89,334
82,870
94,000
Life Insurance
747521
82,500
75,409
87,000
Total Expenditures
14,375,632
149748,959
12,7869951
15,0167000
Net Revenues
861,860
5073295
2,6087284
1,2032000
Fund Balance
897782286
99218,318
11,386,570
12,589,570
Reserves
Less: Restricted for OPEB Funding
(5,249,000)
(5,249,000)
(5,249,000)
(5,249,000)
Total Reserves
(51249,000)
(51249,000)
(512499000)
(5124%000)
Estimated Reserves for Unexpected Claims
$ 3,529,286
$ 3,969,318
$ 6,137,570
$ 7,340,570
25% Reserve
39366,500
37687,240
39410,125
31754,000
Over/(Under)
$ 1627786
$ 282,078
$ 2,727,445
$ 37586,570
Z:\Budget\FY 21\Fund Schedules\Health Fund\Health Fund FY21 11/3/20201:10 PM