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

File Type Posted
ESBD_521004_1780595757286_RFP 2605-004Amendment 1 - Updated Exhibits A-10 & A-11.pdf PDF
ESBD_521004_1780596005194_UPDATED Exhibit A-11 Vision Provider Report.xlsx XLSX spreadsheet
ESBD_521004_1780955159340_RFP 2605-004 Addendum 1 - Q&A Document.pdf PDF
ESBD_521004_1780955124892_Updated Exhibit A-4 -RX Claim, Medical Memborship, Monthly Claims History De-ID 1.1.23 thru present.xlsx XLSX spreadsheet
ESBD_521004_1780955049911_RFP 2605-004 Amendment 2 - Updated Exhibits A--4.pdf PDF
ESBD_521004_1780595977238_UPDATED Exhibit A-10 DPPO Provider Report.xls XLS spreadsheet
ESBD_521004_1780003738276_Exhibit A-1. 2026_Seton ACO_SBC.pdf PDF
ESBD_521004_1780004996397_Exhibit A-17 YOY Rates.xlsx XLSX spreadsheet
ESBD_521004_1780004177857_Exhibit A-7. Prescription Drug NDC 11.xlsx XLSX spreadsheet
ESBD_521004_1780004433000_Exhibit A-12 Census.xlsx XLSX spreadsheet
ESBD_521004_1780003632493_RFP 2605-004 HR Benefits - Medical, Dental & Vision.pdf PDF
ESBD_521004_1780004399033_Exhibit A-11 Vision Provider Report.xlsx XLSX spreadsheet
ESBD_521004_1780004464564_Exhibit A-13 Medical ASO, Dental, Vision Questionnaire 3.31.26kle.xlsx XLSX spreadsheet
ESBD_521004_1780003821808_Exhibit A-2 (PREMIUM PPO PLAN ) Summary .pdf PDF
ESBD_521004_1780004939189_Exhibit A-15 Data Requirements.pdf PDF
ESBD_521004_1780005665914_Exhibit A-7 Large Claim Jan 26.xls XLS spreadsheet
ESBD_521004_1780005824658_Exhibit A-9 Provider Report Most Recent 12month w-o lag 3_31_26 (1).xls XLS spreadsheet
ESBD_521004_1780003853623_Exhibit A-2. -Comprehensive Dental Basic Plan - Multi Plans.PDF PDF
ESBD_521004_1780004199247_Exhibit A-8 - Top 50 Drugs Report.xlsx XLSX spreadsheet
ESBD_521004_1780003765862_Exhibit A-1. 2026_TMN_SBC.pdf PDF
ESBD_521004_1780004979249_Exhibit A-16 Plan Summaries.pdf PDF
ESBD_521004_1780004498571_Exhibit B-1 - Medical ASO Pricing Sheet.pdf PDF
ESBD_521004_1780004547468_Exhibit B-3 - Fully-insured Vision Pricing Sheet.pdf PDF
ESBD_521004_1780004312250_Exhibit A-10 DPPO Provider Report - most recent.xls XLS spreadsheet
ESBD_521004_1780004282954_Exhibit A-3. 2026 Vision Member Summary.pdf PDF
ESBD_521004_1780004140477_Exhibit A-7 Large Claims 3.1.25-12.31.25.xls XLS spreadsheet
ESBD_521004_1780005447955_Exhibit A-10 DPPO Provider Report.xls XLS spreadsheet
ESBD_521004_1780003789859_Exhibit A-2 ( BASIC PPO PLAN) Summary .pdf PDF
ESBD_521004_1780003703946_Exhibit A-1. 2026_HDHP_SBC.pdf PDF
ESBD_521004_1780004525370_Exhibit B-2 - Fully-insured Dental Pricing Sheet.pdf PDF
ESBD_521004_1780007087656_Exhibit A-11 Vision Provider Report - most recent.xlsx XLSX spreadsheet
ESBD_521004_1780004889095_Exhibit A-14 PBM Questionnaire.xlsx XLSX spreadsheet
ESBD_521004_1780005131284_Exhibit A-4 -RX Claim History De-ID 1.1.23 thru present.xlsx XLSX spreadsheet
ESBD_521004_1780004074805_Exhibit A-6. Vision PvC through 11-25.xlsx XLSX spreadsheet
ESBD_521004_1780004246154_Exhibit A-9 Provider Report 12month w-o lag 3_31_26 - most recent.xls XLS spreadsheet
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:

MonthSubscribersMembersMonthly BilledMonthly Dental
PremiumClaims
February 20241,5702,882$97,568$106,934
March 20241,6223,044$102,462$90,920
April 20241,6373,049$103,054$96,371
May 20241,6563,074$104,031$97,729
June 20241,6573,079$103,933$96,343
July 20241,6753,106$105,049$114,305
August 20241,7043,148$106,572$113,039
September 20241,7143,150$106,908$87,690
October 20241,7183,145$107,061$106,592
November 20241,7273,155$107,398$81,866
December 20241,7403,161$107,886$78,566
January 20251,7713,218$109,773$101,716
February 20251,7603,193$109,012$104,610
March 20251,8383,389$132,163$112,156
April 20251,8403,398$132,725$136,815
May 20251,8303,381$131,971$119,272
June 20251,8273,376$131,677$123,913
July 20251,8583,408$133,197$122,123
August 20251,8653,429$134,089$128,130
September 20251,8873,454$135,094$100,553
October 20251,8953,471$135,560$114,721
November 20251,9123,483$136,589$115,255
December 20251,9333,513$138,198$129,057
January 20261,9613,591$141,853$139,051
Aggregate Premium Billed$2,853,825
Aggregate Incurred Claims$2,617,726
Cost Ratio92%
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 .