Exhibit 09d - Cal Yr 2024 City of Miami CIGNA Vision - Monthly Healthcare Experience INN OON Total Claims Subs Mbrs.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- RFP No. 2130386 - Employee Health Benefits Plan
- Solicitation number
- RFP No. 2130386
- Issued by
- Florida
About this file
This document is a monthly healthcare experience report for the City of Miami's CIGNA Vision insurance coverage for calendar year 2024, detailing vision healthcare claims across two funding types: Self-Funded (ASO) and Traditional. The report tracks monthly in-network and out-of-network vision claims, subscriber counts, and member participation from January through December 2024, providing a comprehensive view of healthcare utilization across different vision plan options.
The financial breakdown reveals total annual claims of $434,965, with $424,285 in in-network claims and $10,680 in out-of-network claims. The document shows consistent monthly enrollment between 2,200-2,240 subscribers and 4,330-4,380 total members. Two primary vision plan options are presented: a bundled network participant plan and an enhanced buy-up plan, with varying levels of in-network and out-of-network coverage. The self-funded arrangement allows for detailed tracking of healthcare expenses, enabling the City of Miami to monitor and potentially adjust their vision benefits strategy based on monthly claims experience.
View the file
Other files
Show 40 more
Latest 50 of 114 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Vision Experience-1
| CITY OF MIAMI | |||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | |||||||
| January 2024 thru December 2024 | |||||||
| EXHIBIT 09d | |||||||
| Rating Type : PROSPECTIVE GUARANTEED COST, RETROSPECTIVE EXPERIENCE RATED | |||||||
| Reported Claims: All Claims | |||||||
| Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services. | |||||||
| YTD/MONTH | FUNDING TYPE | BENEFIT OPTION | IN NETWORK | OUT OF NETWORK | TOTAL CLAIMS | TOTAL SUBS | TOTAL MBRS |
| Jan-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (3) | (3) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $7,337 | $0 | $7,337 | 1,439 | 2,769 | ||
| FUNDING TYPE Total | $7,337 | $0 | $7,337 | 1,436 | 2,766 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 0 | (1) | |
| VISE-VISION PLAN ENHANCED BUY-UP | $7,163 | $524 | $7,687 | 804 | 1,614 | ||
| FUNDING TYPE Total | $7,163 | $524 | $7,687 | 804 | 1,613 | ||
| Jan-2024 Total | $14,500 | $524 | $15,024 | 2,240 | 4,379 | ||
| Feb-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (4) | (4) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $14,814 | $0 | $14,814 | 1,437 | 2,766 | ||
| FUNDING TYPE Total | $14,814 | $0 | $14,814 | 1,433 | 2,762 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 0 | (1) | |
| VISE-VISION PLAN ENHANCED BUY-UP | $16,703 | $1,333 | $18,035 | 801 | 1,607 | ||
| FUNDING TYPE Total | $16,703 | $1,333 | $18,035 | 801 | 1,606 | ||
| Feb-2024 Total | $31,517 | $1,333 | $32,850 | 2,234 | 4,368 | ||
| Mar-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (7) | (8) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $19,473 | $0 | $19,473 | 1,434 | 2,762 | ||
| FUNDING TYPE Total | $19,473 | $0 | $19,473 | 1,427 | 2,754 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 0 | (1) | |
| VISE-VISION PLAN ENHANCED BUY-UP | $9,909 | $963 | $10,872 | 808 | 1,619 | ||
| FUNDING TYPE Total | $9,909 | $963 | $10,872 | 808 | 1,618 | ||
| Mar-2024 Total | $29,381 | $963 | $30,344 | 2,235 | 4,372 | ||
| Apr-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (8) | (9) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $13,077 | $0 | $13,077 | 1,439 | 2,770 | ||
| FUNDING TYPE Total | $13,077 | $0 | $13,077 | 1,431 | 2,761 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 0 | (1) | |
| VISE-VISION PLAN ENHANCED BUY-UP | $11,059 | $576 | $11,635 | 802 | 1,619 | ||
| FUNDING TYPE Total | $11,059 | $576 | $11,635 | 802 | 1,618 | ||
| Apr-2024 Total | $24,136 | $576 | $24,712 | 2,233 | 4,379 | ||
| May-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (8) | (9) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $26,197 | $0 | $26,197 | 1,438 | 2,765 | ||
| FUNDING TYPE Total | $26,197 | $0 | $26,197 | 1,430 | 2,756 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 0 | (1) | |
| VISE-VISION PLAN ENHANCED BUY-UP | $11,899 | $253 | $12,152 | 805 | 1,616 | ||
| FUNDING TYPE Total | $11,899 | $253 | $12,152 | 805 | 1,615 | ||
| May-2024 Total | $38,096 | $253 | $38,349 | 2,235 | 4,371 | ||
| Jun-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (8) | (10) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $21,484 | $0 | $21,484 | 1,429 | 2,750 | ||
| FUNDING TYPE Total | $21,484 | $0 | $21,484 | 1,421 | 2,740 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 0 | (1) | |
| VISE-VISION PLAN ENHANCED BUY-UP | $8,627 | $1,623 | $10,250 | 800 | 1,612 | ||
| FUNDING TYPE Total | $8,627 | $1,623 | $10,250 | 800 | 1,611 | ||
| Jun-2024 Total | $30,111 | $1,623 | $31,734 | 2,221 | 4,351 | ||
| Jul-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (8) | (10) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $21,263 | $0 | $21,263 | 1,425 | 2,738 | ||
| FUNDING TYPE Total | $21,263 | $0 | $21,263 | 1,417 | 2,728 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 0 | (1) | |
| VISE-VISION PLAN ENHANCED BUY-UP | $8,832 | $2,118 | $10,949 | 797 | 1,609 | ||
| FUNDING TYPE Total | $8,832 | $2,118 | $10,949 | 797 | 1,608 | ||
| Jul-2024 Total | $30,095 | $2,118 | $32,213 | 2,214 | 4,336 | ||
| Aug-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (11) | (13) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $21,937 | $0 | $21,937 | 1,424 | 2,734 | ||
| FUNDING TYPE Total | $21,937 | $0 | $21,937 | 1,413 | 2,721 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 0 | (1) | |
| VISE-VISION PLAN ENHANCED BUY-UP | $7,861 | $552 | $8,413 | 802 | 1,618 | ||
| FUNDING TYPE Total | $7,861 | $552 | $8,413 | 802 | 1,617 | ||
| Aug-2024 Total | $29,797 | $552 | $30,349 | 2,215 | 4,338 | ||
| Sep-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (11) | (13) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $38,645 | $0 | $38,645 | 1,417 | 2,722 | ||
| FUNDING TYPE Total | $38,645 | $0 | $38,645 | 1,406 | 2,709 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 0 | (1) | |
| VISE-VISION PLAN ENHANCED BUY-UP | $13,077 | $405 | $13,482 | 805 | 1,623 | ||
| FUNDING TYPE Total | $13,077 | $405 | $13,482 | 805 | 1,622 | ||
| Sep-2024 Total | $51,721 | $405 | $52,126 | 2,211 | 4,331 | ||
| Oct-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $0 | $0 | $0 | (12) | (14) |
| VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | $30,279 | $0 | $30,279 | 1,420 | 2,731 | ||
| FUNDING TYPE Total | $30,279 | $0 | $30,279 | 1,408 | 2,717 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $0 | $0 | $0 | 1 | 1 | |
| VISE-VISION PLAN ENHANCED BUY-UP | $11,253 | $1,196 | $12,449 | 806 | 1,623 | ||
| FUNDING TYPE Total | $11,253 | $1,196 | $12,449 | 807 | 1,624 | ||
| Oct-2024 Total | $41,531 | $1,196 | $42,727 | 2,215 | 4,341 | ||
| Nov-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $41,156 | $0 | $41,156 | 1,407 | 2,714 |
| FUNDING TYPE Total | $41,156 | $0 | $41,156 | 1,407 | 2,714 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $10,705 | $280 | $10,985 | 812 | 1,634 | |
| FUNDING TYPE Total | $10,705 | $280 | $10,985 | 812 | 1,634 | ||
| Nov-2024 Total | $51,861 | $280 | $52,141 | 2,219 | 4,348 | ||
| Dec-24 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $41,496 | $0 | $41,496 | 1,406 | 2,709 |
| FUNDING TYPE Total | $41,496 | $0 | $41,496 | 1,406 | 2,709 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $10,042 | $857 | $10,899 | 815 | 1,641 | |
| FUNDING TYPE Total | $10,042 | $857 | $10,899 | 815 | 1,641 | ||
| Dec-2024 Total | $51,538 | $857 | $52,395 | 2,221 | 4,350 |
Grand Total $424,285 $10,680 $434,965 26,693 52,264
&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law. ADVICE Reporting System &8Page &P of &N Date: 1/7/2025 image1.png
File details come from the government source that posted it. Updated .