Exhibit_H_-_Claims_Experience_(2_TABS_to_VIEW)_FINAL.xlsx

This document is an Exhibit H Claims Experience spreadsheet for the County of Volusia, detailing medical and pharmacy claims data from January 2021 through February 2025. The document supports a Request for Proposals (RFP) for a Self-Funded Group Health Plan Administrative Services contract, with the County seeking a provider to administer health benefits for employees, retirees, and COBRA participants. The contract will have an initial five-year term starting January 1, 2027, with a potential subsequent five-year renewal contingent on mutual agreement and county council approval.

The claims data reveals a consistent membership base of approximately 3,150-3,200 members covering around 6,200-6,350 lives, with monthly medical claims ranging from approximately $2.4 million to $5.4 million and pharmacy claims between $760,000 and $1.6 million. Total annual claims expenditure appears to fluctuate between $152 million and $153 million across the documented period. The comprehensive claims experience spreadsheet provides granular monthly data on facility, professional, medical, and pharmacy claims, which would be critical for potential administrative services providers in understanding the historical utilization and cost patterns of the Volusia County government's health plan.