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

File Type Posted
Exhibit 15b - City of Miami Cal Yr 2025 CIGNA Medical - Comp EEs Plan 70 Percent Ded 300 Max Out of Pocket 1K ASO68.pdf PDF
Exhibit 50 - Cal Yr 2024 City of Miami CIGNA Vision Plans Claim Summary Report.pdf PDF
Questionnaire No. 4 (Revised) - Group Benefit Dental Plan.pdf PDF
Exhibit 74 - Cal Yr 2023 City of Miami ASO Fixed Charges and Fees Per Product Type Monthly Healthcare Detail Experience.xlsx XLSX spreadsheet
Exhibit 06d - Cal Yr 2025 City of Miami CIGNA Dental PPO Territorial Legislation - 23 States ETALLD25B.pdf PDF
Exhibit 22 - Cal Yr 2025 City of Miami CIGNA Sum Ben Cov Comp EEs No Rx- Out Of Area Plan - Plan 70 Pct Ded 300 Max Out of Pocket 1K ASO67.pdf PDF
Exhibit 30a - Cal Yr 2025 City of MIami CIGNA VIS Vision Benefit imbedded in Medical Plan Document ASO71.pdf PDF
Attachment A - City of Miami Living Wage Ordinance.pdf PDF
Exhibit 11a - Cal Yr 2022 City of Miami CIGNA Total Health Insight - Claims paid Feb 2023.pdf PDF
Exhibit 18 (Revised) -Cal Yrs 2023-2024 CIGNA City of Miami CAP Report_Redacted.pdf PDF
Exhibit 37 - Cal Yr 2022 City of Miami Stop Loss - Greater than 50K High Claimant Report De-ID Dx.xlsx XLSX spreadsheet
Exhibit 54a - Cal Yr 2025 City of Miami CIGNA Medical - Administrative Services Only ASO And Stop Loss Fees Schedule.pdf PDF
Exhibit 16b - Cal Yr 2025 City of Miami CIGNA Open Access Plan (OAP) Medicare No Rx - Comp EEs Plan 80 Percent Ded 500 Max Out of Pocket 2K ASO70.pdf PDF
Exhibit 03 - City of Miami AFSCME 1907 General Employees Union Contract Oct 1 2023 - Sep 30 2026.pdf PDF
Exhibit 28 - Cal Yr 2025 City of Miami Comprehensive Buy UP Vision Benefit Summary Fully Insured (VISE) C1 PPO.pdf PDF
Exhibit 07 - Cal Yr 2024 City of Miami CIGNA EGWP Medicare - Evidence of Coverage Snapshot.pdf PDF
Exhibit 62 - Cal Yr 2025 City of Miami CIGNA FSA Healthcare - Summary Plan Document.pdf PDF
Exhibit 57a - Cal Yr 2025 City of Miami CIGNA Rx - Standard 3-Tier Prescription Drug List.pdf PDF
Exhibit 35 - Cal Yr 2024 City of Miami CIGNA Dental PPO Summary of Benefits Summary.pdf PDF
Exhibit 02 - City of Miami AFSCME 871 Sanitation Employees Union Contract Oct 1 2023 - Sep 30 2026.pdf PDF
Exhibit 16 - Cal Yr 2024 City of Miami CIGNA Open Access Plan (OAP) Medicare No Rx - Comp EEs Plan 80 Percent Ded 500 Max Out of Pocket 2K ASO66.pdf PDF
Exhibit 26 - Cal Yr 2025 City of Miami Imputed Biweekly Income Table for Domestic Partner Medical Coverage.pdf PDF
Exhibit 69 - Cal Yr 2024 City of Miami RX CAP Report Plan Exec Summ and Top 20 Therapeutic Drugs.ppt PPT presentation
Exhibit 65 - Aug 2024 to Jul 2025 City of Miami CIGNA Lag Report Incurred Date included - Monthly Healthcare Experience by Acct Rlg 12-1.xlsx XLSX spreadsheet
Exhibit 24 - Cal Yr 2025 City of Miami Benefits Biweekly Premiums.pdf PDF
Exhibit 40 - 2025 City of Miami Medical Network Access Disruption Report.pdf PDF
Exhibit 11b - Cal Yr 2023 City of Miami CIGNA Total Health Insight - Claims paid Feb 2024.pdf PDF
Exhibit 09d - Cal Yr 2024 City of Miami CIGNA Vision - Monthly Healthcare Experience INN OON Total Claims Subs Mbrs.xlsx XLSX spreadsheet
Attachment B - Reference Submittal Form.pdf PDF
Questionnaire No. 2 - Stop Loss Insurance.pdf PDF
Exhibit 25 - Cal Yr 2025 City of Miami Cobra Monthly Premiums.pdf PDF
Questionnaire No. 3 (Revised) - Prescription Drugs (Rx).pdf PDF
Exhibit 51a - Cal Yr 2024 City of Miami CIGNA ASO Monthly Fees Healthcare Experience by Benefit Option Rolling 12 BenOpt-1.xlsx XLSX spreadsheet
Exhibit 21 - Cal Yr 2025 City of Miami CIGNA Summary Benefits Coverage OAP - Out Of Area - Ded 300 Maximum Out of Pocket 1K Comp EEs.pdf PDF
Exhibit 08a - Cal Yr 2025 City of Miami CIGNA Medicare EGWP Prescription Drug Plan.pdf PDF
Exhibit 07a - Cal Yr 2025 City of Miami CIGNA Healthcare EGWP Rx Prescription Drug Plan and Summary of Benefits.pdf PDF
Exhibit 57b - Cal Yr 2025 City of Miami YTD as of Apr Stats by Ther Class _ Brand - Healthcare Spend and Trend - Pharmacy - Paid.xlsx XLSX spreadsheet
Exhibit 09b - Cal Yr 2025 City of Miami CIGNA VISE Comprehensive BuyUp Vision Certificate HP-POL1053.pdf PDF
Exhibit 20 - Cal Yr 2025 City of Miami Medicare No Rx - SBC_OAP Plan Comp 300 Ded 300 Max Out of Pocket 1K.pdf PDF
Exhibit 23 - Cal Yr 2025 City of Miami CIGNA Summary Benefits Coverage Open Access Plan - All employees.pdf PDF
Exhibit 27. 2025 City of Miami Master CIGNA Census De-ID All Benefit Options.xlsx XLSX spreadsheet
Exhibit 32 - Cal Yr 2023 CIty of Miami CIGNA Lag Report Incurred Date included - Monthly Healthcare Experience Lag Report by Acct Rolling 12-1.xlsx XLSX spreadsheet
Exhibit 68 - Cal Yr 2024 City of Miami RX Stats by Ther Class _ Brand Healthcare Spend and Trend.xlsx XLSX spreadsheet
Exhibit 14 - Cal Yr 2024 City of Miami CIGNA Medicare Benefits - Comp EEs No Rx Plan 70 Percent Ded 300 Max Out Of Pocket 1K ASO65.pdf PDF
Questionnaire No. 6 - Employee Assistance Program.pdf PDF
Exhibit 48 - Cal Yr 2024 City of Miami CIGNA Dental Experience.xlsx XLSX spreadsheet
Exhibit 54b - Cal Yr 2025 City of Miami Stop CIGNA ISL and ASL Coverage Information Amendment Plan 3202272 CSL-SCH(10-15).pdf PDF
Exhibit 55 - Cal Yr 2025 as of Apr EAP Network Analysis Report Access 118974.pdf PDF
Exhibit 38 - Cal Yr 2023 City of Miami Stop Loss - Greater than 50K High Claimant Report De-ID Dx.xlsx XLSX spreadsheet
Exhibit 15 - City of Miami Cal Yr 2024 CIGNA Medical - Comp EEs Plan 70 Percent Ded 300 Max Out of Pocket 1K ASO64.pdf PDF
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/MONTHPRODUCT TYPEFIXED CHARGESIN NETWORKOUT OF NETWORKDRUGTOTAL CLAIMSTOTAL ASO FEESTOTAL SUBSTOTAL MBRS
Jan-25COH$0$0$0$0$0$02,0074,172
DPP4$0$9,925$288($384)$9,829$000
OAP1$237,984$2,551,930$69,889$1,025,484$3,885,287$82,5632,2694,491
VISP$0$29,479$0$0$29,479$4861,3852,643
Jan-2025 Total$237,984$2,591,334$70,177$1,025,100$3,924,595$83,0495,66111,306
Feb-25COH$0$0$0$0$0$02,0004,157
DPP4$0$26,198$79$86$26,363$000
OAP1$246,791$2,630,985$46,702$1,226,464$4,150,941$81,9832,2634,477
VISP$0$27,080$0$0$27,080$4841,3832,635
Feb-2025 Total$246,791$2,684,262$46,781$1,226,551$4,204,384$82,4665,64611,269
Mar-25COH$0$0$0$0$0$02,0044,172
DPP4$921($3,924)$571$0($2,433)$000
OAP1$235,618$2,644,634$49,978$1,162,835$4,093,065$82,0552,2654,490
VISP$0$14,787$0$0$14,787$4841,3832,637
Mar-2025 Total$236,539$2,655,497$50,548$1,162,835$4,105,419$82,5395,65211,299
Apr-25COH$0$0$0$0$0$02,0014,166
DPP4$0($784)$1,212$65$493$000
OAP1$240,329$3,345,473$59,712$1,120,198$4,765,713$81,8742,2594,481
VISP$0$4,211$0$0$4,211$4831,3812,635
Apr-2025 Total$240,329$3,348,900$60,924$1,120,263$4,770,417$82,3575,64111,282
May-25COH$0$0$0$0$0$02,0034,173
DPP4$0$22,280$1,712$0$23,992$000
OAP1$249,842$3,320,172$40,509$1,067,820$4,678,342$81,8742,2594,486
VISP$0$2,095$0$0$2,095$4831,3812,638
May-2025 Total$249,842$3,344,547$42,220$1,067,820$4,704,429$82,3575,64311,297
Jun-25COH$0$0$0$0$0$01,9934,163
DPP4$0$167,298$998$80$168,376$000
OAP1$245,398$2,247,863$42,067$1,124,271$3,659,599($254)2,2504,477
VISP$0$4,464$0$0$4,464$4821,3782,639
Jun-2025 Total$245,398$2,419,625$43,066$1,124,351$3,832,440$2285,62111,279
Jul-25COH$0$0$0$0$0$01,9984,173
DPP4$0($2,193)$498$0($1,695)$000
OAP1$243,154$2,956,531$42,663$1,263,260$4,505,609$4942,2544,486
VISP$0$3,768$0$0$3,768$4811,3742,634
Jul-2025 Total$243,154$2,958,107$43,161$1,263,260$4,507,682$9755,62611,293
PRODUCT TYPE TotalsCOH$0$0$0$0$0$014,00629,176
DPP4$921$218,800$5,356($152)$224,925$000
OAP1$1,699,115$19,697,588$351,520$7,990,333$29,738,556$410,58915,81931,388
VISP$0$85,885$0$0$85,885$3,3829,66518,461
Grand Total$1,700,036$20,002,273$356,877$7,990,181$30,049,366$413,97139,49079,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 .