RFP_31786-00192_Appendix_7.10_Census_of_Enrolled_as_of_June_2026.xlsx

This is a Census of Enrolled Members document for RFP 31786-00192 related to a Voluntary, Fully-Insured Vision Insurance Plan in Tennessee as of June 2026. The document provides a comprehensive enrollment census organized by benefit plan coverage type, including Employee + Children, Employee + Spouse, Family, One Child Only, Single, Spouse + Child(ren) Only, Spouse Only, and Two or More Children Only categories. Each enrollment record is segmented by birth year, sex, and vision coverage level (Basic Vision or Expanded Vision), with the data spanning from individuals born in 1933 through 2026. The census captures the total enrolled population across all coverage tiers and demographic segments, enabling analysis of plan membership composition and benefit utilization patterns for the vision insurance program.

The enrollment data reflects a diverse membership base across multiple generations, with the largest concentrations of members in the Family and Single coverage categories. The census shows significant enrollment among working-age populations born between 1960 and 2005, with notably higher participation in Expanded Vision coverage compared to Basic Vision coverage across most age groups. The document serves as a baseline demographic and enrollment profile necessary for actuarial analysis, benefit design considerations, and premium development for the vision insurance offering. This snapshot of enrolled members as of June 2026 provides essential information for evaluating plan performance, forecasting claims costs, and determining the financial viability and sustainability of the voluntary vision insurance program.