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

Other files attached to Brevard County Group Dental Plan, newest first.
File Type Posted
RFP_Selection_Committee_Consolidated_Scoresheet.pdf PDF
Attachment_B_WORD_-_Proposal_Worksheet.docx DOCX document
Addendum_4.pdf PDF
Attachment_B_WORD_-_Proposal_Worksheet.docx DOCX document
Addendum_3.pdf PDF
Addendum_3.pdf PDF
Addendum_3.pdf PDF
Addendum_2.pdf PDF
Addendum_2.pdf PDF
Addendum_1.pdf PDF
Revised_Exhibit_A_-_Census.xlsx XLSX spreadsheet
Revised_Exhibit_A_-_Census.xlsx XLSX spreadsheet
Exhibit_B1-Ben_Sum_DPPOH_01.01.2025_Brevard_County_Board_of_County_Commissioners_3308988.pdf PDF
Exhibit_B2-Ben_Sum_DPPOL_01.01.2025_Brevard_County_Board_of_County_Commissioners_3308988.pdf PDF
Exhibit_B6-DPPO_Low_Plan_Certificate_of_Coverage.pdf PDF
Attachment_B_-_Proposal_Worksheet.pdf PDF
Exhibit_B4-DHMO_Schedule_of_Benefits.pdf PDF
Exhibit_C2-BREVARD_COUNTY_BOCC_FL_exp_pkg.xls XLS spreadsheet
Attachment_B_-_Proposal_Worksheet.pdf PDF
Attachment_C_-_Network_and_Procedure_Compare.xlsx XLSX spreadsheet
Exhibit_B3-DHMO_Certificate_of_Coverage.pdf PDF
Exhibit_C1-Brevard_BOCC_2024_DPPO_DHMO_Cigna.xls XLS spreadsheet
Attachment_B_-_Proposal_Worksheet.pdf PDF
Exhibit_B3-DHMO_Certificate_of_Coverage.pdf PDF
Exhibit_B6-DPPO_Low_Plan_Certificate_of_Coverage.pdf PDF
Exhibit_B5-DPPO_High_Plan_Certificate_of_Coverage.pdf PDF
Exhibit_B6-DPPO_Low_Plan_Certificate_of_Coverage.pdf PDF
Exhibit_C2-BREVARD_COUNTY_BOCC_FL_exp_pkg.xls XLS spreadsheet
Attachment_B_-_Proposal_Worksheet.pdf PDF
Exhibit_B2-Ben_Sum_DPPOL_01.01.2025_Brevard_County_Board_of_County_Commissioners_3308988.pdf PDF
Exhibit_B3-DHMO_Certificate_of_Coverage.pdf PDF
Exhibit_B4-DHMO_Schedule_of_Benefits.pdf PDF
Exhibit_B5-DPPO_High_Plan_Certificate_of_Coverage.pdf PDF
Exhibit_B6-DPPO_Low_Plan_Certificate_of_Coverage.pdf PDF
Exhibit_D_-_Draft_Contract.pdf PDF
Attachment_C_-_Network_and_Procedure_Compare.xlsx XLSX spreadsheet
Exhibit_A_-_Census.pdf PDF
Exhibit_B4-DHMO_Schedule_of_Benefits.pdf PDF
Exhibit_C1-Brevard_BOCC_2024_DPPO_DHMO_Cigna.xls XLS spreadsheet
Exhibit_C3-Dental_Utilization_Report_2023_2024.pdf PDF
Exhibit_D_-_Draft_Contract.pdf PDF
Attachment_A_-_Mandatory_Features_Checklist.pdf PDF
Exhibit_D_-_Draft_Contract.pdf PDF
Exhibit_B3-DHMO_Certificate_of_Coverage.pdf PDF
Exhibit_D_-_Draft_Contract.pdf PDF
Exhibit_B3-DHMO_Certificate_of_Coverage.pdf PDF
Exhibit_A_-_Census.pdf PDF
Exhibit_C3-Dental_Utilization_Report_2023_2024.pdf PDF
Attachment_A_-_Mandatory_Features_Checklist.pdf PDF
Attachment_C_-_Network_and_Procedure_Compare.xlsx XLSX spreadsheet
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/MONTHPRODUCT TYPEEMPLOYEE ONLYEMPLOYEE + SPOUSEEMPLOYEE + CHILD(REN)EMPLOYEE + FAMILYEMPLOYEE TOTAL
Jan-24DHMO4091494790695
Jan-2024 Total4091494790695
Feb-24DHMO4181505189708
Feb-2024 Total4181505189708
Mar-24DHMO4221525389716
Mar-2024 Total4221525389716
Apr-24DHMO4181525289711
Apr-2024 Total4181525289711
May-24DHMO4191495192711
May-2024 Total4191495192711
Jun-24DHMO4251485291716
Jun-2024 Total4251485291716
Jul-24DHMO4261505289717
Jul-2024 Total4261505289717
Aug-24DHMO4271525089718
Aug-2024 Total4271525089718
Sep-24DHMO4291505088717
Sep-2024 Total4291505088717
Oct-24DHMO4261495187713
Oct-2024 Total4261495187713
Nov-24DHMO4261495086711
Nov-2024 Total4261495086711
Dec-24DHMO4221485186707
Dec-2024 Total4221485186707
PRODUCT TYPE TotalsDHMO5,0671,7986101,0658,540
Grand Total5,0671,7986101,0658,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/MONTHPRODUCT TYPEEMPLOYEE ONLYEMPLOYEE + SPOUSEEMPLOYEE + CHILD(REN)EMPLOYEE + FAMILYEMPLOYEE TOTAL
Jan-24DPPO1,7596974605243,440
Jan-2024 Total1,7596974605243,440
Feb-24DPPO1,7716964585213,446
Feb-2024 Total1,7716964585213,446
Mar-24DPPO1,7786964585193,451
Mar-2024 Total1,7786964585193,451
Apr-24DPPO1,7736984585163,445
Apr-2024 Total1,7736984585163,445
May-24DPPO1,7846984535173,452
May-2024 Total1,7846984535173,452
Jun-24DPPO1,7847014515203,456
Jun-2024 Total1,7847014515203,456
Jul-24DPPO1,7867074515163,460
Jul-2024 Total1,7867074515163,460
Aug-24DPPO1,7997034485173,467
Aug-2024 Total1,7997034485173,467
Sep-24DPPO1,7937004525133,458
Sep-2024 Total1,7937004525133,458
Oct-24DPPO1,8007014545093,464
Oct-2024 Total1,8007014545093,464
Nov-24DPPO1,8007064564933,455
Nov-2024 Total1,8007064564933,455
Dec-24DPPO1,7997034504953,447
Dec-2024 Total1,7997034504953,447
PRODUCT TYPE TotalsDPPO21,4268,4065,4496,16041,441
Grand Total21,4268,4065,4496,16041,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/MONTHPRODUCT TYPEBILLED PREMIUMTOTAL SUBSTOTAL MBRS
Jan-24DHMO$13,5296951,160
Jan-2024 Total$13,5296951,160
Feb-24DHMO$13,7327081,175
Feb-2024 Total$13,7327081,175
Mar-24DHMO$13,8837161,190
Mar-2024 Total$13,8837161,190
Apr-24DHMO$13,8087111,185
Apr-2024 Total$13,8087111,185
May-24DHMO$13,8277111,198
May-2024 Total$13,8277111,198
Jun-24DHMO$13,8667161,201
Jun-2024 Total$13,8667161,201
Jul-24DHMO$13,8597161,197
Jul-2024 Total$13,8597161,197
Aug-24DHMO$13,8767171,194
Aug-2024 Total$13,8767171,194
Sep-24DHMO$13,8147171,189
Sep-2024 Total$13,8147171,189
Oct-24DHMO$13,7377131,181
Oct-2024 Total$13,7377131,181
Nov-24DHMO$13,6777111,175
Nov-2024 Total$13,6777111,175
Dec-24DHMO$13,6237071,172
Dec-2024 Total$13,6237071,172
PRODUCT TYPE TotalsDHMO$165,2308,53814,217
Grand Total$165,2308,53814,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/MONTHPRODUCT TYPEIN NETWORKOUT OF NETWORKTOTAL CLAIMSBILLED PREMIUMTOTAL LOSS RATIOTOTAL SUBSTOTAL MBRS
Jan-24DPPO$135,648$18,691$154,339$180,03485.7%3,4396,520
Jan-2024 Total$135,648$18,691$154,339$180,03485.7%3,4396,520
Feb-24DPPO$127,875$13,152$141,027$179,57178.5%3,4456,507
Feb-2024 Total$127,875$13,152$141,027$179,57178.5%3,4456,507
Mar-24DPPO$138,302$21,954$160,256$179,76689.1%3,4486,496
Mar-2024 Total$138,302$21,954$160,256$179,76689.1%3,4486,496
Apr-24DPPO$128,640$21,293$149,932$179,58383.5%3,4426,485
Apr-2024 Total$128,640$21,293$149,932$179,58383.5%3,4426,485
May-24DPPO$129,327$22,108$151,435$179,98584.1%3,4476,479
May-2024 Total$129,327$22,108$151,435$179,98584.1%3,4476,479
Jun-24DPPO$145,513$15,496$161,009$180,31489.3%3,4526,490
Jun-2024 Total$145,513$15,496$161,009$180,31489.3%3,4526,490
Jul-24DPPO$119,642$18,200$137,842$180,09076.5%3,4546,484
Jul-2024 Total$119,642$18,200$137,842$180,09076.5%3,4546,484
Aug-24DPPO$151,076$20,298$171,374$180,30195.0%3,4586,477
Aug-2024 Total$151,076$20,298$171,374$180,30195.0%3,4586,477
Sep-24DPPO$112,130$14,658$126,788$179,68370.6%3,4496,460
Sep-2024 Total$112,130$14,658$126,788$179,68370.6%3,4496,460
Oct-24DPPO$116,260$17,933$134,193$179,49074.8%3,4636,469
Oct-2024 Total$116,260$17,933$134,193$179,49074.8%3,4636,469
Nov-24DPPO$117,360$14,397$131,757$178,22973.9%3,4546,430
Nov-2024 Total$117,360$14,397$131,757$178,22973.9%3,4546,430
Dec-24DPPO$92,801$11,057$103,859$177,92558.4%3,4466,414
Dec-2024 Total$92,801$11,057$103,859$177,92558.4%3,4466,414
PRODUCT TYPE TotalsDPPO$1,514,574$209,238$1,723,811$2,154,97280.0%41,39777,711
Grand Total$1,514,574$209,238$1,723,811$2,154,97280.0%41,39777,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 .