Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2025/07/15 Workshop Session 2:00 PM
FILED FOR RECORD tE gyp! DATE �r.. ( f� D� 3 2: ' ; t AT • !.J O'CLOCK [ M ZO$KAREN MCQUEEN BRA COUTY CLERK ,pUt <71 ti8/ By BRAZOS COUNTY BRYAN, TEXAS NOTICE OF MEETING AND AGENDA WORKSHOP SESSION BRAZOS COUNTY COMMISSIONERS COURT BRAZOS COUNTY COMMISSIONERS WILL MEET INAWORKSHOP SESSION AS FOLLOWS: MEETING DATE: July 15, 2025 MEETING TIME: 2:00 PM MEETING PLACE: Commissioners Courtroom of the Brazos County Administration Building, 200 S.Texas Avenue, Suite 106, Bryan, TX 77803 THE PUBLIC MAY WATCH THE MEETING LIVE ON THE BRAZOS COUNTY COMMISSIONERS COURT YOUTUBE CHANNEL AT: HTTPS://WWW.YOUTUBE.COM/@BRAZOSCOUNTY3227. THIS MEETING WILL BE CONDUCTED BY VIDEO CONFERENCE WITH AT LEAST A QUORUM OF COMMISSIONERS COURT MEMBERS PARTICIPATING IN PERSON AT THE COUNTYADMINISTRATION BUILDING IN ACCORDANCE WITH THE PROVISIONS SET FORTH IN SECTION 551.127 OF THE TEXAS GOVERNMENT CODE. 1. Call to Order 2. Presentation and Discussion of the FY 2025-2026 County Budget regarding Insurance Premiums and Contributions(USI). 3. Call for Department Heads and Elected Officials input and/or concerns regarding Insurance Premiums and Contributions. 4. Presentation and Discussion of the FY 2025-2026 County Budget regarding Retirement Plan (TCDRS). 5. Call for Department Heads and Elected Officials input and/or concerns regarding the Retirement Plan. 6. Presentation and Discussion of the FY 2025-2026 County Budget regarding the following: • a. Cost-of-Living-Adjustment(COLA) • b. Merit Allowance and Merit Policy 7. Call for Department Heads and Elected Officials input and/or concerns regarding the following: a P 3 • a. Cost-of-Living-Adjustment(COLA) • b. Merit Allowance and Merit Policy 8. 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. ,f . _ •�p�`��tam. h� �. e' OF • The foregoing minutes of the Workshop held July 15, 2025,have been examined and are approved in open Court this the 12th day of August 2025, in Bryan, Brazos County, exas. Kyl K Bentley Nettles Acting County Judge Commissioner, Precinct 1 uck Konderla Fred Brown Commissioner, Precinct 2 Commissioner, Precinct 3 Wanda J. Watson Commissioner,Precinct 4 Attest: Cf(e Karen cQueen County Clerk E VT. 4{ {t • . T * r7, 8": ` V R Re zsAy„_m M..}Y41F MINUTES J U LY 15, 2025 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 2:00 p.m. on Tuesday, July 15, 2025 with the following members of the Court present: Kyle Kacal,Acting County Judge, Presiding; Bentley Nettles, Commissioner of Precinct 1, Via Video Conference; Chuck Konderla, Commissioner of Precinct 2,Absent; Fred Brown, Commissioner of Precinct 3; Wanda J. Watson, Commissioner of Precinct 4; Karen McQueen, County Clerk; The attached sheets contain the names of the citizens and officials that were in attendance. 2. Presentation and Discussion of the FY 2025-2026 County Budget regarding I nsurance Premiums and Contributions (USI). Bobby Anderson and Brenda Cos with USI Insurance Services presented the Fiscal Year 2026 Insurance Premiums and Contributions review with cost projection data through May. Mr.Anderson discussed the trends for the current fiscal year and Ms. Cos recommended that employee contributions remain the same. The presentation is attached hereto. Director of Human Resources Jennifer Salazar provided the 2025 Employee Insurance Budget Review summary and the proposed Medical and Dental rates for 2026. The review and proposal are both attached hereto. The Court engaged in discussion with Mr.Anderson, Ms. Cos and Ms. Salazar. 3. Call for Department Heads and Elected Officials input and/or concerns regarding Insurance Premiums and Contributions. There were no Department Heads that wished to speak. 4. Presentation and Discussion of the FY 2025 -2026 County Budget regarding Retirement Plan (TCDRS). Budget Officer Nina Payne presented the plan assessment for 2026 regarding the Retirement Plan TCDRS. The assessment is attached hereto. 5. Call for Department Heads and Elected Officials input and/or concerns regarding the Retirement Plan. There were no Department Heads or Elected Officials that wished to speak. 6. Presentation and Discussion of the FY 2025-2026 County Budget regarding the following: • a. Cost-of-Living-Adjustment(COLA) • b. Merit Allowance and Merit Policy Ms. Payne then presented the FY2025-2026 County budget regarding the Cost-of- Living-Adjustment(COLA), Merit Allowance and the Merit Policy. Ms. Payne engaged in discussion with the Court and following discussion Ms. Payne recommended a 4 percent COLA. The presentation is attached hereto. 7. Call for Department Heads and Elected Officials input and/or concerns regarding the following: • a. Cost-of-Living-Adjustment(COLA) • b. Merit Allowance and Merit Policy Ms. Payne read an email submitted by 361st District Judge David Hilburn in favor of the COLA. Brian Baker with the District Attorney's Office addressed the Court in favor of the COLA. 272nd District Judge John Brick addressed the Court in favor of the COLA. Chief Information Officer Eric Caldwell addressed the Court in favor of the COLA and in opposition to the merit system. Constable Jeff Reeves addressed the Court in favor of the COLA. Juvenile Director Linda Ricketson addressed the Court in favor of the COLA. Associate Judge Dana Zachary addressed the Court in favor of the COLA. County Court at Law 2 Judge Roy Brantley addressed the Court in favor of the COLA. County Court at Law 1 Judge Amanda Matzke addressed the Court in favor of the COLA. Chief Deputy Kevin Stuart addressed the Court in favor of the COLA. Wellness Center Director Julie Anderson addressed the Court in favor of the COLA.' Nathan Wood from the Public Defenders Office addressed the Court in favor of the COLA. County Clerk Karen McQueen addressed the Court in favor of the COLA and in opposition to the merit system. County Engineer Prarthana Banerji addressed the Court in favor of the COLA. Auditor Katie Connor addressed the Court in favor of the COLA. The Court provided direction and Ms. Payne stated she would be proposing a 4 percent COLA as part of the Fiscal Year 2026 Budget. The Workshop was adjourned at 3:24pm. 8. Adjourn Pg [ of , BRAZOS COUNTY COMMISSIONER' S COURT 3'. DAY OF - ,,.1 7 , 20,E c9 : Do A ocic stv c Name Organization (PLEASE PRINT) (PLEASE PRINT)A 1(\(X eCLUVL-fi CAAgLA 1)1K1 7-aa\CtAl - - 1141 'f I AZ&',1 cut orA. 'Rol D. 3ra n4le 7 !'Ara, C44- ,,,,V57S i- 5 8Li=5 kt_f Am,,,,,i, a\oria, 0-011 GSA_,((-Z, --- :Oh)Iti6iiii-- u e.£tLW & . C'. ' A \/,da r, pp kre .0 7 1 1 I I AL I• O c , ( I S C,V\C cif Ma 5 13 L.ci 9-P- I:lox COLN)t_ cc 8 c71 titti-- i Av a 'lam ,Inci //Cc� --_ Ca Pg Zof BRAZOS COUNTY COMMISSIONER' S COURT i DAY OF , 20 0 o o AMxI, o (( 5 L Name Organization (PLEASE PRINT) (PLEASE PRINT) /50\0)Q-I )A-J,2( d ;,-1- X4?- e. - 65,9 a4v\uJk LAA/C /)I7 elf:0 n (fd 6ri g?„ 1,.ivx x-hecva 6c 1) Elvo m I e CC> \(),y `tiN\ cc m CCLA v -� 3of5 BRAZOS COUNTY COMMISSIONER' S COURT f DAY OF - , f , 20 .� , D D AM/ 3(IC5t dP Name Organization (PLEASE PRINT) (PLEASE PRINT) E v I( -6ro-2wS Je Sexy) ( 6 Gy9 j f � �iY1P� arl/1 SUS `�f Z`l' WA, QEva2 L AI,s .M.1 PeoS ecr AAI4 -cc1cAo— cvA m oN ono vok J A N\tc\\ CA`e•keYt Ot, rAcr- C'elt.3fa Jo le_ q ('1:Z) e-nno (A011.4 P ••j 6 .11itori� lielk)ess Clinic NP)dL CtAa �� Pg of 5 BRAZOS COUNTY COMMISSIONER' S COURT 1_5 DAY OF 1-3 wL , 20 .A AM , 0( s( a (3$ Name Organization (PLEASE PRINT) (PLEASE PRINT) M I I C5 -C tJa ne ® F1 eN-5\ tIkk' e1 lG L'r , &c e_cZ CAutNYLLLJL C C rut Thial3 crb-s nawit 1)() NthC1x\ itnkby CA,tfreA/Ne4i.s 412\r-tAyV Auk (' 5A- And4t50( „ . ' J el '�� Pg S of 5 BRAZOS COUNTY COMMISSIONER' S COURT DAY OF _1 , 20 2_5 Y-D AM/ JbJIr 51. 0 ? Name Organization (PLE _ PRINT) (PLEASE PRINT),Cltri //(Ann Pc! \)-ew P 1/4---/N__ R e. boo nyD 6/115 , 4a( 1 Corn 6� Aop,,,% � , --PS-I a Sok,IAN town> t el . i;ki ri t'1� A ©; BRAZOS COUNTY BRYAN, TEXAS )EPARTMENT: NUMBER: )ATE OF COURT MEETING: 7/15/2025 TEM: Presentation and Discussion of the FY 2025-2026 County Budget regarding Insurance Premiums and Contributions (USI). -O: Commissioners Court )ATE: 04/07/2025 'ISCAL IMPACT: False UDGETED: False )OLLAR AMOUNT: $0.00 4i 2026 BUDGET REVIEW • BRAZOS COUNTY COST PROJECTION DATA THROUGH MAY - COST COULD INCREASE OR DECREASE DUE TO CLAIMS SPEND 7/15/25 Bobby Anderson - SVP, Employee Benefits Brenda Cos - VP, Strategic Account Executive www.usi.com �... \ , . � , £a;a.g's. . R. ":. „ .r `+;., " A , e .,...."° d 3a€ti.. =". . " > .,..&p w m, trw� ma. mr. .;a ;a .. w&�. r �,_ . a,,wg.,ti8 . «,=r sar ,.w x . „+,.,=.. GeF••ntR•. m ,r g „� w z ..;&tevaa rn >`'a^a�, T Ie ifContentsF,,.. , ,, , ,,, ,, , ,,, ..,,, ,, _,:, lla About USI } Brazos County Trend ��<1 a Medical & Rx _ ▪ Claims Projection ' 1 ■ Contributions ` ▪ Affordability . �' '���` �°' ▪ Dental Claims Projection ▪ Contributions ; f ▪ 2025 Benchmarking 7 . : ©2024 USI Insurance Services.All rights reserved. I : I °,' . , ..„—v,,,, .,. . ''..,fiFf',f ,, ,,,Iff-f.; -,....tref..s. , ... 'ft,-- '7.a,,, ., "....;f.i.`,1-1 ...°°",f:,;a'f:' ' '''flif...'' "•'"441: ,.,. '...',h';',I. -.. , '.'4,,i,, f.," .'.;I-V.': -''''... ,fv!,11f' '' ,I,Ztf...—. ' r":4,fli.,•.,., , 1-,'77- '''',:.„-;r777-79 THE USI ONE ADVANTAGED USI at a Glance I Leading Global Brokerage _ e..-.. . . ',',...... . ' ÷ . 500,000 9 /I.1.1,71 j ./,' .--- 1). :, '177,-N , . , " . , lktt,. ;''' Ilillfv9illL__.---, ,----f ,,‘%;e,,\1,...„3 •,,-4-v„ \ 0. / c.,(•,12\.\ ,...„ Largest privately-held ENTERpRI.E. _. ....,„; ,' a.T.:8..r. :,. broker of U.S. business , ‘„, ,, , . J, f t 1` clients served - - . . The USI ONE. ':f"-----c„, . Advantage® n _ "Top Insurance , ' p ,,,,- , delivers superior , ,,, 4., ,, . . , Over , , , , client solutions f -,-' .'' BILLION , Employer" A. , impact 'III,--,-----:` . . 27 Six Years in Row! I N • Revenue Insurance Business America,201.8-2028. ' " ` f ,, , 1 ir employees 4' , - 200 Local offices, + Ybakrs ro erage Servicing local, 150 e national, i experofience . 0- ..° () . 1 4 0 4 4 4 4 4 4 and international needs. • . ih,V9119 itiP9INI9no through our acquired agencies , PROPERTY:&CASUALTY'., w :EMPLOYEE BENEFITS w . PERSONAL RISK „.- IN' PROGRAMS:' w RETIREMENT CONSOLTING ., ©2024 USI Insurance Services.All rights reserved. MI I 2 -- • , ,xe ,,&c 5• $.d+." 4 t $PP ? .:a }c `d -y.�., �r, q,.: X�yt -.A . 4 �` `g..'. S f __.._v _ ,— .d 'a, ' -,.. "�l .. ., ... , , 4$mr �.i^ -..'Y. ,, r xa a ' USI ONE® Network Provides Deep Expertise i. Unmatched Breadth ,..6 and Dejath of L06:ci 'anc14,5 (lid): ('1 . fm; --National .mployeea° Benefit Resources :� ,. ri � v � AA' ' .. 3 s . . - .,s - , , ,a.; `i —---- mat._.. .-.._.- -. __ .__ "I a .-_ Practice • Compliance HR Account Underwriters ' Wellness t Comms ' Pharmacy Claims Technology Retirement Leaders& Attorneys & Consultants Consultants Consultants , Experts 9y Consultants Consultants Executives I &Analysts 1 Experts Consultants BENEFIT BOBBY WENDY ALEX ANNE' ANDERSON BRENDA COS TONY SANCHEZ CARMICHAEL FERNANDEZ JIM DELGADO DOMINIC VU RESOURCE BURKETT, MATT ARNOUT CENTER Dedicated technical experts networked nationally and embedded in local offices,with 10,000+professionals nationwide to build integrated client centered account teams. e .A n CustEirnized Broad - Worldwide Team N~-- ` Expertise , .._-/ Connectivity Personalized in-house Curated team is Deeply connected nationally employee benefits team collaboratively connected with locally based experts so for Ranger Energy with other disciplines at no you get industry wide expertise Services,LLC additional cost whenever you need it O 2024 USI Insurance Services.All rights reserved. I,US/ I 3 <.s .:roa .. °,e` ,_,,. a ..� ....B- aya " s �K •, ..y°,. „ 9�; +A,' °°- w.y °";;:a. A R .vr..or 'tk __.. _ _ _ o..�"�. , *°.'b;"c ..".�`.® `S. �:_ r �" '�.3.. fig._ , .... ,.�" ` :.", �'. " ,. � �,.z�a s`C ^ .ate-s.,°"" -.�y�" Qs"G�i*zr .c, .,_, _ � _, - •=�;a��sr`.. .— g , �,�._,..___._._ Emerging Trends with Healthcare Healthcare Spending Growth: Healthcare spending in the U.S. is expected to grow at an annual rate of around 7.5%through 2026, driven by factors such as an aging population, increased prevalence of chronic diseases, and advances in medical technology. Disease Costs: As the prevalence of chronic diseases(Cancers)continues to rise, associated management and treatment costs are projected to account for a significant portion of healthcare spending. Rx Trends:The global prescription drug market is anticipated to continue growing around 12%, driven by an aging population, increased prevalence of chronic diseases, and advancements in drug development. Specialty Drugs:There's expected to be an increasing proportion of prescriptions filled for specialty drugs, which are often more expensive and cater to complex health conditions. Biologics and Biosimilars:The market share of biologics is expected to grow as more biosimilars enter the market, lowering costs and increasing access. Projected Healthcare Cost: Total employer healthcare costs to is projected to increase by 10%in 2026. Employee Contribution: Employers are projected to increase employee contributions by 5.9%in 2026. Plan Design Changes:28%of employers are expected to increase deductibles and out of pockets in 2026. Book of Business: Seeing 15% - 20%increases ©2024 USI Insurance Services.All rights reserved USti I 4 ..,4 . • =m.+ +..i. ' .1 y''tms ° e-R°:. .a sA .rs't :a A� b .a ,sr •i^ }-A%°;,, 4. . ,,":f, • :,} d sr ueai .,.° •� ,Q C %,r Bw,' °:fa as ,x�d � ? § `:w., i. t -f 2025 YTD Experience Summary 2024 2025 YTD Projection Observations for the 2025 Plan Year: Budget $20,727,347 $8,775,798 1.3% Overview through May on a PEPM basis: Net Costs $15,961,471 $8,379,914 16.9% Net Position to Budget 77% 95% 88.8% • The budget is 0.4%lower than the previous year. Net Costs PEPM $1,257 $1,554 14.9% • The plan is running at 95%of the budget,or$396k under the budget. • The current budget is$1,627 and the net cost is$1,554,respectively. Average Employees 1,058 1,079 1.7% • Gross Rx Claims make up 31.8%of total paid claims,which is above industry standards(20%-30%). • The top three paid drugs are Takhzyro,Ozempic,and Wegovy. Expected Claims $16,233,545 $7,004,972 3.3% • Enrollment is 2.0%higher than the previous year. Net Claims $12,566,467 $6,722,889 16.9% • Overall,the current cost is 23.5%higher than the previous year. Net Position to Expected 77% 96% 87.6% Net Claims PEPM $990 $1,246 14.9% Large Claimants: • There are eight large claimants over 50%of the$200k Stop Loss Limit(SSL). Large Claimants 2024 2025 YTD • Two of these claimants are over the SSL by$284k with$684k in claims. Number of Large Claimants 21 8 • Large Claimants make up 19%of gross claims. Total Paid for Large Claimants $8,260,452 $1,441,405 The above observations are for demonstrative purposes only. Claimants Over SSL 11 2 USI will continue to monitor the data as it matures. Total Paid Over SSL $4,763,819 $283,816 2025 YTD>_ $100,000 Large Claimants Monthly Budget vs Costs Historic Budget vs. Net Costs as a %of Total Claims �,,� �� $2,000,000 $20,000 $1,500,000 •� $15,000 1 .a ° �. e $10,000 ---a, 1' : zil r $5,000 1 ,. 0 81/0 , aP ya ,a m p �e s t ,,°' $Jr00.000 g s 3 t 'k i' i ; Zi Jn , a.' ,.. y . : ". _ $0 - 2023 PEPY 2024 PEPY 2025 PEPY -i"'•„ , • Jan-25 Feb-25 Mar-25 Apr-25 May-25 Projected Eil Large Claimants u Other Claims ( o Budget ElNet Cost 0Budget a Net Claims 0 2024 USI Insurance Services.All rights reserved. 1. I 5 2025 Cost Summary - Medical/Pharmacy Budget vs. Costs $2.500,000 $2,000,000 -- Px o _$1,500 000 _ "` 9 it,e S ,49; a $1,000,000 - , ,., :1 te--..---A 9.,' ' � df r' TSket:B ,'"_ ea`�..-:F °S w y•• @ Jan-25 Feb-25 Mar-25 Apr-25 May-25 C Budget ®Net Cost Enrollment', •-. Expected •Fixed Cost s'. . tt ,.*_, o.d an°C.sts ^_ "as or A 's "Em�)a efi >,stfiion= Total Total Admin .Stop Loss Medical., Rx Rx Stop Loss Claims Net Total Budget Minus EE %Paid by Month Total Budget Net Cost ER Expense Employees Members Fees Premium Claims Claims Rebates Reimbursements Over SSL Claims Net Cost Contributions Employee': Jan-25 1,085 1,892 $54,938 $278,368 $333,306 $922,912 $475,059 $0 $0 $0 $1,397,971 $1,766,971 $1,731,277 $35,694 ' $230,611 $1,500,666 87% Feb-25 1,080 1,876 $54,778 $277,085 $331,863 $1,283,451 $378,068. ($302,441) ($201,664) $201,664 ` $1,157,414 $1,758,100 $1,489 277 ;`$268,823 $228,820 $1 2,60,457 85%..1" Mar-25 1,079 1,874 $54,483 $276,828 $331,311 $972,700 $547,751 ° $0 ($38,405) $38,405 $1,482,046 $1,756,041 $1,813,357 ($57,316) $228,177 $1585,180 87% Apr-25 1,076 1,854 $54,527 $276,059 $330,586 $935,916 $553,913 $0 ($1,085) $1,085 $1,488,744 $1,748,860$1,819,329 ($70,469) $225,244 $1,594,085 88% ^ May-25 1,074 1,851 $54,415 $275,545 $329,960 $1,192,002 $515,822 ($468,450) ($42,661) $42,661 $1,196,713 $1,745,826 $1,526,673= $219,153 • $225,042 $1,301,631 85% Totals 5,394 9,347 $273,141 $1,383,885 $1,657,026 $5,306,981 $2,470,613($770,890) ($283,816) $283,816 $6,722,889 $8,775,798$8,379,914 $395,884 $1,137,894 $7,242,020 86% • The plan is currently running in -$396K Surplus. ▪ Brazos County (Employer) is paying 86% of the Cost. mg, 16 2024 Cost Summary - Medical/Pharmacy_, 0. Enrollments ..„. Expected Fixed Cost,. t & I,: g 76t ian Cii`Sis g• sltio Em Flo e4P.osit;° Rx SSL Claims'Over Net Total Budget Minus EE _ %Paid by Aonth Total Total Admin Stop Loss Total Medical Claims Rx Rebates Budget Net Cost ER Expense Employees Members Fees Premium Claims Reimbursements SSL Claims Net Cost Contributions Employer an-24 1,039 1,803 $50,460 $227,728 $278,188 $1,734,000 $401,835 $0 ($673,704) $407,520 $1,462,131 $1,690,993 $1,740,319 .,($49,326) $219,769 $1,520,550- 87% 'eb-24 1,043 1,807 $50,409 $228,605 $279,014 $704,159 $413,850 ($312,814) ($477,714) $3,689 $327,481 $1,697,053 $606;494 $1,090,559 $220,165, $386,329. 64%° 4ar-24 1,062 1,823 $51,092 $231,892 $282,984 $1,048,749 $411,210 $0 ($303,731) $273,918 $1,156,227 $1,719,818 $1,439,212 $280,606 $221,690 $1217,522 85% .pr-24 1,053 1,816 $50,992 $230,797 $281,789 $773,248 $491,786 $0 ($185,072) $77,731 $1,079,962 $1,753,439 $1,361,750 , -$391,689 $262,391 $1,099;359 81% lay-24 1,050 1,810 $50,890 $230,139 $281,029 $794,243 $460,652 ($295,602) ($59,070) $58,070 $891,222 $1,748,630 $1,172,251 •,$576,379 $261,830 $910,421 78% s un-24 1,061 1,828 $51,510 $232,550 $284,060 $615,807 $487 790 $0 ($54,358). $54,358 $1,049,239 $1,727,083 $1,333,299 .$393,784 $224,707 $1 108 592 83% 1u1-24 1,060 1,820 $51,133 $232,331 $283,464 $3,490,370 $455,195 . $0 ($2,828,169) $2,828,173 $1,117,396 $1,724,576 $1,400,859 :$323,717` $223,616 $1177;243, . 84% Lug-24 1,062 1,826 $51,024 $232,769 $283,793 $1,095,234 $447,372 ($375,440) ($192,405) $192,405 $974,761 $1,728,182 $1,258,554 $469,628 $224,390 $1;034,164 82% .ep-24 1,060 1,826 $51,216 $232,331 $283,547 $757,066 $562,867 $0 ($219,799) $219,799 $1,100,133 $1,725,396 $1,383,680 $341,716 $224,436 $1,159,244 84% )ct-24 1,068 1,845 $51,703 $234,084 $285,787 ' $795,503 $579,624:, $0 ($185,409) $185,409 $1,189,719 $1,738,972 $1,475,506 $263,466 '$226,684 $1,248;822 85% lov-24 1,067 1,841 $51,644 $233,865 $285,509 $734,180 $462,452 ($280,825)," ($121,152) $121,152 $794,655 .$1,735,777. $1,080,164 ; ;$655,613 $224,905 $855,259 sec-24 1,068 1,840 $51,756 $234,084 $285,840 $1,096,895 $667,266 $0 ($340,620) $340,620 $1,423,541 $1,737,428° '$1,709,381' $28,047 $225,140 , '$1484,241 87% totals 12,693 21,885 $613,829 $2,781,175$3,395,004:$13,639,453 $5,831,900($1,264,681) ($5,640,204)' '$4,762,844 $12,566,467$20,727,347$15,961,471 $4,765,876 $2,759,723 $13,201,748 83% ® The 2024 year ended in -$4.7M Surplus. ■ Brazos County (Employer) paid 83%of the Cost. IUSr'_ i 7 Rolling 12 Cost Summary - Medical/Pharmacy v.;-4 o114"� a' F ExPected•Fixed Cost -,,. ., ," ;fit,;, � , . tili, , q. . .,:': , . ' � '11 osiiotl ::•� 4E lla. r ostti on ,. Budget vlonth Total Total Admin Stop Loss Medical Rx Stop Loss Claims Over' Net Total EE %Paid tip Total Rx Rebates Budget Net Cost Minus Net. ER Expense Employees Members Fees Premium Claims Claims Reimbursements SSL Claims Cost Contributions Employe lun-24 1,061 1,828 $51,510 $232,550 $284,060 $615,807 $487,790 $0 ($54,358) $54,358 $1,049,239 $1,727,083 $1,333,299 , $393,784 $224,707 $1,108,592 83% I Jul-24 1,060 1,820 $51,133 $232,331 $283,464 $3,490,370 $455,195 $0 ($2,828,169), $2,828,173 $1,117,396 $1,724,576 $1,400,859 q,,•$323,717.,' ," $223,616 . $1,177,243 84%'. lug-24 • 1,062 1,826 $51,024 $232,769 $283,793 $1,095,234 $447,372 ($375,440) ($192,405) $192,405 $974,761 $1,728,182 $1,258,554 $469,628 '$224,390 $1,034,164 82%. ;ep-24 1,060 1,826 $51,216 $232,331 $283,547 $757,066 $562,867 $0 ($219,799) $219,799 $1,100,133 $1,725,396 $1,383,680. $341,716 $224,436 $1 159,244 84% Oct-24 1,068 1,845 $51,703 $234,084 $285,787 $795,503 $579,624 $0 ($185,409) $185,409 $1,189,719 $1,738,972 $1,475,506 $263,466 $226,684 $1,248,822 85% Jov-24 1,067 1,841 $51,644 $233,865 $285,509 $734,180 $462,452 ($280,825) ($121,152) $121,152 $794,655 $1,735,777 $1,080,164 $655,613 ° $224,905 $855,259 79% )ec-24 1,068 1,840 $51,756 $234,084 $285,840 $1,096,895 $667,266 $0 " ($340,620); $340,620 $1,423,541 $1,737,428 $1,709,381 528,047 '$225,140'• $1484',°241 87% Ian-25 1,085 1,892 $54,938 $278,368 $333,306 $922,912 $475,059 $0 • , $0 $0 $1,397,971 $1,766,971 $1,731,277' $35,694 $230,611 ' $1,500,666 87% :6-25 1,080 1,876 $54,778 $277,085 $331,863 $1,283,451 $378,068 ($302,441) ($201,664) '$201,664 $1,157,414 $1,758,100 $1,489,277 $268,823 ,$228,820 $1,260,457 85% Aar-25 1,079 1,874 $54,483 $276,828 $331,311 $972,700 $547,751 $0 ) 87% ` 46 $1,756,041 apr-25 1,076 1,854 $54,527 $276,059 $330,586 $935,916 $553,913 $0 _' ( 3($1,085) $1 85 $1488, ,7744 $1 748 860 $1813 329 ($77 469) $228,177 $1594,085,819 329 � ($70 469) $225,244 $1 594,085 88%0 Aay-25 1,074 1,851 $54,415 $275,545 $329,960 $1,192,002 $515,822 ($468,450). ($42,661) $42,661 $1,196,713 $1,745,826 $1,526,673 .°$219,153 ,_$225,042 $1,301,631 85%' Totals 12,840 22,173 $633,127 $3,015,899$3,649,026 $13,892,036 $6,133,180 ($1,427,155). ($4,225,729) $4,225,732 $14,372,332 $20,893,212 $18,021,358 $2,871,854 $2,711,772 $15,309,586 85% mi On a rolling 12-months, the plan is running in -$2.8M surplus. ■ Brazos County (Employer) is paying 85% of the Cost. . 1 8 1,,P.e%i,':,,$):..',:`''''",:e:44C6,,, - -,,%,:ti.... =41 Z•2,:=1,41:':',:°'''04..97:-'r.-,....',41 1". ...'P.MC=r,` ;. .7.."...,:'.4.-J'A:0;'''',..4.40,1'f .-';,:Z11,4•'-:..'.- :„-t,„.: •k-/4.--.- ., Ar; ,,:'. .:-tl:V.,,•7e,',,t0,4frir,,e'.';',.- e'r,-. .:. - f Rolling 12 Month Claims Performance „- -- 'r-'-'3"I-r- 'fft.44',-.`,' ,, , ," ‘1',.2 iv:•-'*1 •'':',-,,,,,,,,:le'.-.1,,,':''-''''.:1---4".‘''''''Z' ' -vm. •Clams Per EE Month Total R011ing12 Medical Rx Total Gross Claims Rx Rebates/ Net Total ,Boljtly4.2.--: Monthly Annual T9'11102, m This chart represents Employees 1VJOnths-, Claims Claims Claims Over SSL Settlement Claims lAiSnfOk Net Claims/EE Net Claims/EE Claims Only. May-23 1,002 11,773 $1,146,105 $446,123 $1,592,229 $151,249 ($186,480) $1,254,500$13,730,983 $1,170 $14,041 18.3% Jun-23 1,003 11,800 $1,328,600 $573,129 $1,901,729 $664,026 $0 $1,237,703$13,935,734 $1,186 $14,236 18.5% Jul-23 1,005 11,836 $792,725 $722,093 $1,514,817 $441,480 $0 $1,073,337$13,921,535 $1,182 $14,190 19.1% ° Brazos County's claims Aug-23 1,017 11,881 $894,076 $543,912 $1,437,989 $255,161 ($192,477) $990,351 $13,828,490 $1,172 $14,063 15.8% are trending at .7% on a Sep-23 1,020 11,930 $789,217 $592,474 $1,381,692 $276,363 $0 $1,105,329$13,969,238 $1,180 $14,163 15.9% rolling 12-month basis. Oct-23 1,027 11,982 $726,536 $515,483 $1,242,019 $148,013 $0 $1,094,006$13,996,454 $1,178 $14,137 15.0% Nov-23 1,032 12,034 $1,068,592 $633,381 $1,701,973 $498,682 $0 $1,203,292$14,073,707 $1,180 $14,156 12.2% Dec-23 1,042 12,090 $1,235,866 $561,363 $1,797,228 $378,678 ($214,587) $1,203,963$14,137,925 $1,180 $14,159 11.0% Enrollment has gone up Jan-24 1,039 12,149 $1,734,000 $401,835 $2,135,835 $407,520 $0 $1,728,315$14,496,980 $1,205 $14,456 10.1% 2% on a rolling 12-month Feb-24 1,043 12,208 $704,159 $413,850 $1,118,009 $3,689 ($312,814) $801,506 $14,346,139 $1,187 $14,239 7.4% basis. Mar-24 1,062 12,284 $1,048,749 $411,210 $1,459,959 $273,918 $0 $1,186,041$13,985,079 $1,151 $13,814 1.2% Apr-24 1,053 12,345 $773,248 $491,786 $1,265,034 $77,731 $0 $1,187,303$14,065,645 $1,152 $13,826 0.7% May-24 1,050 12,393 $794,243 $450,652 $1,244,895 $58,070 ($295,602) $891,222 $13,702,368 $1,115 $13,386 -4.7% Jun-24 1,061 12,451 $615,807 $487,790 $1,103,597 $54,358 $0 $1,049,239$13,513,903 $1,095 $13,136 -7.7% Jul-24 1,060 12,506 $3,490,370 $455,195 $3,945,565$2,828,173 $0 $1,117,392$13,557,958 $1,094 $13,128 -7.5% Aug-24 1,062 12,551 $1,095,234 $447,372 $1,542,606 $192,405 ($375,440) $974,761 $13,542,368 $1,088 $13,052 -7.2% Sep-24 1,060 12,591 $757,066 $562,867 $1,319,932 $219,799 $0 $1,100,133$13,537,173 $1,082 $12,989 -8.3% Oct-24 1,068 12,632 $795,503 $579,624 $1,375,127 $185,409 $0 $1,189,719$13,632,885 $1,086 $13,034 -7.8% Nov-24 1,067 12,667 $734,180 $462,452 $1,196,632 $121,152 ($280,825) $794,655 $13,224,249 $1,050 $12,604 -11.0% Dec-24 1,068 12,693 $1,096,895 $667,266 $1,764,161 $340,620 $0 $1,423,541$13,443,827 $1,064 $12,771 -9.8% Jan-25 1,085 12,739 $922,912 $475,059 $1,397,971 $0 $0 $1,397,971$13,113,484 $1,035 $12,423 -14.1% Feb-25 1,080 12,776 $1,283,451 $378,068 $1,661,519 $201,664 ($302,441) $1,157,414$13,469,393 $1,061 $12,734 -10.6% Mar-25 1,079 12,793 $972,700 $547,751 $1,520,451 $38,405 $0 $1,482,046$13,765,398 $1,081 $12,967 -6.1% Apr-25 1,076 12,816 $935,916 $553,913 $1,489,829 $1,085 $0 $1,488,744$14,066,838 $1,101 $13,212 -4.4% May-25 1,074 12,840 $1,192,002 $515,822 $1,707,824 $42,661 ($468,450) $1,196,713$14,372,329 $1,123 $13,481 0.7% ©2024 USl Insurance Services.All rights reserved. Ita 1 9 . fir -. a., ; ' ®- •sa e Y." .+e. ^a .-A. ' 1 a" w ,n, . vim.. ° S k 't . bF. _ m • ,�;n" V j a, ,- ° i � � 6 _ 4' . . .rm a°fir c �LA °F .-� f ! q M fM14 a .na. j°.a n ...w . . a°rt°y e,.a`.., a . `° g.� .�'Pr., .,v aY°a . . • ,,:E . a �, ta:�_ .___ _. _" __._( Historical Cost Summary, ____. ... Budget vs.Net Costs $25,000 $19045 $19,591 „�—._-- $19,514 , $20,000 $17,101 "l —$37,336 $15086 $15,000 f---- *:,i.,,,,..i.y.`.,..-f..: ''' ' g 10 i 2023 PEPY 2024 PEPY 2025 PEPY Projected i Budget m Net Costs Average Gross Medical Stop Loss Net Total Fixed Time Period Employees Budget Claims Gross Rx Claims Rx Rebate Reimbursements Net Claims Costs/Bud Costs Net Costs 2021 Plan Year 985 $17,687,116 $8,499,476 $5,493,604 ($361,905) ($981,466) $12,649,709 91.7% $3,572,299 $16,222,008 2022 Plan Year 980 $18,344,193 $8,768,495 $6,121,307 ($576,272) ($1,222,063) $13,091,466 90.2% $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% $3,062,908 $17,237,595 2024 Plan Year 1,058 $20,727,347 $13,639,453 $5,831,900 ($1,264,681) ($5,640,204) $12,566,467 77.0% $3,395,004 $15,961,471 2025 Plan Year Projected 1,076 $20,996,580 $13,892,036 $6,133,180 ($1,427,155) ($3,911,015) $14,687,046 88.8% $3,966,749 $18,653,795 Change from Change from Change from Time Period Budget Prior Year Net Claims Prior Year Net Costs Prior Year 2021 PEPY $17,961 N/A $12,846 N/A $16,473 N/A 2022 PEPY $18,712 1.8% $13,354 4.0% $16,887 2.5% 2023 PEPY $19,045 6.0% $14,062 5.3% $17,101 1.3% 2024 PEPY $19,591 2.9% $11,878 -15.5% $15,086 -11.8% 2025 PEPY Projected $19,514 -0.4% $13,650 14.9% $17,336 14.9% ©2024 USI Insurance Services.All rights reserved. tki'll1 I 10 1, • ,A.'",---4.18-1.StAA111„41,„,tr:v-,4_, , , ,, ,- ' , .. - i'07.7' ''' 7 -7'77*' 7 4 7--7'7, ''7.,'".:' -,,--..,77' .1**71 7,-,'' .7'‘:47,k.:4,:*,...''' :7'''.7,7%4''7,-,,,7*,,1,0:1,441 t,-;47, 7. ' •' 7 -,,, Aft,41. ! LWIW , ',..--,!7:AP4kAA.,,A,!:,,,,-.._,...m.:wr,n4-1:-,-- ;.-1:-.---.','"-----6,-r Enrollment by Member Type . ... ,. ,.... ..„„_._ ::-.,--_• ... ... .--, - -.7,-----.._-, - --. Enrollment by Month and Tier Average Enrollment by Year by Tier s_ _________ ___. 900 ,„ _ _ _______ 200 _„_ --- .. 700 „ _,.,__c__„..__ _ ____ , _ EE+Ch(ren 53°0°0 --i76 197 - ------ 500 -* • - "a - A.,W 411 '-.,,,- , a rp 4i, , .... i: , . twi ... ., (..? ,,,, fa* , „-,, , :,,, /--- ) : ,. 1. .. . 112 109 1-----, 100 87 6 ''''4' 44 :0 :'' ' 1 -4r: - 74 -::-. a W:4 ----,, 4 .EE„P -, ;,' L-,-, 00 - . . ';','. —it!.3,7' -- ' ''',L - 41.• 1, kii , ,-, ,,A 14.- .., 44 4, ,' „,„ ' r:--) 4 */* ' • '' '',-,.= wyk . -0- 0 te- - ,,, 0- O " - -"i;1 '- 200 — 1 - ..,. ---, , :- tvt- ES+Fam--- 0 - Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 12 Prior Year:1/2024-12/2024 M Current:01/2025-05/2025 2025 YTD Enrollment Distribution 8% d,,,l',"7.74,7-f? ,.,''',4, t4.-03r, Ai "'Al 6. tit• 71,,, ,,,,(4:41- 64% 10% .7*,..-',4,725..Ltlig,f7t4Z1141,49,4 7:474:70 ')4'kr.'4747.4 ,VP".174744"44,077174:7•:',A7'. ''44,2741:14,,,44V4KU":47.re*,t 77`4 la EE Only a EE+SP 12 EE+Ch(ren) --EE+Fam 1 1 1 USL ©2024 USI Insurance Services.All rights reserved. , .. .., ,; ,.. t..'.., ,.:Ii V t ° k, „7,,1.°.v a W q"e ,° •'V ae+ ',%:: ' "_f .aff m#• •$.. ea ,:.,; :::,:%"'^ . . g "$k'"".�g —_.._ ��',r,.. � ' _A° , ": - .. e°. r � .emu.r r pua .. tp . : - g°9' �' k rt- -'� ., a .. s... y.•"'3 ,,.� ,�.•, a�...s "s' 4'^'��'�°° r-sa.^a�'. �. `. - . �� .?`�e�.6.: i's•�:�'�� ... e..�.._____._•______.._....s Multi-Year Trend Actual PEPY versus Trend $35,000 $30,000 ------...-.__.v.-...__.—_...—�_—_.._.-_�.._. —_._______.._.--__ — ,__— - I $25,000 $22,531� $19,061 $20,724 11 , $20,000 $16;473 ,6661 • —M $15,000 • $16,473 $16,887 — — $17,101 $17,336 i $15,086 $10,000 - $5,000 —.__. — — —...--- — _ _...-._._ . 1 I $0 2021 2022 2023 2024 2025 1 —A Net Costs PEPY ''■=Trended Costs PEP'( Actual Costs 2021 2022 2023 2024 2025 Net Costs $16,222,008 $16,554,714 $17,237,595 $15,961,471 $18,653,795 Net Costs PEPY $16,473 $16,887 $17,101 $15,086 $17,336 %Change from Prior Year n/a 2.5% 1.3% -11.8% 14.9% Average Enrollment 985 980 1,008 1,058 1,076 Trended Claims Costs 2021 2022 2023 2024 2025 Trended Costs PEPY $16,473 $17,666 $19,061 $20,724 $22,531 Observed Blended Trend(80%med/20%rx) 8.0% 7.2% 7.9% 8.7% 8.7% Medical 8.0% 6.9% 7.3% 8.1% 8.1% Prescription 8.2% 8.6% 10.3% 11.2% 11.2% ©2024 USI Insurance Services.All rights reserved. ilia 1 12 = w r. ' , . '' .",,,I. „w S ''''.' ®;sr` § : S� s-, ark = x px ti —__ i;°e A- . � Nvt .,:E a .-E„u, ' y aa'^,wy $ %.>%,e,d• d.=3"aw.„y e ° ,+s, -;r,-:�` .°°) �° amaa ' ; °fis4„t.. . o:« w _ - ti.°. , m „--:e a,.` __'e^". ��,:F °wa °,pryr- i ., = T;.. .'� e �x "Vim„ _. gat ..,, . prRr .R... ,, a . . 2025 Large Claimant Report Paid Claims>$100,000 Amount Claims Over SSL Reimbursements Relationship Diagnosis Plan Claimant 1 $441,671 $241,671 ($241,671) SPS T8452XA-Infection and inflammatory reaction due to internal left hip prosthesis,initial PPO Claimant 2 $242,145 $42,145 ($42,145) SUB F411-Generalized anxiety disorder PPO Claimant 3 $155,091 DEP T7612XA-Child physical abuse,suspected,initial encounter PPO Claimant 4 $138,805 SPS M4723-Other spondylosis with radiculopathy,cervicothoracic region PPO Claimant 5 $130,877 SUB D360-Benign neoplasm of lymph nodes PPO Claimant 6 $122,934 DEP E840-Cystic fibrosis with pulmonary manifestations PPO Claimant 7 $109,868 SUB 1270-Primary pulmonary hypertension PPO Claimant 8 $100,014 SUB C50411-Malignant neoplasm of upper-outer quadrant of right female breast PPO Total $1,441,405 $283,816 ($283,816) Category Total %of Total 2025 YTD>_$100,000 Large Claimants as a%of Total Claims Claims>$200,000 $683,816 8.8% Claims$150,000-$199,999 $155,091 2.0% Claims$100,000-$149,999 $602,498 7.7% 19% Other Claims $6,336,189 81.5% " "'. Total $7,777,594 100.0% 81% . s'::`x a :aid ? e Large Claimants o Other Claims Large Claimants over $100,000 make up 19% of the overall spend. CO 2024 US1 Insurance Services.All rights reserved. OAI I 13 s°. " S v d� fi 9sv...�si R`#NPay +s,. 1y fcy,. m . 2'a?.7a 1 '... .2,� •�. G. a '.-4 a r" 7 41 2025 Top Drug Report _: _ . ., . . , _ _ ___ _ Top Drugs by Paid Drug Name Generic Available #Scripts Total Paid Average$Per Script 1 Takhzyro No 5 $241,841 $48,368.15 2 Ozempic No 338 $227,379 $672.72 3 Wegovy No 244 $203,874 $835.55 4 Zepbound No 210 $141,727 $674.89 5 Trikafta No 7 $116,801 $16,685.84 6 Dupixent No 40 $102,015 $2,550.37 7 Stelara No 4 $93,361 $23,340.21 8 Ibrance No 6 $88,927 $14,821.15 9 Jardiance No 108 $77,858 $720.91 10 Jakafi No 5 $64,661 $12,932.16 Totals 967 $1,358,444 $1,404.80 All Other 15,083 $1,112,169 $73.74 Total All 16,050 $2,470,613 $153.93 Top Drugs by Number of Scripts Drug Name Generic Available #Scripts Total Paid Average$Per Script 1 Amlodipine Besylate Yes 401 $1,088 $2.71 2 Atorvastatin Calcium Yes 387 $6,463 $16.70 3 Ozempic No 338 $227,379 $672.72 4 Rosuvastatin Calcium Yes 311 $5,914 $19.02 5 Levothyroxine Sodium Yes 269 $801 $2.98 6 Losartan Potassium Yes 262 $1,265 $4.83 7 Wegovy No 244 $203,874 $835.55 8 Amphetamine/Dextroampheta Yes 242 $6,149 $25.41 9 Fluticasone Propionate Yes 223 $834 $3.74 10 Lisinopril Yes 222 $831 $3.74 Totals 2,899 $454,598 $156.81 All Other 13,151 $2,016,015 $153.30 Total All 16,050 $2,470,613 $153.93 ©2024 USI Insurance Services.All rights reserved. (li'Eti. I 14 - . S1-!.,4..^MA.1'..%;°°4:1311c4444r4: , rt% : ' — ° : • . , . •1" ' „,, • • . ° `:•° " „ .m edical/Rx, Projection . • •- - Mt I 15 ©2020 USI Insurance Services.All rights reserved. ,p. " 4 �.,. .°,m .-w �•''� '�� '. ° . `if;t . ,, .,.+,gt� g� :. ". a ,r ` e .a€°.�' .•:�. ag„ `aa� a„�:�.p. A®� r 'o ':.r1 'n�. �., Via: wa. P"k� 4 `,, 6 - a ss."r 'i5s+ u t^ ?. a ,4,,, ,' `::! ��� � �°�?sa: �+�"°° :' � `.,.. •�a'.�,ya.. 4 �,e3«. ._� .,'F� . a s� . �4a" �' �. . ° . .� �` r ° ..� .� . � '�.0 .® ems..` a.°°° �.. _ i .... ,,.�.�....:�..,»�1 Medical & Rx Claims Projection - 2026 Time Periods _ _ 6` Current-ALL PLANS mm The plan is calling Renewal Period: Janua -26 December-26 for a 6.1�o Experience Period: June-24 May-25 Enrollment Period: May-24 April-25 reduction to Current Enrolled Employees: 1,074 budget. Current Enrolled Members: 1,851 g Renewal Calculation • PEPM Claim Development . ._ ,. .�'7 : ' ' .-m-_°-_ -- Medical - Rx Paid Claims_ .____ _ $13,892,036 $4,706,025 Total Large Claims in Excess of ISL($200k) ($3,905,861) ($1,605,154) , Benefit Adjustment $0 $0 Adjusted Paid Claims $9,986,174 $3,100,872 Annual Trend 7.0% 13.5% Midpoint Months 20.0 19.0 Applied Trend 11.9% 22.2% Trended Claims $11,178,206 $3,789,314 Portion of Large Claims up to ISL $688,424 $911,576 Total Subscribers 12,816 12,840 Adjusted Trended Claims(PEPM) $925.92 $366.11 Current Employees 1,074 1,074 Total Projected Trended Claims $11,933,297 $4,718,463 Total Projected Trended Claims(PEPM) $1,292.04 Claim Period Weighting 100% otal Experience Projection $16,651,760 $1,292.04 Fixed'Costs. ASO Fee(PEPM) $583,382 $45.27 Rx Rebate Credit(PEPM) ($1,371,928) ($106.45) ISL Rate(PEPM) $3,773,181 $292.77 ASL Rate(PEPM) $28,070 $2.18 PCORI Fee`PEPM $7,390 $0.57 Total Fixed Costs $3,020,096 $234.33 Needed Premium'Equivalents .3.• ;":' '1 '° $19,671,855 $1,526.37 Current Premium Equivalents ..s . $20,949,912 $1,625.54 CO 2024 USI Insurance Services.All ri;Needed'Changeto Current Premium Equivalents . - - - -6.10% = I 16 ,., ti ,....- .. � r=•, ., „�.f. ,�..a s ,- .c ,,.. w.' < nm �" * +..t a .; ' "�'a. q a)°€ ,,.e.a d`*i.." - a"a, _ �� `' "fib` ��, �.�. } �.K r a. , .. a .saw �� „is�� „.. a ' .. ., __ "'":` 9. �..1"�' _ .. •:'8'ti a,.. ... .. 2026 Medical Contributions Model m .. a . a tWy Med al Totals iigeident o i ,=s .�. ` . ... i k y . R x" �I _ ffi . § „.fi , e:::s" .° ! .,: ,7A ,:°vwi.- _ PPO Plan 1 EE Paid($) ER Paid($) ...Budget Rates - %Paid by ER _ . ,Subs `V Eihtinployer Co t, M1, _ Gross_ .1 Employee $63.00 ., $1,416.00 $1,479.00 95.74% 686 $ 971,376 $ 1,014,594 Employee+Spouse $511.00 $1,416.00 $1,927.00 73.48% 109 $ 154,344 $ 210,043 i Employee+Children { $339.00 I $1,416.00 $1,755.00 80.68% 197 $ 278,952 $ 345,735 I Employee+Family i $711.00 . i $1,416.00 $2,127.00 66.57% 87 $ 123,192 $ 185,049 Totals 1,079 $ 1,527,864 $ 1,755,421 $ 18,334,368.00 $ 21,065,052.00 .. s t�.,.,,... �.,+n.�.: '..a.W...� .. .:...,, m 9. .` ... fa�^ ,q.. .�¢ �.t' ' av,�',,,p, .<d �.'. n��<` 'v'• °° S �" fig'>%. °: ,aa:�° x ..�.z _ onthl 'IVleciica 36,1s 2:$,IeY i' ; ,,ix m: 4 4 " a . � m ,:: a ` ;. 1,;,. st„ ,`' �4'.—.::: ., s ' .� , ' i ; ' R- o Paid ,t ` Ubs i "" E Ip er C ii _ PPO Plan [� � EE Paid _ �� �ER P��d,($) � Budget Rates.° _ ��%PaidbyER . �,Emp � � ost�� �� Gross' Employee ,$63.00 $1,325.78 $1,388.78 95.5% 686 $ 909,486 $ 952,704 Employee+Spouse $511.00 $1,298.45 $1,809.45 71.8% 109 $ 141,531 $ 197,230 Employee+Children $339.00 $1,308.95 $1,647.95 79.4% 197 $ 257,862 $ 324,645 Employee+Family $711.00 $1,286.25 $1,997.25 64.4% 87 $ 111,904 $ 173,761 . ; _- . `: OVERALL,' 1,079 ,. $ '., 1,420,783 $,;. ' ,1,648,340 ANNUAL 12,948 $ ~,= 17,049,400 $ 19,780,084 CHANGE(%) . -7.0% . -6.1% $ 17,049,400 $ 19,780,084 Employer,Difference: $ (1,284,968.17) • It is not recommended to lower the budget. ©2024 USI Insurance Services.All rights reserved. , I 17 . ,&,g.° _ -` to *a - • °°�' ._ .. Affordability_ Test _ .., __- _ Renewal Year 2025 If current year not available,use the latest year. Location Lower 48 2025 Federal Poverty Level safe harbor is: $113.20 Lowest Hourly Wage $17.98 Based on a full time employee working 30+hrs/week or 130+hrs/month. Tested Contribution $138.00 Non-Compliant EE Rate is used for the affordability test. Affordability Threshold $210.83 Employee-only contribution of$138.00 is affordable. • • The Wellness penalty is currently$75. The maximum estimated employee contribution including the wellness penalty is $210.83 based on lowest paid employee. • This plan is affordable at $138 for employee only coverage. • This is illustrative only as the 2026 regulations have not been updated. ©2024 USI Insurance Services.All rights reserved. Edi 18 atc� •- -, °�R o"• • -.tia ,.�.�'.-�., a e. mod° �;�' ���� �•" � ants... 2 :: 'F .g, °.? 4 s, 'r e. e `ow "�, _. .. . °a= '� _ v ,:+ yi:.w. s.;�. ,e • :a-..m� - ,ur+. :r. .'-a._..:. .m.<-__: `" '�'„� n,• .._:-:—..,.-- .._._. -- z:.;. :G. -A�. ._»_ .r.__ u .. _..,..:__=.4._.- •:..:,}r:.) ."`°y . ..�wm; .{ ,t•:e e avr t?x.,"• A ti••= " �. . 's:"a*.os`�'' 1 �'.' " . " r .r� ^ 'e ,, °z r j ;, _ §";.^+ ;a a,.n, ^::.° '•°Y ,d, r y3 c 7 =$ `,' ' b s ° °� .. 6 .�`�•°a ��. .q�... ^•�a3, vg .t ., x°aaa.°i d °.,°° •c��• . a a„;� .a:', � 'a'"• 4`e@°°°`.aa qm i ga4 . te a e.a s 2 Deiitdl PrØJettiônA.a�a,.. . ° °aa saff.;« .tl . s` '.• •'a°°'tas ,g,, '° . : yg� F a A � ©2020 USI Insurance Services.All rights reserved. I 1 9 ° ,C^# ,�.'# eTS'- .,, 2" ° . . "' ' [ ° :t@' • • -,, .. 5 � .. T _ °•-. 3 a....._._-_—+ Dental Claims Projection - 202b Time Periods _ ° Current-ALL PLANS Renewal Period: January-26 December-26 Experience Period: July-23 May-25 Enrollment Period: June-23 April-25 Current Enrolled Employees: 995 Renewal Calculation PEPM m ClaiDevelopment *F '* . Dental — : Paid Claims $606,160 Annual Trend 5.0% Midpoint Months 15.0 Applied Trend 6.3% Adjusted Trended Claims $644,278 Total Subscribers 11,876 Adjusted Trended Claims(PEPM) $54.25 Current Employees 995 Total Projected Trended Claims $647,751 Claim Period Weighting 100% otal Experience Projection $647,751 $54.25 Fixed Costs °e.°ry �. ASO Fee(PEPM) $49,790 $4.17 Total 2026 Premium Equivalents .; $697,540 $58.42 Current Budget $884,509 $74.08 Needed.Change to Current PremiumEquivalents _ _ -21% ©2024 USI Insurance Services.All rights reserved. L I 20 - .., .;:47,7°' °-F• : ,,, ...: ,,,, ,,,r,,,,,„...,,., , 2026 Dental Contributions .7`f;6:977v01171'e,,i1 ei t!itlIk - -i'il'.F-7,ih)V, 4:4V '" '2,4).- '•--()-EJY- 'r.A--- 331%.7 g- -. ...:e.F;÷3 t7t34--1) ::15:.#:...eiteC_C4.,::E;:;:i-TA:),:;+- Employee Only $36.00 $18.00 $32.40 $16.20 -$1.80 Employee+Spouse $94.00 $47.00 $84.60 $42.30 -$4.70 Employee+Children $82.00 $41.00 $73.80 $36.90 -$4.10 Employee+Family $148.00 $74.00 $133.20 $66.60 -$7.40 • Recommend 10% reduction to employee contributions. ©2024 USI Insurance Services.All rights reserved. tUS/I. I 21 � �.` • '"";m:v. - �a ns• " ._ •.max.-• R,+ x. �,. .,.. ,*e .� �, .r� g s a .•»` � '` „3 �,�_��'„�-�.`m ;�s,�`,f `°s, �a .� �� ' n y ° W. :R. .,`R s,..r. ani s . .✓' e `_ ;. .:. µ � ,s °a• � „ • .':-::. `. a Vic, °""'° �v � 's'� ;��`� � ,s . ; ,;.a '� s •' "'� fix. 4* .gSd: max;: •� .... �,� �'� a atid � mg �„ ,�,Bnhtidrk°�" ° . „, ,„, • .,: gym. a�.,e "^s.,t* a ,. •- ,. s�, s5..g:; .. `gym° , . � , ��, 's�" �w . , .. . .. .. ,, �s. � ,,_ . a , � .... 0 2020 USI Insurance Services.All rights reserved. Mt I 22 a w,, "�,a . r7'4?: _. a};e' • '::::¢° ,+:t.§z,, ,;Y...77 ��,.=e,a .4"+?fig.. . ,t-x. °gyp s" : �� • $�,i,� e ; Ae..,, r:a , ' `,,. yfn'i ,r, J, 2,, ,�_ 2025 Benchmark '' ' ° , ° • ' ' ° .e ;':�` e'' x qa • \ sew �:a V � . tab e ` t*s ''Brazos County , County Government Cy Government Southwest �. , 4� ` s •' �� $. ss iM� ..a,�V �.- m x. � , ,. . �,L; Actuarial Value 82%° 85% 86% 77% Type of Plan PPO PPO PPO PPO Individual Deductible Ind/Fam $1,000/$2,000 $1,000/$2,000 $500/$1,025 $2,000/$4,800 Out of Pocket $3,500/$7,000 $3,500/$7,000 $3,500/$7,000 $5,500/$12,000 Coinsurance 80% 80% 80% 80% Physician Office Visit $25 Copay $25 Copay $20 Copay $30 Copay c Specilaist Visit io $35 $35 Copay $30 Copay $55 Copay Urgent Care o $50 $40 Copay $30 Copay $70 Copay NJ Inpatient Hospital CO 80%after ded 80%after ded 80%after ded 80%after ded Outpatient Hospital a 80%after ded 80%after ded 80%after ded 80%after ded ER Visit a $150 Copay $200 $150 $350 $10 Generic $10 Generic $10 Generic $10 Generic Prescription Drug Benefit 20%Preferred Brand $30 Preferred Brand $30 Preferred Brand $40 Preferred Brand 20%Non-Preferred $50 Non-Preferred $50 Non-Preferred $75 Non-Preferred ;Monthly Emloyee"Rate ", * ' v,. " �W .i e } v` e °`p : � t . xy .Be .al.e ea Employee 687 $63 $79 $108 $158 Employee&Spouse 108 $511 $330 $360 $631 Employee&Children 193 $339 $287 $358 $525 Employee Family 86 $711 $482 $457 $964 ©2024 USI Insurance Services.Alt rights reserved. M. I 23 P pose @ O@Z De T Rate-sF(D,.4J-) 2.M. ,,,, „ '. ed4+ a _ s 4 Coun'iy,€ontr_ � 2025' a increase - ' is o ee: Monthly $1 ,416 $1 ,416 $0.00 Yearly $16,992 $16,992 $0.00 q .E016 p.o, ee Pre. # t, kn . .&o . =C-.( ant -y G:, � 2026 .[nereafse,.,� Employee Only $138 $138 $0 Employee + Spouse $586 $586 $0 Employee + Children $414 $414 $0 Employee + Family $786 $786 $0 Rew� rd�s- ° ragram -, ,(',7 51 on li Disco iii@myou: 1VledicaO pre; '.i ow)} .. r... .025. 4 202E increase Employee Only $63 $63 $0 Employee + Spouse $511 $511 $0 Employee + Children $339 $339 $0 Employee + Family $711 $711 $0 g .o io ee con:,. a u]ton ; 2025 R 2020 _ ..t. « , _nerease - Employee Only $36 $32 ($4.00) Employee + Spouse $94 $85 ($9.00) Employee + Children $82 $74 ($8.00) Employee + Family $148 $133 ($15.00) 2025 Employee Insurance Budget Review w* ''` i‘* Executive Summary '. � ' o July 15, 2025 — Commissioners Court °gc.; _ ,A,.. Prepared By: Human Resources & USI TYOF13R+• r --- - -. __._. - a, - - ' Brazos County continues to manage its employee health benefits program with a strong focus on fiscal stewardship and data-driven decision-making. Based on current projections and experience through May 2025, several key outcomes highlight the success of the County's approach: • Under Budget Performance: The health plan is currently running approximately $396,000 under budget for 2025. Year-to-date, the County has spent only 95% of budgeted funds, providing a healthy buffer amid rising healthcare costs. • Consistent Employer Cost Share: Brazos County continues to shoulder the majority of healthcare costs, paying 86% of total medical and pharmacy expenses. This is consistent with prior years (83% in 2024), ensuring stability and affordability. • Cost Containment Success: Despite national healthcare costs trending upward (projected 10% increase in 2026), Brazos County's costs are growing at a much slower pace. The rolling 12-month claims trend is just 0.7%, a testament to effective plan management and oversight. • Strategic Planning for 2026: Projections suggest that no budget increase is necessary for the upcoming year. It is recommended to keep the County's contribution at $1,416 per employee per month. In addition, it is recommended to keep employee medical premiums the same as in 2025. With regards to employee dental premiums, it is recommended to decrease premiums slightly (dental is 100% employee funded, the County does not contribute to dental premiums). • Benchmark-Competitive Plan Design: Brazos County's PPO plan continues to be cost- effective and competitive when compared at a high level to other local governments and regional peers. Deductibles, out-of-pocket maximums, and prescription copays are well within or below average ranges. • Affordable for All Employees: The County's employee-only premium rate of$138/month (Non-Wellness Rate) remains compliant with federal affordability standards, even at the lowest hourly wage. • Pharmacy Oversight: High-cost drugs like Ozempic and Wegovy are being carefully monitored. Rx rebates and stop-loss reimbursements have effectively mitigated large claim impacts. In summary, Brazos County's employee health benefits program remains financially healthy, competitive, and well-managed. HR and USI Insurance Services will continue to monitor performance and identify cost-saving strategies to ensure sustainability into 2026 and beyond. ...pc PIrs Or N •�'•ti�w ti:•.td" BRAZOS COUNTY BRYAN, TEXAS )EPARTMENT: NUMBER: )ATE OF COURT MEETING: 7/15/2025 TEM: Presentation and Discussion of the FY 2025- 2026 County Budget regarding Retirement Plan (TCDRS). Commissioners Court )ATE: 06/16/2025 tISCAL IMPACT: False 1UDGETED: False )OLLAR AMOUNT: $0.00 TEXAS® • " , Q' GONNT,Y.R. DISYRI CT ?!� Cj RETIREMENT` SYSTEM Plan Assessment for Plan Year 2026 Brazos County— 120 Participation Date— 1/1/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. 2026 Plan { Basic Plan Options F.__� 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 i Partial Lump Sum No Group Term Life None Retirement Plan Funding • Total Normal Cost Rate 14.91% Employee Deposit Rate -7.00% Employer-Paid Normal Cost Rate 7.91% UAAL/ (OAAL) Rate 6.47% Required Rate 14.38% Elected Rate 17.00% Contribution Rates _ — _ Retirement Plan Rate 17.00% (greater of required and elected rate) Group Term Life Rate N/A Valuation Results (Dec.31,2024) Actuarial Accrued Liability — _$380,038,930 Actuarial Value of Assets $326,385,113 Unfunded / (Overfunded)AAL $53,653,817 Funded Ratio 85.9% Notes: Buyback adopted: 1991 Last COLA: 2023 800-651-3848 * TCDRS.ORC/EMPLOYER I 4/1/2025 What You Are Providing The TCDRS benefit is based on employee deposits,which earn 7% compound interest each year, and employer matching at retirement.The following chart shows the estimated TCDRS benefit as a percentage of final salary prior to retirement for a new hire: of Salary that TCDRS Benefit Replaces at Retirement 120% - Final Salary 100% - 80% - ,t i,� 60% aq 40/° Pogo 'gag=, ,5 �h g.�+P i,4'+ 4 N 20% Po ti r � yF e: x c� r�,i F 4 '# , nti §b e r,t3,r•" x 0% Hired at 55 Hired at 50 Hired at 45 Hired at 40 Hired at 35 Retired at 65 Retired at 65 Retired at 65 Retired at 65 Retired at 65 Assumptions • Employees are new hires and will work for you until retirement. • Your current plan provisions will remain in effect through an employee's retirement. • Current laws governing TCDRS will continue as they are. • Graded salary scales give bigger raises early in careers,with smaller raises later in careers (see Summary Valuation Report at TCDRS.org/Employer). • Based on Single Life benefit. 800-651-3848 * TCDRS.ORC/EMPLOYER 2 4/1/2025 Reasons for Rate Change Below is a record of your required rate history for your retirement plan over the last five years. 18% - 16% - 14% - 1. 12% - 10% - i 8% - 6% - i 4% - 2% - i 0% 2022 2023 2024 2025 2026 I 3 Reasons for Rate Change 2022-2023 2023-2024 2024-2025 2025-2026 Beginning Rate 15.21% 16.21% 16.02% 15.12% Plan Changes Adopted 1.62% 0.00% 0.00% N/A Investment Return -0.18% 0.30% 0.01% -0.08% Elected Rate/Lump Sum -0.13% -0.04% -0.08% -0.19% Demographic/Other Changes 0.23% -0.45% -0.75% -0.47% Assumptions/Methods -0.54% 0.00% -0.08% 0.00% Ending Rate 16.21% 16.02% 15.12% 14.38% Valuation Year 2021 2022 2023 2024 Funded Ratio 83.0% 84.2% 84.9% 85.9% Full details on the valuation calculations are included in the Dec. 31,2024 Summary Valuation Report which will be available mid-May at TCDRS.org/Employer. Next Steps If you are interested in making plan changes,please contact your Employer Services Representative at 800-651-3848.Your benefit selections are due by Dec. 15,2025. 800-651-3848 * TCDRS.ORG/Et PLOVER 3 4/1/2025 BRAZOS COUNTY BRYAN, TEXAS )EPARTMENT: NUMBER: )ATE OF COURT MEETING: 7/15/2025 TEM: Presentation and Discussion of the FY 2025-2026 County Budget regarding the following: • a. Cost-of-Living-Adjustment(COLA) • b. Merit Allowance and Merit Policy -0: Commissioners Court )ATE: 06/16/2025 ISCAL IMPACT: False 3UDGETED: False )OLLAR AMOUNT: $0.00 Living Wage Calculation for Texas 2024-2025 Update ° ° n2 Adults(Both Working) 1 Adult - � . _ ° 2Qdults:(1 Working)0 Children 1 Child 2 Children 3 Children 0 Children 1 Child 2 Children 3 Children 0 Children 1 Child 2 Children 3 Children LivLiving Wage-ing Brazosge-7USACou County $ 20.27 $ 33.08 $ 40.10 $ 51.48 # $ q,07 $35.93 °.$ 39.29 $ '45.13 # $ 15.04 $ 20.49� $ 22.53 $ „ 27.26 28.28 $ 33.06 $ 36.23 $ 42.24 $ 14.14 $ 18.77 Brazos County Lowest Wage"$ 17.98 $ 17-.98 `$ '17.98 `$„°. 17.98;' $°, 17.98 $ 17.98 "$ ` °17.98 °$ -17.98_ $`:17.98 '$ 17.98 `$ 17.98 $ 17.98, Poverty Wage $ 7.52 $ 10.17 $ 12.81 $ 15.46 $ 10.17 $ 12.81 $ 15.46 $ 18.10 # $ 5.08 $ 6.41 $ 7.73 $ 9.05 Minimum Wage $ 7.25 $ 7.25 $ 7.25 $ 7.25 $ 7.25 $ 7.25 $ 7.25 $ 7.25 $ 7.25 $ 7.25 $ 7.25 $ 7.25 USA Living Wage vs.Brazos County Lowest Wage by Percent -21% -102% -147% -212% -67% -100% -119% -151% 16% -14% -37% -64% Brazos County Living Wage vs.Brazos County Lowest Wage by Percent -13% -84% -123% -186% -57% -84% -102% -135% 21% -4% -25% -52% Study was performed by the Department of Urban Studies and Planning at the Massachusetts Institute of Technology. This information was updated as of 2/10/25. https://liyingwage.rnit.edu/states/48 https://l ivi ngwa ge.m it.ed u/counties/48041 Prepared by the Budget Office BRAZOS COUNTY, TEXAS FY 2024 MERIT DISTRIBUTION POLICY MERIT PAY DISTRIBUTION GUIDELINES Brazos County Commissioner's Court is proposing to provide to all operating divisions, funds to be used by the elected official and/or department head for the sole purpose of employee merit pay. The merit pay pool for each department provides the elected official and/or department head the opportunity to reward those employees within their department for outstanding performance. The following guidelines are to be followed by all elected officials and/or department heads with implementing the use of merit pay increases for Fiscal Year 2024: 1. To be eligible to receive merit funds from the merit pool an employee must be employed with the County for six(6)months as of the effective hire date. • 2. Deadline for all merit to be awarded is on Friday, April 5, 2023. See calendar on page 4 important deadlines. 3. All merit pay requests must be made using the FY 2024 (4.5% COLA) Salary Grade Chart (e.g., all requests must be based on the step increases provided for the group in which the employee is currently classified). 4. Merit may not be used on a position'that is-adopted in the FY 2024 Budget that received an increase that is above the Cost-of-Living Adjustment. 5. Merit may not be used to increase an employee's salary over the salary cap for their position. Currently the salary cap within each group is a step 20. 6.. Employees who are on group and step, cannot-be increased by more than 2 steps. Employees who are not on group and step, cannot be increased by more than 5%. 7. All merit pay will be based on an annualized basis regardless of what the effective date of the distribution of the merit pay. 8. At no time during the year may the elected official and/or department head, under the direction of Commissioner's Court,use funds available in the merit pool for the department to increase the elected official or department head's salary. 9. Once the elected official and/or department head has chosen the position(s)to receive a merit,a memo should be submitted to the Budget Analyst in the County Auditor's Office requesting a Position Control Change calculation worksheet for FY 2024. Items to be included in the memo are as follows. • Position Title,Class Code and Position Number, Budgeted Group/Step, Requested Step, AND Hire Date. For employees who are not on Group/Step, list the percentage of increase or dollar amount. Page 1 of 4 MERIT PAY DISTRIBUTION GUIDELINES CONT. 10. Commissioner's Court has the right to deny and/or modify Personnel Action Forms that are submitted for merit approval. 11. If the total department merit goes over what is awarded,the County will support overages $50.00 or below. MERIT CALCULATION GUIDELINES AND EXCEPTIONS 1. Calculations are based on the FY 2023 Adopted Position Control'as of October 1, 2022. 2. Only use the following accounts in the merit calculations:, a. 51100000 Salary—Election Official b. 51150000 Salary—Appointed Official c. 51200000 Salary—Department Heads d. 51300000 Salary—Staff e. 51400000 Salary—AG Extension ' f. 51440000 Salary—Law Enforcement g. 51610000 Hourly—Staff' h. 51615000 Hourly—Law Enforcement i. 51630000 Hourly—Part-Time j. 51630000 Hourly-Temporary k. 51635000 Hourly—Three-QuarterTime I. 51990000 Accrued Salary and Wages 3. Merit Calculation a. Department Salary Accounts* 1.5%=Merit Award w4. Exceptions a.' . County Judge and Veterans.Services i. Use the following positions under County Judge and Veterans Services: B0201-1, B0222- 1, B0223-1, B0240-1, B0241-1, B0243-1, B0209-1, B0219-1, B0226-1, B0218-1, B0225-1, B0213-1 b. Commissioner's Court i. Use the following positions under Commissioner's Court: B0101-1, B0111-1, B0116-1 c. Fleet Services i. Merit includes the following divisions: 11100000 and 56002000 d. Facilities Services i. Merit includes the following divisions: 17000100 and 17000200 e. District Attorney Administration i. Merit includes the following divisions: 19000100, 19010000,and 1920010 Page 2 of 4 MERIT CALCULATION GUIDELINES AND EXCEPTIONS CONT. f. District Clerk i. Merit includes the following divisions:20000100 and 20010000 g. 85th, 272"d and 361'District Courts i. Include the$140,000 state salary for each District Court h. Juvenile Court Referee i. Include the full salary of Associate Judge#2-B2206-1 i. Associate Judge#1 i. Do not include Specialty Court • j. Associate Judge#2 i. Do not include the salary of Associate.Judge#2762206-1,use the full salary of Family Law Associate Judge-B2905-1 k. Sheriff Office:Administration i. Use the following positions under Sheriff's Office:Administration: B1405-1, B1418-1, B1419-1, B1435-5, 61435-6, B1439-1, B1441-1, B1441-2, B1442-1, B1443-1, B1444-2, B1444-3, B1444-4, B1444-5, B1444-6, B1445-1,and 61445-2 I. Sherriff Office:Jail Administration • i. Use the following positions under.Sheriff's Office-Jail Administration: B1563-1, B1517- 1, B1517-2, B1517-3, B1517-4, B1517-5;B1517-6;.B1526-1, B1526-2, B1553-1 m. Juvenile Administration i.. Merit includes the following divisions:31000100,31000110,31000130,31000140, 31000220,31000330,31040030,312110,312111,312123,312132,312143,312154, and 312157 n. Exposition Center i. Merit includes the-following divisions:36000100 and 36100100 o. '•.Hotel Occupancy Fund (Fund 11000) i. Merit can only be used.for division 11002500 p. County Clerk Records Management(Fund 20000) Merit can only:be used for division 21000500 q. Health and Life Fuhd (Fund 50000) Health and Wellness Clinic i. Merit can only be used for division 64005100 Page 3 of 4 Merit Award Calendar for Fiscal Year 2024 * DRAFT * Merit Effective Merit Request { Personnel Action ' Personnel Action Date: Deadline Form Deadline Form Approved October, 10/14/2023 9/22/2023 F 10/4/2023 10/10/2023 10/28/2023 10/6/2023 _ 10/18/2023 10/24/2023 _( ' November 11/11/2023 , 10/20/2023 i ; 1/11/1/2023 -__� i. ._. 11/7/2023 11/25/2023 11/3/2023 11/15/2023 11/21/2023 Decembers 12/9/2023 j ! 11/17/2023 ! 41/29/2023 12/5/2023 _1 12/23/2023 12/1/2023_ 12/13/2023 12/19/2023 1 January, 1/6/2024 12/15/2023:i'` 12/27/2023 1/2/2023tl_!. 1/20/2024 _{ 12/29/2023 1/10/20'24 1/16/2024 February 2/3/2024 , 1/12/2021 j 1/24/2024 1/30/2024 - 2/17/2024 1/26/2024 2/7/2024 2/13/2024 March 3/2/2024 _ t 2/9/2024 1 .� 2/21/2024 — ! ` 2/27/2024 _ 3/16/2024 2/23/2024 — 3/6/2024 3/12/2024 3/30/2024.__.__ u_j..._ . 3/8/2624 24 I�� 3 C 3/20/2024 1 � 3/26/2024 April 4/13/2024 3/22/2024 4/3/2024 4/9/2024 T 4/27/2024 4/5/2024. -4/17/2024 4/23/2024 Deadlines are scheduled to chang e due to County holidays - ; i {.- • • Page 4 of 4 Brazos County,Texas General Fund(01000)COLA Estimate-FY 26 Salary and Wages _ _ ,Salary FY 25 Budget 1% I 2% 3% 3.5% 4% 4.5% 5% 5.5% I 6% I 6.5% I 7% $ 66,139,521 $ 66,800,916 $ 67,462,311 $ 68,123,707 $ 68,454,404 $ 68,785,102 $ 69,115,799 $ 69,446,497 $ 69,777,195 $ 70,107,892 $ 70,438,590 $ 70,769,287 $ 661,395 $ 1,322,790 $ 1,984,186 $ 2,314,883 $ 2,645,581 $ 2,976,278 $ 3,306,976 $ 3,637,674 $ 3,968,371 $ 4,299,069 $ 4,629,766 Difference $ 661,395 $ 661,395 $ 330,698 $ 330,698 $ 330,698 $ 330,698 $ 330,698 $ 330,698 $ 330,698 $ 330,698 Benefits Benefits _ FY 25 Budget 1% 2% 3% 3.5% 4%" - 4.5% I 5% 5.5% 6% I 6.5% 7% $ 16,845,616 $ 17,016,917 $ 17,188,219 $ 17,359,520 $ 17,445,171 $ 17,530,821 $ 17,616,472 $ 17,702,123 $ 17,787,773 $ 17,873,424 $ 17,959,075 $ 18,044,726 $ 171,301 $ 342,603 $ 513,904 $ 599,555 $ 685,205 $ 770,856 $ 856,507 $ 942,157 $ 1,027,808 $ 1,113,459 $ 1,199,110 Difference $ 171,301 $ 171,301 $ 85,651 $ 85,651 $ 85,651 $ 85,651 $ 85,651 $ 85,651 $ 85,651 $ 85,651 General Fund Increase Based on COLA Estimates Estimated 1% 2% 3% 3.5% 4% 4.5% 5% 5.5% 6% 6.5% 7% Additional Salary& Benefits $ 832,697 $ 1,665,393 $ 2,498,090 $ 2,914,438 $ 3,330,786 $ 3,747,135 $ 4,163,483 $ 4,579,831 $ 4,996,179 $ 5,412,528 $ 5,828,876 Prepared by the Budget Office Brazos County,Texas Weighted Average of 5 years For SSI, CPI and Brazos COLA Numbers represent percent change over previous year Consumer Price Index Supplemental Security Income Average of May to April 2021 2022 2023 2024 2025 20-21 21-22 22-23 23-24 24-25 1.3 5.9 8.7 3.2 2.5 21.6 1.6 7.3 7.3 3.2 2.6 22 5.9 8.7 3.2 2.5 20.3 7.3 7.3 3.2 2.6 20.4 8.7 3.2 2.5 14.4 7.3 3.2 2.6 13.1 3.2 2.5 5.7 3.2 2.6 5.8 2.5 2.5 2.6 2.6 64.5 63.9 15 15 Weighted average SSI 4.3 Weighted average CPI 4.3 Brazos County Cost of Living Increases 2021 2022 2023. 2024 2025 0 3 7.5 4.5 5 20 3 7.5 4.5 5 20 7.5 4.5 5 17 4.5 5 9.5 5 5 71.5 15 Weighted average Brazos COLA 4.8 Prepared by the Budget Office