CHIP_T_Dental_Caseload_Cost_by_SDA_SFY2018_SFY2027_v.xlsx

XLSX spreadsheet 46 KB Posted

Attached to
Medicaid and Children’s Health Insurance Program Dental Services
Solicitation number
HHS0017108
Issued by
Texas

About this file

This file is a caseload and cost projection spreadsheet for the Texas Health and Human Services Commission (HHSC) Children's Health Insurance Program (CHIP) Dental Services, tracking enrollment and expenditures across multiple Service Delivery Areas (SDAs) from September 2017 through August 2027. The spreadsheet provides monthly enrollment data segmented by plan type (HMO and EPO) and geographic regions including Bexar, Dallas, El Paso, Harris, Jefferson, Lubbock, Nueces, Tarrant, Travis, and RSA (Rural Service Area). The data includes both actual historical enrollment figures through November 2024 and forecasted projections beginning in December 2024, enabling the state to plan for future dental services capacity and resource allocation.

The accompanying cost analysis reveals dental services expenditures calculated on a per-member-per-month (PMPM) basis, with fiscal year summaries showing total program costs ranging from a low of $15.1 million in FY 2023 to projected costs of $77.1 million in FY 2027. The PMPM rates remain relatively stable, ranging from $21.70 to $24.67 across the fiscal years analyzed. Historical data indicates significant enrollment volatility, with CHIP Traditional caseloads declining sharply from approximately 410,000 members in FY 2018 to 53,600 members in FY 2023, followed by recovery to projected enrollment of 264,500 members by FY 2027. The forecasting data, prepared by HHSC CFO Forecasting in August 2025, supports budget planning and rate-setting for the state's dental benefit administration across all SDAs.

View the file

Other files

File Type Posted
Exhibit G, Medicaid and CHIP Dental Services Statement Of Work (SOW).pdf PDF
Exhibit Q, Evaluation Tool and Scoring Example.pdf PDF
Exhibit C, Deliverables-Liquidated Damages Matrix.pdf PDF
Exhibit S, TDI Certificate of Authority Table.pdf PDF
Exhibit P, Consensus Scoring Rubric.pdf PDF
Exhibit J, Certification Regarding Lobbying.pdf PDF
Exhibit A, Dental Contract Terms and Conditions.pdf PDF
Medicaid_Dental_Caseload_Cost_by_DentalRptRgn_SFY2018_SFY2027_v.xlsx XLSX spreadsheet
Exhibit H, HHS Solicitation Affirmations v. 2.10.pdf PDF
Exhibit E, Access Standards Map.pdf PDF
VPAT2.5Rev_WCAG_February2025.docx DOCX document
D00010_837D_LTC_Companion_Guide.pdf PDF
Exhibit I, Federal Assurances Non-Construction Programs.pdf PDF
Exhibit K, Exceptions.docx DOCX document
Exhibit F, Dental Reporting Regions Map.pdf PDF
ESBD_561159_1791405468508_HHS0017108_Dental_Services.pdf PDF
Exhibit M, Subcontracting Plan.pdf PDF
Exhibit B, Uniform Managed Care Manual (UMCM).pdf PDF
Exhibit N, Breach Disclosure History.pdf PDF
Exhibit L, Assumptions.docx DOCX document
CHIP_T_SDA_County_Zip_201709_202411_v.xlsx XLSX spreadsheet
Exhibit O, Medicaid and Children's Health Insurance Program (CHIP) Dental Services Scoring Guides.pdf PDF
Exhibit R, Procurement Library.pdf PDF
Medicaid_Dental_DentalReportingRegion_County_Zip_201709_202411_v.xlsx XLSX spreadsheet
Exhibit D, Texas Medicaid Provider Procedures Manual.pdf PDF
TX Medicaid and CHIP Enrolled Dental Providers SFY2025YTD_final.xlsb XLSB spreadsheet
D00022_837D_Acute_Care_Companion_Guide.pdf PDF
Show all 27

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

CHIP SDA

CHIP Caseload by SDA*

MonthTotal EnrollmentTotal HMOEPOBexarDallasEl PasoHarrisJeffersonLubbockNuecesTarrantTravisRSA
Sep-17405,551317,12988,42232,70365,08815,012104,6598,3099,5449,06646,90925,83988,422
Oct-17413,910325,65088,26032,52365,48715,078111,6058,9009,6249,64546,87125,91788,260
Nov-17418,794330,08188,71332,35266,33015,117114,4829,0649,7879,81347,13725,99988,713
Dec-17422,402333,35189,05132,30466,58415,013117,0589,2939,79910,07447,14526,08189,051
Jan-18420,154331,46088,69432,16366,24414,956115,9039,1819,79310,00147,10626,11388,694
Feb-18419,772330,96288,81032,19366,18515,114115,2209,1319,7969,90947,17226,24288,810
Mar-18420,340330,63189,70932,21566,75215,116114,0629,1319,8319,84547,44626,23389,709
Apr-18412,736324,29188,44531,95765,91014,851110,9378,6989,7099,51846,84725,86488,445
May-18408,466320,08288,38432,05865,69314,806107,5548,4509,5979,27146,85025,80388,384
Jun-18397,637310,24387,39431,76564,76114,500101,3237,9269,4758,73946,34425,41087,394
Jul-18393,114306,82686,28831,38063,91714,420100,1857,8179,4068,62545,85325,22386,288
Aug-18392,151306,05186,10031,38763,69414,26899,8597,7019,3728,61145,78425,37586,100
Sep-18390,344304,61085,73431,27763,58214,19299,3167,5679,2748,55945,53825,30585,734
Oct-18384,456299,62284,83431,23962,76014,14396,6057,3389,2968,26744,88425,09084,834
Nov-18384,075299,81484,26131,21562,70614,09396,9817,4439,3468,27744,73725,01684,261
Dec-18384,737300,60984,12831,22262,32514,03198,3047,5069,3398,34844,59524,93984,128
Jan-19382,510299,10983,40131,03761,65513,90598,5027,5169,2698,43144,13324,66183,401
Feb-19380,217297,35782,86030,81161,21313,58898,2817,4849,1688,44443,84724,52182,860
Mar-19377,366295,04582,32130,63660,55913,52097,6107,3659,2498,41243,44924,24582,321
Apr-19375,195293,42981,76630,39460,39713,35196,8837,3829,1328,41143,33224,14781,766
May-19374,255292,91681,33930,24660,52713,47696,6377,4219,1448,38643,13523,94481,339
Jun-19369,153288,89180,26229,91959,62913,34195,0527,2979,0638,25342,52523,81280,262
Jul-19364,321285,01779,30429,53558,69813,19193,6137,2488,9998,11041,96923,65479,304
Aug-19362,421283,90178,52029,49258,63713,05793,2697,1708,9368,11441,84423,38278,520
Sep-19361,667283,47178,19629,51258,38013,07493,1677,1378,9437,97442,02123,26378,196
Oct-19360,315282,33877,97729,51358,14613,00892,8877,1238,7687,90441,85523,13477,977
Nov-19358,385280,99577,39029,51757,99012,92292,2307,0588,6467,94241,70622,98477,390
Dec-19355,195278,54376,65229,25757,53212,69791,6897,0398,5407,89241,24022,65776,652
Jan-20352,725276,63476,09128,92957,02412,60391,3587,0158,4397,83040,95322,48376,091
Feb-20349,732274,40075,33228,70956,61212,59890,2946,9818,3477,80440,71122,34475,332
Mar-20342,443268,57973,86428,29355,20012,36688,1176,9148,1477,67939,89821,96573,864
Apr-20330,978259,51671,46227,28953,09911,92685,4806,6817,8947,48438,37121,29271,462
May-20325,066254,86470,20226,70252,31811,75383,7166,5217,7577,24237,83221,02370,202
Jun-20320,789251,26769,52226,28851,77411,62682,3816,4417,5727,17137,32720,68769,522
Jul-20317,392248,38169,01125,90751,13911,56981,6696,3417,4787,08336,89620,29969,011
Aug-20314,084245,71068,37425,62150,55211,43580,8696,2427,3947,03436,45520,10868,374
Sep-20307,372240,49766,87525,00349,61311,17279,0646,0787,3136,90535,67419,67566,875
Oct-20298,972233,73765,23524,30848,34510,88576,5935,9117,1116,75134,74019,09365,235
Nov-20293,932229,82264,11023,88647,56310,67475,2695,8086,9936,60534,20718,81764,110
Dec-20266,193208,05158,14221,45443,1709,74167,5885,2576,3775,95631,15117,35758,142
Jan-21250,128195,45554,67319,99540,8809,05863,2934,9215,9185,52529,38916,47654,673
Feb-21238,195185,98352,21218,96539,0558,66960,1594,6715,5635,17428,02415,70352,212
Mar-21216,816169,42847,38817,38935,8347,91754,2614,2075,0144,70425,69814,40447,388
Apr-21209,826164,11745,70916,87934,7927,69152,3904,0844,8414,54824,91713,97545,709
May-21205,675160,93244,74316,46334,0407,53951,3644,0354,7774,44724,58013,68744,743
Jun-21200,788157,21843,57016,03033,1837,36550,2303,9534,6694,30124,05613,43143,570
Jul-21192,711150,92241,78915,33231,9007,04648,1783,8514,4884,06223,11112,95441,789
Aug-21185,577145,29640,28114,73230,7696,74346,2983,7684,2993,93022,27512,48240,281
Sep-21175,776137,61038,16613,89029,1306,36643,7713,5874,0513,75221,09911,96438,166
Oct-21164,056128,49435,56212,95227,2226,01240,8413,3653,7343,50019,67511,19335,562
Nov-21123,12096,06927,0519,73319,8304,54231,4302,5622,7902,71714,1918,27427,051
Dec-21101,38178,91322,4687,89416,3103,71626,1092,1762,2732,17211,5786,68522,468
Jan-2289,45569,63219,8236,92214,3653,30423,1551,9451,9381,92410,1785,90119,823
Feb-2289,79170,00119,7906,93314,5113,30623,0761,9311,9121,96310,4175,95219,790
Mar-2281,10163,24717,8546,30013,0293,03420,8341,7591,7241,7709,4655,33217,854
Apr-2278,61561,26017,3556,13012,7053,01320,0191,6811,6771,7429,1435,15017,355
May-2274,91058,35516,5555,89612,0322,89519,1021,5831,5911,6868,6864,88416,555
Jun-2273,22757,06716,1605,79611,7732,85618,5911,5531,5901,6728,4534,78316,160
Jul-2269,59454,19515,3995,52111,1132,73917,6631,4781,5041,5898,0104,57815,399
Aug-2266,62551,87214,7535,30910,6642,59816,8951,4051,4411,5327,6514,37714,753
Sep-2264,75650,40714,3495,15910,3532,54016,4221,3861,3761,4977,4444,23014,349
Oct-2262,95148,97813,9734,98710,0822,43615,9851,3601,3171,4557,2044,15213,973
Nov-2258,60645,74612,8604,5569,5512,29014,9291,2861,1831,3566,7673,82812,860
Dec-2253,76542,06411,7014,1198,8012,10213,7311,1841,0651,2396,3613,46211,701
Jan-2350,90939,74811,1613,8618,3221,95413,0101,1439941,1985,9723,29411,161
Feb-2348,87038,11910,7513,7767,9421,87612,5011,1199851,1675,6403,11310,751
Mar-2341,33232,2039,1293,2096,6291,64110,5819418201,0034,7362,6439,129
Apr-2340,31531,3998,9163,1576,4201,62310,3069308039504,6512,5598,916
May-2339,39930,7578,6423,0936,2931,63110,1319087859404,4892,4878,642
Jun-2346,01535,87510,1403,6717,3161,92811,8401,0489161,0875,1962,87310,140
Jul-2359,59646,44013,1564,7889,4972,47515,2461,3381,2251,3916,8543,62613,156
Aug-2376,74759,74717,0006,18712,0983,14319,6371,7291,5261,8138,9604,65417,000
Sep-2389,90470,05419,8507,29514,0013,65722,9812,0791,8132,18210,5555,49119,850
Oct-2399,23377,06422,1698,10915,2973,96425,2662,3712,1032,38911,6285,93722,169
Nov-23114,13188,43125,7009,43417,5574,52229,0862,6492,4612,70313,1126,90725,700
Dec-23130,854101,10029,75410,89320,1315,05533,3653,0492,8663,16714,7787,79629,754
Jan-24140,373108,39831,97511,69921,6035,45135,7413,2113,1363,31615,8238,41831,975
Feb-24145,661112,59233,06912,22222,4965,65136,9943,3313,3013,46416,4378,69633,069
Mar-24145,204112,21732,98712,31922,4805,60036,4743,4033,2873,34416,5788,73232,987
Apr-24149,376115,36734,00912,61123,1545,76837,5133,4743,3713,45817,0748,94434,009
May-24159,160122,84436,31613,28124,7246,02340,2093,6853,6083,66018,1319,52336,316
Jun-24161,504124,73836,76613,31425,0776,07641,1083,6733,6313,72118,4559,68336,766
Jul-24163,027125,92437,10313,36425,2046,14841,6613,6993,6713,70818,7079,76237,103
Aug-24163,517126,06337,45413,37425,3596,20941,4513,6763,7513,69618,7889,75937,454
Sep-24165,595127,70937,88613,72225,8236,25041,8023,7053,7993,78618,9979,82537,886
Oct-24167,492129,16238,33013,87126,0296,31142,3073,6553,8423,83919,3239,98538,330
Nov-24170,790131,89838,89214,08026,5146,48243,1833,7693,9223,98819,71110,24938,892
Dec-24171,956132,88239,07414,30026,6686,56343,5983,9123,8983,98719,66410,29239,074
Jan-25177,427137,22440,20314,76727,5396,77845,0234,0394,0264,11720,30710,62840,203
Feb-25182,639141,15541,48415,19028,3286,97246,3134,1554,1414,23520,88910,93241,484
Mar-25161,786125,10236,68413,46325,1076,17941,0463,6833,6703,75418,5139,68936,684
Apr-25165,222127,76837,45413,75025,6426,31141,9203,7613,7483,83418,9089,89537,454
May-25167,557129,81437,74313,97026,0526,41242,5923,8213,8083,89519,21010,05437,743
Jun-25167,319129,67837,64113,95526,0256,40542,5473,8173,8043,89119,19010,04337,641
Jul-25187,421145,79841,62315,69029,2607,20147,8364,2924,2774,37521,57611,29241,623
Aug-25195,593152,35543,23816,39530,5767,52549,9874,4854,4694,57122,54611,80043,238
Sep-25200,870156,67144,19916,86031,4427,73851,4034,6124,5964,70123,18512,13444,199
Oct-25204,568159,76744,80117,19332,0637,89152,4194,7034,6874,79423,64312,37444,801
Nov-25205,728160,88644,84117,31432,2887,94652,7864,7364,7204,82723,80812,46044,841
Dec-25208,150162,99845,15217,54132,7128,05153,4794,7984,7824,89124,12112,62445,152
Jan-26212,129166,33645,79417,90033,3828,21554,5744,8964,8804,99124,61512,88245,794
Feb-26216,806170,00346,80318,29534,1188,39655,7775,0044,9875,10125,15813,16646,803
Mar-26222,078174,13747,94118,74034,9478,60157,1345,1265,1085,22525,76913,48747,941
Apr-26222,079174,13847,94218,74034,9488,60157,1345,1265,1085,22525,76913,48747,942
May-26223,223175,03448,18818,83635,1288,64557,4285,1525,1355,25225,90213,55648,188
Jun-26230,806180,98149,82619,47636,3218,93959,3795,3275,3095,43026,78214,01749,826
Jul-26240,417188,51751,90020,28737,8339,31161,8525,5495,5305,65627,89714,60051,900
Aug-26248,906195,17353,73321,00339,1699,64064,0365,7455,7265,85628,88215,11653,733
Sep-26253,574198,83454,74121,39739,9049,82065,2375,8535,8335,96629,42415,39954,741
Oct-26256,157200,85955,29821,61540,3109,92165,9015,9135,8926,02729,72415,55655,298
Nov-26255,513200,35455,15921,56140,2099,89665,7365,8985,8786,01229,64915,51755,159
Dec-26256,401201,05055,35121,63640,3499,93065,9645,9185,8986,03229,75215,57155,351
Jan-27259,140203,19855,94221,86740,78010,03666,6695,9815,9616,09730,07015,73755,942
Feb-27262,644205,94556,69922,16341,33110,17267,5706,0626,0426,17930,47715,95056,699
Mar-27266,768209,17957,58922,51141,98010,33168,6316,1576,1366,27630,95516,20157,589
Apr-27264,506207,40557,10022,32041,62410,24468,0496,1056,0846,22330,69316,06357,100
May-27263,593206,68956,90322,24341,48010,20867,8146,0846,0636,20230,58716,00856,903
Jun-27270,195211,86758,32922,80042,51910,46469,5136,2376,2156,35731,35316,40958,329
Jul-27278,996218,76860,22923,54243,90410,80571,7776,4406,4186,56432,37416,94360,229
Aug-27286,311224,50361,80824,16045,05511,08873,6596,6096,5866,73633,22317,38761,808
Fiscal Year Summary: Average Members Per Month
Total EnrollmentTotal HMOEPOBexarDallasEl PasoHarrisJeffersonLubbockNuecesTarrantTravisRSA
FY 2018410,419322,23088,18932,08365,55414,854109,4048,6339,6449,42646,78925,84288,189
FY 2019377,421295,02782,39430,58561,05713,65796,7547,3959,1858,33443,66624,39382,394
FY 2020340,731267,05873,67327,96154,98112,29887,8216,7918,1607,58739,60521,85373,673
FY 2021238,849186,78852,06119,20339,0958,70860,3914,7125,6145,24228,15215,67152,061
FY 202298,97177,22621,7457,77316,0573,69825,1242,0852,1852,16811,5466,58921,745
FY 202353,60541,79011,8154,2148,6092,13713,6931,1981,0831,2586,1903,41011,815
FY 2024138,495107,06631,42911,49321,4245,34435,1543,1923,0833,23415,8398,30431,429
FY 2025173,400134,21239,18814,42926,9646,61644,0133,9243,9504,02319,90310,39039,188
FY 2026219,647172,05347,59318,51534,5298,49856,4505,0655,0475,16225,46113,32547,593
FY 2027264,483207,38857,09622,31841,62110,24368,0436,1056,0846,22330,69016,06257,096
*CHIP Traditional Only.
Data is final through Nov2024. Forecast begins Dec2024.
HHSC CFO Forecasting, August 2025

CHIP Dental SDA CHIP Dental Costs by SDA*

State Fiscal YearTotal CostTotal HMOEPOBexarDallasEl PasoHarrisJeffersonLubbockNuecesTarrantTravisRSADental Cost PMPM
FY 2018$ 121,511,909$ 95,401,918$ 26,109,990$ 9,498,848$ 19,408,368$ 4,397,868$ 32,390,999$ 2,556,078$ 2,855,403$ 2,790,860$ 13,852,627$ 7,650,866$ 26,109,99024.67
FY 2019$ 108,443,109$ 84,769,059$ 23,674,050$ 8,787,961$ 17,543,406$ 3,924,117$ 27,800,134$ 2,124,710$ 2,638,977$ 2,394,677$ 12,546,315$ 7,008,762$ 23,674,05023.94
FY 2020$ 96,338,457$ 75,508,181$ 20,830,276$ 7,905,827$ 15,545,218$ 3,477,167$ 24,830,678$ 1,920,115$ 2,307,281$ 2,145,035$ 11,198,058$ 6,178,801$ 20,830,27623.56
FY 2021$ 65,886,331$ 51,525,440$ 14,360,891$ 5,297,140$ 10,784,432$ 2,402,190$ 16,658,718$ 1,299,803$ 1,548,505$ 1,446,096$ 7,765,672$ 4,322,885$ 14,360,89122.99
FY 2022$ 27,644,177$ 21,570,540$ 6,073,637$ 2,171,125$ 4,484,980$ 1,033,028$ 7,017,493$ 582,491$ 610,422$ 605,627$ 3,224,845$ 1,840,531$ 6,073,63723.28
FY 2023$ 15,113,547$ 11,782,444$ 3,331,103$ 1,187,988$ 2,427,148$ 602,393$ 3,860,708$ 337,673$ 305,320$ 354,684$ 1,745,083$ 961,447$ 3,331,10323.50
FY 2024$ 36,069,183$ 27,883,850$ 8,185,333$ 2,993,170$ 5,579,474$ 1,391,684$ 9,155,392$ 831,225$ 802,990$ 842,250$ 4,125,004$ 2,162,661$ 8,185,33321.70
FY 2025$ 48,211,385$ 37,315,804$ 10,895,580$ 4,011,899$ 7,496,866$ 1,839,371$ 12,237,146$ 1,091,147$ 1,098,349$ 1,118,445$ 5,533,698$ 2,888,884$ 10,895,58023.17
FY 2026$ 62,497,075$ 48,955,123$ 13,541,952$ 5,268,249$ 9,824,782$ 2,417,914$ 16,062,049$ 1,441,066$ 1,436,130$ 1,468,880$ 7,244,549$ 3,791,505$ 13,541,95223.71
FY 2027$ 77,109,368$ 60,463,296$ 16,646,072$ 6,506,688$ 12,134,353$ 2,986,307$ 19,837,850$ 1,779,826$ 1,773,729$ 1,814,178$ 8,947,568$ 4,682,797$ 16,646,07224.30
*Based on overall Dental PMPM. CHIP Traditional only.

File details come from the government source that posted it. Updated .