Employee_Census_2025.xlsx

The document is an Employee Census spreadsheet for the 2025 benefits year, specifically focused on a Pharmacy Benefits Request for Proposal (RFP) for the City of Texas. The RFP seeks Pharmacy Benefit Management services with a strict requirement for 100% Pass-Through Modeling, explicitly rejecting Traditional Modeling. The spreadsheet contains detailed employee demographic and health insurance enrollment information for Blue Cross Blue Shield, covering 445 employees across various health plan options including Low Health Plan (HMO), High Health Plan (PPO), and Retiree Pre-65 Health Plans. Effective dates for coverage range from October 1, 2024, to various dates in 2025, with most enrollments starting on October 1, 2024.

The census data reveals a diverse workforce with employees born between 1949 and 2005, representing multiple coverage levels including Employee, Employee + Spouse, Employee + Child(ren), and Employee + Family plans. The health plans are segmented into Low Health Plan (HMO) and High Health Plan (PPO) categories, with specific provisions for retirees under 65. Zip codes predominantly cluster in the 78500-78600 range, suggesting a concentrated geographical area. The data provides a comprehensive snapshot of the city's healthcare enrollment, which will be critical for potential pharmacy benefit management vendors to understand the population's healthcare needs and potential cost structures for the 2025-2026 contract period.