Exhibit 01a - Cal Yr 2025 YTD as of June City of Miami Monthly Healthcare Detail Experience - Stop Loss ALL claims.xlsx

The document is a monthly healthcare detail experience report for the City of Miami's self-funded employee health benefits plan, covering January through June 2025. The report details healthcare claims, premiums, and membership across various benefit options and employee categories, including executives, active employees, retirees, and Medicare-eligible participants. The data is organized by different plan types such as OAP Plan, Network Open Access POS, and Cigna Vision, with breakdowns by employee groups like general employees, firefighters, and specific retirement classifications.

The report reveals a retrospective experience-rated funding model with administrative services only (ASO) fees. Total gross claims for the six-month period are $26,066,714, with net claims after stop-loss adjustments of $25,541,684. The city offers multiple benefit options covering approximately 33,866 subscribers and 67,734 total members. Monthly enrollment and claims vary across different employee categories, with active employees (general, municipal, and SEA) representing the largest membership groups. The report includes detailed financial information such as fixed charges, in-network and out-of-network claims, drug costs, and administrative fees, providing a comprehensive view of the city's healthcare spending and plan performance.