7-EXHIBIT C - Past Three-Year Claims and Enrollment History.xlsx

This is a past three-year claims and enrollment history document for Marion County Employees' group dental insurance, covering the period from October 2023 through September 2025. The document provides detailed monthly data for group 177L22, which encompasses approximately 2,543 to 2,765 contracts with a total member enrollment ranging from 5,628 to 5,992 individuals across the 24-month period. The data tracks claims paid, claims count, premium billed, and premium paid on a monthly basis, demonstrating the operational scale and utilization patterns of the existing dental benefit program serving Marion County's employee population.

Over the two-year period, Marion County Employees generated total claims of $2,376,716.91 across 17,428 claims with an average monthly billed loss ratio of 73 percent. Total premiums billed amounted to $3,270,698.98, with $3,269,429.92 paid, indicating consistent premium collection. Monthly loss ratios ranged from a low of 52 percent in November 2024 to a high of 88 percent in December 2024, reflecting seasonal variation in dental utilization. The enrollment data shows a gradual growth trajectory, with member counts increasing from 5,628 in October 2023 to 5,968 in September 2025, suggesting expanding benefit participation or organizational growth within Marion County. This historical claims and enrollment information serves as a critical baseline for evaluating proposals in the current group dental insurance services procurement (26P-040) for Florida.