RFP_5800_SLW3030_ATT_7_v1.xlsx

This is a dental claims data file for the City of Austin showing historical utilization and cost information for active employees enrolled in a Dental PPO plan. The data spans five years from 2021 through 2025 and tracks monthly metrics including paid claims amounts, procedure counts, subscriber numbers, and member enrollment. The file provides baseline information that appears to support an RFP for dental benefits administration or claims management services. The data demonstrates consistent month-to-month variations in claims volume and costs, with paid claims generally ranging from approximately $700,000 to $1.2 million monthly across the five-year period. Member enrollment remains relatively stable, fluctuating between approximately 28,000 to 29,800 members annually, while subscriber counts range from roughly 12,900 to 14,700 individuals per month.

The data indicates growing utilization trends from 2021 through 2025, with annual paid claims generally increasing over the period and procedure counts showing corresponding growth. This historical claims information establishes the scope and cost baseline for the dental benefits program that vendors would be expected to service under the forthcoming contract. The file contains no explicit pricing terms, contract duration, or award information, as it functions primarily as a reference document for prospective bidders to understand the current claims environment and plan member demographics relevant to the solicitation.