RFP_5800_SLW3030_ATT_8_v1.xlsx

This spreadsheet contains historical dental PPO claims data for the City of Austin retirees, covering the five-year period from 2021 through 2025. The file presents monthly paid claims, procedure counts, subscriber counts, and member counts organized by calendar year. The data illustrates utilization patterns and financial performance across the retiree population, with claims ranging from approximately $141,000 to $320,000 monthly and procedure counts varying between 1,600 and 4,200 procedures per month depending on the year. Member populations have shown growth over the period, expanding from approximately 6,945 to 9,108 members by December 2025, while subscriber counts have increased from 4,235 to 5,530 over the same timeframe.

The claims data demonstrates relatively consistent utilization rates with seasonal variations and a general upward trend in both paid claims and member enrollment throughout the five-year period. The most recent data from 2025 reflects higher average monthly claims compared to 2021, suggesting either increased utilization, higher procedure costs, or both. This historical data set appears designed to support forecasting, rate development, or performance analysis for dental benefit administration and may serve as baseline information for procurement of dental PPO services or related administrative support for the City of Austin's retiree population.