Schedule S Enrollment Data.xlsx

This is an enrollment data spreadsheet titled "Schedule S" from the State of Michigan's RFP No. 200000001290, containing monthly healthcare enrollment and claims data for 2018 and 2019. The data tracks subscriber counts, spouse counts, dependent counts, total member counts, and total paid claims on a monthly basis across a 24-month period.

The data shows relatively stable enrollment numbers, with total membership ranging from approximately 257,000 to 263,000 members throughout the period. Monthly paid claims varied significantly, ranging from approximately $5.7 million to $8.4 million per month. The highest membership was recorded in September 2019 with 262,673 total members, while the highest monthly paid claims occurred in May 2018 at $8,416,959.37. There is a consistent pattern of membership increases in July of both years, suggesting possible seasonal enrollment trends.