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 document is an enrollment and experience report for dental insurance plans for Brevard County Board of County Commissioners (BOCC) in Florida, covering January through December 2024. The report details two dental plan types: a Dental Health Maintenance Organization (DHMO) and a Dental Preferred Provider Organization (DPPO) plan, with monthly enrollment tracking across four coverage tiers (employee only, employee + spouse, employee + child(ren), and employee + family). The enrollment remains relatively stable throughout the year, with total subscribers ranging from 695 to 718 for DHMO and 3,440 to 3,467 for DPPO, representing a total of 8,540 DHMO and 41,441 DPPO subscribers annually.
The financial details reveal consistent monthly premiums for both plans, with DHMO premiums around $13,600-$13,900 and DPPO premiums between $177,900-$180,300 per month. The DPPO plan shows varying loss ratios from 58.4% to 95.0%, with an annual total loss ratio of 80.0%. Total annual premiums for both plans approximate $2.16 million, with total claims of $1.72 million. The claims are predominantly in-network, with DPPO in-network claims representing approximately 87.8% of total claims. The data suggests stable enrollment and consistent claims performance, indicating a well-managed dental insurance program for Brevard County employees.
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 .