Exhibit 15 State of Ohio Claims and Enrollment Data.xlsxExhibit 15 State of Ohio Claims and Enrollment Data.xlsx

This file is a summary of State of Ohio claims and enrollment data by medical plan option for the period January 2024 through June 2026, organized by geographic region and plan type. The data tracks enrollment and average medical net pay across three plan options—PPO, Select, and HDHP—for eight regions: Cincinnati, Cleveland/Akron, Columbus, Dayton/Springfield, Southern, Toledo, Youngstown, and Out of State. Columbus represents the largest enrollment base, with consistently over 17,000 employees monthly across plan types, while Out of State maintains the smallest enrollment with fewer than 350 employees. The dataset provides month-by-month breakdowns of employee counts and associated medical costs, enabling analysis of enrollment trends, regional variations, and plan utilization across the State's self-insured medical program, Ohio Med, which serves as the foundation for the Department of Administrative Services' Third-Party Administrator RFP.

This exhibit serves as a supporting document for the DAS Medical Plan Third-Party Administrator solicitation, providing historical claims and enrollment data necessary for potential offerors to develop competitive proposals. The data encompasses the period prior to the July 1, 2027 implementation date when the selected contractor must assume claims administration responsibilities. By presenting actual enrollment volumes and medical costs across regions and plan designs, this exhibit allows bidders to understand the scope and complexity of plan administration, analyze claims patterns, and project operational requirements. The data reflects existing plan structures—PPO, Select, and HDHP options—that the successful contractor must administer without modifications, and it demonstrates the geographic distribution of the covered population to inform regional evaluation criteria outlined in the RFP.