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
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:
| Month | Subscribers | Members | Monthly Billed | Monthly Vision |
| Premium | Claims |
| December 2023 | 1,274 | 2,328 | $11,371 | $8,137 |
| January 2024 | 1,296 | 2,354 | $11,527 | $6,563 |
| February 2024 | 1,348 | 2,419 | $11,921 | $9,684 |
| March 2024 | 1,423 | 2,607 | $12,718 | $13,616 |
| April 2024 | 1,436 | 2,608 | $12,772 | $13,432 |
| May 2024 | 1,449 | 2,616 | $12,834 | $9,421 |
| June 2024 | 1,449 | 2,609 | $12,793 | $10,302 |
| July 2024 | 1,469 | 2,640 | $12,981 | $11,469 |
| August 2024 | 1,492 | 2,670 | $13,159 | $11,883 |
| September 2024 | 1,498 | 2,670 | $13,203 | $10,655 |
| October 2024 | 1,501 | 2,664 | $13,192 | $16,256 |
| November 2024 | 1,510 | 2,675 | $13,242 | $10,254 |
| December 2024 | 1,517 | 2,674 | $13,297 | $8,030 |
| January 2025 | 1,549 | 2,727 | $13,566 | $8,219 |
| February 2025 | 1,535 | 2,700 | $13,439 | $9,690 |
| March 2025 | 1,583 | 2,798 | $18,769 | $16,558 |
| April 2025 | 1,583 | 2,798 | $18,768 | $12,182 |
| May 2025 | 1,573 | 2,779 | $18,683 | $12,782 |
| June 2025 | 1,569 | 2,782 | $18,663 | $12,258 |
| July 2025 | 1,601 | 2,831 | $19,008 | $13,405 |
| August 2025 | 1,614 | 2,861 | $19,205 | $14,564 |
| September 2025 | 1,636 | 2,890 | $19,452 | $9,185 |
| October 2025 | 1,643 | 2,899 | $19,521 | $12,534 |
| November 2025 | 1,654 | 2,904 | $19,604 | $12,687 |
| Aggregate Premium Billed | $363,687 |
| Aggregate Incurred Claims | $273,767 |
| Cost Ratio | 75% |
Premium amounts and lives counts displayed on this report are unaudited image1.png
File details come from the government source that posted it. Updated .