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

The file is a monthly healthcare detail experience report for the City of Miami's self-funded Administrative Services Only (ASO) health benefits plan for calendar year 2023. The report provides a comprehensive breakdown of healthcare expenses across multiple product types, including executives, active employees, retirees, Medicare-eligible participants, and COBRA participants. The document tracks monthly financial metrics such as fixed charges, in-network and out-of-network claims, drug expenses, total gross claims, stop-loss adjustments, net claims, ASO fees, and subscriber/member counts for various employee and retiree classifications.

The report reveals a retrospectively experience-rated funding model with total annual gross claims of approximately $45.1 million, with net claims after stop-loss adjustments of $41.45 million. The City of Miami's healthcare plan covers a diverse range of employee groups, with the largest populations being active general employees, active employees in various bargaining units (M/C, SEA), and Medicare-eligible retirees. Monthly membership fluctuates around 5,600-5,700 total subscribers and 11,300-11,400 total members. The data suggests significant variability in claims across different product types, with active employee general and specific bargaining units generating the most substantial claims volumes. The report appears to be part of a broader procurement process for employee health benefits, as indicated by the related RFP No. 2130386 for an Employee Health Benefits Plan in Florida.