Exhibit_L_-_Medical_Discount_Pricing_File_(3_TABS_TO_COMPLETE,_DO_NOT_SUBMIT)_FINAL.xlsx
XLSX spreadsheet 46 KB Posted
- 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
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
| Inpatient | Inpatient | |||
| Facility | Billed Amount | Admits | Allowed Amount | Discount % |
| ADVENTHEALTH DAYTONA BCH | $4,369,379 | 119 | 100% | |
| ADVENTHEALTH ORLANDO | $2,948,491 | 46 | 100% | |
| ORLANDO HLTH INC | $2,448,630 | 40 | 100% | |
| HCA FL LK MONROE HSP | $1,891,906 | 10 | 100% | |
| ADVENTHEALTH FISH MEML | $1,853,715 | 40 | 100% |
| All Others | $7,114,607 | 130 | 100% | |
| Total Facility Inpatient | $20,626,729 | 385 | $0 | 100% |
| Emergency Room | ER | |||
| Facility | ER Billed Amount | ER Visits | Allowed Amount | Discount % |
| ADVENTHEALTH DAYTONA BCH | $3,413,883 | 487 | 100% | |
| ADVENTHEALTH DELAND | $1,742,518 | 222 | 100% | |
| ADVENTHEALTH FISH MEML | $1,690,557 | 229 | 100% | |
| HALIFAX MED CTR | $1,271,872 | 158 | 100% | |
| ADVENTHEALTH NEW SMYRNA | $767,344 | 99 | 100% |
| All Others | $2,720,435 | 446 | 100% | |
| Total | $11,606,609 | 1,641 | $0 | 100% |
| Outpatient | Outpatient | |||
| Facility | Outpatient Billed Amount | Outpatient Visits | Allowed Amount | Discount % |
| ADVENTHEALTH DAYTONA BCH | $2,638,455 | 604 | 100% | |
| ADVENTHEALTH DELAND | $2,230,357 | 757 | 100% | |
| ADVENTHEALTH NEW SMYRNA | $1,590,987 | 348 | 100% | |
| ADVENTHEALTH FISH MEML | $983,250 | 273 | 100% | |
| ADVENTHEALTH ORLANDO | $784,396 | 126 | 100% |
| All Others | $16,563,583 | 5,187 | 100% | |
| Total | $24,791,027 | 7,295 | $0 | 100% |
| Urgent Care | Urgent Care | |||
| Facility | Billed Amount | Visits | Allowed Amount | Discount % |
| All Urgent Care Facilities | $755,927 | 2,283 | 100% | |
| Total | $755,927 | 2,283 | $0 | 100% |
| Total Billed Amount | $57,780,293 | Please transfer your Company's aggregate allowed amount and tabulated average discount to Exhibit B, Section 8, Item 2. |
| Total Allowed Amount | $0 | |
| Average Discount | 100.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 %
| Radiology | Radiology | |||
| All Radiology | $991,676 | 3,326 | 100% |
| Laboratory | Laboratory | |||
| All Laboratory | $5,439,822 | 8,138 | 100% |
| Durable Medical Equipment | Durable Medical Equipment | |||
| All DME | $351,339 | 915 | 100% |
| Total Billed Amount | $6,782,836 | Please transfer your Company's aggregate allowed amount and tabulated average discount to Exhibit B, Section 8, Item 2. |
| Total Allowed Amount | $0 | |
| Average Discount | 100.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 & Specialist | PCP & Specialist | |||
| Physicians | Billed Amount | Visits | Allowed Amount | Discount % |
| Primary Care Office Visits | $1,975,485 | 6,597 | 100% | |
| Specialty Care Office Visits | $9,500,378 | 16,490 | 100% |
Subtotal Primary Care & Specialist $11,475,864 23,087 $0 100%
| Ancillary Professional | Ancillary Professional | |||
| Ancillary Professional Type | Billed Amount | Visits | Allowed Amount | Discount % |
| Anesthesiology | $408,025 | 210 | 100% | |
| Emergency Medicine | $2,316,731 | 1,549 | 100% | |
| Pathology | $348,203 | 832 | 100% |
Subtotal Ancillary Professional $3,072,959 2,591 $0 100%
| Total Billed Amount | $14,548,822 | Please transfer your Company's aggregate allowed amount and tabulated average discount to Exhibit B, Section 8, Item 2. |
| Total Allowed Amount | $0 | |
| Average Discount | 100.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 .