Appendix_7.4%20RFP_31786-00186%20Enrollment%20and%20Premium%20History.xlsx

This document is an enrollment and premium history spreadsheet for Metropolitan Life Insurance Company's long-term disability (LTD) and short-term disability (STD) insurance plans provided to a state organization, covering the period from January 2021 through May 2025. The file tracks pass-through payments across four plan options (Plans 1-4 for LTD and Higher Education Plans A and B, plus State Plans A and B for STD), segmented by employee age brackets ranging from 0-29 years through 70+ years. The data captures monthly enrollment counts and corresponding premium charges for each demographic and plan combination, providing a comprehensive record of benefit administration and cost tracking over a 53-month period.

The spreadsheet documents aggregate enrollment and premium totals that demonstrate consistent participation across all plan offerings, with LTD enrollment generally ranging from 7,000 to 15,600 covered lives monthly and STD enrollment ranging from 7,000 to 8,600 covered lives monthly. Monthly premium payments for the combined LTD and STD offerings typically range from approximately $240,000 to $620,000, reflecting both enrollment fluctuations and potential rate adjustments over the contract period. The data reveals Metropolitan Life Insurance Company as the incumbent vendor throughout the entire period, with Plan 3 Employee Paid and Employer Paid designations indicating a cost-sharing arrangement between the employer and employees. No specific contract award date, renewal options, or set-aside provisions are identified in this administrative document, which serves primarily as a historical record of benefit utilization and premium expense for budgeting and actuarial analysis purposes.