Exhibit 18b - Cal Yr 2025 City of Miami CIGNA ASO and Fixed Charges Monthly Healthcare Experience by Prod YTD.xlsx
XLSX spreadsheet 22 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 health insurance plan for Calendar Year 2025, covering January through July. The report details healthcare costs and enrollment across four product types: COH, DPP4, OAP1, and VISP, with a retrospective experience-rated administrative services only (ASO) structure. The report tracks fixed charges, in-network and out-of-network claims, drug expenses, total claims, ASO fees, subscriber counts, and member enrollment.
The financial breakdown reveals total claims of $30,049,366 across the seven-month period, with the OAP1 product type representing the majority of expenses at $29,738,556. The subscriber base ranges from 5,621 to 5,661 monthly, with total member enrollment between 11,269 and 11,306 individuals. ASO fees totaled $413,971, and fixed charges were $1,700,036. The report suggests a stable healthcare plan with consistent enrollment and a detailed tracking mechanism for healthcare expenditures, which appears to be part of a broader RFP No. 2130386 for the City of Miami's Employee Health Benefits Plan.
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
Acct Product YTD-1
| CITY OF MIAMI | |||||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | |||||||||
| January 2025 thru July 2025 | |||||||||
| EXHIBIT 18b | |||||||||
| 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 | PRODUCT TYPE | FIXED CHARGES | IN NETWORK | OUT OF NETWORK | DRUG | TOTAL CLAIMS | TOTAL ASO FEES | TOTAL SUBS | TOTAL MBRS |
| Jan-25 | COH | $0 | $0 | $0 | $0 | $0 | $0 | 2,007 | 4,172 |
| DPP4 | $0 | $9,925 | $288 | ($384) | $9,829 | $0 | 0 | 0 | |
| OAP1 | $237,984 | $2,551,930 | $69,889 | $1,025,484 | $3,885,287 | $82,563 | 2,269 | 4,491 | |
| VISP | $0 | $29,479 | $0 | $0 | $29,479 | $486 | 1,385 | 2,643 | |
| Jan-2025 Total | $237,984 | $2,591,334 | $70,177 | $1,025,100 | $3,924,595 | $83,049 | 5,661 | 11,306 | |
| Feb-25 | COH | $0 | $0 | $0 | $0 | $0 | $0 | 2,000 | 4,157 |
| DPP4 | $0 | $26,198 | $79 | $86 | $26,363 | $0 | 0 | 0 | |
| OAP1 | $246,791 | $2,630,985 | $46,702 | $1,226,464 | $4,150,941 | $81,983 | 2,263 | 4,477 | |
| VISP | $0 | $27,080 | $0 | $0 | $27,080 | $484 | 1,383 | 2,635 | |
| Feb-2025 Total | $246,791 | $2,684,262 | $46,781 | $1,226,551 | $4,204,384 | $82,466 | 5,646 | 11,269 | |
| Mar-25 | COH | $0 | $0 | $0 | $0 | $0 | $0 | 2,004 | 4,172 |
| DPP4 | $921 | ($3,924) | $571 | $0 | ($2,433) | $0 | 0 | 0 | |
| OAP1 | $235,618 | $2,644,634 | $49,978 | $1,162,835 | $4,093,065 | $82,055 | 2,265 | 4,490 | |
| VISP | $0 | $14,787 | $0 | $0 | $14,787 | $484 | 1,383 | 2,637 | |
| Mar-2025 Total | $236,539 | $2,655,497 | $50,548 | $1,162,835 | $4,105,419 | $82,539 | 5,652 | 11,299 | |
| Apr-25 | COH | $0 | $0 | $0 | $0 | $0 | $0 | 2,001 | 4,166 |
| DPP4 | $0 | ($784) | $1,212 | $65 | $493 | $0 | 0 | 0 | |
| OAP1 | $240,329 | $3,345,473 | $59,712 | $1,120,198 | $4,765,713 | $81,874 | 2,259 | 4,481 | |
| VISP | $0 | $4,211 | $0 | $0 | $4,211 | $483 | 1,381 | 2,635 | |
| Apr-2025 Total | $240,329 | $3,348,900 | $60,924 | $1,120,263 | $4,770,417 | $82,357 | 5,641 | 11,282 | |
| May-25 | COH | $0 | $0 | $0 | $0 | $0 | $0 | 2,003 | 4,173 |
| DPP4 | $0 | $22,280 | $1,712 | $0 | $23,992 | $0 | 0 | 0 | |
| OAP1 | $249,842 | $3,320,172 | $40,509 | $1,067,820 | $4,678,342 | $81,874 | 2,259 | 4,486 | |
| VISP | $0 | $2,095 | $0 | $0 | $2,095 | $483 | 1,381 | 2,638 | |
| May-2025 Total | $249,842 | $3,344,547 | $42,220 | $1,067,820 | $4,704,429 | $82,357 | 5,643 | 11,297 | |
| Jun-25 | COH | $0 | $0 | $0 | $0 | $0 | $0 | 1,993 | 4,163 |
| DPP4 | $0 | $167,298 | $998 | $80 | $168,376 | $0 | 0 | 0 | |
| OAP1 | $245,398 | $2,247,863 | $42,067 | $1,124,271 | $3,659,599 | ($254) | 2,250 | 4,477 | |
| VISP | $0 | $4,464 | $0 | $0 | $4,464 | $482 | 1,378 | 2,639 | |
| Jun-2025 Total | $245,398 | $2,419,625 | $43,066 | $1,124,351 | $3,832,440 | $228 | 5,621 | 11,279 | |
| Jul-25 | COH | $0 | $0 | $0 | $0 | $0 | $0 | 1,998 | 4,173 |
| DPP4 | $0 | ($2,193) | $498 | $0 | ($1,695) | $0 | 0 | 0 | |
| OAP1 | $243,154 | $2,956,531 | $42,663 | $1,263,260 | $4,505,609 | $494 | 2,254 | 4,486 | |
| VISP | $0 | $3,768 | $0 | $0 | $3,768 | $481 | 1,374 | 2,634 | |
| Jul-2025 Total | $243,154 | $2,958,107 | $43,161 | $1,263,260 | $4,507,682 | $975 | 5,626 | 11,293 |
| PRODUCT TYPE Totals | COH | $0 | $0 | $0 | $0 | $0 | $0 | 14,006 | 29,176 |
| DPP4 | $921 | $218,800 | $5,356 | ($152) | $224,925 | $0 | 0 | 0 | |
| OAP1 | $1,699,115 | $19,697,588 | $351,520 | $7,990,333 | $29,738,556 | $410,589 | 15,819 | 31,388 | |
| VISP | $0 | $85,885 | $0 | $0 | $85,885 | $3,382 | 9,665 | 18,461 | |
| Grand Total | $1,700,036 | $20,002,273 | $356,877 | $7,990,181 | $30,049,366 | $413,971 | 39,490 | 79,025 |
&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 .