Attachment_0008,_M200A1_Pricing_Worksheet_29May2019.xlsx

XLSX spreadsheet 66 KB Posted May 31, 2019

Attached to: M200A1 Trailers
Solicitation number: W56HZV18R0173
Issued by: Department of the Army Materiel Command TACOM Life Cycle Management Command

About this file

Written by GovTribe AI · Dec 30, 2023

This document is a pricing worksheet for a federal solicitation seeking trailers and related products and services. The Army Materiel Command TACOM Life Cycle Management Command is soliciting proposals for the production and support of M200A1 trailers, including the AMMPS, NG SEW, and base models, as well as adjustable lunette and product support packages. Offerors are required to provide unit pricing for various quantity ranges for the different trailer models and configurations under multiple contract line item numbers, as well as pricing for first article testing, refurbishment, engineering services, and data deliverables. Instructions require offerors to complete all highlighted cells in the provided template and not alter other cells, with errors noted for any incomplete responses.

From the source

Attachment 0008 PRICING WORKSHEET 29-MAY-2019

View the file

Other files

File	Type	Posted
M200A1_QandA_-_10_July_2019.docx	DOCX document	Jul 10, 2019
W56HZV18R0173-0005.pdf	PDF	Jul 10, 2019
W56HZV18R0173_Conformed_Copy_through_Amendment_0005.pdf	PDF	Jul 10, 2019
M200A1_Q&A.docx	DOCX document	Jul 2, 2019
W56HZV18R0173-0004.pdf	PDF	Jun 21, 2019
Solicitation_4.pdf	PDF	Jun 14, 2019
Attachment_0011_Past_Performance_Questionnaire_11June2019.pdf	PDF	Jun 14, 2019
W56HZV18R0173-0003.pdf	PDF	Jun 14, 2019
Attachment_0011_Past_Performance_Questionnaire_03_June_2019.pdf	PDF	Jun 5, 2019
W56HZV18R0173-0002.pdf	PDF	Jun 5, 2019
W56HZV18R0173.pdf	PDF	Jun 3, 2019
W56HZV18R0173-0001.pdf	PDF	Jun 3, 2019
Exhibit_A_M200A1_Trailer_-_CDRL_A001_-_A014_-_30May2019.pdf	PDF	May 31, 2019
Attachment_0012,_Additional_Guidelines_For_CUI_21_Apr_2017.pdf	PDF	May 31, 2019
RFP_W56HZV-18-R-0173.pdf	PDF	May 31, 2019
Attachment_0011_Past_Performance_Questionnaire_29May2019.doc	DOC document	May 31, 2019
Attachment_0025_Offeror_Compliance_Checklist_Tool.pdf	PDF	May 31, 2019
Attachment_0006,_GFP_Tracker.xlsx	XLSX spreadsheet	May 31, 2019

Show all 18

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.

Instructions

M200A1 Trailers

Attachment 0008 - Pricing Spreadsheet

Solicitation: W56HZV-18-R-0173

INSTRUCTIONS TO OFFERORS:

1. Cells that require inputs are highlighted in yellow.

2. All cells highlighted in yellow must be completed.

3. Do not manipulate or alter any of the other cells, except those that are highlighted in yellow.

4. The "Summary" Worksheet reflects the Total Proposed Price.

5. The Government will add transportation costs to the Total Proposed Price for all CLINS in accordance with Section M to calculate the Total Evaluated Price.

Offeror:

Summary

M200A1 Trailers
Attachment 0008 - Pricing Spreadsheet
Solicitation: W56HZV-18-R-0173
Offeror:	0

	Total
Total Price AMMPS FAT (CLIN 0048) and FAT Refurb (CLIN 0049)	ERROR - Unit Prices Have Not Been Proposed for Both CLINs	1
Total Price M200A1 Trailers: CLIN 0011 - CLIN 0017	ERROR - Unit Prices Have Not Been Proposed for all ranges within each CLIN	1
Total Price M200A1 Trailers W/ADJ Lunette: CLIN 0021 - CLIN 0027	ERROR - Unit Prices Have Not Been Proposed for all ranges within each CLIN	1
Total Price NG SEW Trailers: CLIN 0031 - CLIN 0037	ERROR - Unit Prices Have Not Been Proposed for all ranges within each CLIN	1
Total Price AMMPS Trailers: CLIN 0041 - CLIN 0047	ERROR - Unit Prices Have Not Been Proposed for all ranges within each CLIN	1
Total Price Product Support Package: CLIN 0051	ERROR - Unit Price Has Not Been Proposed For this CLIN	1
CDRLs: CLIN 9001 (See CDRL Tab for list of CDRLS)	NSP
Total Proposed Price All CLINS	ERROR - All cells highlighted in yellow have not been completed

ERROR:#VALUE!

&Z&F

AMMPS FAT Quantity

M200A1 Trailers
Attachment 0008 - Pricing Spreadsheet
Solicitation: W56HZV-18-R-0173
Offeror:	0
								Total
							AMMPS FAT	ERROR - Unit Price Has Not Been Proposed For this CLIN
							FAT Trl Refurb	ERROR - Unit Price Has Not Been Proposed For this CLIN
				Unit Price		Extended Price	Total Price AMMPS FAI and FAI Refurb	ERROR - Unit Prices Have Not Been Proposed for Both CLINs
CLIN 0048: AMMPS Model First Article Test (FAT) Quantity		3	EA		ERROR - Unit Price Has Not Been Proposed For this CLIN
								$ 2.00
CLIN 0049: FAT Trailer Refurbishment		3	EA		ERROR - Unit Price Has Not Been Proposed For this CLIN

M200A1 Base Model

M200A1 Trailers

Attachment 0008 - Pricing Spreadsheet

Solicitation: W56HZV-18-R-0173

Offeror: 0

CLIN 0011-0017: Production: All M200A1 base model trailers will have one unit price per range and may be ordered in tan, green, or camouflage at that unit price. For pricing purposes, assume the designated color estimates.

COLOR ESTIMATE:				100% GREEN					100% GREEN					100% GREEN					100% GREEN					100% GREEN					100% GREEN					100% GREEN
				M200A1					M200A1					M200A1					M200A1					M200A1					M200A1					M200A1
	CLIN 0011					CLIN 0012					CLIN 0013					CLIN 0014					CLIN 0015					CLIN 0016					CLIN 0017
	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight
	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%
	11	-	50		60%	11	-	50		60%	11	-	50		60%	11	-	50		10%	11	-	50		10%	11	-	50		10%	11	-	50		10%
	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%
	101	-	500		10%	101	-	500		10%	101	-	500		10%	101	-	500		60%	101	-	500		60%	101	-	500		60%	101	-	500		60%
		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%
				5	100%				5	100%				5	100%				5	100%				5	100%				5	100%				5	100%
Weighted Ave. Unit Price				ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges
Estimated Quantities				50					50					50					50					50					50					3
Extended Price				ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges

Total Price All CLINs M200A1 Trailer ERROR - Unit Prices Have Not Been Proposed for all ranges within each CLIN

M200A1 w ADJ LUNETTE

M200A1 Trailers

Attachment 0008 - Pricing Spreadsheet

Solicitation: W56HZV-18-R-0173

Offeror: 0

CLIN 0021-0027: Production: All M200A1 trailers with adjustable lunette will have one unit price per range and may be ordered in tan, green, or camouflage at that unit price. For pricing purposes, assume the designated color estimates.

COLOR ESTIMATE:				100% GREEN					100% GREEN					100% GREEN					100% GREEN					100% GREEN					100% GREEN					100% GREEN
				M200A1 W/ADJ LUNETTE					M200A1 W/ADJ LUNETTE					M200A1 W/ADJ LUNETTE					M200A1 W/ADJ LUNETTE					M200A1 W/ADJ LUNETTE					M200A1 W/ADJ LUNETTE					M200A1 W/ADJ LUNETTE
	CLIN 0021					CLIN 0022					CLIN 0023					CLIN 0024					CLIN 0025					CLIN 0026					CLIN 0027
	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight
	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%
	11	-	50		60%	11	-	50		60%	11	-	50		60%	11	-	50		60%	11	-	50		60%	11	-	50		60%	11	-	50		60%
	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%
	101	-	500		10%	101	-	500		10%	101	-	500		10%	101	-	500		10%	101	-	500		10%	101	-	500		10%	101	-	500		10%
		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%
				5	100%				5	100%				5	100%				5	100%				5	100%				5	100%				5	100%
Weighted Ave. Unit Price				ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges
Estimated Quantities				50					50					50					50					50					50					3
Extended Price				ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges

Total Price All CLINs M200A1 Trailer with adjustable lunette ERROR - Unit Prices Have Not Been Proposed for all ranges within each CLIN

NG SEW

M200A1 Trailers

Attachment 0008 - Pricing Spreadsheet

Solicitation: W56HZV-18-R-0173

Offeror: 0

CLIN 0031-0037: Production: All NG SEW trailers will have one unit price per range and may be ordered in tan, green, or camouflage at that unit price. For pricing purposes, assume the designated color estimates.

COLOR ESTIMATE:				100% TAN					100% TAN					100% TAN					100% TAN					100% TAN					100% TAN					100% TAN
				NG SEW					NG SEW					NG SEW					NG SEW					NG SEW					NG SEW					NG SEW
	CLIN 0031					CLIN 0032					CLIN 0033					CLIN 0034					CLIN 0035					CLIN 0036					CLIN 0037
	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight
	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%
	11	-	50		60%	11	-	50		60%	11	-	50		60%	11	-	50		60%	11	-	50		60%	11	-	50		60%	11	-	50		60%
	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%
	101	-	500		10%	101	-	500		10%	101	-	500		10%	101	-	500		10%	101	-	500		10%	101	-	500		10%	101	-	500		10%
		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%
				5	100%				5	100%				5	100%				5	100%				5	100%				5	100%				5	100%
Weighted Ave. Unit Price				ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges
Estimated Quantities				12					38					36					40					38					23					3
Extended Price				ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges

Total Price All CLINs NG SEW Trailer ERROR - Unit Prices Have Not Been Proposed for all ranges within each CLIN

AMMPS

M200A1 Trailers

Attachment 0008 - Pricing Spreadsheet

Solicitation: W56HZV-18-R-0173

Offeror: 0

CLIN 0041-0047: Production: All AMMPS trailers will have one unit price per range and may be ordered in tan, green, or camouflage at that unit price. For pricing purposes, assume the designated color estimates.

COLOR ESTIMATE:				100% TAN					100% TAN					100% TAN					100% TAN					100% TAN					100% TAN					100% TAN
				AMMPS					AMMPS					AMMPS					AMMPS					AMMPS					AMMPS					AMMPS
	CLIN 0041					CLIN 0042					CLIN 0043					CLIN 0044					CLIN 0045					CLIN 0046					CLIN 0047
	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight	Quantity Ranges:			Unit Price	Weight
	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%	1	-	10		10%
	11	-	50		10%	11	-	50		10%	11	-	50		10%	11	-	50		10%	11	-	50		10%	11	-	50		10%	11	-	50		10%
	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%	51	-	100		10%
	101	-	500		60%	101	-	500		60%	101	-	500		60%	101	-	500		60%	101	-	500		60%	101	-	500		60%	101	-	500		60%
		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%		501+			10%
				5	100%				5	100%				5	100%				5	100%				5	100%				5	100%				5	100%
Weighted Ave. Unit Price				ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges
Estimated Quantities				590					585					585					585					585					585					585
Extended Price				ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges					ERROR - Unit Prices Have Not Been Proposed for All Ranges

Total Price All CLINs AMMPS Trailer ERROR - Unit Prices Have Not Been Proposed for all ranges within each CLIN

Product Support Package

M200A1 Trailers
Attachment 0008 - Pricing Spreadsheet
Solicitation: W56HZV-18-R-0173
Offeror:	0
			Unit Price		Extended Price
CLIN 0050: Product Support Package		1 EA			ERROR - Unit Price Has Not Been Proposed For this CLIN
				1

CDRLS

M200A1 Trailers

Attachment 0008 - Pricing Spreadsheet

Soliciation: W56HZV-18-R-0173

CLIN	CDRL	Description
9001		CONTRACT DATA REQUIREMENTS LIST

A001	ENGINEERING CHANGE PROPOSAL (ECP) VALUE ENGINEERING CHANGE PROPOSAL (VECP)
A002	REQUEST FOR VARIANCE (RFV)
A003	NDT WELD INSPECTION SAMPLING PLAN
A004	CONFERENCE AGENDA AND CONFERENCE MINUTES
A005	PRODUCT QUALITY DEFICIENCY (PQDR) RESPONSES
A006	TEST WORK AUTHORIZATION DOCUMENT
A007	FAILURE ANALYSIS CORRECTIVE ACTION REPORT (FACAR)
A008	FINAL INSPECTION RECORD (FIR)
A009	PRODUCT SUPPORT PACKAGE LIST (PSPL)
A010	PRODUCTION DATABASE
A011	OPERATIONS SECURITY (OPSEC) ANNEX AND TRAINING
A012	LOGISTICS PRODUCT DATA
A013	SPECIAL TOOLS
A014	PROGRAM PRODUCTION DATA

File details come from the government source that posted it. Updated Dec 30, 2023.