Appendix_7.2_Enrollment_History.xlsx

This is an enrollment history spreadsheet for The Tennessee Plan, a self-insured supplemental medical insurance program administered by the State of Tennessee's Department of Finance and Administration, Division of Benefits Administration. The spreadsheet documents monthly enrollment counts spanning from January 2007 through September 2025, tracking member participation in the plan designed for Medicare-eligible state retirees who began employment prior to July 1, 2015. The data reveals consistent enrollment growth over the 18-year period, with membership increasing from 23,642 members in January 2007 to 47,856 members in September 2025, representing an annual average growth rate of approximately 1,500 to 2,000 members per year.

The enrollment data serves as a critical baseline for evaluating third-party administrator proposals under RFP #31786-00187, as the scale and growth trajectory of the membership directly impact administrative workload, claims volume projections, and per-member-per-month (PMPM) pricing calculations. The steady and predictable membership growth pattern indicates a stable, mature population of retirees, with historical data demonstrating that the plan has maintained consistent month-to-month enrollment levels with slight seasonal variations. This enrollment information is essential for qualified bidders to accurately forecast operational costs, staffing requirements, and service delivery capacity for the contract period running from January 1, 2027, through December 31, 2031, with claims run-out extending through December 31, 2033.