Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2024/07/09 WORKSHOP SESSION 1:30PM
II. � isOR RECORD o aT E. o 'T� DATE '7-/- z .2 4 / * * AT f'S O'CLOCK A I M , ,� 41�EN MCQUEE A.A �o , yaZ(4C W7Y C f Ric rY or a� . By c ee • BRAZOS COUNTY BRYAN, TEXAS NOTICE OF MEETING AND AGENDA WORKSHOP SESSION BRAZOS COUNTY COMMISSIONERS COURT BRAZOS COUNTY COMMISSIONERS WILL MEET IN A WORKSHOP SESSION AS FOLLOWS: MEETING DATE: July 9, 2024 MEETING TIME: 1:30 PM MEETING PLACE: Commissioners Courtroom of the Brazos County Administration Building, 200 S.Texas Avenue, Suite 106, Bryan, TX 77803 1. Call to Order 2. FY2024-2025 Budget Discussion Regarding Insurance Premiums and Contributions. 3. FY2024-2025 Budget Discussion Regarding Retirement Plan(TCDRS). 4. Adjourn The Commissioners Courtroom of the Brazos County Administration Building.200 S.Texas Avenue.Suite 106,Bryan,TX 77803 is wheelchair accessible.Handicap parking spaces are available.Any request for sign interpretive services must be made two working days before the meeting.To make arrangements,please call(979)361-4102. s,��� OF Tom}. ONi 7f4 , *I ti. 4).\...' or The foregoing minutes of the Commissioners Court Workshop Session held July 9, 2024, have been examined and are approved in open Court this the 6th day of August 2024,in Bryan,Brazos County, Texas. 101*-j- Duane Peters Steve Aldrich County Judge Commissioner, Precinct 1 --------- --- -----;tiva.cid, g--..e Chuck Kon erla Nancy Berry Commissioner, Precinct 2 Commissioner, Precinct 3 Wanda J. Watso Commissioner, Precinct 4 Attest: mac&0.� Karen cQueen ji , 4 , County Clerk l I an', -- Apki �, n + Ci":, , �G s't7. MINUTES J U LY 9, 2024 BRAZOS COUNTY COMMISSIONERS COURT WORKSHOP SESSION 1. Call to Order A workshop session of the Commissioners' Court of Brazos County, Texas was held in the Brazos County Commissioners Courtroom in the Administration Building, 200 South Texas Avenue, in Bryan, Brazos County, Texas, beginning at 1:30 p.m. on Tuesday, July 9, 2024 with the following members of the Court present: Duane Peters, County Judge, Presiding; Steve Aldrich, Commissioner of Precinct 1; Chuck Konderla, Commissioner of Precinct 2; Nancy Berry, Commissioner of Precinct 3; Wanda J. Watson, Commissioner of Precinct 4; Karen McQueen, County Clerk,Absent. The attached sheets contain the names of the citizens and officials that were in attendance. 2. FY2024-2025 Budget Discussion Regarding Insurance Premiums and Contributions. Judge Peters called the meeting to order at 1:39 p.m. and invited Human Resources Director Jennifer Salazar and Assistant Human Resources Director Raeanna McConathy to speak. Ms. McConathy discussed the current medical coverage data for employees enrolled in the County health plan. She stated that there are 1,055 employees enrolled in medical coverage, and of those, 926 participate in the wellness reward program. Ms. Salazar presented data to the Court showing the trend for the County contributions and employee premiums. They then invited Brenda Cos, VP Strategic Account Executive with USI Insurance Services to discuss the year-to-date claims for the County. Ms. Cos walked the Court through the budgeted versus net costs for 2024, noting that the plan is trending favorably for the County. She provided a cost summary to further detail medical claims, prescription claims, and dental claims. Ms. Cos stated that the dental plan is running at a deficit and it is her recommendation to increase the contribution for 2025. Commissioner Aldrich discussed the possibility of implementing stricter wellness reward plan criteria to further incentivize employees to invest in their health. Ms. Salazar and Ms. Cos agreed that it would be best to work with Texas Association of Counties to enhance the current wellness reward plan. Ms. Salazar then briefly discussed employee life insurance options. 3. FY2024-2025 Budget Discussion Regarding Retirement Plan (TCDRS). Ms. Salazar stated that the current contribution rate to the retirement plan is 17 percent and it is her recommendation to keep that same contribution for Fiscal Year 2025. Commissioner Aldrich requested clarification on the health and life fund balance and the potential to use surplus funds to put toward the OPEB Trust.Auditor Katie Conner and Budget Officer Nina Payne provided clarification and the Court entered into further discussion on the matter. Ms. Conner, Ms. Payne and Ms. Salazar urged the Court to consider that it is important to maintain a surplus in the health and life fund to ensure that sufficient funding is available in the event of a year with several costly claims. Ms. Salazar also noted that based on a recent employee survey, a majority of employees value having retiree insurance. She stated that Human Resources has begun looking into the options. Judge Peters adjourned the meeting at 2:37 p.m. 4. Adjourn Pg I of a- BRAZOS COUNTY COMMISSIONER' S COURT Er DAY OF - i , 20 2 3 0 AM/404 A/©\rlohoe Name Organization (PLEASE PRINT) (PLEASE PRINT) POI 42 P 5 -I flk Xv ciA co '�e�'�`5 of-F. Sips evn c v' PAGLS lb(Ac19e,+ //644 409 n 111- 0/41 41-11(&,, 3A-e0( AN.r 7 n o<r-i J') er-; C 36-.4- !Ay :� L, ,�,� Ai'r�- Co . C.I o r/s Oa . *A. 0\1446 Pim/ubtioi '$A,40tr[As j0c ,LNe96-6\ � v 1 . \Mar() A '7 (ui r c -it 7cArr\JrfA' , / '(12 Pg&of 7�__ BRAZOS COUNTY COMMISSIONER' S COURT '->r DAY OF 20 I �rJ AM/M „ (IC sLb Name Organization (PLEASE PRINT) (PLEASE PRINT) V\<1 r C jUa t e , • a, Egc.,pf=-r- LeAiL &thy,,,a3 c.ouv.,11 re0,1 7 rca5 Nut Cam Cunol- 00(x-t- -N-Annettt# aour+- , Medical Coverage Data Medical Coverage Total Count Wellness Reward Participation Total Count • Employees/Retirees Offered.Medical 'IT 1135:I ness Rate ($75/month discount) i Well 926 Employees/Retirees Enrolled in Medical 1055 : Non-Wellness Rate 127 Employee/Retirees Waived MedicalG *Not included:2 retirees hired<2000 80 ; 12% Medical Coverage Tiers Total Count j Employee/Retiree Only _ IC 671 Employee/Retiree + Child(ren) 191 Employee/Retiree+ Spouse !� 1131 Employee/Retiree + Family 80 : 88% •Wellness • Non-Wellness r ti County Contributions (2008 to Present) $1,600.00 $1,416 $1,400.00 — — $1,373-- . $1,326 $1,274 $1,274 $1,200.00 — — $1,073 $,1,041 $1,000.00 $976 $916 $861 $800.00 $745 $682 $700 $646 $600.00 $547.50- $547.50 $484.50 $400.00 LILi $200.00 — 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 EMPLOYEE PREMIUM HISTORY $800.00 - ph' $600.00 - - ---- - - - -- - - - - - $500.00 Y•, iF $400.00 * „,...i.,, ! ka $300.00 , ' „ $200.00 " ?I L ....; '..,,-: : f $100.00 1 j a y,y0 i; I n p�, Employee Only Employee+Spouse Employee+Children Employee+Family ■2010. $30.00 $320.00 $215.00 $440.00 I■2011 $40.00 $368.00 $247.00 $506.00 ■2012 $50.00 $372.00 $250.00 $512.00 ■2013 $50.00 $372.00 $250.00 - -- $512.00 -- - - ■2014 $50.00 $372.00 $250.00 $512.00 ®2015 - - $53.00 $390.00 $262.00 T $538.00 j■2016, $58.00 $429.00 $288.00 $595.00 1----- - - - - -- -- ----- - - - - --- -- - - - - - --- ■2017 $62.00 $456.00 $306.00 $634.00 ■2018 $66.00 $487.00 $326.00 $676.00 2019 $66.00 $487.00 $326.00 $676.00 ®2020 $74.00 $501.00 $338.00 - - $692.00 122021 $74.00 $501.00 $338.00 $692.00 ;02022 $78.00 $526.00 $354.00 $726.00 ■2023 $63.00 $511.00 $339.00 $711.00 ■2024 $63.00 $511.00 $339.00 $711.00 Wellness Rewards Program History (2018 to Present) 2018 2019 2020 2021 20.22 2023 2024 $2op $3oJ $50 We I I n ess I We l l n ess ;; Wellness We l l n ess *e I I n ess Me I I n ess We l l n ess 1 DiscountjDiscountJ[ Discount_{LDiscount Discount iLDiscountj Discount l Employee Only Premiums (2008 to Present) $90.00 $80.00 - — $78.00 $74.00 $74.00 $70.00 - - - — — $66.00 $66.00 $62.00 $63.00 $63.00 $60.00 $58.00 $53.00 $50.00 $50.00 $50.00 $50.00 - - - - - - $40.00 $40.00 -- - - -- $30.00 $30.00 $30.00 $26.25 - - - - - - - ::::: III - - $0.00 - -- — — 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 l Employee & Spouse Premiums $600.00 (2008 to Present) $526 $501 $501 $511 $511 $500.00 -$487- $487 - $456 $429 $400.00 - - - - ---$390 - - - $368 $372 $372 $372 $320 $320 $304.50 $300.00 $200.00 - - - • - $100.00 - $0.00 — -- 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 Employee & Child(ren) Premiums (2008 to Present) $400.00 — — $354 $350.00 -- — - -- -- $338 -- $338 $339-----$339— $326 $326 • $306 $300.00 $262 $247 $250 $250 $250 $250.00 - - $215 $215 $204.75 $200.00 $150.00 - - - - - - --- --- — $100.00 $50.00 $0.00 = — -- — — —_. — — — — — — -- --- — — 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 Employee & Family Premiums (2008 to Present) $800.00 - - - - ----- - - - $726 $711 $711 $700.00 - - — $676- - -$676 $692 $692 $634 $600.00 - $595 $538 $506 $512 $512 $512 $500.00 -- - $440 $440 $418.95 $400.00 $300.00 - $200.00 - - I. 1 ,1 $100.00 - - 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 USI BUDGET REVIEW BRAZOS COUNTY July 9, 2024 Bobby Anderson - SVP Employee Benefits Brenda Cos-VP Strategic Account Executive www.usi.com ,42.4,.:4:if:44 .•: 'i•:„--'-y;-iral,-:-•;:;f;.„ .:,,,,,,-,zzi. ..,...3,,,,,,,,ti, ••,,,,,,,,,,,,,.., A., ,:,,, ,..... .„-.„,,,...„ • ,,,,,...i.,„, ,,,, , , •., Ta b l e of Contents : t I 4E61 '" ` • Health Experience # Budget Review , • Medical Projection and Contributions >' 4 1 Affordability u Dental Projection and Contributions ate- �. = i k exe Life Insurance Benchmark • Addendum :;#i.„ � Usi it } • Plan Historical *- 2025 COBRA Rates ©2023 USI Insurance Services.All rights reserved. 12 Experience Dashboard Expenence ummary 2tf23 ay YTD d om 2023 Observations or the 2024`Plan ear: Budget $19,197,676 $8,483,971 6.1% Overview through May on a PEPM basis: Net Costs $17,237,595 $6,368,961 -9.9% Net Position to Budget 90% 75% 0` The current month's budget is 2.5%higher from the prior year due to an average increase of 2.5%to premium rates. Net Costs PEPM $1,425 $1,221 -12.9% 0 The Net Position to Budget is 75%,translating to the plan being under the budget by$2.1 million YTD. 0 This includes stop loss reimbursements of$877,360 from 2023. Expected Claims $13,188,860 $6,674,317 21.5% 0 Without these reimbursements,the plan would only be$1.2 million under budget. Net Claims $14,174,686 $5,000,281 -13.6% 0 Current budget is$1,587 and the net cost is$1,221,respectively. Net Position to Expected 107% 75% 0 Gross Rx Claims make up 30%of total paid claims,which is within industry standards(20%-30%). Net Claims PEPM $1,172 $958 -16.5% 0 Enrollment is 3.5%higher from the prior plan year. Average Employees 1,008 1,043 3.5% 1' Overall,current net costs are 14.4%lowerthan the prior year. Large Claimants: 0 Aggregating Specific Deductible of$6ok was eliminated for 2024. Large Claimants 2023 May YTD D There are currently nine large claimants over 50%of the specific stop loss limit(SSL)of 200k. Number of Large Claimants 25 9 a Four of these large claimants are over the SSL by$821k with$1.6 million in claims. Total Paid for Large Claimants $7,164,576 $2,228,042 0 Large claimants make up 34%of gross claims. Claimants Over SSL 14 4 Total Paid Over SSL $2,902,662 $820,931 With only five months of data,the above observations are for demonstrative purposes only. USI will continue to monitor the data as it matures. ---------------- 2024 Budget vs.Net Cosh Historic Budget vs. Idet Costs 2024 YTD >$100,000 Large Claimants $2,000,000 -_.-___ _�. ___ _—___ _. as a%of Total Claims , x 44 _ $20000 __._ $1,500,000 _r 34% $1,000,000 $15,000 -__. 9s .___ __._____ tat%�� � ` e r $10,000 j .� $500,000 ,— — Q - -- - n � ,. $5,000�_ 66 en.;eteeeeekeeeeee'eft.te..,eet , �o- Jan-24 Feb-24 Mpr-24 Apr-24 May-24 $0 _t......_ 2022 2023 2024 'Ili Le e Budget El Net Cost e Budget PEPY B Net Costs PEPY j ■Large Claimants e Other Claims 3 L L"° 2024 Cost Summary - Medical/Rx Budget vs.Net Costs $2,000,000 $1,800,000 $1,600,000 4 s $1,400,000 $1,000,000 c a� �' $800,003 t a: � ; 1 ' z.$600,000 ' / s e •,t �� e r � E ° . " $400,000 �n s ' � a to $200,000 4 i Y � x s tit IC Vie.. ..a t, ,° ,:, "°• - °.,�'s . _ i°L,'a" .. Jan-24 Feb-24 Mar-24 Apr-24 May-24 e Budget m Net Cost . . ..-- . .. s a Enrollment E •ected Fixed Cost 9 . , , 4,�g .,; - r ,ab - .. °'$"� Total Plan Costs Empbyer Position Posifi,on ` Paid Claims a°3 .s �.. Total Total Stop Loss Medical Rx Stop Loss Net Total EE %Paid by Budget Minus Month Admin Fees Total OverSSL Budget Net Cost Contributions: ER Expense Employees Members Premium Claims Claims Reimbursements Claims Employer Actual Wellness Rates Jan-24 1,039 1,803 $44,854 $227,728 $272,582 $1,734,002 $401,835 ($673,707) $407,520 $1,462,131 $1,690,993 $1,734,712 $219,769 $1,514,943 87% ($43,719) Feb-24 1,040 1,801 $44,897 $227,947 $272,844 $704,159 $413,850 ($364,642) $3,689 $753,367 $1,691,272 $1,026,211 $218,632 $807,579 79% $665,061 Mar-24 1,047 1,805 $45,199 $229,481 $274,680 $1,048,749 $411,210 ($333,545) $273,918 $1,126,414 $1,701,977 $1,401,094 $219,425 $1,181,669 84% $300,883 Apr-24 1,045 1,798 $45,113 $229,043 $274,156 $773,248 $491,786 ($185,072) $77,657 $1,079,962 $1,698,839 $1,354,118 $219,119 $1,134,999 84% $344,721 May-24 1,046 1,801 $45,156 $229,262 $274,418 $794,243 $450,652 ($58,070) $58,070 $1,186,824 $1,700,890 $1,461,242 $219,754 $1,241,488 85% $239,648 Rx Rebates ($608,416) - ($608,416) $608,416 Totals 5,217 9,008 $225,218 $1,143,462 $1,368,680 $5,054,401 $1,560,917 ($1,615,036) $820,854 $5,000,281 $8,483,971 $6,368,961 $1,096,699 $5,880,679 92% $2,115,010 ©2023 USI Insurance Services.All rights reserved. Mat I 4 2023 Cost Summary Budget vs.Net Costs S2,500,000 $2,000,000cp $1,500,000 li j 6Ear$1,000000 g b b aq ice' 8 SO Est 4 .° '3I �' Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 a Budget ®Net Cost s . Enrollment` Expected Fixed Cost '` �.e, ��i ldfiCidlms �gb •� �4 �§` Claims PEPM . Total Plan Costs: Employer Position .�'Posl_one EE Total Total Admin Stop Loss Medical Rx Stop Loss Net Total Net Claims/ %Paid by Budget Minus Month Total Over SSL Budget Net Cost Contributions: ER Expense Actual Employees Members Fees Premium Claims Claims Reimbursements Claims EE Wellness Rates Employer Jan-23 980 1,718 $48,324 $200,824 $249,147 $845,591 $523,670 ($308,558) $0 $1,060,702 1,082 $1,557,708 $1,309,849 $212,168 $1,097,681 84% $247,859 Feb-23 984 1,721 $48,521 $201,340 $249,861 $670,073 $455,299 ($228,820) $0 $896,552 911 $1,563,452 $1,146,413 $212,420 $933,993 81% $417,039 Mar-23 986 1,723 $48,620 $201,799 $250,419 $1,027,256 $530,303 ($85,990) $10,457 $1,471,569 1,492 $1,567,144 $1,721,988 $213,366 $1,508,622 88% ($154,844) Apr-23 992 1,729 $48,916 $202,574 $251,490 $670,545 $514,745 ($277,230) $78,553 $908,059 915 $1,575,760 $1,159,549 $213,744 $945,805 82% $416,211 May-23 1,002 1,743 $49,409 $204,066 $253,475 $1,146,105 $446,123 $0 $151,249 $1,592,229 1,589 $1,590,396 $1,845,703 $214,650 $1,631,053 88% ($255,307) Jun-23 1,003 1,753 $49,458 $204,597 $254,055 $1,328,600 $573,129 ($29,010) $664,026 $1,872,719 1,867 $1,592,756 $2,126,774 $215,637 $1,911,137 90% ($534,018) Jul-23 1,005 1,755 $49,557 $205,056 $254,612 $792,725 $722,093 ($124,596) $441,480 $1,390,222 1,383 $1,595,904 $1,644,834 $216,039 $1,428,795 87% ($48,930) Aug-23 1,017 1,771 $50,148 $207,408 $257,557 $894,076 $543,912 ($257,279) $255,161 $1,180,709 1,161 $1,614,440 $1,438,266 $218,099 $1,220,167 85% $176,174 Sep-23 1,020 1,783 $50,296 $208,599 $258,895 $789,217 $592,474 ($430,244) $276,363 $951,448 933 $1,620,396 $1,210,342 $219,936 $990,406 82% $410,054 Oct-23 1,027 1,791 $50,641 $209,302 $259,943 $726,536 $515,483 ($699,797) $148,013 $542,222 528 $1,630,200 $802,165 $220,129 $582,036 73% $828,035 Nov-23 1,032 1,803 $50,888 $209,948 $260,835 $1,068,592 $633,381 ($276,363) $498,682 $1,425,610 1,381 $1,637,580 $1,686,446 $220,644 $1,465,802 87% ($48,866) Dec-23 1,042. 1,813 $51,381 $211,239 $262,620 $1,235,866 $561,363 ($148,013) $378,678 $1,649,215 1,583 $1,651,940 $1,911,835 $221,274 $1,690,561 88% ($259,895) Rx Rebates ($766,570) ($766,570) $766,570 Aggregating Specific Deductible ($60,000) Totals L 12,0901 21,103 $596,158 $2,466,751 $3,062,908 $11,195,182 $5,845,405 ($2,865,901)$2,842,662 $14,174,686 $1,172 $19,197,676 $17,237,595 $2,598,106 $15,406,059 89% $1,960,081 U 023 USI Insurance ervices.All rights reserved. i 5 `3 Rolling 12 - Month Claim Performance Enrollment "°`,- '-', , `Paid Claims a Claims Per EE ,J Monthly Annual leGj 5�� Total Rolling 12 Medical Rx Total Gross SSL Net Total Rolling12- .. Month Rx Rebates Net Claims/ Net Claims/ Employees Months Claims Claims Claims Reimbursement Claims Months ' EC EE' $%.'� Jan-22 998 11,817 $633,311 $379,656 $1,012,967 ($87,025) $0 $925,942 $12,390,348 $1,049 $12,599 Feb-22 992 11,818 $562,732 $385,120 $947,852 ($227,279) ($117,323) $603,250 $12,210,730 $1,033 $12,400 Mar-22 989 11,815 $630,017 $552,147 $1,182,164 ($74,465) $0 $1,107,699 $11,855,328 $1,003 $12,039 Apr-22 980 11,810 $650,888 $493,953 $1,144,841 $0 $0 $1,144,841 $11,715,437 $991 $11,896 May-22 976 11,800 $684,454 $516,888 $1,201,343 $0 ($148,896) $1,052,446 $11,729,522 $993 $11,913 Jun-22 976 11,795 $689,355 $437,815 $1,127,170 ($46,956) $0 $1,080,214 $11,843,808 $1,003 $12,034 • Jul-22 969 11,786 $677,411 $520,701 $1,198,112 ($97,393) $0 $1,100,719 $11,565,963 $980 $11,762 Aug-22 972 11,785 $794,884 $601,170 $1,396,053 ($94,217) ($143,361) $1,158,475 $11,862,608 $1,006 $12,069 Sep-22 971 11,782 $596,912 $636,174 $1,233,086 ($110,576) $0 $1,122,511 $11,856,131 $1,006 $12,071 Oct-22 975 11,780 $769,448 $537,332 $1,306,780 ($289,270) $0 $1,017,510 $12,027,726 $1,021 $12,247 Nov-22 980 11,772 $961,986 $501,747 $1,463,732 ($96,882) ($166,692) $1,200,159 $12,457,115 $1,057 $12,688 Dec-22 986 11,764 $1,117,098 $558,604 $1,675,702 ($98,001) $0 $1,577,701 $13,091,466 $1,111 $13,336 3.9% Jan-23 980 11,746 $845,591 $523,670 $1,369,260 ($308,559) $0 $1,060,702 $13,226,226 $1,124 $13,482 7.1% Feb-23 984 11,738 $670,073 $455,299 $1,125,372 ($228,820) ($173,027) $723,525 $13,346,502 $1,135 $13,614 9.8% Mar-23 986 11,735 $1,027,256 $530,303 $1,557,559 ($85,990) $0 $1,471,569 $13,710,372 $1,167 $14,007 16.3% Apr-23 992 11,747 $670,545 $514,745 $1,185,289 ($277,230) $0 $908,059 $13,473,590 $1,148 $13,774 15.8% May-23 1,002 11,773 $1,146,105 $446,123 $1,592,229 $0 ($186,480) $1,405,749 $13,826,893 $1,178 $14,139 18.7% Jun-23 1,003 11,800 $1,328,600 $573,129 $1,901,729 ($29,010) $0 $1,872,719 $14,619,399 $1,245 $14,934 24.1% Jul-23 1,005 11,836 $792,725 $722,093 $1,514,817 ($124,596) $0 $1,390,222 $14,909,901 $1,266 $15,196 29.2% Aug-23 1,017 11,881 $894,076 $543,912 $1,437,989 ($257,279) ($192,477) $988,233 $14,738,659 $1,249 $14,988 24.2% Sep-23 1,020 11,930 $789,217 $592,474 $1,381,692 ($430,244) $0 $951,448 $14,567,596 $1,231 $14,769 22.4% Oct-23 1,027 11,982 $726,536 $515,483 $1,242,019 ($699,797) $0 $542,222 $14,092,308 $1,186 $14,233 16.2% Nov-23 1,032 12,034 $1,068,592 $633,381 $1,701,973 ($276,363) ($214,587) $1,211,023 $14,103,172 $1,182 $14,186 11.8% Dec-23 1,042 12,090 $1,235,866 $561,363 $1,797,228 ($148,013) $0 $1,649,215 $14,174,686 $1,183 $14,196 6.4% Jan-24 1,039 12,149 $1,734,002 $401,835 $2,135,837 ($673,707) $0 $1,462,131 $14,576,115 $1,211 $14,535 7.8% Feb-24 1,040 12,205 $704,159 $413,850 $1,118,009 ($3E4,642) ($312,814) $440,552 $14,293,142 $1,182 $14,187 4.2% Mar-24 1,047 12,266 $1,048,749 $411,210 $1,459,959 ($333,545) $0 $1,126,414 $13,947,986 $1,148 $13,777 -1.6% Apr-24 1,045 12,319 $773,248 $491,786 $1,265,034 ($185,072) $0 $1,079,962 $14,119,889 $1,157 $13,883 nui amit I a May-24 1,046 12,363 $794,243 $450,652 $1,244,895 ($58,070) ($295,602) $891,222 $13,605,363 $1,109 $13,310 f -5.9% . . Historical Cost Summary Budget vs.Net Costs $25,000 $20,000 $15,000 '$16,893 $17,101 $14,889 $10,000 �. 1 ' ' '_ - °'. r�. 2. $5,000 1 $0 _ 2022 PEPY 2023 PEPY 2024 PEPY Annualized ■Budget •Net Costs Average Medical SSL Net Admin Stop Loss Total Fixed Time Period Employees Budget Claims Rx Claims Rx Rebates Reimbursement Net Claims Costs/Bud Fees Premium Costs Net Costs 2022 Plan Year 980 $18,344,193 $8,768,495 $6,121,307 ($576,272) ($1,222,063) $13,091,466 90.2% $580,436 $2,882,812 $3,463,248 $16,554,714 2023 Plan Year 1,008 $19,197,676 $11,195,182 $6,611,976 ($766,570) ($2,865,901) $14,174,686 89.8% 5596,158 $2,466,751 $3,062,908 $17,237,595 2024 Annualized Plan Year 1,043 520,361,530 $12,130,562 $5,206,399 ($1,216,833) ($3,876,087) $12,244,042 76.3% 5540,523 $2,744,309 $3,284,832 $15,528,874 Change from Change from Change from Time Period Budget Prior Year Net Claims Prior Year Net Costs Prior Year 2022 PEPY $18,719 N/A $13,359 N/A $16,893 N/A 2023 PEPY $19,045 1.7% $14,062 5.3% $17,101 1.2% 2024 PEPY Annualized $19,522 2.5% $11,739 -16.5% $14,889 -12.9% 7 7.„'f-• . 1-, r®° ` , Enrollment by Month and Tier a i¢' s le 7: 200 s 11' Q Ee+Fam ' a is Ee+Ch(ren) .z t •400 - - ■Ee+Sp •, E n roll _m egnt . , 200 -- — ■Ee Only -- -- - r - ti o7' odo o�`' odo oti3 o�� oti' dti r tii> tia tia tip tia ti,1,"'byMe mbe r ti fy ti � \ti dtid d d o \ ti 4 a\ 4 b\ 4 ,\\ ,ti\ ti4a4 g T e° . : Average Enrollment by Year by Tier 1 Year To Date Enrollment Distribution 632 663 600--- 18% u a .1 400 --- R°, WI 184 190 • 1 \`�• ;s 200 - i10—09 "` 82 80 64% Ee Only Ee+Sp Ee+Ch(ren) Ee+Fam ■Prior Year:1/2023-12/2023 a Current Year To Date:1/2024-5/2024 1 ■Ee Only n Ee+Sp •Ee+Ch(ren) n Ee+Fam 8 't • Net Costs PEPY versusTrend • ° a $30,000 $20,040 21 623 ° _, s�°° 520,000 � $17,296 s $15,000 16,893 .. _ _. .. $17,101 4 _° $16,469 $ $14,889 ° $5,000 ae°° aM'utiYear 2020 2021 2022 2023 2024 Net Costs PEPY Trended Costs PEPY Tre n d Actual Costs 2020 2021 2022 2023 2024 Net Costs $17,140,700 $16,222,008' $16,554,714 $17,237,596 $16,628,874 Average Enrollment 991 985 980 1,008 1,043 Net Costs PEPY $17,296 $16,469 $16,893 $17,101 $14,889 Change from Prior Year 0.6% 4.8% 2.6% 1.2% -12.9% Trended Costs 2020 2021 2022 2023 2024 Trended Costs PEPY $17,296 $18,687 $20,040 $21,623 $23,331 Observed Blended Trend(80% med/20%rx) 7.9% 8.0% 7.2% 7.9% 7.9% Medical 7.7% 8.0% 6.9% 7.3% 7.3% Prescription 8.7% 8.2%' 8.6% 10.3% 10.3% 9 �/'� v - ° ,.�� 2024 YID $100 000 Large Clalmantsas a%of Total Claims s . pI 34% l - s ■Large Claimants ■Other Claims . - a '� e. LI .a I Category Total 11 of Total Claims>5200,000 .. $1,620,931 24.5% 2024Claims 5100,000-$149,999 $0 0.0% Canon$100A00-$149,999 , $607,110_` 9.25 s - - Other Claims 54,387,276 66.3% Total 56,619,318 100.0% Paid Claims>3100.000 Amount Claims Over SSL Reimbursements Relationship Diagnosis Plan Claimant - 575$284 ;$558,284 -($558,284) SUB. :C641-Ma6gnantneoPla;mof right kidney,except renal pelvis PPO Claimant 2 $362,958 $162,958 ($162,958) SUB A419-Sepsis,unspecified organism PPO Claimant3 - $299,143 599,143 ($99,143) SU8 F411-Generalized anzietydisonier` PPO Claimant4 $200,546 5546 ($546) SUB 87031-Alcoholic cirrhosis of liver withascites PPO Claimant5 $141,724 - SPS. '751D-Encounterforantineoplastic iationtherapy:, PPO Claimant 6 -$122,250 SUB 2602-Saddle embolus of pulmonary artery with acute cur psimonalef PPO Claimant 7 $115,082 ; DEP i E840-Cysticfibrosis with Pulmonary manifestations :PPO Claimant8 $114,062. SUB 12510-Atherosclerotic heart disease of native coronary artery without angina pectoris PPO' Claimant $113,992., SUB •-� C50411-Malignaninebplasm of upper-outer quadrant of right female breast ', �PPO. S2,228042 ism,931 ($B2os3i) o. 10 ° Top Drugs by Paid A Drug Name Generic Available #Scripts Total Paid Average$Per Script ;; ` ° ° 1 Takhzyro No 6 $298,934 $49,822.30 • 2 Ozempic No 319 $214,316 $671.84 F : ° r, r 3 Stelara No 5 $132,548 $26,509.60 ' x 4 Trikafta No 4 $105,041 $26,260.18 gv a 5 Humira Pen No 16 $104,016 $6,501.03 ° 6 Ibrance No 6 $95,011 $15,835.13 s 7y - � 7 Wegovy No 83 $77,847 $937.92 - ° _ 8 Biktarvy No 24 $75,119 $3,129.98 ., 9 Jardiance No 102• ° � $68,565 $672.21 S 44h yo R 10 Jakafi - No 5 $63,092 $12,618.44 ,To N .. i Totals 570 $1,234,491 $2,165.77 - , ) 'D r gs I All Other 13,882 $934,842 $67.34 1 g ,4= ; Total All 14,452 $2,169,333 $150.11 a °:m ;I Top Drugs by Number of Scripts �i Drug Name Generic Available #Scripts Total Paid Average$Per Script 1 Atorvastatin Calcium Yes 366 $5,942 $16.23 re# ., 2 Amlodipine Besylate Yes 343 $732 $2.13 r 3 Ozempic No 319 $214,316 $671.84 4 Levothyroxine Sodium Yes 242 $1,353 $5.59 , 5 Lisinopril Yes 237 $715 $3.02 6 Losartan Potassium Yes 237 $1,238 $5.22 7 Rosuvastatin Calcium Yes 230 $3,976 $17.29 ,-,., g 8 Pantoprazole Sodium Yes 222 $1,065 $4.80 —.... ° •., •- 9 Metoprolol Succinate Er Yes 211 $1,706 $8.08 10 Prednisone Yes 179 $92 $0.52 Totals 2,586 $231,136 $89.38 All Other 11,866 $1,938,197 $163.34 Total All 14,452 $2,169,333 $150.11 11 2024 Cost Summary - Dental Budget vs.Actual Net Cost $70,000 $60,000 $50,000 $40,000 -- ------ ---• $30,000 - - - - - $20,000 --- - - -- - - ------ - -- -- - -- -. . _ -- $10,000 - - - - -- 0 $0 �a Jan-24 Feb-24 Mar-24 Apr-24 •Budget •Actual Cost Enrollment .Actual Fixed Cost Paid Claims Claims PEPM Total Plan Cost Employer Position Position EE %Paid by Budget Minus Month Total Employees Admin Fees Dental Claims Claims/EE Budget Actual Cost Contributions ER Expense Employer Actual Jan-24 971 $2,306 $41,551 $42.79 $45,694 $43,857 45,694 (1,837) -4.2% $1,836.51 Feb-24 971 $2,309 $51,888 $53.44 $45,609 $54,197 45,609 8,588 15.8% ($8,587.55) Mar-24 977 $2,321 $58,628 $60.01 $45,718 $60,948 45,718 15,230 25.0% ($15,230.33) Apr-24 974 $2,313 $59,964 $61.56 $45,617 $62,277 45,617 16,661 26.8% ($16,660.56) May-24 974 $2,316 $50,040 $51.38 $45,742 $52,355 45,742 6,613 12.6% ($6,612.92) Totals 4,867 $11,564 $262,071 $53.85 $228,380 $273,635 228,380 45,255 16.5% ($45,255) ©2023 USI Insurance Services.All rights reserved. M. I 12 0 t A 2024 Cost Summary - Dental - Budget vs.Actual Net Cost $60,000 $50,000 $40,000 a ° s� €5 $30,000 4.E111 � � `��A :: . Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 la Budget ®Actual Cost Enrollment Actual Fixed Cost' Paid Claims Claims PEPM Total Plan Cost Employer Position Position ; Month Total Employees Admin Fees Dental Claims Claims/EE Budget Actual Cost EE Contributions ER Expense Paid by Budget Minus Employer Actual Jan-23 915 3,181 $40,184 $43.92 $43,045 $43,364.80 $43,045 $320 0.7% ($320.03) Feb-23 920 3,198 $47,962 $52.13 $43,211 $51,160.20 $43,211 $7,949 15.5% ($7,948.82) Mar-23 918 3,191 $46,661 $50.83 $43,165 $49,852.06 $43,165 $6,687 13.4% ($6,687.48) Apr-23 924 3,212 $45,698 $49.46 $43,329 $48,910.19 $43,329 $5,581 11.4% ($5,580.88) May-23 933 3,243 $48,949 $52.46 $43,835 $52,192.59 $43,835 $8,358 16.0% ($8,357.84) Jun-23 935 3,250 $37,795 $40.42 $43,923 $41,045.03 $43,923 ($2,878) -7.0% $2,877.71 Jul-23 935 3,250 $34,682 $37.09 $43,958 $37,932.79 $43,958 ($6,026) -15.9% $6,025.51 Aug-23 947 3,292 $50,088 $52.89 $44,518 $53,380.16 $44,518 $8,862 16.6% ($8,862.13) Sep-23 948 3,296 $39,131 $41.28 $44,651 $42,426.24 $44,651 ($2,225) -5.2% $2,224.70 Oct-23 955 3,309 $48,377 $50.66 $44,881 $51,686.81 $44,881 $6,806 13.2% ($6,805.61) Nov-23 959 3,320 $45,954 $47.92 $45,117 $49,274.10 $45,117 $4,157 8.4% ($4,157.03) Dec-23 968 3,365 $34,866 $36.02 $45,345 $38,231.34 $45,345 ($7,114) -18.6% $7,114.12 1JS/) I 13 Totals 11,257 $39,108 $520,348 $46.22 $528,979 $559,456 $528,979 $30,478 5.4% ($30,478) Time Periods Current-AIL PLAt4S Renewal Period: January-25 December-25 Experience Period: June-23 May-24 Enrollment Period: May-23 April-24 Current Enrolled Employees: 1,046 T Current Enrolled Members: 1,801 // Renewal Calculation PEPM / Claim Development Medical Rx • ,` '� Paid Claims I $11,890,013 I $5,886,892 1 r,s .°.r°°°� '^_r= �_6 Total Large Claims in Excesso1151(5200k) ($3,191,710) ($2,456,210) g ° ° Benefit Adjustment ($173,883) ($68,581) Adjusted Paid Claims $8,524,421 $3,362,102 • ° ° ®\ a 1 Annual Trend 6.0% 12.0% Q ° ° 4 Midpoint Months 20.0 19.0 it� � � Applied Trend 10.2% 19.7% UnderwrTrended Claims $9,393,800 54,022,901 g � Portion of Large Claims up to 1SL $1425,463 $1,174,537 2025 ' Adjusted Trended Claims 510,819,263 $5,197,438 M Total Subscribers 12 3fl9 12,363 e d/R X Adjusted Trended Claims(PEPM) $878 26 $420.40 x .°°.st° Current Employees 1,046 1,046 I a Pr oj,e'c t I O ri Total Projected Trended Claims $11,023,897 $5,276,894 Total Projected Trended Claims(PEPM) $1,298.66 Claim Period Weighting 100% \ Total Experience Projection I $16,300 791 I $1,298.66 Fixed Costs MO Fee(PEPM) 5558,126 544-47 15L Rate(PEPM) $3,135.239 5249.78 ASL Rate(PEPM) 524,853 $1.98 PCORI Fee(PEPM) 56,694 $053 Total Fixed Costs $3.724.911 5296.76 Needed Premium Equivalents 20025703 $1 95.42 Current Premium E•ulvalents 520,41.0.680 1,626.09 14 Needed Change to Current Premium Equivalents -1.9% 2025 contribution Discussion Brazos County- 2025 Contribution Scenarios Monthly Medical Totals 1)24(Current.PY),::: , e - i' , t. .o„ � „ „d .. r PPO Plan ki 4i-d` Wig a � ; :: rff o' r 3, . , ' a'ss a^ st 0 4 ER Cost G Employee $63 00 �` 1 $1,416.00 $1,479.00 95.74% 666 $ 943,056 $ 985,014 Employee+Spouse $51100 $1,416.00 $1,927.00 73.48% 110 $ 155,760 $ 211,970 Employee+Children $339 00 I $1,416.00 $1,755.00 80.68% 189 $ 267,624 $ 331,695 Employee+Family .,$71100 h,.1 $1,416.00 $2,127.00 66.57% 80 $ 113,280 $ 170,160 Totals 1,045 $ 1,479,720 $ 1,698,839 Enter Desired EE Increase(%): o : 1 $ 17,756,640.00 $ 20,386,068.00 PIVfonthiy}Medical Totals(202 PYVY g . �': h ' ' •1 `' _ ` s ° a ' � z PPO Plan ' aid sow 3 a ,°�'1 � s . o ,,G,vss e: e ,�-a il �� . . Employee $63.00 $1,387.90 $1,450.90 95.7% 666 $ 924,341 $ 966,299 Employee+Spouse $511.00 $1,379.39 $1,890.39 73.0% 110 $ 151,733 $ 207,943 Employee+Children $339.00 $1,382.66 $1,721.66 80.3% 189 $ 261,322 $ 325,393 Employee+Family $711.00 $1,375.59 $2,086.59 65.9% 80 $ 110,047 $ 166,927 OVERALL 1,045 $ 1,447,442 $ 1,666,561 ANNUAL 12,540 $ 17,369,305 $ 19,998,733 CHANGE(%) -2.2% -1.9% • It is not recommended to lower the budget. $ 17,369,305 $ 19,998,733 ©2023USIIn VOA _ r`it __ _St ,iP 1 . I 15 Affordability Enter lowest FTE monthly income here: L$ 2,225.67 Enter lowest hourly wage here (leave blank if no hourly wage information is provided): Enter highest monthly employee-only contribution for lowest cost plan here: $ 63.00 Enter any monthly cash-out payment available if an employee waives coverage here(leave blank if no cash-out is available)7*: $ - Maximum monthly Ee cost: $ 186.73 Is current coverage affordable? k,b:e. • Wellness penalty is currently $75. Maximum estimated wellness penalty $123 based on lowest paid. • This is illustrative only as 2025 regulations have not yet been updated. ©2023 USI Insurance Services.All rights reserved. USI I 16 Time Periods Current-ALL PLANS . Renewal Perio-d. 3asauary 25 December-25 Experience Peri®al: .hnie 23 May-24 • Enrollment Period: May-23 April-24 6 3. °* Current Enrolled Ernp2oyees 974 ¢, ° ° ;� Renewal Calculation PEPM` ® > ..a ` Claim Development ° Paid Claims $552,964 ° _ ®enefit Adjasstrsrent $0 a i teal Paid Claims $ 3 ass 52,964 5 a ° Annual Trend 4.0% �",U , E�liatianint 61�unihs nde.rwrIt� ng . °a � Via ` Applied Trend 6.4% . . $ $2 0 2D ental R n `� Adjusted Trended Claims $5 �,392 Total Subscribers 11,473 1!-a'P rod east i on 3*r Adjusted Trended Claisrss(PEPMi) $5t 2E • r 3' IDS'. p • Current Employees 974 Total Projenter$Trended Claims $599,418 Claim Period llyei68stin� 100% °,_ Totaterience Projection $559;41� I $SIl 28 Fixed Costs ASO Fee(PEPM) 1 $34,069 1 $293 Projected Premium Equivalents 6334�7 54.20 Current Budget $548,908 $46.96 Needed'Chanaeio Curren!Premium'Equivalents `t 17 2025 Dental Contributions Monthl 2024 Monthly.2024 Per Pa (24 2025 Morlthl^° 2025Pe15Ra,>24? '.ifference Per Pa 1 Round Per Pay EE $ 30.00 $ 15.00 $ 34.62 $ 17.31 $ 2.31 $ 18.00 ES $ 80.00 $ 40.00 $ 92.32 $ 46.16 $ 6.16 $ 47.00 EC $ 71.00 $ 35.50 $ 81.93 $ 40.97 $ 5.47 $ 41.00 EF $ 127.00 $ 63.50 $ 146.56 $ 73.28 $ 9.78 $ 74.00 ©2023 USI Insurance Services.All rights reserved. MI I 18 Life Insurance Benchmark Ccun?q' SCCC4 `zb251c ufe Gc rumen* Employtees southaess Basic Life Percent of groups offering basic life insurance • 65% 84% 78% 1times pay 17% 25% 16% 1.5 times pay 1% 5% 2% 2 times pay 6% 15% 10% Another multiple of pay 1% 5% 4% Flat amount • 75% 50% 68% Average Flat Amount $20,000 $50,000 $50,000 $50,000 Benefit Maximum 5100,000 $125,000 $100,000 Life Amount Life Rate ____Volume_ Monthly Life Total AD&D.Rate.Monthly AD&D Total Total Monthly Life and AD&D Total Annual Delta $ 20,000.00 $ 0.185 $15,835,000.00 $ 2,929.48 $ 0.027 $ 427.55 $ 3,357.02 $ 40,284.24 $ 50,000.00 $ 0.179 $35,735,000.00 $ 6,396.57 $ 0.027 $ 964.85 $ 7,361.41 $ 88,336.92 $ 48,052" $100,000.00 $ 0.179 $71,470,000.00 $ 12,793.13 $ 0.027 $ 1,929.69 $ 14,722.82 $176,673.84 $13638970 ©2023 USI Insurance Services.All rights reserved. I 19 i e Addendum ©2023 USI Insurance Services.All rights reserved. !USI'1 I 20 0 30 -- ' '3030 20I1 2022 23 IU34' In-Network Out-ol-Network In-Network Outol-Network In-Network Out-of-Network In-Network, Out-of-Network In-Network Out<r-Ndtwork Individual Deductible $3 m0 $1.Sm $1,D00 $1.5m $1.000 $1,Sm $1Dm $I.Sm $],000 $1,500 ° Family Oetlumhle •$2,Ey30, $3,m0 $2,000 $3,OOD $20m $3,DD0 $2Dm $3,0% $2.m0 $3,000 "' IntivdueI Dutof Pocket ,.5,,001 8: $9,000 $3,500 59,000 $3,500 $9,000 $3,500 $9,000 $3,500 $9,D00 Family Out of Pocket 57660 R`. $18.003 $7,m0 $18,000 $7,000 $18,000 $7,003 518,000 57,030 $18,000 = weemeraxermmare °' Cainsuran¢ 00% 30% ✓% 30% 80% 30% 8006 30% 006 30% • • g • a,,° : Office Visits $25/$35Copay Deductible•70% 525/$35 Copey Deductible•70% $25/$35Copay Deducible•70% $25/$35Copay Deductible•20% $25/$35Copey 01000libl e•70% URGENT CARE 550 De doable•70% $50 Deauable•JO% 550 Deducible•70% 550 Deducible•76% $50 Deduuble•70% g €-`<' b`7'•` ER 0070$ tAxnl $I$000Pay then 2W6 5150 Copey then 20% $150Copay then 20% $150 Copay Ilan 20% 9°'Ott _ { ial- S = evvvvwv�mf�/ nr4 Cvnav waned/ tad veil/ uN C070povry / mrtee eoeav�0 7 mR[d ° p .• - i` ° ° ° E Mil Order M II Order M IIoider Mall Order k M II Order 5I° pro.,,,,,,nDrirgrCOPay Retail RNail Retail. R to I' s,a ,�° a ,+'_ (90 Day Supply) (90 Day5UVPIYI (90 paY5uPp)Y)` 190 DaY5UPPIY). Retail (90D Y5upply)' _2 a a;.= b a cenedc ° ;1D'.".:. s15 $10 Ss $10 y s1s $1D I. 51D 51s ffi i°° $ ° Rmntl Formulary 2py6 (M nimum 20% (Nummum 20% (Mnimum 20% IMmmum ID% (Nvnimum 20% (Nu'nimum 2% IM n mum 10% (hln mum 20% IMin mum 20% (Nunimum °- °° $25510imum $SO,Maamum $25,510 i) $50,Manmum $25,Maamum $50,Minimum $25,Maamum $SO Maximum $25,$103) m $SO 5200) m s �a= slur) $zm) Slm) $zml slur) $2m1 $100) $zml $1m1 Szml 9 3mrt� g i ° p ' g' a p 01, &antl Non-Formulary - .Ag=si 20% (M'imam 30% IM nimum 2D)6 (Mnrmum 2036 IM nimum 20% INtin mum 20% (M-n'mum 2036 IM nimum 20% IM nimum 20% (NLn mum 2W6 IM'n mum ° °' =� ° " am_ g a oNer WCo$ov4me0r eP5ntare1ds0 0m0e)0nn0humvae c ewp�tiNv$0enso1 nm$Mo2 as0ca0holas)m rehua mre CWw$ommer,e PM5nre1'asm xvmie1m nnutibmvae c ewp0Ehv$menso,nmM5200)asmxhiasm nreua mre [Wa$ov4me0r.e PM$ nrl'aesmivme lm nnutihmvae c ewDitt M1$v 8an0so nmM$2 as0mvh0)asm rehuar me CWo$ov-4m eDr e MP$nr1'aes0 iv0me)m nnuttrimvae<ewpibth$v mensO nMm5200)asmaM1 asm rheua mre CWNoo$ovn4me-0or,e PMl$n3r1'0aes0 cv00m e )lm nn0utilmmv8e 0m0 w0p bN$v 0ens10, nm$Mo2 asmmxhia) 'y q '= RY OUT-OF-ROUST $3650/527 53650/577M 53650/577 $3850/577 $3R50/57)m PI1 2y [aver Clinical Trials Q n y ° .„ .,, a ga .. ° ,,,......,,.....,, e f S � P . 2 ° , 1 ' :�H 1StrIca ® f, . ° to dT C Joined TAC Joined TAe loured TAC Joined TAe' , } • f sm reh ,,. ua mr—Oe INS Ca mark Rs wl[M1 NS/Caremah oe withM Caremark Ra with[VS/Caremarkfly with NS/Caremark 4 } S a- g 7.""K F„ f 5peuhcDeductble a@5_ 5305 20K 2000 2000 20K i per 'F=.° a Aggregating 5pedcflc Deductible 60K 60K WK 60K 60K e^" Ta x "5 / • ` . ° Co db1310 s.. w/O W ill r wellness W/O Wbillneu'. wellness w/O W 111 W Ilness W/D Weillo301 W II s w/Dw-illness wellness ° e • Employe O IY $]3 4mq r,3'$74m 5124.03 $74.m $13831 6` a $78m 5138.m $63m' $13800 503.m Employ Spouse $Sia m 550100 555100 550100 $50 m6 y 6 55,00 $586 m m $511 ,_ $566.00 5511m = Employe Children 5368m 5338 m• $38800 5330m $44m $354m 5414,m $339m` $4141U 533Am ' 0 Employee+Family 5742G0.,�w 569200 574203 5692m 578E ___'.$720.m $786.00 $71103• $7 0) 571100 a 550 Dsmb 0000p m m I0r $m DismunlunEEpremium for = .• „ L.IF`�oeo>u Wellness 6u° 6 s Employee.nly 5(42696 51,425.96 51'43208 012D160 51,294.60 A z° $ � EmplOyee+Spouzv 523fiY 50 51,86150 �i959D4 §`. /2/7,69 51,20).69 • - _x„ ' Employee+Cnldren £ $69k`2 51.695,4 $l31360 `1$}54.04 51,549.09 Employee+Fam ly a:.»s$'2256 ='02. $2,056.32 ;,$}9364 ,.,, ,. .1,5189111 $1.892.11 Do 581Wpdz$50 llneu- Doesnolineude 550wellness 00e include ssowellness DOesnutmdutle$mwellness Ito Sootndude 550wellness d bl tine COONA Rat%: tliamunt mrtme C08RARale. dismunlf0rlme C080A Rate. dtsc0unl10r We C00RA Rafe. d'sc0unt mr 00 C080A Rafe Fm310400 Daly $157400, 51279.00 $13 fim $13)3m $416m Employee+Spouse $1.77400 $1,224.0 5 1 6.m $1,373 m i $1416m Employee+Children $13J4m $1,224.0 31'f-&C00 $13730 $Z 1600 Employee+Famdy „$1'274U0 __ $1.224m 53,3260% $137300 ° ',. 1600 < P - 51/5(. ,RI Daai c a i- 21 Ry -0 fed fu'r.9.6%.' Pry 9'p )ledlor 0 H will 36%increase 0 vka Wil 3Y othe 'lhebudfel — ,.., C$40101, r `,l 1 2025 Medical COBRA Rates Brazos County-2025 Contribution Scenarios `Monthly Medical Totals.2024(current PY) PPO Plan V Paidl } ER Raids s Budgeter 4 '7 . :Subs Est..2024 ER Cost p Employee $63.00 i $1,416.00 $1,479.00 95.74% 666 $ 943,056 $ 985,014 Employee+Spouse 'L $511.00 $1,416.00 $1,927.00 73.48% 110 $ 155,760 $ 211,970 Employee+Children $339.00 $1,416.00 $1,755.00 80.68% 189 $ 267,624 $ 331,695 Employee+Family $711.00 $1,416.00 $2,127.00 66.57% 80 $ 113,280 $ 170,160 Totals 1,045 $ 1,479,720 $ 1,698,839 Enter Desired EE Increase(%): ` 44 $ 17,756,640.00 $ 20,386,068.00 Monthly Medical Totals(2025 PY) PPO Plan Efilraid(;$) E,tgari's3r($) Bat et Rates cratZtjftgitEl. ,,i1Subs, Est,.2.025 ER Cost Grass Employee $63.00 $1,387.90 $1,450.90 95.7% 666 $ 924,341 $ 966,299 Employee+Spouse $511.00 $1,379.39 $1,890.39 73.0% 110 $ 151,733 $ 207,943 Employee+Children $339.00 $1,382.66 $1,721.66 80.3% 189 $ 261,322 $ 325,393 Employee+Family $711.00 $1,375.59 2086.59 65.9% 80 $ 110,047 $ 166,927 OVERALL 1,045 $ 1,447,442 $ 1,666,561 ANNUAL 12,540 $ 17,369,305 :$ 19,998,733 CHANGE(%) -2.2% -1.9% • COBRA rates are the new 2025 budget rates plus 2%. $ 17,369,305 $ 19,998,733 L, t r ©2023 USI Insurance Services.All rights reserved.. I 22 2025 Dental COBRA Rates Montn < 2024 Monthi 2024;Pe.r Pa -24 -° 025!1Pa a ,b�lffece WO- Par Round Per Pay EE $ 30.00 $ 15.00 r$ 34.62 $ 17.31 $ 2.31 $ 18.00 ES $ 80.00 $ 40.00_ $ 92.32_$ 46.16 $ 6.16 $ 47.00 EC $ 71.00 $ 35.50 $ 81.93 $ 40.97 $ 5.47 $ 41.00 EF $ 127.00 $ 63.50 $ 146.56 $ 73.28 $ 9.78 $ 74.00 • COBRA rates are the new 2025 budget rates plus 2%. ©2023 USI Insurance Services.All rights reserved. . I 23 n,r .„^- '/ , ck.)) 1171,1,,,,,,,-, II,„,,-, 11 )z„,,,, i,,,,4. [:(77„., r,G)lpf.P'=:5 ad :I/ 1E.1-LII::;;''''Z 1 (c,-4, L-) 74 tr r lid Li'.20 r i(f,-,,rj Z33) I. ",c)ri MtdilCR Ccurit, Contiboar)N 2024 2025 $ Increase Per Employee Monthly $1,416 $1,416 $0.00 Yearly $16,992 $16,992 $0.00 CM piB or e PTe J-T)I U in t3 Medlcui (Viorithiy) 2024 2025 $ Increase Employee Only $138 $138 $0 Employee + Spouse $586 $586 $0 Employee + Children $414 $414 $0 Employee + Family $786 $786 $0 VW'rileacr ReFfecis Prfo2 Felin ($1511iionth Dizcount On lwr Medical Pmrdwim ) 2024 2025 $ Increase Employee Only $63 $63 $0 Employee + Spouse $511 $511 $0 Employee + Children $339 $339 $0 Employee + Family $711 $711 $0 -1--)SITU-11_ Employee Contributions 2024 2025 $ Increase Employee Only $30 $36 $6 Employee + Spouse $80 $94 $14 Employee + Children $71 $82 $11 Employee + Family $127 $148 $21 itagrallons-3? ConlTel i I'Lirilil ',IiterAli Man tit vg,1% Mal., TEXAS NS �' ICO:UNTY & O DI5T RI-CT RETIREMENT' SYSTEM Plan Assessment for Plan Year 2025 Brazos County— 120 Participation Date— I/I/1968 It's that time of year again—time to look at your TCDRS retirement plan and decide whether or not your benefits are adequate and affordable.This plan assessment will give you an overview of the benefits you provide as well as how much it will cost to provide these benefits in the upcoming plan year. 2025 Plan Basic Plan Options _ 1 Employee Deposit Rate 7% Employer Matching 225% Retirement Eligibility Age 60 (Vesting) 8 years of service Rule of 75 years total age+ service At Any Age 30 years of service Optional Benefits V-- I Partial Lump Sum No Group Term Life None Retirement Plan Funding Total Normal Cost Rate 14.94% Employee Deposit Rate -7.00% Employer-Paid Normal Cost Rate 7.94% UAAL/ (OAAL) Rate 7.18% Required Rate 15.12% Elected Rate 17.00% Contribution Rates 1 Retirement Plan Rate 17.00% (greater of required and elected rate) Group Term Life Rate N/A Valuation Results(Dec.31,2023) Actuarial Accrued Liability $356,441,751 Actuarial Value of Assets $302,778,996 Unfunded / (Overfunded)AAL $53,662,755 Funded Ratio 84.9% Notes: Buyback adopted: 1991 Last COLA: 2023 800-651-3848 * TCDRS.ORC/EMPLOYER 1 4/1/2024