Exhibit 47 - Cal Yr 2023 City of Miami CIGNA Dental Exp.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- RFP No. 2130386 - Employee Health Benefits Plan
- Solicitation number
- RFP No. 2130386
- Issued by
- Florida
About this file
The document is a monthly healthcare detail experience report for dental services provided by CIGNA to the City of Miami for calendar year 2023. The report covers dental insurance claims and premium data from January through December 2023, tracking in-network and out-of-network dental service utilization for the city's employee health benefits plan. The document appears to be related to a Request for Proposals (RFP No. 2130386) for an Employee Health Benefits Plan in the state of Florida.
The report shows consistent monthly dental service usage, with total annual claims of $888,065 against billed premiums of $1,041,263. The city's dental plan covered between 1,207 and 1,219 subscribers and 2,342 to 2,368 total members throughout the year. Monthly in-network claims ranged from $36,313 to $50,476, while out-of-network claims varied between $24,148 and $35,390. The data suggests a stable enrollment and relatively consistent healthcare utilization pattern for the City of Miami's dental insurance coverage during the specified period.
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
GC Dental Experience-1
| CITY OF MIAMI | |||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | |||||||
| EXHIBIT 47 | |||||||
| January 2023 thru December 2023 | |||||||
| 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-23 | DENT | $41,773 | $35,390 | $77,162 | $87,131 | 1,219 | 2,368 |
| Jan-2023 Total | $41,773 | $35,390 | $77,162 | $87,131 | 1,219 | 2,368 | |
| Feb-23 | DENT | $44,933 | $30,872 | $75,805 | $86,829 | 1,215 | 2,358 |
| Feb-2023 Total | $44,933 | $30,872 | $75,805 | $86,829 | 1,215 | 2,358 | |
| Mar-23 | DENT | $49,245 | $33,720 | $82,965 | $86,662 | 1,214 | 2,353 |
| Mar-2023 Total | $49,245 | $33,720 | $82,965 | $86,662 | 1,214 | 2,353 | |
| Apr-23 | DENT | $50,476 | $27,478 | $77,954 | $86,581 | 1,213 | 2,351 |
| Apr-2023 Total | $50,476 | $27,478 | $77,954 | $86,581 | 1,213 | 2,351 | |
| May-23 | DENT | $47,915 | $31,105 | $79,020 | $86,384 | 1,209 | 2,342 |
| May-2023 Total | $47,915 | $31,105 | $79,020 | $86,384 | 1,209 | 2,342 | |
| Jun-23 | DENT | $47,386 | $33,006 | $80,392 | $86,668 | 1,212 | 2,351 |
| Jun-2023 Total | $47,386 | $33,006 | $80,392 | $86,668 | 1,212 | 2,351 | |
| Jul-23 | DENT | $48,903 | $31,461 | $80,364 | $86,549 | 1,210 | 2,351 |
| Jul-2023 Total | $48,903 | $31,461 | $80,364 | $86,549 | 1,210 | 2,351 | |
| Aug-23 | DENT | $39,290 | $35,368 | $74,657 | $86,708 | 1,213 | 2,355 |
| Aug-2023 Total | $39,290 | $35,368 | $74,657 | $86,708 | 1,213 | 2,355 | |
| Sep-23 | DENT | $38,860 | $24,148 | $63,008 | $87,025 | 1,212 | 2,362 |
| Sep-2023 Total | $38,860 | $24,148 | $63,008 | $87,025 | 1,212 | 2,362 | |
| Oct-23 | DENT | $40,713 | $24,770 | $65,483 | $86,789 | 1,207 | 2,357 |
| Oct-2023 Total | $40,713 | $24,770 | $65,483 | $86,789 | 1,207 | 2,357 | |
| Nov-23 | DENT | $36,313 | $28,306 | $64,619 | $86,919 | 1,210 | 2,354 |
| Nov-2023 Total | $36,313 | $28,306 | $64,619 | $86,919 | 1,210 | 2,354 | |
| Dec-23 | DENT | $39,608 | $27,029 | $66,637 | $87,019 | 1,212 | 2,357 |
| Dec-2023 Total | $39,608 | $27,029 | $66,637 | $87,019 | 1,212 | 2,357 |
| PRODUCT GROUP Totals | DENT | $525,412 | $362,653 | $888,065 | $1,041,263 | 14,546 | 28,259 |
| Grand Total | $525,412 | $362,653 | $888,065 | $1,041,263 | 14,546 | 28,259 |
&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 .