Exhibit 67 - Cal Yr 2025 YTD City of Miami Cigna Retiree Fixed Charges and Claims Monthlty Healthcare Experience INN OON RX Total Claims Subs Mbrs.xlsx
XLSX spreadsheet 22 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 retiree health benefits, covering January through July 2025, prepared by Cigna for retiree healthcare claims and fixed charges. The report details monthly healthcare experience across three retiree categories: Medicare Eligibles Under 65, Non-Medicare Retirees, and Retirees Over 65, with retrospective experience-rated funding and administrative services only (ASO) fee structures.
The financial details reveal total gross claims of $2,510,189 for the seven-month period, with net claims of $2,448,256 after stop-loss adjustments. The non-Medicare retiree segment represents the largest portion of claims, accounting for $2,301,104 in gross claims. Monthly enrollment fluctuates between 385-397 total subscribers and 547-560 total members, with fixed charges, in-network claims, out-of-network claims, and prescription drug expenses tracked separately. The report is linked to a related Request for Proposals (RFP No. 2130386) for Employee Health Benefits Plan in Florida, suggesting this is part of an ongoing healthcare benefits procurement and reporting process.
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
Grouped Retiree Exp-1
| CITY OF MIAMI | |||||||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | |||||||||||
| January 2025 thru July 2025 | |||||||||||
| EXHIBIT 67 | |||||||||||
| All Funding Types | |||||||||||
| Branch : ALL MEDICARE ELIGIBLES UNDER 65, NON-MEDICARE RETIREE, RETIREES OVER 65 | |||||||||||
| Rating Type : RETROSPECTIVE EXPERIENCE RATED | |||||||||||
| Reported Premium: ASO Fees | |||||||||||
| Reported Claims: All Claims | |||||||||||
| Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services. | |||||||||||
| YTD/MONTH | BRANCH | FIXED CHARGES | IN NETWORK | OUT OF NETWORK | DRUG | TOTAL GROSS CLAIMS | STOP LOSS | TOTAL NET CLAIMS | TOTAL ASO FEES | TOTAL SUBS | TOTAL MBRS |
| Jan-25 | ALL MEDICARE ELIGIBLES UNDER 65 | $107 | $344 | $0 | $0 | $451 | $0 | $451 | $37 | 5 | 8 |
| NON-MEDICARE RETIREE | $10,235 | $171,205 | ($91) | $84,556 | $265,905 | ($40) | $265,865 | $0 | 324 | 437 | |
| RETIREES OVER 65 | $1,609 | $5,763 | $0 | $15,491 | $22,863 | $0 | $22,863 | $0 | 56 | 102 | |
| Jan-2025 Total | $11,952 | $177,312 | ($91) | $100,046 | $289,219 | ($40) | $289,179 | $37 | 385 | 547 | |
| Feb-25 | ALL MEDICARE ELIGIBLES UNDER 65 | $108 | $104 | $0 | $310 | $522 | $0 | $522 | $37 | 5 | 8 |
| NON-MEDICARE RETIREE | $10,402 | $152,190 | $303 | $108,756 | $271,652 | $0 | $271,652 | $0 | 327 | 443 | |
| RETIREES OVER 65 | $1,594 | $6,941 | $0 | $29,172 | $37,707 | $0 | $37,707 | $0 | 56 | 102 | |
| Feb-2025 Total | $12,104 | $159,235 | $303 | $138,238 | $309,881 | $0 | $309,881 | $37 | 388 | 553 | |
| Mar-25 | ALL MEDICARE ELIGIBLES UNDER 65 | $95 | $402 | $0 | $15 | $512 | $0 | $512 | $37 | 5 | 8 |
| NON-MEDICARE RETIREE | $10,425 | $201,707 | $4,450 | $97,169 | $313,751 | $0 | $313,751 | $0 | 330 | 446 | |
| RETIREES OVER 65 | $1,431 | $11,271 | $490 | $15,527 | $28,719 | $0 | $28,719 | $0 | 56 | 102 | |
| Mar-2025 Total | $11,950 | $213,380 | $4,940 | $112,712 | $342,982 | $0 | $342,982 | $37 | 391 | 556 | |
| Apr-25 | ALL MEDICARE ELIGIBLES UNDER 65 | $107 | $3 | $0 | $207 | $317 | $0 | $317 | $37 | 5 | 8 |
| NON-MEDICARE RETIREE | $10,352 | $300,009 | $524 | $71,986 | $382,871 | $0 | $382,871 | $0 | 328 | 444 | |
| RETIREES OVER 65 | $1,577 | $18,807 | ($118) | $17,789 | $38,055 | $0 | $38,055 | $0 | 56 | 102 | |
| Apr-2025 Total | $12,036 | $318,819 | $406 | $89,982 | $421,243 | $0 | $421,243 | $37 | 389 | 554 | |
| May-25 | ALL MEDICARE ELIGIBLES UNDER 65 | $108 | $2,479 | $0 | $194 | $2,780 | $0 | $2,780 | $37 | 5 | 8 |
| NON-MEDICARE RETIREE | $10,531 | $341,375 | ($919) | $127,202 | $478,189 | $0 | $478,189 | $0 | 333 | 446 | |
| RETIREES OVER 65 | $1,596 | $9,280 | $60 | $17,816 | $28,752 | $0 | $28,752 | $0 | 56 | 102 | |
| May-2025 Total | $12,234 | $353,134 | ($859) | $145,211 | $509,720 | $0 | $509,720 | $37 | 394 | 556 | |
| Jun-25 | ALL MEDICARE ELIGIBLES UNDER 65 | $108 | $1,143 | $0 | $169 | $1,420 | $0 | $1,420 | $0 | 5 | 8 |
| NON-MEDICARE RETIREE | $10,809 | $234,661 | $472 | $108,891 | $354,832 | ($60,073) | $294,759 | $0 | 336 | 449 | |
| RETIREES OVER 65 | $1,682 | $4,387 | $0 | $15,081 | $21,150 | $0 | $21,150 | $0 | 56 | 102 | |
| Jun-2025 Total | $12,598 | $240,191 | $472 | $124,141 | $377,402 | ($60,073) | $317,329 | $0 | 397 | 559 | |
| Jul-25 | ALL MEDICARE ELIGIBLES UNDER 65 | $105 | $0 | $0 | $0 | $105 | $0 | $105 | ($36) | 2 | 2 |
| NON-MEDICARE RETIREE | $10,073 | $128,749 | $275 | $94,807 | $233,904 | ($1,820) | $232,084 | $0 | 336 | 456 | |
| RETIREES OVER 65 | $1,963 | $5,584 | $65 | $18,120 | $25,732 | $0 | $25,732 | $0 | 56 | 102 | |
| Jul-2025 Total | $12,141 | $134,333 | $340 | $112,928 | $259,741 | ($1,820) | $257,921 | ($36) | 394 | 560 |
| BRANCH Totals | ALL MEDICARE ELIGIBLES UNDER 65 | $737 | $4,474 | $0 | $895 | $6,107 | $0 | $6,107 | $147 | 32 | 50 |
| NON-MEDICARE RETIREE | $72,827 | $1,529,897 | $5,014 | $693,366 | $2,301,104 | ($61,933) | $2,239,170 | $0 | 2,314 | 3,121 | |
| RETIREES OVER 65 | $11,451 | $62,034 | $498 | $128,996 | $202,979 | $0 | $202,979 | $0 | 392 | 714 | |
| Grand Total | $85,016 | $1,596,404 | $5,512 | $823,258 | $2,510,189 | ($61,933) | $2,448,256 | $147 | 2,738 | 3,885 |
&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 .