Exhibit 09c - Cal Yr 2025 YTD as of Jul City of Miami CIGNA VISION Monthly Healthcare Experience INN OON Total Claims Subs Mbrs.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- RFP No. 2130386 - Employee Health Benefits Plan
- Solicitation number
- RFP No. 2130386 - Employee Health Benefits Plan
- Issued by
- Florida
About this file
This document is a monthly healthcare experience report for the City of Miami's vision insurance coverage through CIGNA Vision, covering the period from January through July 2025. The report details vision healthcare claims across two funding types: a self-funded (ASO) vision plan for network participants and a traditional enhanced buyup vision plan, with both in-network and out-of-network claims data.
The report shows consistent monthly enrollment of approximately 2,240-2,260 subscribers and 4,400-4,420 total members. Total claims across both plans for the seven-month period were $247,045, with $241,572 from in-network claims and $5,473 from out-of-network claims. The self-funded plan (VIS-CIGNA VISION FOR NETWORK PARTICIPANTS) consistently had lower monthly claims compared to the traditional enhanced buyup plan, which showed more variability in monthly claims ranging from $16,819 to $35,060. The document appears to be part of a larger procurement process for an Employee Health Benefits Plan (RFP No. 2130386) in Florida, providing detailed financial and enrollment metrics for the vision insurance component.
View the file
Other files
Show 40 more
Latest 50 of 115 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 2025 thru July 2025 | |||||||
| EXHIBIT 09c | |||||||
| 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-25 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $29,479 | $0 | $29,479 | 1,385 | 2,643 |
| FUNDING TYPE Total | $29,479 | $0 | $29,479 | 1,385 | 2,643 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $23,680 | $1,651 | $25,332 | 877 | 1,776 | |
| FUNDING TYPE Total | $23,680 | $1,651 | $25,332 | 877 | 1,776 | ||
| Jan-2025 Total | $53,159 | $1,651 | $54,811 | 2,262 | 4,419 | ||
| Feb-25 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $27,080 | $0 | $27,080 | 1,383 | 2,635 |
| FUNDING TYPE Total | $27,080 | $0 | $27,080 | 1,383 | 2,635 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $33,627 | $1,433 | $35,060 | 873 | 1,770 | |
| FUNDING TYPE Total | $33,627 | $1,433 | $35,060 | 873 | 1,770 | ||
| Feb-2025 Total | $60,707 | $1,433 | $62,140 | 2,256 | 4,405 | ||
| Mar-25 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $14,787 | $0 | $14,787 | 1,383 | 2,637 |
| FUNDING TYPE Total | $14,787 | $0 | $14,787 | 1,383 | 2,637 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $22,270 | $1,068 | $23,338 | 875 | 1,779 | |
| FUNDING TYPE Total | $22,270 | $1,068 | $23,338 | 875 | 1,779 | ||
| Mar-2025 Total | $37,058 | $1,068 | $38,126 | 2,258 | 4,416 | ||
| Apr-25 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $4,211 | $0 | $4,211 | 1,381 | 2,635 |
| FUNDING TYPE Total | $4,211 | $0 | $4,211 | 1,381 | 2,635 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $26,417 | $298 | $26,715 | 869 | 1,765 | |
| FUNDING TYPE Total | $26,417 | $298 | $26,715 | 869 | 1,765 | ||
| Apr-2025 Total | $30,628 | $298 | $30,926 | 2,250 | 4,400 | ||
| May-25 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $2,095 | $0 | $2,095 | 1,381 | 2,638 |
| FUNDING TYPE Total | $2,095 | $0 | $2,095 | 1,381 | 2,638 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $18,406 | $180 | $18,586 | 868 | 1,768 | |
| FUNDING TYPE Total | $18,406 | $180 | $18,586 | 868 | 1,768 | ||
| May-2025 Total | $20,501 | $180 | $20,681 | 2,249 | 4,406 | ||
| Jun-25 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $4,464 | $0 | $4,464 | 1,378 | 2,639 |
| FUNDING TYPE Total | $4,464 | $0 | $4,464 | 1,378 | 2,639 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $15,971 | $848 | $16,819 | 862 | 1,760 | |
| FUNDING TYPE Total | $15,971 | $848 | $16,819 | 862 | 1,760 | ||
| Jun-2025 Total | $20,435 | $848 | $21,283 | 2,240 | 4,399 | ||
| Jul-25 | SELF-FUNDED (ASO) | VIS-CIGNA VISION FOR NETWORK PARTICIPANTS (B | $3,768 | $0 | $3,768 | 1,374 | 2,634 |
| FUNDING TYPE Total | $3,768 | $0 | $3,768 | 1,374 | 2,634 | ||
| TRADITIONAL | VISE-CIGNA VISION PLAN ENHANCED BUYUP | $15,316 | ($5) | $15,311 | 872 | 1,773 | |
| FUNDING TYPE Total | $15,316 | ($5) | $15,311 | 872 | 1,773 | ||
| Jul-2025 Total | $19,085 | ($5) | $19,080 | 2,246 | 4,407 |
Grand Total $241,572 $5,473 $247,045 15,761 30,852
&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: 8/6/2025 image1.png
File details come from the government source that posted it. Updated .