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 claims experience report for Brevard County Board of County Commissioners (BOCC), Florida, detailing dental insurance coverage for January through December 2024. The report covers two dental product 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 DHMO plan shows consistent monthly enrollment around 700-718 participants, while the DPPO plan demonstrates higher enrollment ranging from 3,440 to 3,467 participants, with a total annual enrollment of 8,540 for DHMO and 41,441 for DPPO.
The financial details reveal monthly billed premiums for DHMO at approximately $13,600-$13,900, totaling $165,230 annually, with total subscribers of 8,538 and 14,217 total members. The DPPO plan shows more complex financial metrics, with monthly billed premiums around $177,925-$180,314, totaling $2,154,972 annually. The loss ratio for DPPO varies monthly, ranging from 58.4% to 95.0%, with an annual average of 80.0%. Total claims for DPPO were $1,723,811, split between in-network claims of $1,514,574 and out-of-network claims of $209,238. The data suggests stable enrollment and relatively consistent claims performance across both dental plan types throughout the year.
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 .