Exhibit 74 - Cal Yr 2023 City of Miami ASO Fixed Charges and Fees Per Product Type Monthly Healthcare Detail Experience.xlsx

This document is a monthly healthcare detail experience report for the City of Miami's self-funded Administrative Services Only (ASO) healthcare plan for calendar year 2023. The report provides a comprehensive breakdown of healthcare claims, fixed charges, and membership details across multiple product types, including active employees, retirees, Medicare-eligible participants, executives, and COBRA participants. The data is organized by month from January through December 2023, tracking in-network and out-of-network claims, drug costs, stop-loss amounts, and total net claims for various employee and retiree categories.

The report reveals a retrospectively experience-rated funding model with total gross claims ranging from approximately $3 million to $4.4 million monthly, with some months showing stop-loss credits that offset total net claims. The City of Miami's healthcare plan covers diverse employee groups, with the largest populations in the "Active Employees (General)" and "Active Employees (M/C)" categories. Throughout the year, the total membership remained relatively stable, fluctuating between 11,250 and 11,450 total members. The plan includes various fixed charges and administrative service fees, with monthly ASO fees typically around $80,000, and the total annual gross claims for 2023 summing to approximately $45.1 million, with net claims of $41.45 million after stop-loss adjustments.