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 Brevard County Board of County Commissioners (BOCC), Florida, detailing dental health insurance enrollment and claims data for DHMO and DPPO plans from January through December 2024. The report covers two primary product types: a Dental Health Maintenance Organization (DHMO) plan and a Dental Preferred Provider Organization (DPPO) plan, tracking monthly enrollment across four coverage tiers (employee only, employee + spouse, employee + child(ren), and employee + family). The documentation includes detailed monthly enrollment figures, with total subscribers ranging from 695 to 718 for DHMO and 3,440 to 3,467 for DPPO throughout the year.
The financial data reveals consistent monthly billed premiums for DHMO at approximately $13,600-$13,900 and DPPO premiums around $177,900-$180,300, with total annual premiums for DHMO at $165,230 and DPPO at $2,154,972. The loss ratio for DPPO fluctuates 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%. Total members across both plans represent 8,540 for DHMO and 41,441 for DPPO, indicating a comprehensive coverage approach for Brevard County employees. The report, generated by the ADVICE Reporting System on 3/21/2025, contains proprietary information and provides a detailed breakdown of healthcare utilization and cost metrics.
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 .