ESBD_521004_1780004043386_Exhibit A-5 Dental PvC through 1-26.xlsx
XLSX spreadsheet 26 KB Posted
- Attached to
- HR Benefits - Medical, Dental, and Vision
- Solicitation number
- 2605-004
- Issued by
- Travis County, Austin City, Texas
About this file
This is an Experience Exhibit displaying dental plan claims data for Travis County Healthcare District - Central Health, a covered entity under Group Control #00169460. The exhibit presents a rolling 24-month analysis of dental plan performance with claims incurred and completed through January 2026 and claims paid through February 2026. The data encompasses monthly subscriber and member counts, billed premiums, and dental premium claims across the evaluation period.
The exhibit demonstrates consistent growth in both subscriber and member enrollment, increasing from 1,570 subscribers and 2,882 members in February 2024 to 1,961 subscribers and 3,591 members in January 2026. Monthly billed premiums ranged from approximately $97,500 to $141,800, with aggregate premiums billed totaling $2,853,825 over the 24-month period. Aggregate incurred claims reached $2,617,726, resulting in a cost ratio of 92 percent. Monthly dental premium claims fluctuated between $78,566 and $139,051, with notable variation suggesting seasonal patterns in utilization. The unaudited data excludes DMO information from the analysis. This claims experience data serves as supporting documentation for the bidding process, providing potential vendors with historical plan performance metrics necessary for proposal development and pricing calculations.
View the file
Other files
Show all 35
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
BTD_24
| TRAVIS COUNTY HEALTHCARE DISTRICT - CENTRAL HEALTH | |
| Group/Control#: 00169460 |
Experience Exhibit
| - Claims displayed are incurred and completed through January 2026. |
| - Claims displayed are based on a rolling 24 months of data. |
| - Claims paid through February 2026. |
Monthly Claims:
| Month | Subscribers | Members | Monthly Billed | Monthly Dental |
| Premium | Claims |
| February 2024 | 1,570 | 2,882 | $97,568 | $106,934 |
| March 2024 | 1,622 | 3,044 | $102,462 | $90,920 |
| April 2024 | 1,637 | 3,049 | $103,054 | $96,371 |
| May 2024 | 1,656 | 3,074 | $104,031 | $97,729 |
| June 2024 | 1,657 | 3,079 | $103,933 | $96,343 |
| July 2024 | 1,675 | 3,106 | $105,049 | $114,305 |
| August 2024 | 1,704 | 3,148 | $106,572 | $113,039 |
| September 2024 | 1,714 | 3,150 | $106,908 | $87,690 |
| October 2024 | 1,718 | 3,145 | $107,061 | $106,592 |
| November 2024 | 1,727 | 3,155 | $107,398 | $81,866 |
| December 2024 | 1,740 | 3,161 | $107,886 | $78,566 |
| January 2025 | 1,771 | 3,218 | $109,773 | $101,716 |
| February 2025 | 1,760 | 3,193 | $109,012 | $104,610 |
| March 2025 | 1,838 | 3,389 | $132,163 | $112,156 |
| April 2025 | 1,840 | 3,398 | $132,725 | $136,815 |
| May 2025 | 1,830 | 3,381 | $131,971 | $119,272 |
| June 2025 | 1,827 | 3,376 | $131,677 | $123,913 |
| July 2025 | 1,858 | 3,408 | $133,197 | $122,123 |
| August 2025 | 1,865 | 3,429 | $134,089 | $128,130 |
| September 2025 | 1,887 | 3,454 | $135,094 | $100,553 |
| October 2025 | 1,895 | 3,471 | $135,560 | $114,721 |
| November 2025 | 1,912 | 3,483 | $136,589 | $115,255 |
| December 2025 | 1,933 | 3,513 | $138,198 | $129,057 |
| January 2026 | 1,961 | 3,591 | $141,853 | $139,051 |
| Aggregate Premium Billed | $2,853,825 |
| Aggregate Incurred Claims | $2,617,726 |
| Cost Ratio | 92% |
| Premium amounts and lives counts displayed on this report are unaudited |
| DMO information is not included in this report |
image1.png
File details come from the government source that posted it. Updated .