Attachment_F_-_Census.xlsx

This is a census data file for Orange County, Florida's Medicare Supplemental Plans and Medicare Part D Employer Group Waiver Plans procurement (Y26-151). The file contains detailed enrollment information for retirees as of January 1, 2026, documenting individual beneficiary demographics and plan selections. The dataset includes 400+ retirees with their ages, gender, selected plans (primarily Cigna-HealthSpring Rx PDP and Medicare Surround Cigna supplemental plans at various tier levels), and residential zip codes across Florida and other states. Sealed responses for this procurement were due by 4:00 pm EST on Thursday, May 7, 2026, with submission required exclusively through the OpenGov e-Procurement Platform. No hand-delivered, mailed, faxed, or emailed submissions were permitted.

The census data reveals a retiree population predominantly aged 64 to 92 years, with fairly balanced gender distribution. Enrollees are distributed across multiple zip codes with concentrations in the 32700-32900 range (Orange County area). Plan selections show a mix of prescription drug plans (PDP) at low and high tier levels alongside Medicare Surround supplemental coverage, primarily Plans F, G, and N on an individually rated basis. The data includes several entries with incomplete or irregular zip code formatting, suggesting potential data quality issues. This census information serves as the actuarial basis for Orange County's evaluation of proposed Medicare Supplemental and Part D EGWP rates and benefits from potential plan vendors responding to the procurement.