Exhibit_C1-Brevard_BOCC_2024_DPPO_DHMO_Cigna.xls

The file is an enrollment and experience report for dental health insurance plans for Brevard County Board of County Commissioners (BOCC) in Florida, covering January through December 2024. The document details two dental plan types: a Dental Health Maintenance Organization (DHMO) and a Dental Preferred Provider Organization (DPPO) plan, with monthly enrollment data tracking participant counts across different coverage tiers (employee only, employee + spouse, employee + child(ren), and employee + family). The total annual enrollment ranges between 8,540 to 8,718 participants for DHMO and 41,441 to 41,471 participants for DPPO, with consistent monthly variations.

The financial details reveal monthly billed premiums for DHMO ranging from $13,529 to $13,883, totaling $165,230 annually, while DPPO premiums range from $177,925 to $180,314, totaling $2,154,972 annually. The loss ratios for DPPO plans fluctuate monthly, with percentages ranging from 58.4% to 95.0%, and an annual average of 80.0%. The claims data shows a mix of in-network and out-of-network claims, with in-network claims consistently representing the majority. Total annual claims for DPPO are $1,723,811, comprising $1,514,574 in-network and $209,238 out-of-network claims. The data suggests stable enrollment and relatively consistent healthcare utilization throughout the year.