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 file is an enrollment and healthcare experience report for Brevard County Board of County Commissioners (BOCC), Florida, detailing DHMO and DPPO insurance coverage from January through December 2024. The document provides comprehensive monthly enrollment data across four coverage tiers (Employee Only, Employee + Spouse, Employee + Child(ren), and Employee + Family) for both DHMO and DPPO products, showing consistent enrollment numbers ranging between 695-718 subscribers for DHMO and 3,440-3,467 subscribers for DPPO throughout the year.
The report includes detailed financial metrics such as billed premiums, total subscribers, and total members, with the DHMO product generating $165,230 in total premiums for 8,538 subscribers and the DPPO product generating $2,154,972 in total premiums for 41,397 subscribers. The DPPO claims experience shows varying monthly loss ratios from 58.4% to 95.0%, with total annual claims of $1,723,811 split between in-network ($1,514,574) and out-of-network ($209,238) claims. The data suggests stable enrollment and consistent healthcare utilization patterns for Brevard County's employee health insurance programs.
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 .