17-Manor ISD - Medical Census 02012026.xlsx

This is a medical census file for Manor Independent School District (Manor ISD) in Texas, containing employee enrollment data for the 2025-2026 plan year. The document lists 1,256 full-time and substitute employees with their demographic information, including employee ID, sex, date of birth, zip code, employment classification, enrollment status, medical plan selection, and coverage tier. The census data identifies employee participation across three primary plan offerings: Blue Choice HDHP (with $3,400 deductible), Blue Choice PPO (with $1,400 deductible), and Blue Essentials HMO (with $3,000 deductible). Coverage tiers vary, with employees enrolling in employee-only coverage, employee plus child(ren), employee plus spouse, employee plus family, or waived coverage options. This census serves as the actuarial and operational basis for Manor ISD's 2026 Medical RFP, in which the district is soliciting proposals for self-funded and fully insured medical and prescription drug plans, as well as stop loss products.

The census data reflects a workforce with geographic concentration in the 78653 zip code area (Manor, Texas) and surrounding Central Texas communities. Approximately 87% of the workforce has active medical coverage through the 2025-2026 plans, while approximately 13% have waived coverage. The distribution between plan types shows significant enrollment in Blue Essentials HMO and Blue Choice HDHP options, with smaller representation in the PPO option. Family coverage selections account for a meaningful portion of the enrollment, indicating that benefit design and dependent coverage provisions are material considerations for the district's vendor selection process. This census data will be critical for vendors responding to Manor ISD's medical RFP to develop accurate rate proposals, determine stop loss attachment points, and model claims experience and utilization patterns for their bids.