Exhibit_C1-Brevard_BOCC_2024_DPPO_DHMO_Cigna.xls

The file is an Excel spreadsheet detailing dental health insurance enrollment and claims data for Brevard County Board of County Commissioners (BOCC) in Florida for the year 2024, covering two primary product types: Dental Health Maintenance Organization (DHMO) and Dental Preferred Provider Organization (DPPO) plans. The document provides comprehensive monthly enrollment statistics broken down by coverage tiers (Employee Only, Employee + Spouse, Employee + Child(ren), Employee + Family) and tracks total subscribers, total members, billed premiums, and claims data from January through December 2024.

The enrollment data reveals consistent participation across both DHMO and DPPO plans, with total monthly subscribers ranging between 8,538-8,540 for DHMO and 41,397-41,441 for DPPO. The DPPO plan shows more varied monthly claims, with total claims fluctuating between $103,859 and $171,374, and total loss ratios ranging from 58.4% to 95.0%. Billed monthly premiums remain relatively stable, with DHMO premiums around $13,600-$13,900 and DPPO premiums consistently near $177,000-$180,000. The data provides detailed insights into Brevard County's current dental insurance enrollment, utilization, and financial performance, which could be valuable for future procurement and benefits planning.