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
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/MONTH | PRODUCT GROUP | IN NETWORK | OUT OF NETWORK | TOTAL CLAIMS | BILLED PREMIUM | TOTAL SUBS | TOTAL MBRS |
| Jan-24 | DENT | $47,318 | $36,538 | $83,856 | $91,679 | 1,272 | 2,470 |
| Jan-2024 Total | $47,318 | $36,538 | $83,856 | $91,679 | 1,272 | 2,470 | |
| Feb-24 | DENT | $39,321 | $34,061 | $73,383 | $91,209 | 1,269 | 2,461 |
| Feb-2024 Total | $39,321 | $34,061 | $73,383 | $91,209 | 1,269 | 2,461 | |
| Mar-24 | DENT | $57,762 | $42,722 | $100,484 | $91,176 | 1,265 | 2,457 |
| Mar-2024 Total | $57,762 | $42,722 | $100,484 | $91,176 | 1,265 | 2,457 | |
| Apr-24 | DENT | $54,021 | $30,534 | $84,555 | $91,022 | 1,259 | 2,457 |
| Apr-2024 Total | $54,021 | $30,534 | $84,555 | $91,022 | 1,259 | 2,457 | |
| May-24 | DENT | $51,994 | $37,608 | $89,602 | $90,932 | 1,260 | 2,447 |
| May-2024 Total | $51,994 | $37,608 | $89,602 | $90,932 | 1,260 | 2,447 | |
| Jun-24 | DENT | $50,801 | $26,505 | $77,307 | $90,688 | 1,258 | 2,442 |
| Jun-2024 Total | $50,801 | $26,505 | $77,307 | $90,688 | 1,258 | 2,442 | |
| Jul-24 | DENT | $47,937 | $23,419 | $71,357 | $90,490 | 1,254 | 2,439 |
| Jul-2024 Total | $47,937 | $23,419 | $71,357 | $90,490 | 1,254 | 2,439 | |
| Aug-24 | DENT | $54,912 | $36,609 | $91,520 | $90,568 | 1,256 | 2,444 |
| Aug-2024 Total | $54,912 | $36,609 | $91,520 | $90,568 | 1,256 | 2,444 | |
| Sep-24 | DENT | $37,214 | $24,626 | $61,841 | $90,078 | 1,251 | 2,432 |
| Sep-2024 Total | $37,214 | $24,626 | $61,841 | $90,078 | 1,251 | 2,432 | |
| Oct-24 | DENT | $52,785 | $28,595 | $81,380 | $90,230 | 1,253 | 2,440 |
| Oct-2024 Total | $52,785 | $28,595 | $81,380 | $90,230 | 1,253 | 2,440 | |
| Nov-24 | DENT | $28,279 | $17,671 | $45,950 | $89,993 | 1,257 | 2,436 |
| Nov-2024 Total | $28,279 | $17,671 | $45,950 | $89,993 | 1,257 | 2,436 | |
| Dec-24 | DENT | $62,287 | $41,615 | $103,903 | $90,369 | 1,259 | 2,443 |
| Dec-2024 Total | $62,287 | $41,615 | $103,903 | $90,369 | 1,259 | 2,443 |
| PRODUCT GROUP Totals | DENT | $584,633 | $380,504 | $965,136 | $1,088,435 | 15,113 | 29,368 |
| Grand Total | $584,633 | $380,504 | $965,136 | $1,088,435 | 15,113 | 29,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 .