Exhibit_F_-_Medicare_Census.xlsx

This is a Medicare Census exhibit for Volusia County, Florida, documenting the current enrollment and premium information for the County's Medicare Supplement and Part D Pharmacy Insurance programs. The file contains detailed enrollment records for approximately 500 Medicare-eligible participants, including retirees and their spouses, with dates of birth, ages, zip codes, carrier information, plan names, and monthly premium amounts. All current participants are enrolled in UnitedHealthCare plans, specifically the 2024-2025 and 2025 UHC AARP Medicare Supplement and UHC AARP Part D Prescription Drug Plans. Monthly premiums for Medicare Supplement coverage range from approximately $119.88 to $389.95, while Part D pharmacy plan premiums are standardized at $340.98 monthly across all participants. The census data reflects enrollment as of March 13, 2026, and serves as the baseline enrollment information for the County's Request for Proposal issued for Medicare Supplement and Part D Pharmacy Insurance services effective January 1, 2027.

The census data demonstrates UnitedHealthCare's current incumbency and provides critical actuarial and demographic information for prospective bidders to develop proposals and pricing. Participants are distributed across Volusia County zip codes, with concentrations in 32724, 32174, 32127, 32720, and 32168, indicating geographic diversity across the County. The file enables prospective contractors to analyze current enrollment patterns, premium structures, and participant demographics to develop competitive bids that must provide combined Medicare Supplement Plan N and Part D Pharmacy premiums lower than the County's current medical and pharmacy premium of $971 per month for single coverage. This enrollment information is essential for bidders to assess risk, project claims costs, and determine pricing strategies for the five-year contract term with optional renewal.