G-11-10-27-9D4 - 10/27/2011ORDINANCE NO. Ci" "Ile -2$#_iii
AN ORDINANCE ADOPTING A BUDGET FOR THE SELF-FUNDED
HEALTH INSURANCE FUND FOR THE 2011-2012 FISCAL YEAR.
WHEREAS, the Finance Department has submitted a proposed budget for the Self -
Funded Health Insurance Fund for fiscal year 2011-2012, Now Therefore
BE IT ORDAINED BY THE CITY 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 2011-2012, 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 Ordinance was adopted was posted and that such
meeting was open to the public as required by law at all times during which this Ordinance 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.
READ and APPROVED on first reading this the t01 day of a...42)),--
2011.
...42) ),--
2011.
411
READ, APPROVED and ADOPTED on second reading this the day of
o�
ATTEST:
, 2011.
0711-14/
ALAN MCGRAW, Mayor
City of Round Rock, Texas
SARA L. WHITE, City Secretary
O:\wdox\SCCInts\0112\ 1104\MUNICIPAL\00233 735.DOC/rmc
City of Round Rock
Self -Funded Health Insurance Fund
2011-2012 Proposed Budget
ACCOUNT NO
Description of Item
10-11
Approved
Budget
10-11 11-12
Estimated Proposed
Actuals Budget
4520-820-00000
4521-820-00000
4610-820-00000
4615-820-00000
7100-820-00000
7200-820-00000
7710-820-00000
7860-820-00000
5133-820-00000
5216-820-00000
5404-820-00000
5405-820-00000
5406-820-00000
5407-820-00000
5411-820-00000
5412-820-00000
Fund Balance 10/1/11
Less: Restricted for GASB 45 Funding
Less: 20% Reserves
REVENUES:
Reinsurance Proceeds
COBRA/Retiree Contributions
Interest Income
Miscellaneous Revenue
City/Employee Contributions -
City/Employee Contributions -
City/Employee Contributions -
City/Employee Contributions -
General Fund
Utility Fund
Hotel Fund
Drainage
Total Revenues
Total Funds Available
EXPENDITURES:
Wellness Programs
Professional Services
Administratvie Fees
Stop Loss/Reinsurance Fees
Health Claims
Dental Claims
Vision Claims
Prescription Claims
Total Expenditures
Transfer to General Fund
Transfer to Utility Fund
Total Transfers
Total Expenditures & Transfers
Estimated Unreserved Fund Balance 9/30/12
based on 777 employees
$10,495,332
(4,000,000)
(2,099,066)
4,396,265
250,000
150,000
35,000
0
6,153,075
1,155,744
25,000
127,602
7,896,421
10,186,024
(4,000,000)
(2,037,205)
4,148,819
1,347,112
172,126
18,342
0
5,762,252
1,060,649
18,005
117,208
8,495,694
12, 292, 686 12,644, 513
10,000 25,005
77,000 72,940
365,000 352,677
875,500 812,019
5,000,000 5,011,093
400,000 330,828
96,000 68,048
1,450,000 1,176,152
8,273,500 7,848,761
759,240 759,240
103,934 103,934
863,174 863,174
9,136,674 8,711,935
$3,156,012 $3,932,578
•
EXHIBIT
"A»
` J-�
$9,969,783
(5,249,000)
(1,993,957)
2,726,826
250,000
175,000
20,000
0
6,320,794
1,183,316
22,698
128,622
8,100,430
10,827,256
58,275
75,000
371,212
1,005,685
6,000,000
350,000
80,000
1,450,000
9,390,172
530,600
72,624
603,224
9,993,396
$833,860
ROUND ROCK, TEXAS
PURPOSE. PASSION. PROSPERITY
City Council Agenda Summary Sheet
Agenda Item No. *9D4.
Consider an ordinance adopting the Self -Funded Health Fund Budget for FY 2011-2012.
Agenda Caption: (Second Reading)
Meeting Date: October 27, 2011
Department: Finance
Staff Person making presentation: Cheryl Delaney
Finance Director
Item Summary:
The City provides a self-funded health, dental, and vision plan which was originally created in 1993. The City
updates the plan periodically to address the needs of its employees. By reviewing the marketplace and updating the
plan design, the City has shown cost savings throughout the years.
This fund accounts for the activities of the City's health insurance needs. This ordinance will establish a budget for
sources and uses related to this fund. It will continue to restrict funds related to GASB 45 (retiree health insurance
benefits) and allocate funds to the operating departments for the City's retirement program (TMRS).
Cost: N/A
Source of Funds: N/A
Date of Public Hearing (if required): N/A
Recommended Action: Approval