Exhibit A-5 - Dental Plan and Claim Information.xlsx

XLSX spreadsheet 28 KB Posted

Attached to
Medical, Dental, Vision Insurance Services
Solicitation number
2604-002
Issued by
Travis County, Austin City, Texas

About this file

Exhibit A-5 is a dental plan and claim information spreadsheet used to document and track dental coverage details and associated claim data for a state or local government entity. The document serves as a reference tool for understanding the dental benefits structure, including plan designs, coverage parameters, and claim processing information relevant to the contracted dental services. While specific response dates, due dates, site visits, or bidders' meetings are not indicated within this exhibit, the spreadsheet appears designed to provide baseline information about dental plan offerings to support procurement or contract administration activities related to dental benefits.

The exhibit functions as a supporting document within a larger contract opportunity, likely containing pricing information, claim handling procedures, and plan specifications that would inform bidders' proposals and the entity's evaluation criteria. This reference material would typically be used by the contracting agency to establish expectations for dental plan administration, claims processing timelines, and benefit structures that potential vendors must understand to submit compliant proposals. The specific financial terms, funding sources, and plan design details contained within the spreadsheet would guide the scope of work for any dental benefits contract awarded to qualified providers.

View the file

Other files

File Type Posted
EXHIBIT I - Form 1295 Certificate of Interested Parties.pdf PDF
EXHIBIT C - Acknowledgement of Receipt Form.pdf PDF
Exhibit A-4 - Medical, Prescription Drug and Claim Information.xlsx XLSX spreadsheet
Exhibit A-1 -2026 Medical, Prescription Drug, Summary of Benefit Coverages.pdf PDF
Exhibit A-10 - DPPO Provider Report.xls XLS spreadsheet
Exhibit A-3 - 2026 Vision Member Summary.pdf PDF
Exhibit A-11 - Vision Provider Report.xlsx XLSX spreadsheet
Exhibit A-7 - Medical, prescription drug, Large Claim Report.xls XLS spreadsheet
Exhibit A-14 - PBM Questionnaire.xlsx XLSX spreadsheet
Exhibit B-1 - Medical ASO Pricing Sheet.pdf PDF
EXHIBIT G - Sample Contract.pdf PDF
Exhibit A-6 - Vision Plan and Claim Information.xlsx XLSX spreadsheet
Exhibit A-12 - Census.xlsx XLSX spreadsheet
Exhibit A-9 - Medical, prescription drug, Provider Utilization Report.xls XLS spreadsheet
EXHIBIT E - Conflict of Interest.pdf PDF
Exhibit A-8 - Top 50 Drugs Report.xlsx XLSX spreadsheet
Exhibit B-2 - Fully-insured Dental Pricing Sheet.pdf PDF
ESBD_510133_1776997796981_RFP 2604-002 Medical, Dental, Vision.pdf PDF
EXHIBIT D - Business Development Form.pdf PDF
Exhibit B-3 - Fully-insured Vision Pricing Sheet.pdf PDF
Exhibit A-2 - 2026 Dental Summary of Benefit Coverages.pdf PDF
EXHIBIT F - Certificate of Secretary.pdf PDF
EXHIBIT K - Insurance Coverage.pdf PDF
Exhibit A - Scope of Work.pdf PDF
Exhibit A-15 - Data Requirements.pdf PDF
Exhibit A-13 - Medical ASO, Dental, Vision Questionnaire.xlsx XLSX spreadsheet
Show all 26

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 .