R-2017-4939 - 11/9/2017 RESOLUTION NO. R-2017-4939
WHEREAS, the Finance Department has submitted a proposed budget for the Self-
Funded Health Insurance Fund for fiscal year 2017-2018,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 2017-2018, 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 551, Texas Government Code, as amended.
RESOLVED this 9th day of November, 2017.
4 A/"� A/,
CRAI OR , Mayor
City of Round Kock, Texas
ATTEST:
�F�A L .
PLmk-
SARA L. WHITE, City Clerk
0112.1704;00388845
EXHIBIT
11A„
City of Round Rock
Self-Funded Health Insurance Fund
2017-2018 Budget
15-16 16-17 16-17 17-18
YE Adopted Estimated Proposed
BudgetDescription of Item Actuals Budget Actuals
Beginning Fund Balance $ 9,295,089 $ 7,526,373 $ 7,526,373 $ 6,550,896
REVENUES:
Reinsurance Proceeds 300,956 301,000 459,051 301,000
COBRA/Retiree Contributions 223,002 223,000 212,501 223,000
Interest Income 27,715 27,700 25,213 27,700
Miscellaneous Revenue 167,106 170,000 253,874 170,000
City Contributions-General Fund A 5,815,000 6,914,000 6,747,892 8,686,667
City Contributions-Utility Fund B 995,000 1,144,000 1,139,470 1,394,829
City Contributions-Hotel Fund 18,800 43,500 32,745 47,133
City Contributions-Sports Complex 78,000 103,000 103,996 123,414
City Contributions-Multi Purpose - 54,500 16,421 41,439
City Contributions-Drainage 191,500 208,000 206,665 245,311
Total Employee Contributions 2,490,000 2,800,000 2,785,756 2,800,000
GSFC Contribution 500,000
Total Revenues 10,307,079 11,988,700 11,983,583 14,560,493
EXPENDITURES:
Wellness Programs 71,045 80,000 79,979 80,000
Health Clinic 564,288 630,000 870,870 786,000
Janitorial 9,600 10,000 9,685 10,000
R&M-Building 434 1,000 920 1,000
Power&Light 664 3,000 223 3,000
Internet Communications 4,793 5,200 5,144 5,200
Office Furniture 1,000 15 1,000
Supplies&Screenings 1,000 - 1,000
Professional Services 98,832 75,000 72,000 75,000
Administrative Fees 528,549 550,000 513,144 688,000
Stop Loss/Reinsurance Fees 1,013,307 1,100,000 1,178,099 1,200,000
Health Claims 6,334,908 7,000,000 7,039,349 6,800,000
Dental Claims 535,670 515,000 541,107 600,000
Prescription Claims 2,754,733 3,100,000 2,497,458 3,000,000
Long Term Disability 90,099 95,000 78,653 95,000
Life Insurance 68,873 77,000 72,415 77,000
Total Expenditures 12,075,795 13,243,200 12,959,060 13,422,200
Net Revenues (1,768,716) (1,254,500) (975,477) 1,138,293
Fund Balance 7,526,373 6,271,873 6,550,896 7,689,189
Reserves
Less: Restricted for GASB 45 Funding (5,249,000) (5,249,000) (5,249,000) (5,249,000)
Total Reserves (5,249,000) (5,249,000) (5,249,000) (5,249,000)
Estimated Reserves for Unexpected Claims $ 2,277,373 $ 9,022,873 $ 1,301,896 $ 2,440,189
25%Reserve (3,355,550)
A:The General Fund contributions include$336,000 for 28 retirees. C $ (915,361)
B:The Utility Fund contributions include$48,000 for 4 retirees.
C:The fund reserves have declined over the previous three years due to higher than expected
claims.City contributions were adjusted beginning in 2017/18 as a three year plan to restore
reserves to the recommended 25%level.
Z:\Budget\FY 18\Fund Schedules\Health Fund\Health Fund 17-18 Budget 10/30/201711:33 AM