Exhibit_L_-_Medical_Discount_Pricing_File_(3_TABS_TO_COMPLETE,_DO_NOT_SUBMIT)_FINAL.xlsx

XLSX spreadsheet 46 KB Posted

Attached to
25-P-115TF Self-Funded Group Health Plan Administrative Services
Solicitation number
25-P-115TF
Issued by
Volusia County, Florida

About this file

Exhibit L - Medical Discount Pricing File for Volusia County, Florida Self-Funded Group Health Plan Administrative Services

This is a medical claims re-pricing exhibit prepared for the Volusia County, Florida RFP 25-P-115TF for self-funded group health plan administrative services. The document contains detailed claims data incurred from January 1, 2024 through December 31, 2024, with payments processed through February 28, 2025. The file is organized into three primary sections—Facility, Ancillary, and Professional services—and presents historical claims information by provider, service type, and visit category to establish baseline pricing benchmarks for proposal evaluation. Bidders are instructed to use this data to calculate their aggregate allowed amounts and average discount percentages, which must be transferred to Exhibit B, Section 8, Item 2 of their proposals.

The facility services section documents $57.78 million in total billed amounts across 11,604 inpatient admits and outpatient/emergency room visits, with major providers including AdventHealth Daytona Beach, AdventHealth Orlando, and Orlando Health Inc. Ancillary services total $6.78 million in billed claims covering radiology ($991,676), laboratory ($5.44 million), and durable medical equipment ($351,339). Professional services claims total $14.55 million, encompassing primary care and specialist office visits ($11.48 million) and ancillary professional services including anesthesiology, emergency medicine, and pathology ($3.07 million). All service categories currently show 100% discount percentages with zero allowed amounts, indicating this is a template requiring bidders to complete pricing information. The combined total billed amount across all three categories is $79.11 million, representing the claims experience baseline for the approximately 3,047 total subscribers covered under the county's self-funded plan.

View the file

Other files

File Type Posted
25-P-115TF_Self-Funded_Group_Health_Plan_Administrative_Services_(Addendum_#6_Revision).pdf PDF
25-P-115TF_Self-Funded_Group_Health_Plan_Administrative_Services.pdf PDF
Exhibit_D_-_Insurance_Requirements_(For_DRAFT_Contract)_FINAL_.pdf PDF
25-P-115TF_Self-Funded_Group_Health_Plan_Admin_Srvs_Agreement_FINAL_DRAFT.pdf PDF
Exhibit_M_-_Pharmacy_Claims_Pricing_File_(1_TAB_TO_COMPLETE,_DO_NOT_SUBMIT)_FINAL.xlsx XLSX spreadsheet
Exhibit_L_-_Medical_Discount_Pricing_File_(3_TABS_TO_COMPLETE,_DO_NOT_SUBMIT)_FINAL.xlsx XLSX spreadsheet
Exhibit_K_–_Medical_Claims_Pricing_File_(3_TABS_TO_COMPLETE,_DO_NOT_SUBMIT)_FINAL.xlsx XLSX spreadsheet
Exhibit_J_-_Large_Claims_2022-2024_(3_TABS_to_VIEW)_FINAL.xlsx XLSX spreadsheet
Exhibit_I_-_Census_(3_TABS_to_VIEW)_FINAL.xlsx XLSX spreadsheet
Exhibit_H_-_Claims_Experience_(2_TABS_to_VIEW)_FINAL.xlsx XLSX spreadsheet
Exhibit_G_-_County_Computing_Security_Procedures_FINAL.pdf PDF
Exhibit_F_-_HIPPA_Business_Associate_Agreement_FINAL.pdf PDF
Exhibit_E_-_Human_Trafficking_Affidavit_FINAL.pdf PDF
Exhibit_C_-_Summary_Plan_Document_(2025)_FINAL.pdf PDF
Attachment_B.1_Pharmacy_Pricing_Guarantees_(1_TAB_TO_COMPLETE)_FINAL.xlsx XLSX spreadsheet
Exhibit_B_-_Fees_and_Performance_Guarantees_FINAL.docx DOCX document
Exhibit_A.4_-_Onsite_Job_Descriptions_FINAL.pdf PDF
Exhibit_A.3_-_Claims_Reporting_Fields_FINAL.pdf PDF
Attachment_A.2_-_Network_and_Formulary_Disruption_(4_TABS_TO_COMPLETE)_FINAL.xlsx XLSX spreadsheet
Attachment_A.1_-_Worksheet_Health_Plan_Administrative_Services_FINAL.docx DOCX document
Exhibit_A_-_Scope_of_Services_FINAL.pdf PDF
Show all 21

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Facility Health Plan Administrative Services

Facility Services
Incurred: 01/01/2024 - 12/31/2024
Paid: 01/01/2024 - 02/28/2025

MEDICAL CLAIMS RE-PRICING - CONFIDENTIAL - DO NOT SUBMIT THIS INFORMATION WITH YOUR PROPOSAL

FACILITY PRICING

InpatientInpatient
FacilityBilled AmountAdmitsAllowed AmountDiscount %
ADVENTHEALTH DAYTONA BCH$4,369,379119100%
ADVENTHEALTH ORLANDO$2,948,49146100%
ORLANDO HLTH INC$2,448,63040100%
HCA FL LK MONROE HSP$1,891,90610100%
ADVENTHEALTH FISH MEML$1,853,71540100%
All Others$7,114,607130100%
Total Facility Inpatient$20,626,729385$0100%
Emergency RoomER
FacilityER Billed AmountER VisitsAllowed AmountDiscount %
ADVENTHEALTH DAYTONA BCH$3,413,883487100%
ADVENTHEALTH DELAND$1,742,518222100%
ADVENTHEALTH FISH MEML$1,690,557229100%
HALIFAX MED CTR$1,271,872158100%
ADVENTHEALTH NEW SMYRNA$767,34499100%
All Others$2,720,435446100%
Total$11,606,6091,641$0100%
OutpatientOutpatient
FacilityOutpatient Billed AmountOutpatient VisitsAllowed AmountDiscount %
ADVENTHEALTH DAYTONA BCH$2,638,455604100%
ADVENTHEALTH DELAND$2,230,357757100%
ADVENTHEALTH NEW SMYRNA$1,590,987348100%
ADVENTHEALTH FISH MEML$983,250273100%
ADVENTHEALTH ORLANDO$784,396126100%
All Others$16,563,5835,187100%
Total$24,791,0277,295$0100%
Urgent CareUrgent Care
FacilityBilled AmountVisitsAllowed AmountDiscount %
All Urgent Care Facilities$755,9272,283100%
Total$755,9272,283$0100%
Total Billed Amount$57,780,293Please transfer your Company's aggregate allowed amount and tabulated average discount to Exhibit B, Section 8, Item 2.
Total Allowed Amount$0
Average Discount100.00%

&"Arial,Bold"25-P-115TF &"Arial,Bold"Exhibit L - Medical Discount Pricing File (Facility)

&"Arial,Regular"Page &P of &N

Ancillary Health Plan Administrative Services

Ancillary
Incurred: 01/01/2024 - 12/31/2024
Paid: 01/01/2024 - 02/28/2025

MEDICAL CLAIMS RE-PRICING - CONFIDENTIAL - DO NOT SUBMIT THIS INFORMATION WITH YOUR PROPOSAL

ANCILLARY PRICING

Ancillary Type Billed Amount Visits Allowed Amount Discount %

RadiologyRadiology
All Radiology$991,6763,326100%
LaboratoryLaboratory
All Laboratory$5,439,8228,138100%
Durable Medical EquipmentDurable Medical Equipment
All DME$351,339915100%
Total Billed Amount$6,782,836Please transfer your Company's aggregate allowed amount and tabulated average discount to Exhibit B, Section 8, Item 2.
Total Allowed Amount$0
Average Discount100.00%

&"Arial,Bold"25-P-115TF &"Arial,Bold"Exhibit L - Medical Discount Pricing File (Ancillary)

&"Arial,Regular"Page &P of &N

Professional Health Plan Administrative Services

Professional Services
Incurred: 01/01/2024 - 12/31/2024
Paid: 01/01/2024 - 02/28/2025

MEDICAL CLAIMS RE-PRICING - CONFIDENTIAL - DO NOT SUBMIT THIS INFORMATION WITH YOUR PROPOSAL

PROFESSIONAL PRICING

Primary Care & SpecialistPCP & Specialist
PhysiciansBilled AmountVisitsAllowed AmountDiscount %
Primary Care Office Visits$1,975,4856,597100%
Specialty Care Office Visits$9,500,37816,490100%

Subtotal Primary Care & Specialist $11,475,864 23,087 $0 100%

Ancillary ProfessionalAncillary Professional
Ancillary Professional TypeBilled AmountVisitsAllowed AmountDiscount %
Anesthesiology$408,025210100%
Emergency Medicine$2,316,7311,549100%
Pathology$348,203832100%

Subtotal Ancillary Professional $3,072,959 2,591 $0 100%

Total Billed Amount$14,548,822Please transfer your Company's aggregate allowed amount and tabulated average discount to Exhibit B, Section 8, Item 2.
Total Allowed Amount$0
Average Discount100.00%

&"Arial,Bold"25-P-115TF &"Arial,Bold"Exhibit L - Medical Discount Pricing File (Professional)

&"Arial,Bold"Page &P of &N

File details come from the government source that posted it. Updated .