ATT0002.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- W56HZV-21-R-0169
About this file
This document contains a pricing workbook for a federal solicitation seeking an Enhanced Heavy Equipment Transport System (EHETS). The solicitation will be released by the Army Contracting Command - Detroit Arsenal for a five year requirements contract to provide 466 EHETS trailers. The pricing workbook instructions require offerors to provide unit pricing for various contract line items, including EHETS production trailers, training, product support packages, and federal excise tax. Pricing is to be provided for five ordering periods. The workbook also includes templates for offerors to summarize proposed pricing by ordering period and overall. The level of detail in required pricing inputs will allow for automatic calculation of total proposed prices.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ATT0002 rev 5Oct.xlsx | XLSX spreadsheet | |
| Draft RFP W56HZV21R0169 rev 6Oct.pdf | ||
| ATT0040.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 - Federal Retail Excise Tax - 12% | $ - 0 | |||
| 1006 | D.1.3.1 | Ordering Period 1 - Trailer Care and Storage | Per Day | $ - 0 | 3240 | $ - 0 |
| 1007 | C.6.5.3.1 | Ordering Period 1 - Product Support Package - System Support Items | EA | $ - 0 | 3 | $ - 0 |
| 1008 | C.6.9.4.2 | Ordering Period 1 - ME Training Event | LO | $ - 0 | 1 | $ - 0 |
| 1009 | C.6.9.4.4 | Ordering Period 1 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 1010 | 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 - Federal Retail Excise Tax - 12% | $ - 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 Training Event | LO | $ - 0 | 1 | $ - 0 |
| 2007 | C.6.9.4.4 | Ordering Period 2 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 2008 | 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 - Federal Retail Excise Tax - 12% | $ - 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 Training Event | LO | $ - 0 | 1 | $ - 0 |
| 3007 | C.6.9.4.4 | Ordering Period 3 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 3008 | 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 - Federal Retail Excise Tax - 12% | $ - 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 Training Event | LO | $ - 0 | 1 | $ - 0 |
| 4007 | C.6.9.4.4 | Ordering Period 4 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 4008 | 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 - Federal Retail Excise Tax - 12% | $ - 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 Training Event | LO | $ - 0 | 1 | $ - 0 |
| 5007 | C.6.9.4.4 | Ordering Period 5 - TM Verification Training Event | LO | $ - 0 | 1 | $ - 0 |
| 5008 | 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 .