Summary

This file is an enrollment projection spreadsheet for a voluntary, fully-insured vision insurance plan administered through EyeMed Vision for the state of Tennessee. The document provides detailed enrollment data organized by employee classification (State, Local Education, and Local Government), coverage type (Employee, Dependent, and Retiree), plan type (Vision Basic and Vision Expanded), and specific coverage codes (Single, Employee + Child(ren), Employee plus Spouse, Family, and spouse-only/children-only variants). The data spans from January 2023 through June 2026, with monthly snapshots showing enrollment counts for each coverage combination. The spreadsheet appears to serve as a baseline projection tool for forecasting utilization and claims costs across multiple employer groups within Tennessee's public sector employee benefits program.

The enrollment data demonstrates significant variation across the different employee groups and plan types, with State employees comprising the largest enrollment segment across most coverage categories, followed by Local Education and Local Government employees. Vision Expanded plans consistently show higher enrollment than Vision Basic plans, indicating member preference for more comprehensive vision coverage. Dependent and employee-only coverage options both maintain substantial enrollment levels, reflecting diverse family composition among the insured population. The data structure enables the plan administrator and EyeMed to track month-to-month enrollment trends, manage premium calculations, and project future benefit utilization for budget and actuarial purposes throughout the contract performance period.