8-Exhibit F Report of Medical and Rx Claims Jan-Jun 2025.xlsx

This document is a comprehensive medical claims and enrollment report for the Hillsborough County Board of County Commissioners (BOCC), covering healthcare experience from January through June 2025. The report details medical and prescription claims across two primary benefit options: a High Deductible Health Plan (HDHP) Modern Plan and an Open Access Plan (OAP) Traditional Plan, with enrollment data for active employees, retirees, and COBRA participants. The report tracks monthly claims, fixed charges, in-network and out-of-network expenses, drug costs, and total per-member costs across various county departments including Property Appraisers, Expressway Authority, Sports Authority, Court, Children's Board, and Clerk's Office.

The financial summary reveals total claims of $119,092,633 for the reporting period, with a total membership of 68,965 subscribers and 144,689 total members. The HDHP Modern Plan had total claims of $32,421,911, while the OAP Traditional Plan had significantly higher claims at $86,773,902. The report breaks down costs by employee tiers (employee only, employee + spouse, employee + children, employee + family) and includes detailed analysis of claims exceeding $100,000, highlighting specific medical conditions and treatments. The document also provides insights into stop-loss claims, showing multiple high-cost medical events across various age groups and medical conditions, which could be relevant for future insurance coverage and risk management strategies.