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 document tracks monthly enrollment counts for plan members from January 2007 through September 2025, providing historical data essential for projecting administrative workload and operational requirements for the Third-Party Administrator (TPA) contract. The data demonstrates consistent enrollment growth over the 18-year period, beginning with 23,642 members in January 2007 and reaching 47,856 members by September 2025, representing a steady annual increase of approximately 1,500 to 2,000 members. This enrollment trajectory is critical for understanding the scale and scope of administrative services required, including claims processing, member communications, and call center operations that the selected TPA must manage beginning January 1, 2027.

The enrollment figures serve as the foundation for calculating monthly per-member-per-month (PMPM) rates that will determine contract compensation under the RFP #31786-00187. The consistent growth pattern and current enrollment levels of approximately 48,000 members indicate a substantial administrative burden and corresponding contract value, with annual claims volumes in the tens of millions of dollars based on the referenced claims history data showing approximately 4% annual cost increases. The enrollment data enables bidders to accurately estimate staffing requirements, technology infrastructure, and operational costs necessary to deliver comprehensive TPA services throughout the five-year contract term from January 1, 2027, through December 31, 2031, with a claims run-out period extending through December 31, 2033.