RFP_31786-00192_Appendix_7.8_Expanded_Plan_Vision_Utilization_by_Year_2023%20June%202026.xlsx

This file is an Expanded Plan Vision Utilization projection spreadsheet for the State of Tennessee's Voluntary, Fully-Insured Vision Insurance Plan, covering the period from 2023 through the second quarter of 2026. The document projects utilization metrics across three primary categories: client utilization (subscribers), members, and paid claims by month. Subscriber counts are projected to increase from 56,027 in January 2023 to 62,908 by Q2 2026, while member counts are expected to grow from 114,286 to 128,970 over the same period. Monthly paid claims are forecasted to range from approximately $550,000 to $1,088,000 throughout the projection period, with notable variation month-to-month. The spreadsheet additionally provides detailed service utilization counts across twenty-two vision care service categories, including exams, retinal imaging, contacts, frames, various lens options, and coating services.

The projections indicate steady growth in service utilization across nearly all categories from 2023 through 2025, with some moderation in Q2 2026 data due to the partial-year reporting period. Exams represent the highest volume service with 44,687 projected uses in 2023, increasing to 51,082 by 2025. Ancillary services such as frames, polycarbonate lenses, and anti-reflective coatings also demonstrate significant utilization patterns. The data suggests a maturing plan with consistent subscriber and member enrollment growth, supporting the financial projections reflected in the monthly paid claims figures.