Attachment 5_Price Worksheet (Lot 2) HT0038-21-R-0001.xlsx
XLSX spreadsheet 25 KB Posted
- Solicitation number
- HT003821R0001B
- Issued by
-
Defense Health Agency
About this file
This document package includes an Excel price worksheet template and instructions for a federal contract opportunity. The price worksheet template is to be used by offerors to provide pricing for an Accelerator Task Order under solicitation number HT0038-21-R0001. The instructions specify that offerors are to input unit prices, quantities, and total amounts by requirement in the provided template. Pricing is to be provided at the Contract Line Item Number level for the Accelerator Task Order, which is for Workforce 3.0 managed services and solutions to support the Defense Health Agency. Additional details provided in the document include the period of performance for Lot 2, the small business set-aside designation, and that pricing should be provided using inflated then-year dollars.
View the file
Other files
Show all 22
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_Instructions Price Worksheet: Table of Contents and Instructions
| # | Category / Worksheet name | Description / Instruction | ||
| 1 | 1_Instructions | Provide all values in inflated Then-Year (TY) Dollars. | ||
| General Information | The [PEO DHMS WBS] tab is included for informational purposes and do not require Offeror input. | |||
| Cell formulas must be used and operational. Modifications to Cell Formulas will result in the Offeror proposal being evaluated as Unacceptable. | ||||
| All Offeror entries shall be numeric values and not include formulas or internal/external references. | ||||
| Ensure all worksheets include all information required by the SF1449, 52.212-1. | ||||
| Offerors shall input values for cells under green header columns. Blue header columns have been pre-populated by the Government. | ||||
| Do not include any additional rows that are not requested by the Government. | ||||
| Offeror Input Sheets | 2 | 2_Accelerator | a. | Offeror shall use this worksheet to provide a catalog price for the [Accelerator Task Order]. |
| b. | For each existing entry row, reference a single Source, Proposal Date, Period Start Date, Small Business Type, Total Amount. |
&"Arial,Regular"&9DHMSM Cost-Price Evaluation Template &"Arial,Regular"&9&A
&"Arial,Regular"&9Solicitation Number: HT0038-19-R-0002 &"Arial,Regular"&9Attachment 6 &"Arial,Regular"&9&P
2_Accelerator
| Source | Proposal Date (MM/DD/YYYY) | Requirement # | Requirement Description | Type | |||||||||||||||||||
| (Labor, Materials, Travel, ODCs) | Task Order | Period # | |||||||||||||||||||||
| (e.g, Year, Lot #, etc.) | Period Start Date (MM/DD/YYYY) | Period Quantity | Period Unit | CLIN | CLIN Description | WBS | WBS Description | Workstream/Price ID | Workstream/Price ID Description | Entity (Name of Prime/Sub) | Small Business Type | Material Description | |||||||||||
| (if applicable) | Material Quantity | ||||||||||||||||||||||
| (if applicable) | Profit % | ||||||||||||||||||||||
| (calculated) | Profit | Total Amount | |||||||||||||||||||||
| Metztimates-SB, Inc. | HT003821R0001 | Workforce 3.0 | N/A (Total) | Accelerator Task Order | N/A | 1 | Each | 1001 | Accelerator Task Order | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | $100 |
Price Eval Table - Lot 2
| Offeror-Proposed Amounts | Proposed Amount | ||||
| (including Profit) | Potential | ||||
| Profit | Profit | ||||
| Percentage | CLIN | Catalog | |||
| Price | Contract Type | Price Evaluation | Completeness | Reasonableness | Unbalanced |
Pricing
| Small Business Task Order Lot | ||||||||||
| Accelerator Task Order | $ 100 | N/A | N/A | 1001 | Yes | FFP | Yes | Yes | Yes | Yes |
| Total Lot 1 | $ 100 | $ - 0 |
PEO DHMS WBS
| WBS | L | Title | Description | Comment |
| A.1 | 1 | DoD Healthcare Management System Modernization (DHMSM) - Segment One Investment | DHMSM Automated Information System (AIS). The complex of enterprise elements, equipment (hardware), software, legacy systems, users, business rules, data and facilities required to develop or configure, test and deploy DHMSM. This WBS element includes all elements and tasks common between Segment One and Segment Two, as well as all elements unique to Segment One. | |
| A.2 | 1 | DoD Healthcare Management System Modernization (DHMSM) - Segment Two Investment | DHMSM Automated Information System (AIS). The complex of enterprise elements, equipment (hardware), software, legacy systems, users, business rules, data and facilities required to develop or configure, test and deploy DHMSM. This WBS element includes all elements and tasks unique to Segment Two (Expeditionary environment). | |
| B.1 | 1 | Joint Operational Medicine Information System (JOMIS) Investment | JOMIS Automated Information System (AIS). The complex of enterprise elements, equipment (hardware), software, legacy systems, users, business rules, data and facilities required to develop or configure, test and deploy JOMIS. | |
| C.1 | 1 | Defense Medical Information Exchange (DMIX) Investment | DMIX Automated Information System (AIS). The complex of enterprise elements, equipment (hardware), software, legacy systems, users, business rules, data and facilities required to develop or configure, test and deploy DMIX. | |
| D.1 | 1 | integrated Electronic Health Record (iEHR) | iEHR Automated Information System (AIS). The complex of enterprise elements, equipment (hardware), software, legacy systems, users, business rules, data and facilities required to develop or configure, test and deploy iEHR. | |
| E.1 | 1 | DoD/VA Interagency Program Office (IPO) | The complex of enterprise elements, equipment (hardware), software, legacy systems, users, business rules, data and facilities required to execute the mission of the IPO. | |
| F.1 | 1 | Program Executive Office for Defense Healthcare Management Systems (PEO DHMS) | The complex of enterprise elements, equipment (hardware), software, legacy systems, users, business rules, data and facilities required to execute the mission of the PEO DHMS. | |
| x.1 | 2 | Prime Mission Product | Information Systems (IS) / Defense Business Systems (DBS) Development/Customization/Configuration |
See MIL STD 881 for definition
| x.1.1 | 3 | Custom Application 1…n (Specify) | See MIL STD 881 for definition |
| x.1.1.1 | 4 | Custom Application Hardware (Specify) | See MIL STD 881 for definition |
| x.1.1.2 | 4 | Custom Application Software CSCI 1…n (Specify) | See MIL STD 881 for definition |
| x.1.1.3 | 4 | Custom Application Integration, Assembly, Test, and Checkout | See MIL STD 881 for definition |
| x.1.2 | 3 | Enterprise Service Element 1…n (Specify) | See MIL STD 881 for definition |
| x.1.2.1 | 4 | Enterprise Service Element Hardware (Specify) | See MIL STD 881 for definition |
| x.1.2.2 | 4 | Enterprise Service Element Software CSCI 1…n (Specify) | See MIL STD 881 for definition |
| x.1.2.3 | 4 | Enterprise Service Element Integration, Assembly, Test, and Checkout | See MIL STD 881 for definition |
| x.1.3 | 3 | Enterprise Information Systems 1…n (Specify) | See MIL STD 881 for definition |
| x.1.3.1 | 4 | Business Area Hardware (Specify) | See MIL STD 881 for definition |
| x.1.3.2 | 4 | Business Area Software CSCI 1…n (Specify) | See MIL STD 881 for definition |
| x.1.3.3 | 4 | Business Area Integration, Assembly, Test, and Checkout | See MIL STD 881 for definition |
| x.1.4 | 3 | External System Interface Development 1…n (Specify) | See MIL STD 881 for definition |
| x.1.4.1 | 4 | External System Interface Hardware (Specify) | See MIL STD 881 for definition |
| x.1.4.2 | 4 | External System Interface Software CSCI 1…n (Specify) | See MIL STD 881 for definition |
| x.1.4.3 | 4 | External System Interface Integration, Assembly, Test, and Checkout | See MIL STD 881 for definition |
| x.1.5 | 3 | AIS Platform Hardware (Specify) | System Level Hardware |
See MIL STD 881 for definition
| x.1.6 | 3 | System Level Integration | See MIL STD 881 for definition |
| x.2 | 2 | System Engineering | See MIL STD 881 for definition |
| x.2.1 | 3 | Government System Engineering | See MIL STD 881 for definition |
| x.2.2 | 3 | Contractor System Engineering | See MIL STD 881 for definition |
| x.3 | 2 | Program Management | See MIL STD 881 for definition |
| x.3.1 | 3 | Government Program Management | See MIL STD 881 for definition |
| x.3.2 | 3 | Contractor Program Management | See MIL STD 881 for definition |
| x.4 | 2 | Change Management | See MIL STD 881 for definition |
| x.5 | 2 | System Test and Evaluation | See MIL STD 881 for definition |
| x.5.1 | 3 | Development Test and Evaluation | See MIL STD 881 for definition |
| x.5.2 | 3 | Operational Test and Evaluation | See MIL STD 881 for definition |
| x.5.3 | 3 | Mock-ups / System Integration Labs (SILs) | See MIL STD 881 for definition |
| x.5.4 | 3 | Test and Evaluation Support | See MIL STD 881 for definition |
| x.5.5 | 3 | Test Facilities | See MIL STD 881 for definition |
| x.6 | 2 | Training | See MIL STD 881 for definition |
| x.6.1 | 3 | Equipment | See MIL STD 881 for definition |
| x.6.2 | 3 | Services | See MIL STD 881 for definition |
| x.6.3 | 3 | Facilities | See MIL STD 881 for definition |
| x.7 | 2 | Data | See MIL STD 881 for definition |
| x.7.1 | 3 | Data Deliverables 1…n (Specify) | See MIL STD 881 for definition |
| x.7.2 | 3 | Data Repository | See MIL STD 881 for definition |
| x.7.3 | 3 | Data Rights 1…n (Specify) | See MIL STD 881 for definition |
| x.8 | 2 | Peculiar Support Equipment | See MIL STD 881 for definition |
| x.8.1 | 3 | Test and Measurement Equipment | See MIL STD 881 for definition |
| x.8.2 | 3 | Support and Handling Equipment | See MIL STD 881 for definition |
| x.9 | 2 | Common Support Equipment | See MIL STD 881 for definition |
| x.9.1 | 3 | Test and Measurement Equipment | See MIL STD 881 for definition |
| x.9.2 | 3 | Support and Handling Equipment | See MIL STD 881 for definition |
| x.10 | 2 | Operational/Site Activation by Site 1…n (Specify) | See MIL STD 881 for definition |
| x.10.x | 3 | Site Type x (Specify) | See MIL STD 881 for definition |
| x.10.x.1 | 4 | Deployment Hardware and Software | See MIL STD 881 for definition |
| x.10.x.1.1 | 5 | Initial Hardware Procurement | See MIL STD 881 for definition |
| x.10.x.1.2 | 5 | Initial Software License | See MIL STD 881 for definition |
| x.10.x.2 | 4 | User Documentation | See MIL STD 881 for definition |
| x.10.x.3 | 4 | Site Activation | See MIL STD 881 for definition |
| x.10.x.4 | 4 | User Training | See MIL STD 881 for definition |
| x.10.x.5 | 4 | Data Migration | See MIL STD 881 for definition |
| x.10.x.6 | 4 | Management/Engineering Support | See MIL STD 881 for definition |
| x.10.x.7 | 4 | Interim Logistics Support | See MIL STD 881 for definition |
| x.11 | 2 | Industrial Facilities | See MIL STD 881 for definition |
| x.11.1 | 3 | Construction/Conversion/Expansion | See MIL STD 881 for definition |
| x.11.2 | 3 | Equipment Acquisition or Modernization | See MIL STD 881 for definition |
| x.11.3 | 3 | Maintenance (Industrial Facilities) | See MIL STD 881 for definition |
| x.12 | 2 | Initial Spares and Repair Parts | See MIL STD 881 for definition |
| A.1.13 | 2 | DHMSM Segment 1 Operations and Support (O&S) | Operations and sustainment are all direct and indirect costs incurred in using the prime system— |
manpower, maintenance, and support—through the entire life cycle. Also included are sustaining engineering and other collateral activities.
A.2.13 2 DHMSM Segment 2 Operations and Support (O&S) Operations and sustainment are all direct and indirect costs incurred in using the prime system— manpower, maintenance, and support—through the entire life cycle. Also included are sustaining engineering and other collateral activities.
B.2 1 JOMIS Operations and Support (O&S) Operations and sustainment are all direct and indirect costs incurred in using the prime system— manpower, maintenance, and support—through the entire life cycle. Also included are sustaining engineering and other collateral activities.
C.2 1 DMIX Operations and Support (O&S) Operations and sustainment are all direct and indirect costs incurred in using the prime system— manpower, maintenance, and support—through the entire life cycle. Also included are sustaining engineering and other collateral activities.
D.2 1 iEHR Operations and Support (O&S) Operations and sustainment are all direct and indirect costs incurred in using the prime system— manpower, maintenance, and support—through the entire life cycle. Also included are sustaining engineering and other collateral activities.
E.2 1 DoD/VA IPO Operations and Support (O&S) Operations and sustainment are all direct and indirect costs incurred in executing the IPO mission— manpower, maintenance, and support—through the entire life cycle. Also included are sustaining engineering and other collateral activities.
F.2 1 PEO DHMS Operations and Support (O&S) Operations and sustainment are all direct and indirect costs incurred in executing the PEO DHMS mission— manpower, maintenance, and support—through the entire life cycle. Also included are sustaining engineering and other collateral activities.
| x.1 | 3 | Program Management | See MIL STD 881 for definition |
| x.2 | 3 | Systems/Sustainment Engineering | See MIL STD 881 for definition |
| x.3 | 3 | Change Management | See MIL STD 881 for definition |
| x.4 | 3 | Help Desk | See MIL STD 881 for definition |
| x.5 | 3 | Data Cleansing/Data Maintenance | See MIL STD 881 for definition |
| x.6 | 3 | System/Database Administration | See MIL STD 881 for definition |
| x.7 | 3 | IT Infrastructure/Network Maintenance Support | See MIL STD 881 for definition |
| x.7.1 | 4 | IT Infrastructure Hardware/Equipment Maintenance | See MIL STD 881 for definition |
| x.7.2 | 4 | IT Infrastructure Software License Support Services | See MIL STD 881 for definition |
| x.7.3 | 4 | IT Infrastructure Management | See MIL STD 881 for definition |
| x.7.4 | 4 | Other IT Infrastructure Support 1…n (Specify) | See MIL STD 881 for definition |
| x.8 | 3 | Operational Hardware Refresh/Upgrade | See MIL STD 881 for definition |
| x.8.1 | 4 | End-User Equipment | See MIL STD 881 for definition |
| x.8.2 | 4 | Cybersecurity Equipment | See MIL STD 881 for definition |
| x.8.3 | 4 | IT Infrastructure and Enterprise Services Equipment | See MIL STD 881 for definition |
| x.8.4 | 4 | Other (Specify) | See MIL STD 881 for definition |
| x.9 | 3 | Operational Software License Refresh/Update | See MIL STD 881 for definition |
| x.9.1 | 4 | End-User Software License | See MIL STD 881 for definition |
| x.9.2 | 4 | Cybersecurity Software Licenses/Services | See MIL STD 881 for definition |
| x.9.3 | 4 | IT Infrastructure and Enterprise Software Licenses/Services | See MIL STD 881 for definition |
| x.9.4 | 4 | Other (Specify) | See MIL STD 881 for definition |
| x.10 | 3 | Cybersecurity Maintenance Management | See MIL STD 881 for definition |
| x.10.1 | 4 | Cybersecurity Compliance Operations and Tracking | See MIL STD 881 for definition |
| x.10.2 | 4 | Follow-on Cybersecurity Test and Evaluation | See MIL STD 881 for definition |
| x.10.3 | 4 | Cybersecurity and IT Certification and Accreditation | See MIL STD 881 for definition |
| x.11 | 3 | Follow-on User Training | See MIL STD 881 for definition |
| x.12 | 3 | System Independent Verification and Validation | See MIL STD 881 for definition |
| x.13 | 3 | Continuing System Improvements | See MIL STD 881 for definition |
| x.13.1 | 4 | Operational Hardware Modification | See MIL STD 881 for definition |
| x.13.1.1 | 5 | Mod Kit Hardware Development | See MIL STD 881 for definition |
| x.13.1.2 | 5 | Mod Kit Hardware Procurement | See MIL STD 881 for definition |
| x.13.1.3 | 5 | Mod Kit Hardware Installation | See MIL STD 881 for definition |
| x.13.2 | 4 | Software Release Modification/Enhancement 1…n (Specify) | See MIL STD 881 for definition |
| x.13.2.1 | 5 | Modifications/Enhancements | See MIL STD 881 for definition |
| x.13.2.2 | 5 | Routine Fixes and Deficiency Correction | See MIL STD 881 for definition |
| x.13.2.3 | 5 | Installation/Test | See MIL STD 881 for definition |
| x.13.2.4 | 5 | IAVAs | See MIL STD 881 for definition |
| x.14 | 3 | AW/Safety/Networthiness Certification | See MIL STD 881 for definition |
| x.15 | 3 | Facilities | See MIL STD 881 for definition |
PEO DHMS WBS Dictionary
&P of &N
File details come from the government source that posted it. Updated .