ATT0002 rev 5Oct.xlsx
XLSX spreadsheet 37 KB Posted
- Solicitation number
- W56HZV-21-R-0169
About this file
This document contains a pricing workbook attachment for a federal solicitation seeking proposals for an Enhanced Heavy Equipment Transport System (EHETS) trailer. The solicitation will be issued by the Army Contracting Command - Detroit Arsenal and anticipates awarding a five year requirements contract for 466 EHETS trailers. The pricing workbook provides instructions to offerors for completing proposed pricing for the base year and four option years, including unit prices for the trailers and various training and support services. Pricing is also required for separately priced Contract Data Requirements Lists (CDRLs) that can be ordered over the life of the contract. Comments on the draft solicitation and attachments are being accepted until the notice closing date to inform development of the final solicitation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Draft RFP W56HZV21R0169 rev 6Oct.pdf | ||
| ATT0040.xlsx | XLSX spreadsheet | |
| ATT0002.xlsx | XLSX spreadsheet | |
| ATT0038.xlsx | XLSX spreadsheet | |
| ATT0026.pdf | ||
| ATT0036.xlsx | XLSX spreadsheet | |
| ATT0007.pdf | ||
| ATT0041.pdf | ||
| ATT0048.pdf | ||
| ATT0009.xlsx | XLSX spreadsheet | |
| ATT0043.pdf | ||
| ATT0019.pdf | ||
| ATT0047.pdf | ||
| ATT0020.pdf | ||
| ATT0030.pdf | ||
| ATT0037.xlsx | XLSX spreadsheet | |
| ATT0027.pdf | ||
| ATT0028.pdf | ||
| ATT0049.pdf | ||
| EXHA.pdf | ||
| Draft RFP W56HZV21R0169.pdf | ||
| ATT0046.xlsx | XLSX spreadsheet | |
| ATT0042.docx | DOCX document | |
| ATT0008.XLSX | XLSX spreadsheet |
Show all 24
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
Instructions
| Enhanced Heavy Equipment Transporter System (EHETS) |
| Solicitation W56HZV-21-R-0169 |
| Attachment 0002 - Pricing Workbook |
| INSTRUCTIONS TO OFFERORS: |
| 1. Cells that require inputs are highlighted in yellow. |
| 2. All cells that are highlighted in yellow must be completed. |
| 3. If an offeror intends to price a CLIN/ELIN at no cost, enter the number 0 in the approporiate yellow cell. |
| 4. The required inputs are used to auto calculate the Total Proposed Price on the "Summary" tab. |
| 5. The 12% Federal Retail Excise Tax (FRET) is automatically calculated within the Pricing Workbook and added to the total for each Ordering Period. |
| 6. Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells. |
| 7. Do not add worksheets to this Attachment. |
| Distribution Statement A - Approved for Public Release. |
Summary Offeror:
SUMMARY (SOLICITATION W56HZV-21-R-0169)
| First Ordering Period | $ - 0 |
| Second Ordering Period | $ - 0 |
| Third Ordering Period | $ - 0 |
| Fourth Ordering Period | $ - 0 |
| Fifth Ordering Period | $ - 0 |
| CDRLs | $ - 0 |
Total Proposed Price: $ - 0
First Ordering Period
| First Ordering Period |
| Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this worksheet |
| CLIN | RFP Ref | Description | Unit of Issue | Unit Price | Est Qty | Total Est Price |
| 1001 | C.1.3(a) | EHETS Trailer Test Assets - PVT/OT | EA | $ - 0 | 2 | $ - 0 |
| 1002 | C.1.3(b), C.6.1.10 | EHETS Trailer Test Assets - Logistics Development | EA | $ - 0 | 2 | $ - 0 |
| 1003 | C.1.3(c ) | EHETS Trailer Test Asset - Production Standard | EA | $ - 0 | 1 | $ - 0 |
| 1004 | C.1.1 | Ordering Period 1 - EHETS Production Trailers | EA | $ - 0 | 18 | $ - 0 |
| 1005 | H.3 | Ordering Period 1 - FRET 12% CLIN 1001 | EA | $ - 0 | 2 | $ - 0 |
| 1006 | H.3 | Ordering Period 1 - FRET 12% CLIN 1002 | EA | $ - 0 | 2 | $ - 0 |
| 1007 | H.3 | Ordering Period 1 - FRET 12% CLIN 1003 | EA | $ - 0 | 1 | $ - 0 |
| 1008 | H.3 | Ordering Period 1 - FRET 12% CLIN 1004 | EA | $ - 0 | 18 | $ - 0 |
| 1009 | D.1.3.1 | Ordering Period 1 - Trailer Care and Storage | Per Day | $ - 0 | 3240 | $ - 0 |
| 1010 | C.6.5.3.1 | Ordering Period 1 - Product Support Package - System Support Items | EA | $ - 0 | 3 | $ - 0 |
| 1011 | C.6.9.4.2 | Ordering Period 1 - ME Operator Training Event | LO | $ - 0 | 1 | $ - 0 |
| 1012 | C.6.9.4.2 | Ordering Period 1 - ME Maintainer Training Event | LO | $ - 0 | 1 | $ - 0 |
| 1013 | C.6.9.4.4 | Ordering Period 1 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 1014 | C.6.9.4.5 | Ordering Period 1 - IKPT Training Event | LO | $ - 0 | 1 | $ - 0 |
Total $ - 0
Second Ordering Period
| Second Ordering Period |
| Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this worksheet |
| CLIN | RFP Ref | Description | Unit of Issue | Unit Price | Est Qty | Total Est Price |
| 2001 | C.1.1 | Ordering Period 2 - EHETS Production Trailers | EA | $ - 0 | 146 | $ - 0 |
| 2002 | H.3 | Ordering Period 2 - FRET 12% CLIN 2001 | EA | $ - 0 | 146 | $ - 0 |
| 2003 | D.1.3.1 | Ordering Period 2 - Trailer Care and Storage | Per Day | $ - 0 | 120 | $ - 0 |
| 2004 | C.6.4.17.1 | Ordering Period 2 - Maintenance Tool Kit | EA | $ - 0 | 2 | $ - 0 |
| 2005 | C.6.5.3.1 | Ordering Period 2 - Product Support Package - System Support Items | EA | $ - 0 | 1 | $ - 0 |
| 2006 | C.6.9.4.2 | Ordering Period 2 - ME Operator Training Event | LO | $ - 0 | 1 | $ - 0 |
| 2007 | C.6.9.4.2 | Ordering Period 2 - ME Maintainer Training Event | LO | $ - 0 | 1 | $ - 0 |
| 2008 | C.6.9.4.4 | Ordering Period 2 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 2009 | C.6.9.4.5 | Ordering Period 2 - IKPT Training Event | LO | $ - 0 | 1 | $ - 0 |
Total $ - 0
Third Ordering Period
| Third Ordering Period |
| Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this worksheet |
| CLIN | RFP Ref | Description | Unit of Issue | Unit Price | Est Qty | Total Est Price |
| 3001 | C.1.1 | Ordering Period 3 - EHETS Production Trailers | EA | $ - 0 | 122 | $ - 0 |
| 3002 | H.3 | Ordering Period 3 - FRET 12% CLIN 3001 | EA | $ - 0 | 122 | $ - 0 |
| 3003 | D.1.3.1 | Ordering Period 3 - Trailer Care and Storage | Per Day | $ - 0 | 120 | $ - 0 |
| 3004 | C.6.4.17.1 | Ordering Period 3 - Maintenance Tool Kit | EA | $ - 0 | 3 | $ - 0 |
| 3005 | C.6.5.3.1 | Ordering Period 3 - Product Support Package - System Support Items | EA | $ - 0 | 1 | $ - 0 |
| 3006 | C.6.9.4.2 | Ordering Period 3 - ME Operator Training Event | LO | $ - 0 | 1 | $ - 0 |
| 3007 | C.6.9.4.2 | Ordering Period 3 - ME Maintainer Training Event | LO | $ - 0 | 1 | $ - 0 |
| 3008 | C.6.9.4.4 | Ordering Period 3 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 3009 | C.6.9.4.5 | Ordering Period 3 - IKPT Training Event | LO | $ - 0 | 1 | $ - 0 |
Total $ - 0
Fourth Ordering Period
| Fourth Ordering Period |
| Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this worksheet |
| CLIN | RFP Ref | Description | Unit of Issue | Unit Price | Est Qty | Total Est Price |
| 4001 | C.1.1 | Ordering Period 4 - EHETS Production Trailers | EA | $ - 0 | 120 | $ - 0 |
| 4002 | H.3 | Ordering Period 4 - FRET 12% CLIN 4001 | EA | $ - 0 | 120 | $ - 0 |
| 4003 | D.1.3.1 | Ordering Period 4 - Trailer Care and Storage | Per Day | $ - 0 | 120 | $ - 0 |
| 4004 | C.6.4.17.1 | Ordering Period 4 - Maintenance Tool Kit | EA | $ - 0 | 12 | $ - 0 |
| 4005 | C.6.5.3.1 | Ordering Period 4 - Product Support Package - System Support Items | EA | $ - 0 | 1 | $ - 0 |
| 4006 | C.6.9.4.2 | Ordering Period 4 - ME Operator Training Event | LO | $ - 0 | 1 | $ - 0 |
| 4007 | C.6.9.4.2 | Ordering Period 4 - ME Maintainer Training Event | LO | $ - 0 | 1 | $ - 0 |
| 4008 | C.6.9.4.4 | Ordering Period 4 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 4009 | C.6.9.4.5 | Ordering Period 4 - IKPT Training Event | LO | $ - 0 | 1 | $ - 0 |
Total $ - 0
Fifth Ordering Period
| Fifth Ordering Period |
| Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this worksheet |
| CLIN | RFP Ref | Description | Unit of Issue | Unit Price | Est Qty | Total Est Price |
| 5001 | C.1.1 | Ordering Period 5 - EHETS Production Trailers | EA | $ - 0 | 55 | $ - 0 |
| 5002 | H.3 | Ordering Period 5 - FRET 12% CLIN 5001 | EA | $ - 0 | 55 | $ - 0 |
| 5003 | D.1.3.1 | Ordering Period 5 - Trailer Care and Storage | Per Day | $ - 0 | 120 | $ - 0 |
| 5004 | C.6.4.17.1 | Ordering Period 5 - Maintenance Tool Kit | EA | $ - 0 | 12 | $ - 0 |
| 5005 | C.6.5.3.1 | Ordering Period 5 - Product Support Package - System Support Items | EA | $ - 0 | 1 | $ - 0 |
| 5006 | C.6.9.4.2 | Ordering Period 5 - ME Operator Training Event | LO | $ - 0 | 1 | $ - 0 |
| 5007 | C.6.9.4.2 | Ordering Period 5 - ME Maintainer Training Event | LO | $ - 0 | 1 | $ - 0 |
| 5008 | C.6.9.4.4 | Ordering Period 5 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 5009 | C.6.9.4.5 | Ordering Period 5 - IKPT Training Event | LO | $ - 0 | 1 | $ - 0 |
Total $ - 0
CDRLs
| CDRLs |
| Offeror is required to fill in the lot price for each separately priced CDRL in Column C of this worksheet IAW Exhibit A and associated statement of work. |
| CDRLs are built under CLIN 6000, are not tied to any particular ordering period and can be ordered at any time during the five year ordering life of the contract. |
| ELIN | Description | Lot Price |
| A001 | Conference Agenda | NSP |
| A002 | Meeting Minutes | NSP |
| A003 | Program Schedule | NSP |
| A004 | ECP/VECP | NSP |
| A005 | Request for Variance | NSP |
| A006 | Indentured Bill Of Materials (IBOM) | NSP |
| A007 | Equipment Tie-Down Report | NSP |
| A008 | Corrosion Prevention and Control Plan (CPCP) | NSP |
| A009 | Configuration Status Accounting (CSA) Information | NSP |
| A010 | Logistics Product Data | $ - 0 |
| A011 | Error-Proofing Audits Results and Corrective Actions | $ - 0 |
| A012 | Logistics Quality Plan | $ - 0 |
| A013 | Technical Manual Plan | $ - 0 |
| A014 | Logistic Configuration Summary Report | $ - 0 |
| A015 | Maintenance Support Plan | $ - 0 |
| A016 | Product Supportability Analysis Plan | $ - 0 |
| A017 | Failure Mode, Effects and Criticality Analysis (FMECA) (LSA-056) | $ - 0 |
| A018 | Reliability Centered Maintenance (RCM) (LSA-050) | $ - 0 |
| A019 | PMCS and Scheduled Based Services Analysis (LSA-033) | $ - 0 |
| A020 | Critical Maintenance Task Summary (LSA-006) | $ - 0 |
| A021 | Task Inventory | $ - 0 |
| A022 | Level of Repair Analysis (LORA) Report | $ - 0 |
| A023 | Maintenance Task Analysis (MTA) (LSA-019) | $ - 0 |
| A024 | Final Inspection Record (FIR) | NSP |
| A025 | Summary of Non-Conforming Requests | NSP |
| A026 | Final Non-Conformance Report | NSP |
| A027 | Welding Procedures | NSP |
| A028 | Previously Qualified Welding Procedures | NSP |
| A029 | Manpower Requirements Criteria (MARC) (LSA-065) | $ - 0 |
| A030 | Safety Assessment Report (SAR) | NSP |
| A031 | Hazardous Materials Management Program (HMMR) Report Format | NSP |
| A032 | First Production Vehicle Inspection (FPVI) Report | NSP |
| A033 | Annual Man-Hour by Skill Specialty Code and Level of Maintenance (LSA-001) | $ - 0 |
| A034 | Maintenance Allocation Chart (MAC) (LSA-004) | $ - 0 |
| A035 | Transportability Report (LSA-085) | $ - 0 |
| A036 | Demilitarization (DEMIL) & Disposal Plan | $ - 0 |
| A037 | Hazardous Material Summary Report (LSA-078) | $ - 0 |
| A038 | Long Lead Time Item (LLTI) List | $ - 0 |
| A039 | Authorization List Items Report (LSA-040) | $ - 0 |
| A040 | Mandatory Replacement Parts (MRP) List | $ - 0 |
| A041 | Support Items List (LSA-009) | $ - 0 |
| A042 | Tool Layout Plan | $ - 0 |
| A043 | Maintenance Tool Kit Component List | $ - 0 |
| A044 | Digital Tool Images | $ - 0 |
| A045 | Copyright Release | $ - 0 |
| A046 | Calibration Procedures | $ - 0 |
| A047 | Calibration and Measurement Requirements Summary (CMRS) LSA-076 | $ - 0 |
| A048 | Diagnostic Testability Analysis | $ - 0 |
| A049 | Recommended Spare Parts List for Spare Acquisition Integrated with Production (SAIP) Report (LSA-155 | $ - 0 |
| A050 | Product Support Package Plan (PSPP) | $ - 0 |
| A051 | Product Support Package List (PSPL) | $ - 0 |
| A052 | Technical Manual | $ - 0 |
| A053 | Discrepancy Report | $ - 0 |
| A054 | Fault Insertion Plan | $ - 0 |
| A055 | Engineering Data for Provisioning (EDFP) | $ - 0 |
| A056 | Provisioning Requirements Report (PRR) (LSA-036) | $ - 0 |
| A057 | Provisioning Pre-procurement Screening (PPS) | $ - 0 |
| A058 | Clean or Green Parts Exception List | $ - 0 |
| A059 | Foreign Sources of Supply Notice | $ - 0 |
| A060 | Provisioning Requirements for Conference | $ - 0 |
| A061 | Indentured Parts List Report Specification (LSA-030) | $ - 0 |
| A062 | Bill of Materials (BOM) Report (LSA-080) | $ - 0 |
| A063 | Commonality List | $ - 0 |
| A064 | Technical Manual Source Data | $ - 0 |
| A065 | Validation Plan | $ - 0 |
| A066 | Validation Records, Reports and Certificates | $ - 0 |
| A067 | NMWR Delivery | $ - 0 |
| A068 | LDP Coded Data Products Packaging | $ - 0 |
| A069 | Special Packaging Instruction (SPI) | NSP |
| A070 | Special Packaging Validation Test Report | NSP |
| A071 | Equipment Preservation Data Sheet (EPDS) | NSP |
| A072 | EPDS Validation | NSP |
| A074 | Repair Cost Report | $ - 0 |
| A075 | Critical Task Analysis Report | $ - 0 |
| A076 | Learning Analysis Report | $ - 0 |
| A077 | Training Support Packages (TSP) | $ - 0 |
| A078 | Student Guides | $ - 0 |
| A079 | Instructor Guides | $ - 0 |
| A080 | Lesson Plans | $ - 0 |
| A082 | Class Demographic Data | $ - 0 |
| A083 | Training Program Development and Management Plan (TPDMP) | $ - 0 |
| A084 | Item Unique Identification (IUID) Candidate List-IUID Marking Plan | $ - 0 |
| A085 | Item Unique Identification (IUID) Marking Activity, Validation and Verification Report-Raw Scan Report | $ - 0 |
| A086 | Sample IUID Data Plate Report | $ - 0 |
| A087 | DMSMS Management Plan | $ - 0 |
| A088 | DMSMS Quarterly Status Report | $ - 0 |
| A089 | DMSMS Health Status Report | $ - 0 |
| A090 | DMSMS GIDEP Annual Status Report | $ - 0 |
| A091 | Logistics Product Data Summary | $ - 0 |
| A093 | Systems Engineering Management Plan | NSP |
| A094 | Transportability Report | NSP |
| A095 | Performance Specification Report | NSP |
| A096 | Failure Analysis and Corrective Action Report | NSP |
| A097 | Engineering Release Record | NSP |
| A098 | Test System Support Package List (TSSPL) | NSP |
| A099 | Work Authorization Document (WAD) | NSP |
| A100 | Mobile Office Request | NSP |
| A101 | Configuration Management Plan | NSP |
| A102 | Notice of Revision (NOR) | NSP |
| A103 | Finish Specification | NSP |
| A104 | TDP For EHETS Trailer Unique Components | $ - 0 |
| A105 | Advanced Manufacturing Candidate List | $ - 0 |
| A106 | Advanced Manufacturing Technical Data Package | $ - 0 |
Total $ - 0
File details come from the government source that posted it. Updated .