ATTM 008.xlsx
XLSX spreadsheet 43 KB Posted
- Attached to
- MEDICAID CLINICAL DATA EXCHANGE
- Solicitation number
- 5400030026
- Issued by
- Richland County, South Carolina
About this file
This is a price proposal and pricing tables spreadsheet for the Medicaid Clinical Data Exchange Solution, a procurement by the South Carolina Department of Health and Human Services (SCDHHS). The project encompasses implementation and operations phases for a clinical data exchange system designed to process Admission/Discharge/Transfer (ADT) data and Bed Status information from healthcare providers into the Medicaid system. Vendors are required to submit bids for all line items across each tab of the pricing tables, or their offers will be deemed non-responsive. The contract term spans seven years, consisting of four base years and three optional years. Implementation activities include completion of a Requirements Traceability Matrix (RTM), User Acceptance Testing (UAT), system go-live, and onboarding of licensed hospitals to transmit data. Bed Status implementation requires design, configuration, testing, validation, and deployment of all required data sources.
The pricing structure consists of four primary cost components: implementation costs, operations costs for ADT functionality, operations costs for Bed Status functionality, and a modification pool capped at $2,500,000 for scope changes requested by the agency during the maintenance and operations phase. Operations pricing for ADT is calculated based on a monthly cost per member applied to an estimated 438,968 members across the contract years, plus costs for onboarding new contributors and subscribers. Bed Status operations are priced as a fixed monthly cost with an annual calculation over the seven-year contract term. The modification pool requires agency approval prior to use and is governed by the rate card provided by the vendor. Vendors must complete a rate card identifying hourly rates for various roles to support potential scope change requests. All pricing calculations automatically populate in yellow cells based on vendor inputs, with the total all-inclusive evaluated price used for bid comparison and evaluation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amendment 1.pdf | ||
| Amendment 2.pdf | ||
| PL 001.pdf | ||
| ATTM 003.pdf | ||
| ATTM 005.pdf | ||
| PL 005.pdf | ||
| ATTM 013.xlsx | XLSX spreadsheet | |
| ATTM 004.pdf | ||
| ATTM 025.pdf | ||
| ATTM 019.pdf | ||
| ATTM 018.pdf | ||
| ATTM 023.pdf | ||
| PL 004.pdf | ||
| ATTM 017.pdf | ||
| ATTM 010.pdf | ||
| PL 002.pdf | ||
| ATTM 002.pdf | ||
| ATTM 007.pdf | ||
| ATTM 022(b).xlsx | XLSX spreadsheet | |
| ATTM 020.pdf | ||
| ATTM 001.pdf | ||
| ATTM 014.pdf | ||
| ATTM 012.xlsx | XLSX spreadsheet | |
| ATTM 011.pdf | ||
| ATTM 021.pdf | ||
| ATTM 016.pdf | ||
| ATTM 009.xlsx | XLSX spreadsheet | |
| ATTM 022(a).pdf | ||
| _MCDE RFP.pdf | ||
| ATTM 015.pdf | ||
| ATTM 006.pdf | ||
| ATTM 024.pdf | ||
| PL 003.pdf |
Show all 33
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
1 - Directions
ATTM 008
MEDICAID CLINICAL DATA EXCHANGE SOLUTION
PRICE PROPOSAL AND PRICING TABLES
| Directions |
| A bid is required and must be received for every line item on each tab or your offer will be considered non-responsive and will not be accepted. |
| This completed spreadsheet should be saved and attached as an Excel file online with your offer. |
| Use the Cell Color Key below to identify what actions, if any, to take on each tab of the Pricing Tables. (Keys are included at the bottom of every tab for ease of use) |
| Cell Color Key |
| TAN cells include directions and information. |
| GREEN cells indicate a required field. A response is required for all cells in GREEN. |
| YELLOW cells will automatically calculate based on input. |
| WHITE cells should be left blank. |
&A
2 - Implementation
TOTAL COST FOR IMPLEMENTATION PHASE
Vendor Name:
Notes
All-inclusive implementation cost $ - 0 This amount is calculated from the payment milestones below and is used to calculate the Total All-Inclusive Price in Tab 5 - Total
| ADT | ||
| Payment Milestones | Amount | Completion Criteria |
Requirements Approval (ADT) Requirements Traceability Matrix (RTM) populated and all requirements signed off and approved.
User Acceptance Testing (UAT) Complete Exit Critiera for UAT met and system approved to proceed to Go Live.
System Go-Live Exit Critiera for Go-Live met and project shifts into Maintenance & Operations phase.
50% Licensed Hospitals onboarded and transmitting data.
| BED STATUS | ||
| Payment Milestones | Amount | Completion Criteria |
Bed Status All required Bed Status data sources are designed, configured, tested, validated, and deployed, and Bed Status functionality is approved by SCDHHS for operational use.
| Notes: |
| Implementation cost shall include ADT and Bed Status implementation efforts unless otherwise itemized within the milestone table. |
| Cell Color Key |
| TAN cells include directions and information. |
| GREEN cells indicate a required field. A response is required for all cells in GREEN. |
| YELLOW cells will automatically calculate based on input. |
| WHITE cells should be left blank. |
3A - Operations (ADT)
| TOTAL COST FOR OPERATIONS PHASE (ADT) | |
| Vendor Name: | 0 |
Total Estimated Operational Cost $ - 0
| Year | Monthly Cost | |
| per Member | Estimated | |
| Members | Cost per | |
| New Contributer | Estimated New | |
| Contributers (NTE) | Cost per | |
| New Subscriber | Estimated New | |
| Subscribers (NTE) | Calculated |
Cost per Year
| Base Year 1 | 438,968 | 56 | 5 | $ - 0 |
| Base Year 2 | 438,968 | 56 | 5 | $ - 0 |
| Base Year 3 | 438,968 | 56 | 5 | $ - 0 |
| Base Year 4 | 438,968 | 56 | 5 | $ - 0 |
| Option Year 5 | 438,968 | 56 | 5 | $ - 0 |
| Option Year 6 | 438,968 | 56 | 5 | $ - 0 |
| Option Year 7 | 438,968 | 56 | 5 | $ - 0 |
| Turnover Complete | ||||
| Notes: | ||||
| Estimated Members total is the 2-year average of total unique members with at least one admission-side event for SFY's 2022-2023 and 2023-2024. Totals are based on SCDHHS FFS and MCO claims data. | ||||
| Estimated Members are not intended to guarantee any service level and are provided for evalutation purposes only. | ||||
| Additional information about total SCDHHS enrollment can be found on the SCDHHS Medicaid Enrollment Dashboard: https://www.scdhhs.gov/partners/reports-and-statistics/medicaid-enrollment-dashboard. | ||||
| Cost per New Contributer and Cost per New Subscriber are for the onboarding of new additions and not the total number of Contributors or Subscribers per year. NTE = Not to Exceed. | ||||
| Cost is calculated as (Monthly Cost per Member * Estimated Members * 12 months) + (Cost Per New Contributer * Estimated New Contributers (NTE)) + (Cost per New Subscriber * Estimated New Subscribers (NTE)). |
| Assumptions |
| Estimated New Contributers are Not To Exceed estimates. |
| Estimated New Subscribers are Not To Exceed estimates. |
| Monthly Cost per Member should decrease over time as solution matures. |
| Contributer integration cost should decrease over time as solution matures. |
| Subscriber integration cost should decrease over time as solution matures. |
| Cell Color Key |
| TAN cells include directions and information. |
GREEN cells indicate a required field. A response is required for all cells in GREEN.
YELLOW cells will automatically calculate based on input.
WHITE cells should be left blank.
3B - Operations (Bed Status)
| TOTAL COST FOR OPERATIONS PHASE (Bed Status) | ||
| Operations - Bed Status | Price | Notes |
Fixed Monthly Price Monthly cost to operate and support Bed Status during the O&M period.
Months Per Year 12 Fixed value used to calculate the annual operating cost.
Fixed Annual Price $0.0 Automatically calculated annual O&M cost for Bed Status.
Contract Term Years 7 Number of years used to compute the total contract‑term O&M cost.
Contract Term Price $0.0 Total Bed Status operating cost over the full contract term.
| Notes: |
| The Fixed Monthly Price shall include all operational effort required to maintain Bed Status data ingestion, validation, integration, monitoring, and support. |
| Bed Status O&M costs shall remain fixed throughout the contract.. |
| Cell Color Key |
| TAN cells include directions and information. |
GREEN cells indicate a required field. A response is required for all cells in GREEN.
YELLOW cells will automatically calculate based on input.
WHITE cells should be left blank.
4 - Rate Card
| RATE CARD |
| Rates provided in this sheet shall be used to estimate cost of modifications made to the contract due to scope changes requested by the agency . Offerors shall include all cost necessary to delivery the scope of the RFP within Tab 2 - Implementation and Tabs 3A and 3B - Operations. Additional work defined as scope changes shall be subject to this rate card and limited to the modification pool defined on Tab 5 - Total. |
Offerors are encouraged to include roles necessary for the delivery of the scope of work defined in this RFP so that such resources can be included for any subsequent change orders.
Vendor Name: 0
Roles Hourly Rate Qualifications
| Cell Color Key |
| TAN cells include directions and information. |
| GREEN cells indicate a required field. A response is required for all cells in GREEN. |
| YELLOW cells will automatically calculate based on input. |
| WHITE cells should be left blank. |
5 - Total
TOTAL ALL-INCLUSIVE EVALUATED PRICE
Vendor Name: 0
| Cost Area | Amount | Comments |
| Implementation | $ - 0 | Populated from cell B4 on sheet 2 - Implementation |
| Operations - ADT | $ - 0 | Populated from cell D4 on sheet 3A - Operations (ADT) |
| Operations - Bed Status | $ - 0 | Populated from cell D13 on sheet 3B - Operations (Bed Status) |
Modification Pool $ 2,500,000.00 Shall not exceed $2,500,000. Shall be used for modifications to the system during Maintenance & Operations. Use of Modificiation Pool funds requires agency approval prior to use and is subject to the rate card provided in Tab 4 - Rate Card.
TOTAL ALL-INCLUSIVE COST TO BE USED FOR EVALUATION: $ 2,500,000.00 Calculated as the sum of Implementation Total Amount, Operations Total Amount, and Modficiation Pool.
| Cell Color Key |
| TAN cells include directions and information. |
GREEN cells indicate a required field. A response is required for all cells in GREEN.
YELLOW cells will automatically calculate based on input.
WHITE cells should be left blank.
File details come from the government source that posted it. Updated .