Exhibit 01b - Cal Yr 2024 City of Miami CIGNA Monthly Healthcare Detail Experience - Stop Loss ALL claims.xlsx

The document is a detailed monthly healthcare claims experience report for the City of Miami's health benefits plan for calendar year 2024, covering multiple product types and employee classifications. The report provides a comprehensive monthly breakdown of healthcare claims across various categories, including executives, active employees, retirees, and Medicare-eligible participants, with detailed financial information such as fixed charges, in-network and out-of-network claims, drug costs, and stop-loss calculations. The report tracks claims for different employee groups like general employees, management, SEA (likely a specific employee association), executives, and retirees, with monthly data from January through December 2024.

The healthcare plan is self-funded with a retrospective experience-rated funding type, meaning the city's actual claims experience will determine final costs. The report shows significant monthly variation in claims, with total gross claims ranging from approximately $3.2 million in January to over $5.3 million in December 2024. The grand total for the year shows $49,031,117 in total gross claims, with a net claims amount of $46,783,552 after stop-loss adjustments. The plan covers a total of 135,119 member months across various product types, including DPP4, OAP1, and VISP plans, with the majority of participants being active general employees, management, and SEA employees.