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

This is a Medical Discount Pricing File (Exhibit L) supporting Volusia County, Florida's RFP 25-P-115TF for self-funded group health plan administrative services, effective January 1, 2027. The file contains historical medical claims data from the plan year incurred January 1, 2024 through December 31, 2024, with payments processed through February 28, 2025. The data is organized into three primary service categories: facility services (inpatient, emergency room, outpatient, and urgent care), ancillary services (radiology, laboratory, and durable medical equipment), and professional services (primary care, specialty care, anesthesiology, emergency medicine, and pathology). The file documents actual claims experience across multiple providers and service types to establish baseline pricing for competitive bidding purposes.

The total billed amount across all service categories reached $57.78 million for facility services, $6.78 million for ancillary services, and $14.55 million for professional services, with a combined total of approximately $79.11 million in medical claims. The file presents facility-specific data for major providers including AdventHealth locations, Orlando Health Inc., HCA Florida Lake Monroe Hospital, and Halifax Medical Center, reflecting the plan's approximately 3,047 total subscribers across four coverage tiers. All line items in the file display a 100% discount percentage with $0 allowed amounts, indicating this is a template document requiring the selected vendor to complete pricing by transferring aggregate allowed amounts and tabulated average discount percentages to Exhibit B, Section 8, Item 2. The data is marked confidential and explicitly states it should not be submitted with proposals, serving instead as reference information for respondents to develop their pricing proposals.

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 .