Appendix_7_5_Enrollment_by_Plan.xlsx

This is an enrollment data file documenting health plan membership across multiple government employee groups, including Local Education, Local Government, and State employees. The spreadsheet provides a comprehensive census of 299,066 total enrollees distributed across four primary plan types: Limited PPO, CDHP (Consumer-Driven Health Plan), Premier PPO, and Standard PPO. Enrollment is segmented by dependent versus employee status, gender, and age brackets ranging from less than one year to 65 and older. The Local Education group represents the largest segment with 126,115 members, followed by the State group with 146,281 members and the Local Government group with 26,670 members. Premier PPO is the most popular plan option overall, accounting for 161,511 total enrollees across all jurisdictions, while Limited PPO serves 24,218 members primarily within the Local Education and Local Government populations.

The data reflects the current benefit plan utilization across three distinct government employee populations and provides the baseline enrollment metrics necessary for benefit plan design, actuarial analysis, and cost projections. The gender distribution is relatively balanced across most age groups, with notable concentrations of family coverage (dependents) in the 1 to 18 age bracket and employee-only enrollment in the 40 to 64 age range, indicating a mature workforce with established family units. This enrollment composition is essential for understanding healthcare utilization patterns, setting renewal rates, and evaluating plan performance across the three government jurisdictions represented in the dataset.