ESBD_521004_1780004074805_Exhibit A-6. Vision PvC through 11-25.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 a Vision Plan of Care Experience Exhibit submitted by Travis County Healthcare District - Central Health for a state and local contract opportunity. The document presents a 24-month rolling claims data set for vision insurance coverage, with information displayed through November 2025 and claims paid through December 2025. The exhibit tracks monthly subscriber and member enrollment, billed premiums, and vision insurance claims incurred across the coverage period from December 2023 through November 2025.

The aggregate premium billed over the 24-month period totaled $363,687, with corresponding aggregate incurred claims of $273,767, resulting in a 75% cost ratio. Monthly subscriber counts ranged from 1,274 in December 2023 to 1,654 in November 2025, while member counts increased from 2,328 to 2,904 over the same period. Monthly billed premiums grew from approximately $11,371 to $19,604, reflecting increases in both enrollment and premium rates. Monthly vision claims varied throughout the period, ranging from $6,563 to $16,558, with notable fluctuations that indicate variable utilization patterns among covered members. The data demonstrates the historical performance and cost experience of the vision plan serving the Travis County Healthcare District population.

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_1780004043386_Exhibit A-5 Dental PvC through 1-26.xlsx XLSX spreadsheet
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_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

BTV_24

TRAVIS COUNTY HEALTHCARE DISTRICT - CENTRAL HEALTH
Group/Control#: 00285663

Experience Exhibit

- Claims displayed are incurred and completed through November 2025.
- Claims displayed are based on a rolling 24 months of data.
- Claims paid through December 2025.

Monthly Claims:

MonthSubscribersMembersMonthly BilledMonthly Vision
PremiumClaims
December 20231,2742,328$11,371$8,137
January 20241,2962,354$11,527$6,563
February 20241,3482,419$11,921$9,684
March 20241,4232,607$12,718$13,616
April 20241,4362,608$12,772$13,432
May 20241,4492,616$12,834$9,421
June 20241,4492,609$12,793$10,302
July 20241,4692,640$12,981$11,469
August 20241,4922,670$13,159$11,883
September 20241,4982,670$13,203$10,655
October 20241,5012,664$13,192$16,256
November 20241,5102,675$13,242$10,254
December 20241,5172,674$13,297$8,030
January 20251,5492,727$13,566$8,219
February 20251,5352,700$13,439$9,690
March 20251,5832,798$18,769$16,558
April 20251,5832,798$18,768$12,182
May 20251,5732,779$18,683$12,782
June 20251,5692,782$18,663$12,258
July 20251,6012,831$19,008$13,405
August 20251,6142,861$19,205$14,564
September 20251,6362,890$19,452$9,185
October 20251,6432,899$19,521$12,534
November 20251,6542,904$19,604$12,687
Aggregate Premium Billed$363,687
Aggregate Incurred Claims$273,767
Cost Ratio75%

Premium amounts and lives counts displayed on this report are unaudited image1.png

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