Attachment 0010 - Pricing Workbook - All CLINS 9.10.2024.xlsx

XLSX spreadsheet 62 KB Posted Sep 10, 2024

Attached to: M870A4 Semitrailer, Lowbed, Construction Equipment Transporter (SLCET) 40-Ton
Solicitation number: M870A4-Amendment0002
Issued by: Department of the Army Materiel Command TACOM Life Cycle Management Command

About this file

Written by GovTribe AI · Sep 10, 2024

This document is a pricing workbook (Attachment 0010) related to a federal contract opportunity for the M870A4 Semitrailer, Lowbed, Construction Equipment Transporter (SLCET), 40-Ton. The contract opportunity is for a five-year, with two optional one-year ordering periods, Indefinite Delivery/Indefinite Quantity (IDIQ) contract. The pricing workbook provides instructions for offerors to input unit pricing for various Contract Line Item Numbers (CLINs) across the different ordering periods, including production trailers, first article tests, spare parts, and shipping. The pricing is used to calculate the Total Evaluated Price. The opportunity is a 100% Small Business set-aside, solicited by the Department of the Army Materiel Command TACOM Life Cycle Management Command. The guaranteed minimum quantity is 10 and the maximum is 840 units.

View the file

Other files

File	Type	Posted
W912CH24R0025-0002.pdf	PDF	Sep 10, 2024
W912CH24R0025-0002 Full.PDF	PDF	Sep 10, 2024

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: W56HZV-24-R-0032

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,0231	$ - 0
Order Period 2, CLINs 0042,0062,0082,0232	$ - 0
Order Period 3, CLINs 0043,0063,0083,0233	$ - 0
Order Period 4, CLINs 0044,0064,0084,0234	$ - 0
Order Period 5, CLINs 0045,0065,0085,0235	$ - 0
Option Period 1, CLINs 0046,0066,0086,0236	$ - 0
Option Period 2, CLINs 0047,0067,0087,0237	$ - 0
FRET	$ - 0

Total Evaluated Price: $ - 0

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)
CLIN	SOW	Description	Range	Unit Price	Weighting	Weighted Avg Unit Price	Quantity	Total Price
0041		M870A4 Production Trailer, Range 1-5	1-5	$ - 0	5%	$ - 0	115	$ - 0
0041		M870A4 Production Trailer, Range 6-20	6-20	$ - 0	40%	$ - 0	115	$ - 0
0041		M870A4 Production Trailer, Range 21-75	21-75	$ - 0	40%	$ - 0	115	$ - 0
0041		M870A4 Production Trailer, Range 76-100	76-100	$ - 0	10%	$ - 0	115	$ - 0
0041		M870A4 Production Trailer, Range 101+	101+	$ - 0	5%	$ - 0	115	$ - 0

$ - 0

M870A4 First Production Vehicle Inpection (FPVI) Trailer
CLIN	SOW	Description	Unit Price	Quantity	Total Price
0011		FPVI Trailer	$ - 0	1	$ - 0

M870A4 First Article Test (FAT)
CLIN	SOW	Description	Unit Price	Quantity	Total Price
0021		FAT Trailer	$ - 0	4	$ - 0
0021		FAT Test Support Package	$ - 0	4	$ - 0

$ - 0

Test Service Representative (TSR)
CLIN	SOW	Description	Hourly Rate	Hours	Total Price
0051		TSR	$ - 0	1,920	$ - 0

Proposed Spare Parts List (PSPL)
CLIN	SOW	Description	Unit Price	Quantiy	Total Price
0061		PSPL	$ - 0	120	$ - 0

Care & Storage
CLIN	SOW	Description	Daily Rate (120 Days)	Quantity	Total Price
0081		Care & Storage	$ - 0	14,400	$ - 0

CPC OCONUS Shipment
CLIN	SOW	Description	Unit Price	Quantity	Total Price
0231		CPC OCONUS Shipment	$ - 0	120	$ - 0

Order Period 1 Total $ - 0

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)
CLIN	SOW	Description	Range	Unit Price	Weighting	Weighted Avg Unit Price	Quantity	Total Price
0042		M870A4 Production Trailer, Range 1-5	1-5	$ - 0	5%	$ - 0	120	$ - 0
0042		M870A4 Production Trailer, Range 6-20	6-20	$ - 0	40%	$ - 0	120	$ - 0
0042		M870A4 Production Trailer, Range 21-75	21-75	$ - 0	40%	$ - 0	120	$ - 0
0042		M870A4 Production Trailer, Range 76-100	76-100	$ - 0	10%	$ - 0	120	$ - 0
0042		M870A4 Production Trailer, Range 101+	101+	$ - 0	5%	$ - 0	120	$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLIN	SOW	Description	Unit Price	Quantiy	Total Price
0062		PSPL	$ - 0	120	$ - 0

Care & Storage
CLIN	SOW	Description	Daily Rate (120 Days)	Quantity	Total Price
0082		Care & Storage	$ - 0	14,400	$ - 0

CPC OCONUS Shipment
CLIN	SOW	Description	Unit Price	Quantity	Total Price
0232		CPC OCONUS Shipment	$ - 0	120	$ - 0

Order Period 2 Total $ - 0

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)
CLIN	SOW	Description	Range	Unit Price	Weighting	Weighted Avg Unit Price	Quantity	Total Price
0043		M870A4 Production Trailer, Range 1-5	1-5	$ - 0	5%	$ - 0	120	$ - 0
0043		M870A4 Production Trailer, Range 6-20	6-20	$ - 0	40%	$ - 0	120	$ - 0
0043		M870A4 Production Trailer, Range 21-75	21-75	$ - 0	40%	$ - 0	120	$ - 0
0043		M870A4 Production Trailer, Range 76-100	76-100	$ - 0	10%	$ - 0	120	$ - 0
0043		M870A4 Production Trailer, Range 101+	101+	$ - 0	5%	$ - 0	120	$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLIN	SOW	Description	Unit Price	Quantiy	Total Price
0063		PSPL	$ - 0	120	$ - 0

Care & Storage
CLIN	SOW	Description	Daily Rate (120 Days)	Quantity	Total Price
0083		Care & Storage	$ - 0	14,400	$ - 0

CPC OCONUS Shipment
CLIN	SOW	Description	Unit Price	Quantity	Total Price
0233		CPC OCONUS Shipment	$ - 0	120	$ - 0

Order Period 3 Total $ - 0

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)
CLIN	SOW	Description	Range	Unit Price	Weighting	Weighted Avg Unit Price	Quantity	Total Price
0044		M870A4 Production Trailer, Range 1-5	1-5	$ - 0	5%	$ - 0	120	$ - 0
0044		M870A4 Production Trailer, Range 6-20	6-20	$ - 0	40%	$ - 0	120	$ - 0
0044		M870A4 Production Trailer, Range 21-75	21-75	$ - 0	40%	$ - 0	120	$ - 0
0044		M870A4 Production Trailer, Range 76-100	76-100	$ - 0	10%	$ - 0	120	$ - 0
0044		M870A4 Production Trailer, Range 101+	101+	$ - 0	5%	$ - 0	120	$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLIN	SOW	Description	Unit Price	Quantiy	Total Price
0064		PSPL	$ - 0	120	$ - 0

Care & Storage
CLIN	SOW	Description	Daily Rate (120 Days)	Quantity	Total Price
0084		Care & Storage	$ - 0	14,400	$ - 0

CPC OCONUS Shipment
CLIN	SOW	Description	Unit Price	Quantity	Total Price
0234		CPC OCONUS Shipment	$ - 0	120	$ - 0

Order Period 4 Total $ - 0

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)
CLIN	SOW	Description	Range	Unit Price	Weighting	Weighted Avg Unit Price	Quantity	Total Price
0045		M870A4 Production Trailer, Range 1-5	1-5	$ - 0	5%	$ - 0	120	$ - 0
0045		M870A4 Production Trailer, Range 6-20	6-20	$ - 0	40%	$ - 0	120	$ - 0
0045		M870A4 Production Trailer, Range 21-75	21-75	$ - 0	40%	$ - 0	120	$ - 0
0045		M870A4 Production Trailer, Range 76-100	76-100	$ - 0	10%	$ - 0	120	$ - 0
0045		M870A4 Production Trailer, Range 101+	101+	$ - 0	5%	$ - 0	120	$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLIN	SOW	Description	Unit Price	Quantiy	Total Price
0065		PSPL	$ - 0	120	$ - 0

Care & Storage
CLIN	SOW	Description	Daily Rate (120 Days)	Quantity	Total Price
0085		Care & Storage	$ - 0	14,400	$ - 0

CPC OCONUS Shipment
CLIN	SOW	Description	Unit Price	Quantity	Total Price
0235		CPC OCONUS Shipment	$ - 0	120	$ - 0

Order Period 5 Total $ - 0

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)
CLIN	SOW	Description	Range	Unit Price	Weighting	Weighted Avg Unit Price	Quantity	Total Price
0046		M870A4 Production Trailer, Range 1-5	1-5	$ - 0	5%	$ - 0	120	$ - 0
0046		M870A4 Production Trailer, Range 6-20	6-20	$ - 0	40%	$ - 0	120	$ - 0
0046		M870A4 Production Trailer, Range 21-75	21-75	$ - 0	40%	$ - 0	120	$ - 0
0046		M870A4 Production Trailer, Range 76-100	76-100	$ - 0	10%	$ - 0	120	$ - 0
0046		M870A4 Production Trailer, Range 101+	101+	$ - 0	5%	$ - 0	120	$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLIN	SOW	Description	Unit Price	Quantiy	Total Price
0066		PSPL	$ - 0	120	$ - 0

Care & Storage
CLIN	SOW	Description	Daily Rate (120 Days)	Quantity	Total Price
0086		Care & Storage	$ - 0	14,400	$ - 0

CPC OCONUS Shipment
CLIN	SOW	Description	Unit Price	Quantity	Total Price
0236		CPC OCONUS Shipment	$ - 0	120	$ - 0

Option Period 1 Total $ - 0

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)
CLIN	SOW	Description	Range	Unit Price	Weighting	Weighted Avg Unit Price	Quantity	Total Price
0047		M870A4 Production Trailer, Range 1-5	1-5	$ - 0	5%	$ - 0	120	$ - 0
0047		M870A4 Production Trailer, Range 6-20	6-20	$ - 0	40%	$ - 0	120	$ - 0
0047		M870A4 Production Trailer, Range 21-75	21-75	$ - 0	40%	$ - 0	120	$ - 0
0047		M870A4 Production Trailer, Range 76-100	76-100	$ - 0	10%	$ - 0	120	$ - 0
0047		M870A4 Production Trailer, Range 101+	101+	$ - 0	5%	$ - 0	120	$ - 0

$ - 0

Proposed Spare Parts List (PSPL)
CLIN	SOW	Description	Unit Price	Quantiy	Total Price
0067		PSPL	$ - 0	120	$ - 0

Care & Storage
CLIN	SOW	Description	Daily Rate (120 Days)	Quantity	Total Price
0087		Care & Storage	$ - 0	14,400	$ - 0

CPC OCONUS Shipment
CLIN	SOW	Description	Unit Price	Quantity	Total Price
0237		CPC OCONUS Shipment	$ - 0	120	$ - 0

Option Period 2 Total $ - 0

FRET

Federal Retail Excise Tax (FRET) M870A4 SCLET Trailer

No Fill-ins required. FRET is automatically calculated.

FRET
CLIN	Description	SOW	Unit Price	Total Price
0071	Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 1		$ - 0	$ - 0
0072	Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 2		$ - 0	$ - 0
0073	Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 3		$ - 0	$ - 0
0074	Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 4		$ - 0	$ - 0
0075	Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Ordering Period 5		$ - 0	$ - 0
0076	Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Option Period 1		$ - 0	$ - 0
0077	Federal Retail Excise Tax (FRET) - M870A4 SCLET Trailer Option Period 2		$ - 0	$ - 0

$ - 0

File details come from the government source that posted it. Updated Sep 10, 2024.