Attachment 0010 - Pricing Workbook - All CLINS 2.28.24.xlsx

XLSX spreadsheet 72 KB Posted

Attached to
M870A4 Semitrailer, Lowbed, Construction Equipment Transporter (SLCET) 40-Ton
Solicitation number
W912CH24R0025
Issued by

About this file

Written by GovTribe AI ·

This document is an Attachment 0010 - Pricing Workbook for a Request for Proposal (RFP) issued by the Department of the Army Materiel Command TACOM Life Cycle Management Command for the M870A4 Semitrailer, Lowbed, Construction Equipment Transporter (SLCET) 40-Ton.

The workbook provides instructions and a pricing template for offerors to submit unit prices for the various contract line items (CLINs) over five base ordering periods and two optional ordering periods. The key CLINs include production trailers, first article test, spare parts, care and storage, corrosion inhibitor, service contract reporting, and OCONUS shipment. Offerors must input pricing for all highlighted cells, and failure to do so may result in proposal rejection. The workbook calculates a total evaluated price based on the unit prices and quantities provided. The overall procurement is a 100% small business set-aside.

View the file

Other files

File Type Posted
Attachment 0017 - Experience Matrix.xlsx XLSX spreadsheet
Attachment 0019 - RESERVED.docx DOCX document
Attachment 0012 - Production Weekly Report.xlsx XLSX spreadsheet
W912CH24R0025 Final.pdf PDF
Attachment 0020 - Hazardous Materials Management Report (HMMR) Template.xlsx XLSX spreadsheet
Attachment 0008 - M870A4 TDP Use and Non-Disclosure Agreement _ W912CH24R0025 Final.pdf PDF
Attachment 0030 - M870A4 SCLET ECP TM Update.zip ZIP file
Attachment 0011 - Economic Price Adjustment (EPA) - Labor and Material 13 FEB 24 FINAL.xlsx XLSX spreadsheet
Attachment 0007 - Request for Use of Prohibited Materials.docx DOCX document
Attachment 0022 TOP_01-1-010A_Vehicle_Test_Course_Severity.pdf PDF
Attachment 0029 - RESERVED.docx DOCX document
Attachment 0008 - M870A4 TDP Use and Non-Disclosure Agreement _ W912CH24R0025 Final.docx DOCX document
Attachment 0025 - DA 2404 Equipment Inspection and Maintance Worksheet.pdf PDF
Attachment 0024- Use of Existing Government-Furnished Property.xlsx XLSX spreadsheet
Attachment 0002 - PEO CSCSS Armoring SCG.pdf PDF
Attachment 0004 - Contract Data Requirements List (CDRL) Module Access.docx DOCX document
Attachment 0028 - Change Package TM Requirements Matrix.pdf PDF
Attachment 0021 - M870A4 SLCET Care Storage Report.xlsx XLSX spreadsheet
Attachment 0005 - OEM Contractor CDRL Module Access Request Form.docx DOCX document
Attachment 0026 - M870A4 PSPL.pptx PPTX presentation
Attachment 0009 - M870A4 TM 5-2330-343-13andP.pdf PDF
Attachment 0006 - Army CDRL Module OEM Contractor Training.pptx PPTX presentation
Attachment 0016 - TACOM Linear Sample Data Plate FI-06.pdf PDF
Attachment 0013 - Provisioning Requirements Summary (LSA-036) Data Products Worksheet.xlsx XLSX spreadsheet
Attachment 0015 - IUID Val Ver Report Template 4 Jan 23.xlsx XLSX spreadsheet
Attachment 0023 - Special Waiver Requests.docx DOCX document
Attachment 0014 - Items Requiring IUID Worksheet 4 Jan 23.xlsx XLSX spreadsheet
Show all 27

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Summary

Request for Proposal: W912CH-24-R-0025
Attachment 0010
Instructions
1. Cells that require inputs are highlighted in yellow.
2. All cells that are highlighted in yellow must be completed.
3. Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.
4. Do not add worksheets to this attachment.
5. The required inputs are used to calculate the Total Evaluated Price in the "Summary" tab.
6. If the offeror fails to provide inputs for all cells highlighted in yellow, then the offeror's proposal may be rejected in accordance with Section M.2 - Rejection of Offers.

Total Evaluated Price Summary

Order Period 1, CLINs 0011,0021,0031,0041,0051,0061,0081,0091,0301,0231$ - 0
Order Period 2, CLINs 0042,0062,0082,0092,0301,0232$ - 0
Order Period 3, CLINs 0043,0063,0083,0093,0301,0233$ - 0
Order Period 4, CLINs 0044,0064,0084,0094,0301,0234$ - 0
Order Period 5, CLINs 0045,0065,0085,0095,0301,0235$ - 0
Option Period 1, CLINs 0046,0066,0086,0096,0301,0236$ - 0
Option Period 2, CLINs 0047,0067,0087,0097,0301,0237$ - 0
CDRLs, CLIN 0101$ - 0
FRET$ - 0

Total Evaluated Price: $ - 0

Order Period 1

Order Period 1
Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this tab
M870A4 Semitrailer, Lowbed, Contruction Equipment Transporter (SLCET)
CLINSOWDescriptionRangeUnit PriceWeightingWeighted Avg Unit PriceQuantityTotal Price
0041M870A4 Production Trailer, Range 1-51-5$ - 05%$ - 0115$ - 0
0041M870A4 Production Trailer, Range 6-206-20$ - 040%$ - 0115$ - 0
0041M870A4 Production Trailer, Range 21-7521-75$ - 040%$ - 0115$ - 0
0041M870A4 Production Trailer, Range 76-10076-100$ - 010%$ - 0115$ - 0
0041M870A4 Production Trailer, Range 101+101+$ - 05%$ - 0115$ - 0

$ - 0

M870A4 First Production Vehicle Inpection (FPVI) Trailer
CLINSOWDescriptionUnit PriceQuantityTotal Price
0011FPVI Trailer$ - 01$ - 0
M870A4 First Article Test (FAT)
CLINSOWDescriptionUnit PriceQuantityTotal Price
0021FAT Trailer$ - 04$ - 0
0021FAT Test Support Package$ - 04$ - 0

$ - 0

Test Service Representative (TSR)
CLINSOWDescriptionHourly RateHoursTotal Price
0051TSR$ - 01,920$ - 0
Proposed Spare Parts List (PSPL)
CLINSOWDescriptionUnit PriceQuantiyTotal Price
0061PSPL$ - 0120$ - 0
Care & Storage
CLINSOWDescriptionDaily Rate (120 Days)QuantityTotal Price
0081Care & Storage$ - 014,400$ - 0
Corrosion Inhibitor
CLINSOWDescriptionUnit PriceQuantityTotal Price
0091Corrosion Inhibitor$ - 0115$ - 0
Service Contract Reporting
CLINSOWDescriptionUnit PriceQuantityTotal Price
0301Service Contract Reporting - All Years$ - 0115$ - 0
CPC OCONUS Shipment
CLINSOWDescriptionUnit PriceQuantityTotal Price
0231CPC OCONUS Shipment$ - 0120$ - 0

Order Period 1 Total $ - 0

Order Period 2

Order Period 2
Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this tab
M870A4 Semitrailer, Lowbed, Contruction Equipment Transporter (SLCET)
CLINSOWDescriptionRangeUnit PriceWeightingWeighted Avg Unit PriceQuantityTotal Price
0042M870A4 Production Trailer, Range 1-51-5$ - 05%$ - 0120$ - 0
0042M870A4 Production Trailer, Range 6-206-20$ - 040%$ - 0120$ - 0
0042M870A4 Production Trailer, Range 21-7521-75$ - 040%$ - 0120$ - 0
0042M870A4 Production Trailer, Range 76-10076-100$ - 010%$ - 0120$ - 0
0042M870A4 Production Trailer, Range 101+101+$ - 05%$ - 0120$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLINSOWDescriptionUnit PriceQuantiyTotal Price
0062PSPL$ - 0120$ - 0
Care & Storage
CLINSOWDescriptionDaily Rate (120 Days)QuantityTotal Price
0082Care & Storage$ - 014,400$ - 0
Corrosion Inhibitor
CLINSOWDescriptionUnit PriceQuantityTotal Price
0092Corrosion Inhibitor$ - 0120$ - 0
Service Contract Reporting
CLINSOWDescriptionUnit PriceQuantityTotal Price
0301Service Contract Reporting - All Years$ - 0115$ - 0
CPC OCONUS Shipment
CLINSOWDescriptionUnit PriceQuantityTotal Price
0232CPC OCONUS Shipment$ - 0120$ - 0

Order Period 2 Total $ - 0

Order Period 3

Order Period 3
Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this tab
M870A4 Semitrailer, Lowbed, Contruction Equipment Transporter (SLCET)
CLINSOWDescriptionRangeUnit PriceWeightingWeighted Avg Unit PriceQuantityTotal Price
0043M870A4 Production Trailer, Range 1-51-5$ - 05%$ - 0120$ - 0
0043M870A4 Production Trailer, Range 6-206-20$ - 040%$ - 0120$ - 0
0043M870A4 Production Trailer, Range 21-7521-75$ - 040%$ - 0120$ - 0
0043M870A4 Production Trailer, Range 76-10076-100$ - 010%$ - 0120$ - 0
0043M870A4 Production Trailer, Range 101+101+$ - 05%$ - 0120$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLINSOWDescriptionUnit PriceQuantiyTotal Price
0063PSPL$ - 0120$ - 0
Care & Storage
CLINSOWDescriptionDaily Rate (120 Days)QuantityTotal Price
0083Care & Storage$ - 014,400$ - 0
Corrosion Inhibitor
CLINSOWDescriptionUnit PriceQuantityTotal Price
0093Corrosion Inhibitor$ - 0120$ - 0
Service Contract Reporting
CLINSOWDescriptionUnit PriceQuantityTotal Price
0301Service Contract Reporting - All Years$ - 0115$ - 0
CPC OCONUS Shipment
CLINSOWDescriptionUnit PriceQuantityTotal Price
0233CPC OCONUS Shipment$ - 0120$ - 0

Order Period 3 Total $ - 0

Order Period 4

Order Period 4
Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this tab
M870A4 Semitrailer, Lowbed, Contruction Equipment Transporter (SLCET)
CLINSOWDescriptionRangeUnit PriceWeightingWeighted Avg Unit PriceQuantityTotal Price
0044M870A4 Production Trailer, Range 1-51-5$ - 05%$ - 0120$ - 0
0044M870A4 Production Trailer, Range 6-206-20$ - 040%$ - 0120$ - 0
0044M870A4 Production Trailer, Range 21-7521-75$ - 040%$ - 0120$ - 0
0044M870A4 Production Trailer, Range 76-10076-100$ - 010%$ - 0120$ - 0
0044M870A4 Production Trailer, Range 101+101+$ - 05%$ - 0120$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLINSOWDescriptionUnit PriceQuantiyTotal Price
0064PSPL$ - 0120$ - 0
Care & Storage
CLINSOWDescriptionDaily Rate (120 Days)QuantityTotal Price
0084Care & Storage$ - 014,400$ - 0
Corrosion Inhibitor
CLINSOWDescriptionUnit PriceQuantityTotal Price
0094Corrosion Inhibitor$ - 0120$ - 0
Service Contract Reporting
CLINSOWDescriptionUnit PriceQuantityTotal Price
0301Service Contract Reporting - All Years$ - 0115$ - 0
CPC OCONUS Shipment
CLINSOWDescriptionUnit PriceQuantityTotal Price
0234CPC OCONUS Shipment$ - 0120$ - 0

Order Period 4 Total $ - 0

Order Period 5

Order Period 5
Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this tab
M870A4 Semitrailer, Lowbed, Contruction Equipment Transporter (SLCET)
CLINSOWDescriptionRangeUnit PriceWeightingWeighted Avg Unit PriceQuantityTotal Price
0045M870A4 Production Trailer, Range 1-51-5$ - 05%$ - 0120$ - 0
0045M870A4 Production Trailer, Range 6-206-20$ - 040%$ - 0120$ - 0
0045M870A4 Production Trailer, Range 21-7521-75$ - 040%$ - 0120$ - 0
0045M870A4 Production Trailer, Range 76-10076-100$ - 010%$ - 0120$ - 0
0045M870A4 Production Trailer, Range 101+101+$ - 05%$ - 0120$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLINSOWDescriptionUnit PriceQuantiyTotal Price
0065PSPL$ - 0120$ - 0
Care & Storage
CLINSOWDescriptionDaily Rate (120 Days)QuantityTotal Price
0085Care & Storage$ - 014,400$ - 0
Corrosion Inhibitor
CLINSOWDescriptionUnit PriceQuantityTotal Price
0095Corrosion Inhibitor$ - 0120$ - 0
Service Contract Reporting
CLINSOWDescriptionUnit PriceQuantityTotal Price
0301Service Contract Reporting - All Years$ - 0115$ - 0
CPC OCONUS Shipment
CLINSOWDescriptionUnit PriceQuantityTotal Price
0235CPC OCONUS Shipment$ - 0120$ - 0

Order Period 5 Total $ - 0

Option Period 1

Option Period 1
Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this tab
M870A4 Semitrailer, Lowbed, Contruction Equipment Transporter (SLCET)
CLINSOWDescriptionRangeUnit PriceWeightingWeighted Avg Unit PriceQuantityTotal Price
0046M870A4 Production Trailer, Range 1-51-5$ - 05%$ - 0120$ - 0
0046M870A4 Production Trailer, Range 6-206-20$ - 040%$ - 0120$ - 0
0046M870A4 Production Trailer, Range 21-7521-75$ - 040%$ - 0120$ - 0
0046M870A4 Production Trailer, Range 76-10076-100$ - 010%$ - 0120$ - 0
0046M870A4 Production Trailer, Range 101+101+$ - 05%$ - 0120$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLINSOWDescriptionUnit PriceQuantiyTotal Price
0066PSPL$ - 0120$ - 0
Care & Storage
CLINSOWDescriptionDaily Rate (120 Days)QuantityTotal Price
0086Care & Storage$ - 014,400$ - 0
Corrosion Inhibitor
CLINSOWDescriptionUnit PriceQuantityTotal Price
0096Corrosion Inhibitor$ - 0120$ - 0
Service Contract Reporting
CLINSOWDescriptionUnit PriceQuantityTotal Price
0301Service Contract Reporting - All Years$ - 0115$ - 0
CPC OCONUS Shipment
CLINSOWDescriptionUnit PriceQuantityTotal Price
0236CPC OCONUS Shipment$ - 0120$ - 0

Option Period 1 Total $ - 0

Option Period 2

Option Period 2
Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column B of this tab
M870A4 Semitrailer, Lowbed, Contruction Equipment Transporter (SLCET)
CLINSOWDescriptionRangeUnit PriceWeightingWeighted Avg Unit PriceQuantityTotal Price
0047M870A4 Production Trailer, Range 1-51-5$ - 05%$ - 0120$ - 0
0047M870A4 Production Trailer, Range 6-206-20$ - 040%$ - 0120$ - 0
0047M870A4 Production Trailer, Range 21-7521-75$ - 040%$ - 0120$ - 0
0047M870A4 Production Trailer, Range 76-10076-100$ - 010%$ - 0120$ - 0
0047M870A4 Production Trailer, Range 101+101+$ - 05%$ - 0120$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLINSOWDescriptionUnit PriceQuantiyTotal Price
0067PSPL$ - 0120$ - 0
Care & Storage
CLINSOWDescriptionDaily Rate (120 Days)QuantityTotal Price
0087Care & Storage$ - 014,400$ - 0
Corrosion Inhibitor
CLINSOWDescriptionUnit PriceQuantityTotal Price
0097Corrosion Inhibitor$ - 0120$ - 0
Service Contract Reporting
CLINSOWDescriptionUnit PriceQuantityTotal Price
0301Service Contract Reporting - All Years$ - 0115$ - 0
CPC OCONUS Shipment
CLINSOWDescriptionUnit PriceQuantityTotal Price
0237CPC OCONUS Shipment$ - 0120$ - 0

Option Period 2 Total $ - 0

CDRLs

CDRLs
Offeror is required to fill in the unit price for each CLIN IAW sections of the solicitation listed in column C of this tab
CDRLs, (CLIN 0101)
CDRLsDescriptionSOWUnit PriceQuantityTotal Price
A014Provisioning Pre-Procurement Screening (PPS)$ - 01$ - 0
A015Provisioning Parts List (PPL)$ - 01$ - 0
A016Provisioning Parts List Index (PPLI)$ - 01$ - 0
A017Engineering Data for Provisioning (EDFP)$ - 01$ - 0
A019Technical Manual$ - 01$ - 0
A020Validation Plan$ - 01$ - 0
A021Validation Report$ - 01$ - 0
A022IUID Marking Plan$ - 01$ - 0
A023IUID Marking Validation / Verification Report$ - 01$ - 0
A028Production Weekly Report$ - 01$ - 0
A029Shipping Documents$ - 01$ - 0
A033Test System Support Package (TSSPL)$ - 01$ - 0

Total $ - 0

FRET

Federal Retail Excise Tax (FRET) M870A4 SCLET Trailer
No Fill-ins required. FRET is automatically calculated.
FRET
CLINDescriptionSOWUnit PriceTotal Price
0071Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 1$ - 0$ - 0
0072Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 2$ - 0$ - 0
0073Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 3$ - 0$ - 0
0074Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 4$ - 0$ - 0
0075Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 5$ - 0$ - 0
0076Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Option Period 1$ - 0$ - 0
0077Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Option Period 2$ - 0$ - 0

$ - 0

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