ATT0002 18Jan2022.xlsx
XLSX spreadsheet 40 KB Posted
- Solicitation number
- W56HZV21R0169
About this file
This document contains a pricing workbook and instructions for an upcoming solicitation seeking proposals for an Enhanced Heavy Equipment Transporter System. The Army is soliciting proposals for a five-year firm-fixed-price requirements contract to acquire 466 Enhanced Heavy Equipment Transporter trailers over five ordering periods, with delivery of five test trailers within six months of award. Offerors must provide unit pricing and estimated quantities for the production trailers by quantity range for each ordering period, as well as pricing for logistics data, training, and other contract line items. The evaluation factors are technical capability, price, and small business participation, with technical capability being most important. The technical factors are payload capacity, maneuverability, and payload safe transport. The Army intends to issue this solicitation on or after November 24, 2021.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| W56HZV21R0169-0003.pdf | ||
| W56HZV21R0169-0002.pdf | ||
| ATT 0018 - EHETS TRAILER QA LOG.pdf | ||
| W56HZV21R0169 Amendment 0002.pdf | ||
| ATT 0018 - EHETS TRAILER QA LOG.pdf | ||
| W56HZV21R0169-0001.pdf | ||
| ATT0046.xlsx | XLSX spreadsheet | |
| ATT0008.XLSX | XLSX spreadsheet | |
| ATT0049.pdf | ||
| ATT0019.pdf | ||
| ATT0047.pdf | ||
| ATT0020.pdf | ||
| ATT0036.xlsx | XLSX spreadsheet | |
| ATT0042.docx | DOCX document | |
| ATT0002.xlsx | XLSX spreadsheet | |
| ATT0048.pdf | ||
| ATT0037.xlsx | XLSX spreadsheet | |
| ATT0007.pdf | ||
| ATT0038.xlsx | XLSX spreadsheet | |
| W56HZV21R0169.pdf | ||
| ATT0009.xlsx | XLSX spreadsheet | |
| ATT0010.xlsx | XLSX spreadsheet | |
| ATT0028.pdf | ||
| ATT0040.xlsx | XLSX spreadsheet | |
| ATT0026.pdf | ||
| ATT0041.pdf | ||
| ATT0030.pdf | ||
| ATT0027.pdf | ||
| ATT0043.pdf | ||
| EXHA.pdf | ||
| ATT0017.docx | DOCX document |
Show all 31
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. |
For production trailers, the offeror is required to fill in the unit price for each quantity range.
| Range Pricing | |||
| Quantity Range | CLIN 1004 - Unit Price | CLIN 1008 FRET - Unit Price | Weighting |
| 1 - 15 | $ - 0 | 10% | |
| 16 - 40 | $ - 0 | 40% | |
| 41 - 70 | $ - 0 | 10% | |
| 71 - 120 | $ - 0 | 30% | |
| 121+ | $ - 0 | 10% |
| 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 | 2 | $ - 0 | |
| 1002 | C.1.3(b), C.6.1.10 | EHETS Trailer Test Assets - Logistics Development | EA | 2 | $ - 0 | |
| 1003 | C.1.3(c ) | EHETS Trailer Test Asset - Production Standard | EA | 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 | 3240 | $ - 0 | |
| 1010 | C.6.5.3.1 | Ordering Period 1 - Product Support Package - System Support Items | EA | 3 | $ - 0 | |
| 1011 | C.6.9.4.2 | Ordering Period 1 - ME Operator Training Event | LO | 1 | $ - 0 | |
| 1012 | C.6.9.4.2 | Ordering Period 1 - ME Maintainer Training Event | LO | 1 | $ - 0 | |
| 1013 | C.6.9.4.4 | Ordering Period 1 - TM Verification Training Event | LO | 1 | $ - 0 | |
| 1014 | C.6.9.4.5 | Ordering Period 1 - IKPT Training Event | LO | 1 | $ - 0 |
*Weighted average unit price calculated from range prices for evaluation purposes only 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. |
For production trailers, the offeror is required to fill in the unit price for each quantity range.
| Range Pricing | |||
| Quantity Range | CLIN 2001 - Unit Price | CLIN 2002 FRET - Unit Price | Weighting |
| 1 - 15 | $ - 0 | 10% | |
| 16 - 40 | $ - 0 | 10% | |
| 41 - 70 | $ - 0 | 10% | |
| 71 - 120 | $ - 0 | 45% | |
| 121+ | $ - 0 | 25% |
| 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 | 120 | $ - 0 | |
| 2004 | C.6.4.17.1 | Ordering Period 2 - Maintenance Tool Kit | EA | 2 | $ - 0 | |
| 2005 | C.6.5.3.1 | Ordering Period 2 - Product Support Package - System Support Items | EA | 1 | $ - 0 | |
| 2006 | C.6.9.4.2 | Ordering Period 2 - ME Operator Training Event | LO | 1 | $ - 0 | |
| 2007 | C.6.9.4.2 | Ordering Period 2 - ME Maintainer Training Event | LO | 1 | $ - 0 | |
| 2008 | C.6.9.4.4 | Ordering Period 2 - TM Verification Training Event | LO | 1 | $ - 0 | |
| 2009 | C.6.9.4.5 | Ordering Period 2 - IKPT Training Event | LO | 1 | $ - 0 |
*Weighted average unit price calculated from range prices for evaluation purposes only 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. |
For production trailers, the offeror is required to fill in the unit price for each quantity range.
| Range Pricing | |||
| Quantity Range | CLIN 3001 - Unit Price | CLIN 3002 FRET - Unit Price | Weighting |
| 1 - 15 | $ - 0 | 40% | |
| 16 - 40 | $ - 0 | 15% | |
| 41 - 70 | $ - 0 | 15% | |
| 71 - 120 | $ - 0 | 15% | |
| 121+ | $ - 0 | 15% |
| 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 | 120 | $ - 0 | |
| 3004 | C.6.4.17.1 | Ordering Period 3 - Maintenance Tool Kit | EA | 3 | $ - 0 | |
| 3005 | C.6.5.3.1 | Ordering Period 3 - Product Support Package - System Support Items | EA | 1 | $ - 0 | |
| 3006 | C.6.9.4.2 | Ordering Period 3 - ME Operator Training Event | LO | 1 | $ - 0 | |
| 3007 | C.6.9.4.2 | Ordering Period 3 - ME Maintainer Training Event | LO | 1 | $ - 0 | |
| 3008 | C.6.9.4.4 | Ordering Period 3 - TM Verification Training Event | LO | 1 | $ - 0 | |
| 3009 | C.6.9.4.5 | Ordering Period 3 - IKPT Training Event | LO | 1 | $ - 0 |
*Weighted average unit price calculated from range prices for evaluation purposes only 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. |
For production trailers, the offeror is required to fill in the unit price for each quantity range.
| Range Pricing | |||
| Quantity Range | CLIN 4001 - Unit Price | CLIN 4002 FRET - Unit Price | Weighting |
| 1 - 15 | $ - 0 | 20% | |
| 16 - 40 | $ - 0 | 20% | |
| 41 - 70 | $ - 0 | 20% | |
| 71 - 120 | $ - 0 | 20% | |
| 121+ | $ - 0 | 20% |
| 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 | 120 | $ - 0 | |
| 4004 | C.6.4.17.1 | Ordering Period 4 - Maintenance Tool Kit | EA | 12 | $ - 0 | |
| 4005 | C.6.5.3.1 | Ordering Period 4 - Product Support Package - System Support Items | EA | 1 | $ - 0 | |
| 4006 | C.6.9.4.2 | Ordering Period 4 - ME Operator Training Event | LO | 1 | $ - 0 | |
| 4007 | C.6.9.4.2 | Ordering Period 4 - ME Maintainer Training Event | LO | 1 | $ - 0 | |
| 4008 | C.6.9.4.4 | Ordering Period 4 - TM Verification Training Event | LO | 1 | $ - 0 | |
| 4009 | C.6.9.4.5 | Ordering Period 4 - IKPT Training Event | LO | 1 | $ - 0 |
*Weighted average unit price calculated from range prices for evaluation purposes only 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. |
For production trailers, the offeror is required to fill in the unit price for each quantity range.
| Range Pricing | |||
| Quantity Range | CLIN 5001 - Unit Price | CLIN 5002 FRET - Unit Price | Weighting |
| 1 - 15 | $ - 0 | 20% | |
| 16 - 40 | $ - 0 | 20% | |
| 41 - 70 | $ - 0 | 20% | |
| 71 - 120 | $ - 0 | 20% | |
| 121+ | $ - 0 | 20% |
| 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 | 120 | $ - 0 | |
| 5004 | C.6.4.17.1 | Ordering Period 5 - Maintenance Tool Kit | EA | 12 | $ - 0 | |
| 5005 | C.6.5.3.1 | Ordering Period 5 - Product Support Package - System Support Items | EA | 1 | $ - 0 | |
| 5006 | C.6.9.4.2 | Ordering Period 5 - ME Operator Training Event | LO | 1 | $ - 0 | |
| 5007 | C.6.9.4.2 | Ordering Period 5 - ME Maintainer Training Event | LO | 1 | $ - 0 | |
| 5008 | C.6.9.4.4 | Ordering Period 5 - TM Verification Training Event | LO | 1 | $ - 0 | |
| 5009 | C.6.9.4.5 | Ordering Period 5 - IKPT Training Event | LO | 1 | $ - 0 |
*Weighted average unit price calculated from range prices for evaluation purposes only 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 | |
| A011 | Error-Proofing Audits Results and Corrective Actions | |
| A012 | Logistics Quality Plan | |
| A013 | Technical Manual Plan | |
| A014 | Logistic Configuration Summary Report | |
| A015 | Maintenance Support Plan | |
| A016 | Product Supportability Analysis Plan | |
| A017 | Failure Mode, Effects and Criticality Analysis (FMECA) (LSA-056) | |
| A018 | Reliability Centered Maintenance (RCM) (LSA-050) | |
| A019 | PMCS and Scheduled Based Services Analysis (LSA-033) | |
| A020 | Critical Maintenance Task Summary (LSA-006) | |
| A021 | Task Inventory | |
| A022 | Level of Repair Analysis (LORA) Report | |
| A023 | Maintenance Task Analysis (MTA) (LSA-019) | |
| 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) | |
| 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) | |
| A034 | Maintenance Allocation Chart (MAC) (LSA-004) | |
| A035 | Transportability Report (LSA-085) | |
| A036 | Demilitarization (DEMIL) & Disposal Plan | |
| A037 | Hazardous Material Summary Report (LSA-078) | |
| A038 | Long Lead Time Item (LLTI) List | |
| A039 | Authorization List Items Report (LSA-040) | |
| A040 | Mandatory Replacement Parts (MRP) List | |
| A041 | Support Items List (LSA-009) | |
| A042 | Tool Layout Plan | |
| A043 | Maintenance Tool Kit Component List | |
| A044 | Digital Tool Images | |
| A045 | Copyright Release | |
| A046 | Calibration Procedures | |
| A047 | Calibration and Measurement Requirements Summary (CMRS) LSA-076 | |
| A048 | Diagnostic Testability Analysis | |
| A049 | Recommended Spare Parts List for Spare Acquisition Integrated with Production (SAIP) Report (LSA-155 | |
| A050 | Product Support Package Plan (PSPP) | |
| A051 | Product Support Package List (PSPL) | |
| A052 | Technical Manual | |
| A053 | Discrepancy Report | |
| A054 | Fault Insertion Plan | |
| A055 | Engineering Data for Provisioning (EDFP) | |
| A056 | Provisioning Requirements Report (PRR) (LSA-036) | |
| A057 | Provisioning Pre-procurement Screening (PPS) | |
| A058 | Clean or Green Parts Exception List | |
| A059 | Foreign Sources of Supply Notice | |
| A060 | Provisioning Requirements for Conference | |
| A061 | Indentured Parts List Report Specification (LSA-030) | |
| A062 | Bill of Materials (BOM) Report (LSA-080) | |
| A063 | Commonality List | |
| A064 | Technical Manual Source Data | |
| A065 | Validation Plan | |
| A066 | Validation Records, Reports and Certificates | |
| A067 | NMWR Delivery | |
| A068 | LDP Coded Data Products Packaging | |
| 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 | |
| A075 | Critical Task Analysis Report | |
| A076 | Learning Analysis Report | |
| A077 | Training Support Packages (TSP) | |
| A078 | Student Guides | |
| A079 | Instructor Guides | |
| A080 | Lesson Plans | |
| A082 | Class Demographic Data | |
| A083 | Training Program Development and Management Plan (TPDMP) | |
| A084 | Item Unique Identification (IUID) Candidate List-IUID Marking Plan | |
| A085 | Item Unique Identification (IUID) Marking Activity, Validation and Verification Report-Raw Scan Report | |
| A086 | Sample IUID Data Plate Report | |
| A087 | DMSMS Management Plan | |
| A088 | DMSMS Quarterly Status Report | |
| A089 | DMSMS Health Status Report | |
| A090 | DMSMS GIDEP Annual Status Report | |
| A091 | Logistics Product Data Summary | |
| 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 | |
| A105 | Advanced Manufacturing Candidate List | |
| A106 | Advanced Manufacturing Technical Data Package |
Total $ - 0
File details come from the government source that posted it. Updated .