Exhibit_C1-Brevard_BOCC_2024_DPPO_DHMO_Cigna.xls
XLS spreadsheet 97 KB Posted
- Attached to
- Brevard County Group Dental Plan State and local contract opportunity
- Solicitation number
- RFP-1-25-18
- Issued by
- Brevard County, Florida
About this file
The provided file is an enrollment and experience report for Brevard County Board of County Commissioners (BOCC), Florida, detailing dental health insurance coverage for the calendar year 2024. The document encompasses two primary dental plan types: Dental Health Maintenance Organization (DHMO) and Dental Preferred Provider Organization (DPPO), tracking monthly enrollment across four coverage tiers (Employee Only, Employee + Spouse, Employee + Child(ren), and Employee + Family). The total annual enrollment ranges from 695 to 718 participants for DHMO and 3,440 to 3,467 participants for DPPO, with a combined annual total of approximately 8,540 DHMO and 41,441 DPPO subscribers.
The financial details reveal monthly billed premiums for DHMO at approximately $13,600-$13,900 and total annual premiums of $165,230, while DPPO premiums range from $177,900 to $180,300 with total annual premiums of $2,154,972. The loss ratios for DPPO plans fluctuate monthly, ranging from a low of 58.4% in December to a high of 95.0% in August, with an annual average of 80.0%. The claims data shows a mix of in-network and out-of-network claims, with in-network claims consistently representing the majority of total healthcare expenses. The report, generated on 3/21/2025 by the ADVICE Reporting System, contains proprietary and confidential information related to Brevard County's healthcare enrollment and claims experience.
View the file
Other files for this state and local contract opportunity
Show all 50
Brevard County Group Dental Plan has more files on GovTribe.
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Enroll DHMO-1
| BREVARD COUNTY BOCC, FL | ||||||
| TRADITIONAL ENROLLMENT BY RATE TIER | ||||||
| January 2024 thru December 2024 | ||||||
| Funding Type : MINIMUM PREMIUM, N/A, TRADITIONAL | ||||||
| Rating Type : N/A, PROSPECTIVE GUARANTEED COST, RETROSPECTIVE EXPERIENCE RATED | ||||||
| YTD/MONTH | PRODUCT TYPE | EMPLOYEE ONLY | EMPLOYEE + SPOUSE | EMPLOYEE + CHILD(REN) | EMPLOYEE + FAMILY | EMPLOYEE TOTAL |
| Jan-24 | DHMO | 409 | 149 | 47 | 90 | 695 |
| Jan-2024 Total | 409 | 149 | 47 | 90 | 695 | |
| Feb-24 | DHMO | 418 | 150 | 51 | 89 | 708 |
| Feb-2024 Total | 418 | 150 | 51 | 89 | 708 | |
| Mar-24 | DHMO | 422 | 152 | 53 | 89 | 716 |
| Mar-2024 Total | 422 | 152 | 53 | 89 | 716 | |
| Apr-24 | DHMO | 418 | 152 | 52 | 89 | 711 |
| Apr-2024 Total | 418 | 152 | 52 | 89 | 711 | |
| May-24 | DHMO | 419 | 149 | 51 | 92 | 711 |
| May-2024 Total | 419 | 149 | 51 | 92 | 711 | |
| Jun-24 | DHMO | 425 | 148 | 52 | 91 | 716 |
| Jun-2024 Total | 425 | 148 | 52 | 91 | 716 | |
| Jul-24 | DHMO | 426 | 150 | 52 | 89 | 717 |
| Jul-2024 Total | 426 | 150 | 52 | 89 | 717 | |
| Aug-24 | DHMO | 427 | 152 | 50 | 89 | 718 |
| Aug-2024 Total | 427 | 152 | 50 | 89 | 718 | |
| Sep-24 | DHMO | 429 | 150 | 50 | 88 | 717 |
| Sep-2024 Total | 429 | 150 | 50 | 88 | 717 | |
| Oct-24 | DHMO | 426 | 149 | 51 | 87 | 713 |
| Oct-2024 Total | 426 | 149 | 51 | 87 | 713 | |
| Nov-24 | DHMO | 426 | 149 | 50 | 86 | 711 |
| Nov-2024 Total | 426 | 149 | 50 | 86 | 711 | |
| Dec-24 | DHMO | 422 | 148 | 51 | 86 | 707 |
| Dec-2024 Total | 422 | 148 | 51 | 86 | 707 | |
| PRODUCT TYPE Totals | DHMO | 5,067 | 1,798 | 610 | 1,065 | 8,540 |
| Grand Total | 5,067 | 1,798 | 610 | 1,065 | 8,540 |
&R &8Page &P of &N Date: 3/21/2025&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.
Enroll DPPO-1
| BREVARD COUNTY BOCC, FL | ||||||
| TRADITIONAL ENROLLMENT BY RATE TIER | ||||||
| January 2024 thru December 2024 | ||||||
| Funding Type : MINIMUM PREMIUM, N/A, TRADITIONAL | ||||||
| Rating Type : N/A, PROSPECTIVE GUARANTEED COST, RETROSPECTIVE EXPERIENCE RATED | ||||||
| YTD/MONTH | PRODUCT TYPE | EMPLOYEE ONLY | EMPLOYEE + SPOUSE | EMPLOYEE + CHILD(REN) | EMPLOYEE + FAMILY | EMPLOYEE TOTAL |
| Jan-24 | DPPO | 1,759 | 697 | 460 | 524 | 3,440 |
| Jan-2024 Total | 1,759 | 697 | 460 | 524 | 3,440 | |
| Feb-24 | DPPO | 1,771 | 696 | 458 | 521 | 3,446 |
| Feb-2024 Total | 1,771 | 696 | 458 | 521 | 3,446 | |
| Mar-24 | DPPO | 1,778 | 696 | 458 | 519 | 3,451 |
| Mar-2024 Total | 1,778 | 696 | 458 | 519 | 3,451 | |
| Apr-24 | DPPO | 1,773 | 698 | 458 | 516 | 3,445 |
| Apr-2024 Total | 1,773 | 698 | 458 | 516 | 3,445 | |
| May-24 | DPPO | 1,784 | 698 | 453 | 517 | 3,452 |
| May-2024 Total | 1,784 | 698 | 453 | 517 | 3,452 | |
| Jun-24 | DPPO | 1,784 | 701 | 451 | 520 | 3,456 |
| Jun-2024 Total | 1,784 | 701 | 451 | 520 | 3,456 | |
| Jul-24 | DPPO | 1,786 | 707 | 451 | 516 | 3,460 |
| Jul-2024 Total | 1,786 | 707 | 451 | 516 | 3,460 | |
| Aug-24 | DPPO | 1,799 | 703 | 448 | 517 | 3,467 |
| Aug-2024 Total | 1,799 | 703 | 448 | 517 | 3,467 | |
| Sep-24 | DPPO | 1,793 | 700 | 452 | 513 | 3,458 |
| Sep-2024 Total | 1,793 | 700 | 452 | 513 | 3,458 | |
| Oct-24 | DPPO | 1,800 | 701 | 454 | 509 | 3,464 |
| Oct-2024 Total | 1,800 | 701 | 454 | 509 | 3,464 | |
| Nov-24 | DPPO | 1,800 | 706 | 456 | 493 | 3,455 |
| Nov-2024 Total | 1,800 | 706 | 456 | 493 | 3,455 | |
| Dec-24 | DPPO | 1,799 | 703 | 450 | 495 | 3,447 |
| Dec-2024 Total | 1,799 | 703 | 450 | 495 | 3,447 | |
| PRODUCT TYPE Totals | DPPO | 21,426 | 8,406 | 5,449 | 6,160 | 41,441 |
| Grand Total | 21,426 | 8,406 | 5,449 | 6,160 | 41,441 |
&R &8Page &P of &N Date: 3/21/2025&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.
Exp DHMO-1
| BREVARD COUNTY BOCC, FL | ||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | ||||
| January 2024 thru December 2024 | ||||
| Funding Type : TRADITIONAL | ||||
| Rating Type : PROSPECTIVE GUARANTEED COST | ||||
| Reported Premium: Billed Premium without 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 | BILLED PREMIUM | TOTAL SUBS | TOTAL MBRS |
| Jan-24 | DHMO | $13,529 | 695 | 1,160 |
| Jan-2024 Total | $13,529 | 695 | 1,160 | |
| Feb-24 | DHMO | $13,732 | 708 | 1,175 |
| Feb-2024 Total | $13,732 | 708 | 1,175 | |
| Mar-24 | DHMO | $13,883 | 716 | 1,190 |
| Mar-2024 Total | $13,883 | 716 | 1,190 | |
| Apr-24 | DHMO | $13,808 | 711 | 1,185 |
| Apr-2024 Total | $13,808 | 711 | 1,185 | |
| May-24 | DHMO | $13,827 | 711 | 1,198 |
| May-2024 Total | $13,827 | 711 | 1,198 | |
| Jun-24 | DHMO | $13,866 | 716 | 1,201 |
| Jun-2024 Total | $13,866 | 716 | 1,201 | |
| Jul-24 | DHMO | $13,859 | 716 | 1,197 |
| Jul-2024 Total | $13,859 | 716 | 1,197 | |
| Aug-24 | DHMO | $13,876 | 717 | 1,194 |
| Aug-2024 Total | $13,876 | 717 | 1,194 | |
| Sep-24 | DHMO | $13,814 | 717 | 1,189 |
| Sep-2024 Total | $13,814 | 717 | 1,189 | |
| Oct-24 | DHMO | $13,737 | 713 | 1,181 |
| Oct-2024 Total | $13,737 | 713 | 1,181 | |
| Nov-24 | DHMO | $13,677 | 711 | 1,175 |
| Nov-2024 Total | $13,677 | 711 | 1,175 | |
| Dec-24 | DHMO | $13,623 | 707 | 1,172 |
| Dec-2024 Total | $13,623 | 707 | 1,172 | |
| PRODUCT TYPE Totals | DHMO | $165,230 | 8,538 | 14,217 |
| Grand Total | $165,230 | 8,538 | 14,217 |
&RADVICE Reporting System &8Page &P of &N Date: 3/21/2025&C&G&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.
Exp DPPO-1
| BREVARD COUNTY BOCC, FL | ||||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | ||||||||
| January 2024 thru December 2024 | ||||||||
| Funding Type : TRADITIONAL | ||||||||
| Rating Type : PROSPECTIVE GUARANTEED COST | ||||||||
| Reported Premium: Billed Premium without fees | ||||||||
| Reported Claims: All Claims | ||||||||
| Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services. | ||||||||
| YTD/MONTH | PRODUCT TYPE | IN NETWORK | OUT OF NETWORK | TOTAL CLAIMS | BILLED PREMIUM | TOTAL LOSS RATIO | TOTAL SUBS | TOTAL MBRS |
| Jan-24 | DPPO | $135,648 | $18,691 | $154,339 | $180,034 | 85.7% | 3,439 | 6,520 |
| Jan-2024 Total | $135,648 | $18,691 | $154,339 | $180,034 | 85.7% | 3,439 | 6,520 | |
| Feb-24 | DPPO | $127,875 | $13,152 | $141,027 | $179,571 | 78.5% | 3,445 | 6,507 |
| Feb-2024 Total | $127,875 | $13,152 | $141,027 | $179,571 | 78.5% | 3,445 | 6,507 | |
| Mar-24 | DPPO | $138,302 | $21,954 | $160,256 | $179,766 | 89.1% | 3,448 | 6,496 |
| Mar-2024 Total | $138,302 | $21,954 | $160,256 | $179,766 | 89.1% | 3,448 | 6,496 | |
| Apr-24 | DPPO | $128,640 | $21,293 | $149,932 | $179,583 | 83.5% | 3,442 | 6,485 |
| Apr-2024 Total | $128,640 | $21,293 | $149,932 | $179,583 | 83.5% | 3,442 | 6,485 | |
| May-24 | DPPO | $129,327 | $22,108 | $151,435 | $179,985 | 84.1% | 3,447 | 6,479 |
| May-2024 Total | $129,327 | $22,108 | $151,435 | $179,985 | 84.1% | 3,447 | 6,479 | |
| Jun-24 | DPPO | $145,513 | $15,496 | $161,009 | $180,314 | 89.3% | 3,452 | 6,490 |
| Jun-2024 Total | $145,513 | $15,496 | $161,009 | $180,314 | 89.3% | 3,452 | 6,490 | |
| Jul-24 | DPPO | $119,642 | $18,200 | $137,842 | $180,090 | 76.5% | 3,454 | 6,484 |
| Jul-2024 Total | $119,642 | $18,200 | $137,842 | $180,090 | 76.5% | 3,454 | 6,484 | |
| Aug-24 | DPPO | $151,076 | $20,298 | $171,374 | $180,301 | 95.0% | 3,458 | 6,477 |
| Aug-2024 Total | $151,076 | $20,298 | $171,374 | $180,301 | 95.0% | 3,458 | 6,477 | |
| Sep-24 | DPPO | $112,130 | $14,658 | $126,788 | $179,683 | 70.6% | 3,449 | 6,460 |
| Sep-2024 Total | $112,130 | $14,658 | $126,788 | $179,683 | 70.6% | 3,449 | 6,460 | |
| Oct-24 | DPPO | $116,260 | $17,933 | $134,193 | $179,490 | 74.8% | 3,463 | 6,469 |
| Oct-2024 Total | $116,260 | $17,933 | $134,193 | $179,490 | 74.8% | 3,463 | 6,469 | |
| Nov-24 | DPPO | $117,360 | $14,397 | $131,757 | $178,229 | 73.9% | 3,454 | 6,430 |
| Nov-2024 Total | $117,360 | $14,397 | $131,757 | $178,229 | 73.9% | 3,454 | 6,430 | |
| Dec-24 | DPPO | $92,801 | $11,057 | $103,859 | $177,925 | 58.4% | 3,446 | 6,414 |
| Dec-2024 Total | $92,801 | $11,057 | $103,859 | $177,925 | 58.4% | 3,446 | 6,414 | |
| PRODUCT TYPE Totals | DPPO | $1,514,574 | $209,238 | $1,723,811 | $2,154,972 | 80.0% | 41,397 | 77,711 |
| Grand Total | $1,514,574 | $209,238 | $1,723,811 | $2,154,972 | 80.0% | 41,397 | 77,711 |
&RADVICE Reporting System &8Page &P of &N Date: 3/21/2025&C&G&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.
File details come from the government source that posted it. Updated .