Exhibit_C1-Brevard_BOCC_2024_DPPO_DHMO_Cigna.xls

The file is an Excel spreadsheet titled "Exhibit_C1-Brevard_BOCC_2024_DPPO_DHMO_Cigna.xls" detailing enrollment and experience reports for Brevard County, Florida's Dental Health Maintenance Organization (DHMO) and Dental Preferred Provider Organization (DPPO) health plans for the calendar year 2024. The document provides monthly enrollment data across four coverage tiers (employee only, employee + spouse, employee + child(ren), and employee + family) and includes detailed healthcare experience metrics such as billed premiums, total subscribers, total members, and claims information. The enrollment data shows slight fluctuations throughout the year, with total DHMO enrollment ranging from 695 to 718 members and DPPO enrollment between 3,440 and 3,467 members.

The financial metrics reveal important insights into the health plans' performance, with the DPPO experiencing monthly loss ratios between 58.4% and 95.0%, averaging 80.0% for the year. The billed monthly premiums for the DHMO remain relatively consistent, ranging from $13,529 to $13,883, while DPPO premiums hover around $177,925 to $180,314 per month. The claims data demonstrates a mix of in-network and out-of-network utilization, with total monthly DPPO claims varying from $103,859 to $171,374. This detailed documentation supports the upcoming Brevard County Group Dental Plan procurement for a five-year contract beginning January 1, 2026, which will cover active employees, retirees, and eligible dependents.