Exhibit 09d - Cal Yr 2024 City of Miami CIGNA Vision - Monthly Healthcare Experience INN OON Total Claims Subs Mbrs.xlsx

This document is a monthly healthcare experience report for CIGNA Vision services for the City of Miami, covering the calendar year 2024 from January through December. The report details vision insurance claims and membership data across two primary funding types: Self-Funded (ASO) and Traditional plans, with two specific vision benefit options - "VIS-CIGNA Vision for Network Participants" and "VISE-Vision Plan Enhanced Buy-Up". The report tracks monthly in-network and out-of-network claims, total subscribers, and total members for each month of the year.

The financial summary reveals total claims of $434,965 for the entire year, with $424,285 in in-network claims and $10,680 in out-of-network claims. Membership remains relatively stable throughout the year, ranging between 2,200-2,240 total subscribers and 4,330-4,380 total members. The data suggests a self-funded healthcare arrangement with prospective guaranteed cost and retrospective experience-rated components. The report appears to be part of a broader employee health benefits plan procurement process, specifically related to RFP No. 2130386 for the State of Florida, providing detailed claims experience to support potential contract negotiations or renewals.