ATT0002 rev 5Oct.xlsx

XLSX spreadsheet 37 KB Posted

Attached to
Enhanced Heavy Equipment Transport System (EHETS) Trailer
Solicitation number
W56HZV-21-R-0169
Issued by

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 PDF
ATT0040.xlsx XLSX spreadsheet
ATT0002.xlsx XLSX spreadsheet
ATT0038.xlsx XLSX spreadsheet
ATT0026.pdf PDF
ATT0036.xlsx XLSX spreadsheet
ATT0007.pdf PDF
ATT0041.pdf PDF
ATT0048.pdf PDF
ATT0009.xlsx XLSX spreadsheet
ATT0043.pdf PDF
ATT0019.pdf PDF
ATT0047.pdf PDF
ATT0020.pdf PDF
ATT0030.pdf PDF
ATT0037.xlsx XLSX spreadsheet
ATT0027.pdf PDF
ATT0028.pdf PDF
ATT0049.pdf PDF
EXHA.pdf PDF
Draft RFP W56HZV21R0169.pdf 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
CLINRFP RefDescriptionUnit of IssueUnit PriceEst QtyTotal Est Price
1001C.1.3(a)EHETS Trailer Test Assets - PVT/OTEA$ - 02$ - 0
1002C.1.3(b), C.6.1.10EHETS Trailer Test Assets - Logistics DevelopmentEA$ - 02$ - 0
1003C.1.3(c )EHETS Trailer Test Asset - Production StandardEA$ - 01$ - 0
1004C.1.1Ordering Period 1 - EHETS Production TrailersEA$ - 018$ - 0
1005H.3Ordering Period 1 - FRET 12% CLIN 1001EA$ - 02$ - 0
1006H.3Ordering Period 1 - FRET 12% CLIN 1002EA$ - 02$ - 0
1007H.3Ordering Period 1 - FRET 12% CLIN 1003EA$ - 01$ - 0
1008H.3Ordering Period 1 - FRET 12% CLIN 1004EA$ - 018$ - 0
1009D.1.3.1Ordering Period 1 - Trailer Care and StoragePer Day$ - 03240$ - 0
1010C.6.5.3.1Ordering Period 1 - Product Support Package - System Support ItemsEA$ - 03$ - 0
1011C.6.9.4.2Ordering Period 1 - ME Operator Training EventLO$ - 01$ - 0
1012C.6.9.4.2Ordering Period 1 - ME Maintainer Training EventLO$ - 01$ - 0
1013C.6.9.4.4Ordering Period 1 - TM Verification Training EventLO$ - 01$ - 0
1014C.6.9.4.5Ordering Period 1 - IKPT Training EventLO$ - 01$ - 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
CLINRFP RefDescriptionUnit of IssueUnit PriceEst QtyTotal Est Price
2001C.1.1Ordering Period 2 - EHETS Production TrailersEA$ - 0146$ - 0
2002H.3Ordering Period 2 - FRET 12% CLIN 2001EA$ - 0146$ - 0
2003D.1.3.1Ordering Period 2 - Trailer Care and StoragePer Day$ - 0120$ - 0
2004C.6.4.17.1Ordering Period 2 - Maintenance Tool KitEA$ - 02$ - 0
2005C.6.5.3.1Ordering Period 2 - Product Support Package - System Support ItemsEA$ - 01$ - 0
2006C.6.9.4.2Ordering Period 2 - ME Operator Training EventLO$ - 01$ - 0
2007C.6.9.4.2Ordering Period 2 - ME Maintainer Training EventLO$ - 01$ - 0
2008C.6.9.4.4Ordering Period 2 - TM Verification Training EventLO$ - 01$ - 0
2009C.6.9.4.5Ordering Period 2 - IKPT Training EventLO$ - 01$ - 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
CLINRFP RefDescriptionUnit of IssueUnit PriceEst QtyTotal Est Price
3001C.1.1Ordering Period 3 - EHETS Production TrailersEA$ - 0122$ - 0
3002H.3Ordering Period 3 - FRET 12% CLIN 3001EA$ - 0122$ - 0
3003D.1.3.1Ordering Period 3 - Trailer Care and StoragePer Day$ - 0120$ - 0
3004C.6.4.17.1Ordering Period 3 - Maintenance Tool KitEA$ - 03$ - 0
3005C.6.5.3.1Ordering Period 3 - Product Support Package - System Support ItemsEA$ - 01$ - 0
3006C.6.9.4.2Ordering Period 3 - ME Operator Training EventLO$ - 01$ - 0
3007C.6.9.4.2Ordering Period 3 - ME Maintainer Training EventLO$ - 01$ - 0
3008C.6.9.4.4Ordering Period 3 - TM Verification Training EventLO$ - 01$ - 0
3009C.6.9.4.5Ordering Period 3 - IKPT Training EventLO$ - 01$ - 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
CLINRFP RefDescriptionUnit of IssueUnit PriceEst QtyTotal Est Price
4001C.1.1Ordering Period 4 - EHETS Production TrailersEA$ - 0120$ - 0
4002H.3Ordering Period 4 - FRET 12% CLIN 4001EA$ - 0120$ - 0
4003D.1.3.1Ordering Period 4 - Trailer Care and StoragePer Day$ - 0120$ - 0
4004C.6.4.17.1Ordering Period 4 - Maintenance Tool KitEA$ - 012$ - 0
4005C.6.5.3.1Ordering Period 4 - Product Support Package - System Support ItemsEA$ - 01$ - 0
4006C.6.9.4.2Ordering Period 4 - ME Operator Training EventLO$ - 01$ - 0
4007C.6.9.4.2Ordering Period 4 - ME Maintainer Training EventLO$ - 01$ - 0
4008C.6.9.4.4Ordering Period 4 - TM Verification Training EventLO$ - 01$ - 0
4009C.6.9.4.5Ordering Period 4 - IKPT Training EventLO$ - 01$ - 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
CLINRFP RefDescriptionUnit of IssueUnit PriceEst QtyTotal Est Price
5001C.1.1Ordering Period 5 - EHETS Production TrailersEA$ - 055$ - 0
5002H.3Ordering Period 5 - FRET 12% CLIN 5001EA$ - 055$ - 0
5003D.1.3.1Ordering Period 5 - Trailer Care and StoragePer Day$ - 0120$ - 0
5004C.6.4.17.1Ordering Period 5 - Maintenance Tool KitEA$ - 012$ - 0
5005C.6.5.3.1Ordering Period 5 - Product Support Package - System Support ItemsEA$ - 01$ - 0
5006C.6.9.4.2Ordering Period 5 - ME Operator Training EventLO$ - 01$ - 0
5007C.6.9.4.2Ordering Period 5 - ME Maintainer Training EventLO$ - 01$ - 0
5008C.6.9.4.4Ordering Period 5 - TM Verification Training EventLO$ - 01$ - 0
5009C.6.9.4.5Ordering Period 5 - IKPT Training EventLO$ - 01$ - 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.
ELINDescriptionLot Price
A001Conference AgendaNSP
A002Meeting MinutesNSP
A003Program ScheduleNSP
A004ECP/VECPNSP
A005Request for VarianceNSP
A006Indentured Bill Of Materials (IBOM)NSP
A007Equipment Tie-Down ReportNSP
A008Corrosion Prevention and Control Plan (CPCP)NSP
A009Configuration Status Accounting (CSA) InformationNSP
A010Logistics Product Data$ - 0
A011Error-Proofing Audits Results and Corrective Actions$ - 0
A012Logistics Quality Plan$ - 0
A013Technical Manual Plan$ - 0
A014Logistic Configuration Summary Report$ - 0
A015Maintenance Support Plan$ - 0
A016Product Supportability Analysis Plan$ - 0
A017Failure Mode, Effects and Criticality Analysis (FMECA) (LSA-056)$ - 0
A018Reliability Centered Maintenance (RCM) (LSA-050)$ - 0
A019PMCS and Scheduled Based Services Analysis (LSA-033)$ - 0
A020Critical Maintenance Task Summary (LSA-006)$ - 0
A021Task Inventory$ - 0
A022Level of Repair Analysis (LORA) Report$ - 0
A023Maintenance Task Analysis (MTA) (LSA-019)$ - 0
A024Final Inspection Record (FIR)NSP
A025Summary of Non-Conforming RequestsNSP
A026Final Non-Conformance ReportNSP
A027Welding ProceduresNSP
A028Previously Qualified Welding ProceduresNSP
A029Manpower Requirements Criteria (MARC) (LSA-065)$ - 0
A030Safety Assessment Report (SAR)NSP
A031Hazardous Materials Management Program (HMMR) Report FormatNSP
A032First Production Vehicle Inspection (FPVI) ReportNSP
A033Annual Man-Hour by Skill Specialty Code and Level of Maintenance (LSA-001)$ - 0
A034Maintenance Allocation Chart (MAC) (LSA-004)$ - 0
A035Transportability Report (LSA-085)$ - 0
A036Demilitarization (DEMIL) & Disposal Plan$ - 0
A037Hazardous Material Summary Report (LSA-078)$ - 0
A038Long Lead Time Item (LLTI) List$ - 0
A039Authorization List Items Report (LSA-040)$ - 0
A040Mandatory Replacement Parts (MRP) List$ - 0
A041Support Items List (LSA-009)$ - 0
A042Tool Layout Plan$ - 0
A043Maintenance Tool Kit Component List$ - 0
A044Digital Tool Images$ - 0
A045Copyright Release$ - 0
A046Calibration Procedures$ - 0
A047Calibration and Measurement Requirements Summary (CMRS) LSA-076$ - 0
A048Diagnostic Testability Analysis$ - 0
A049Recommended Spare Parts List for Spare Acquisition Integrated with Production (SAIP) Report (LSA-155$ - 0
A050Product Support Package Plan (PSPP)$ - 0
A051Product Support Package List (PSPL)$ - 0
A052Technical Manual$ - 0
A053Discrepancy Report$ - 0
A054Fault Insertion Plan$ - 0
A055Engineering Data for Provisioning (EDFP)$ - 0
A056Provisioning Requirements Report (PRR) (LSA-036)$ - 0
A057Provisioning Pre-procurement Screening (PPS)$ - 0
A058Clean or Green Parts Exception List$ - 0
A059Foreign Sources of Supply Notice$ - 0
A060Provisioning Requirements for Conference$ - 0
A061Indentured Parts List Report Specification (LSA-030)$ - 0
A062Bill of Materials (BOM) Report (LSA-080)$ - 0
A063Commonality List$ - 0
A064Technical Manual Source Data$ - 0
A065Validation Plan$ - 0
A066Validation Records, Reports and Certificates$ - 0
A067NMWR Delivery$ - 0
A068LDP Coded Data Products Packaging$ - 0
A069Special Packaging Instruction (SPI)NSP
A070Special Packaging Validation Test ReportNSP
A071Equipment Preservation Data Sheet (EPDS)NSP
A072EPDS ValidationNSP
A074Repair Cost Report$ - 0
A075Critical Task Analysis Report$ - 0
A076Learning Analysis Report$ - 0
A077Training Support Packages (TSP)$ - 0
A078Student Guides$ - 0
A079Instructor Guides$ - 0
A080Lesson Plans$ - 0
A082Class Demographic Data$ - 0
A083Training Program Development and Management Plan (TPDMP)$ - 0
A084Item Unique Identification (IUID) Candidate List-IUID Marking Plan$ - 0
A085Item Unique Identification (IUID) Marking Activity, Validation and Verification Report-Raw Scan Report$ - 0
A086Sample IUID Data Plate Report$ - 0
A087DMSMS Management Plan$ - 0
A088DMSMS Quarterly Status Report$ - 0
A089DMSMS Health Status Report$ - 0
A090DMSMS GIDEP Annual Status Report$ - 0
A091Logistics Product Data Summary$ - 0
A093Systems Engineering Management PlanNSP
A094Transportability ReportNSP
A095Performance Specification ReportNSP
A096Failure Analysis and Corrective Action ReportNSP
A097Engineering Release RecordNSP
A098Test System Support Package List (TSSPL)NSP
A099Work Authorization Document (WAD)NSP
A100Mobile Office RequestNSP
A101Configuration Management PlanNSP
A102Notice of Revision (NOR)NSP
A103Finish SpecificationNSP
A104TDP For EHETS Trailer Unique Components$ - 0
A105Advanced Manufacturing Candidate List$ - 0
A106Advanced Manufacturing Technical Data Package$ - 0

Total $ - 0

File details come from the government source that posted it. Updated .