Schedule S Enrollment Data.xlsx

This is an enrollment data file for the State of Michigan related to RFP No. 200000001290, containing monthly health plan membership and claims information for 2018 and 2019. The document presents a Schedule S enrollment summary tracking subscriber counts, spouse counts, dependent counts, total members, and total paid claims on a monthly basis across the two-year period. The data indicates relatively stable membership throughout both years, with subscriber counts ranging from approximately 165,000 to 168,000 members, spouse counts between 86,600 and 88,500, and dependent counts between 5,077 and 5,809. Total members across all three categories fluctuated between approximately 257,000 and 262,000 monthly participants.

Total paid claims data reveals significant monthly variation within both years, ranging from approximately $5.7 million to $8.4 million per month. In 2018, claims peaked in January at $8,092,767.67 and May at $8,416,959.37, while July represented the lowest month at $5,965,886.72. The 2019 data shows similar patterns, with May recording the highest claims at $8,271,999.99 and September the lowest at $5,987,503.69. The enrollment and claims data collectively demonstrate the scale and scope of the State of Michigan's health plan administration during this period, providing baseline metrics for historical cost and membership analysis that would be relevant to contract planning and budgeting purposes.