Exhibit 48 - Cal Yr 2024 City of Miami CIGNA Dental Experience.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 detail experience report for a dental insurance contract with the City of Miami, covering calendar year 2024. The report provides a comprehensive monthly breakdown of dental insurance claims and subscriber data for CIGNA, detailing in-network and out-of-network claims, billed premiums, total subscribers, and total members from January through December 2024.

The financial metrics reveal consistent monthly dental insurance coverage with total annual claims of $965,136, spanning in-network claims of $584,633 and out-of-network claims of $380,504. The total annual billed premium is $1,088,435, with subscriber numbers ranging between 1,251 and 1,272 and total member counts between 2,432 and 2,470 throughout the year. The report appears to be part of a prospective guaranteed cost rating type for the City of Miami's dental insurance experience, potentially related to a broader Request for Proposals (RFP No. 2130386) for an Employee Health Benefits Plan in Florida.

View the file

Other files

File Type Posted
Exhibit 18b - Cal Yr 2025 City of Miami CIGNA ASO and Fixed Charges Monthly Healthcare Experience by Prod YTD.xlsx XLSX spreadsheet
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 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

GC Dental Experience-1

CITY OF MIAMI
MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT
EXHIBIT 48
January 2024 thru December 2024
Rating Type : PROSPECTIVE GUARANTEED COST
Reported Premium: Billed Premium without fees
Reported Claims: All Claims
YTD/MONTHPRODUCT GROUPIN NETWORKOUT OF NETWORKTOTAL CLAIMSBILLED PREMIUMTOTAL SUBSTOTAL MBRS
Jan-24DENT$47,318$36,538$83,856$91,6791,2722,470
Jan-2024 Total$47,318$36,538$83,856$91,6791,2722,470
Feb-24DENT$39,321$34,061$73,383$91,2091,2692,461
Feb-2024 Total$39,321$34,061$73,383$91,2091,2692,461
Mar-24DENT$57,762$42,722$100,484$91,1761,2652,457
Mar-2024 Total$57,762$42,722$100,484$91,1761,2652,457
Apr-24DENT$54,021$30,534$84,555$91,0221,2592,457
Apr-2024 Total$54,021$30,534$84,555$91,0221,2592,457
May-24DENT$51,994$37,608$89,602$90,9321,2602,447
May-2024 Total$51,994$37,608$89,602$90,9321,2602,447
Jun-24DENT$50,801$26,505$77,307$90,6881,2582,442
Jun-2024 Total$50,801$26,505$77,307$90,6881,2582,442
Jul-24DENT$47,937$23,419$71,357$90,4901,2542,439
Jul-2024 Total$47,937$23,419$71,357$90,4901,2542,439
Aug-24DENT$54,912$36,609$91,520$90,5681,2562,444
Aug-2024 Total$54,912$36,609$91,520$90,5681,2562,444
Sep-24DENT$37,214$24,626$61,841$90,0781,2512,432
Sep-2024 Total$37,214$24,626$61,841$90,0781,2512,432
Oct-24DENT$52,785$28,595$81,380$90,2301,2532,440
Oct-2024 Total$52,785$28,595$81,380$90,2301,2532,440
Nov-24DENT$28,279$17,671$45,950$89,9931,2572,436
Nov-2024 Total$28,279$17,671$45,950$89,9931,2572,436
Dec-24DENT$62,287$41,615$103,903$90,3691,2592,443
Dec-2024 Total$62,287$41,615$103,903$90,3691,2592,443
PRODUCT GROUP TotalsDENT$584,633$380,504$965,136$1,088,43515,11329,368
Grand Total$584,633$380,504$965,136$1,088,43515,11329,368

&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law. &G ADVICE Reporting System &8Page &P of &N Date: 4/10/2025 image1.png image2.png

File details come from the government source that posted it. Updated .