Attachment_0003_-_Pricing_Spreadsheeet.xlsx

XLSX spreadsheet 151 KB Posted Sep 27, 2019

Attached to: M16A4 RIFLES - 1005--GUNS, THROUGH 30MM
Solicitation number: W56HZV-19-R-0067
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 contains a pricing spreadsheet template and instructions for a solicitation seeking M16A4 rifles. The solicitation will be issued by the Army Contracting Command-Warren seeking fixed price indefinite delivery indefinite quantity contracts for up to five years to provide M16A4 rifles in standard, alternate one, and alternate two configurations. Production quantities will range from 12 rifles for first article testing to a maximum of 215,000 rifles total across both contracts if awarded. Offerors must complete the pricing template by inputting unit prices and calculated weighted average ceiling prices for each contract line item number across the five potential ordering years. The template will automatically calculate a total evaluated price for evaluation purposes.

From the source

Attachment 0003 - Pricing Spreadsheeet

View the file

Other files

File	Type	Posted
W56HZV19R0067-0005.pdf	PDF	Nov 1, 2019
Questions_and_Answers_-_Set_4-_W56HZV-19-R-0067_-_31_October_2019.pdf	PDF	Oct 31, 2019
W56HZV19R0067-0004.pdf	PDF	Oct 30, 2019
W56HZV19R0067-0003.pdf	PDF	Oct 28, 2019
Attachment_0003_-_Pricing_Spreadsheet_-_Amendment_0003.xlsx	XLSX spreadsheet	Oct 28, 2019
W56HZV19R0067-0002.pdf	PDF	Oct 25, 2019
Questions_and_Answers_-_Set_3-_W56HZV-19-R-0067_-_25_October_2019.pdf	PDF	Oct 25, 2019
W56HZV19R0067-0001.pdf	PDF	Oct 25, 2019
Questions_and_Answers_-_Set_2-_W56HZV-19-R-0067_-_24_October_2019.pdf	PDF	Oct 24, 2019
Questions_and_Answers_-_W56HZV-19-R-0067_-_Correction__-_22_October_2019.pdf	PDF	Oct 22, 2019
Questions_and_Answers_-_W56HZV-19-R-0067_-_21_October_2019.pdf	PDF	Oct 21, 2019
Request_for_Proposal_(RFP)_W56HZV-19-R-0067.pdf	PDF	Sep 27, 2019
Attachment_0007_-_Certificate_of_Destruction_of_Technical_Data.doc	DOC document	Sep 27, 2019
Attachment_0002_-_Past_Performance_Questionnaire.docx	DOCX document	Sep 27, 2019
Attachment_0004_-_SBP_Workbook.xlsx	XLSX spreadsheet	Sep 27, 2019
Attachment_0001_-_Non-disclosure_Agreement.pdf	PDF	Sep 27, 2019
Attachment_0006_-_SBP_Certification_of_Subcontractor.docx	DOCX document	Sep 27, 2019
Attachment_0005_-_SBP_Workbook_Instructions.docx	DOCX document	Sep 27, 2019
Attachment_0002_-_Past_Performance_Questionnaire_DRAFT.docx	DOCX document	Aug 1, 2019
Attachment_0001_-_Non-disclosure_Agreement_DRAFT.pdf	PDF	Aug 1, 2019
Attachment_0004_-_SBP_Workbook_DRAFT.xlsx	XLSX spreadsheet	Aug 1, 2019
Attachment_0007_-_Certificate_of_Destruction_of_Technical_Data_DRAFT.doc	DOC document	Aug 1, 2019
Attachment_0005_-_SBP_Workbook_Instructions_DRAFT.docx	DOCX document	Aug 1, 2019
Attachment_0006_-_SBP_Certification_of_Subcontractor_DRAFT.docx	DOCX document	Aug 1, 2019
DRAFT_W56HZV-19-R-0067_01Aug2019_DRAFT.pdf	PDF	Aug 1, 2019
Attachment_0003_-_Pricing_Spreadsheeet_DRAFT.xlsx	XLSX spreadsheet	Aug 1, 2019

Show all 26

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 to Offerors

INSTRUCTIONS TO OFFERORS

1)	Offeror input is required in the yellow highlighted cells in the "Pricing Input Worksheet".
	All yelllow highlighted cells must be completed.

2) Do not manipulate any other cells or worksheets.

3)	The "Summary" tab calulates the Total Evaluated Price that will be used for purposes
	of evaluation.

Summary

M16A4 Rifle Summary

Solicitation: W56HZV-19-R-0067

CLIN Description Price

0011	Weighted Average Ceiling Unit Price - Standard Yr. 1	$ - 0
0021	Weighted Average Ceiling Unit Price - Standard Yr. 2	- 0
0031	Weighted Average Ceiling Unit Price - Standard Yr. 3	- 0
0041	Weighted Average Ceiling Unit Price - Standard Yr. 4	- 0
0051	Weighted Average Ceiling Unit Price - Standard Yr. 5	- 0
	Subtotal Standard Configuration	$ - 0

0012	Weighted Average Ceiling Unit Price - Alternate One Yr. 1	$ - 0
0022	Weighted Average Ceiling Unit Price- Alternate One Yr. 2	- 0
0032	Weighted Average Ceiling Unit Price - Alternate One Yr. 3	- 0
0042	Weighted Average Ceiling Unit Price- Alternate One Yr. 4	- 0
0052	Weighted Average Ceiling Unit Price- Alternate One Yr. 5	- 0
	Subtotal Atlernate One Configuration	$ - 0

0013	Weighted Average Ceiling Unit Price - Alternate Two Yr. 1	$ - 0
0023	Weighted Average Ceiling Unit Price- Alternate Two Yr. 2	- 0
0033	Weighted Average Ceiling Unit Price - Alternate Two Yr. 3	- 0
0043	Weighted Average Ceiling Unit Price - Alternate Two Yr. 4	- 0
0053	Weighted Average Ceiling Unit Price- Alternate Two Yr. 5	- 0
	Subtotal Atlernate Two Configuration	$ - 0

0061 First Article Test (FAT) $ - 0

Total Evaluated Price $ - 0

Note: CLIN 0071 is Not Separately Priced (NSP)

Pricing Input Worksheet

M16A4 Rifle: Price Input Worksheet
Solicitation: W56HZV-19-R-0067
Input Name and CAGE number
Ordering Year 1
CLIN	Description	Unit of Issue	Quantity	Weighting	CLIN Type	Unit Price	Amount
0011	M16A4 Rifles Standard Configuration Production	EA	1 - 1,000	10%	FFP		$ - 0
			1,001 - 5,000	15%	FFP		- 0
			5,001 - 15,000	20%	FFP		- 0
			15,001 - 30 000	25%	FFP		- 0
			30,001 - 50,000	30%	FFP		- 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				35,000
			Weighted Average CLIN Price - Standard Yr. 1				$ - 0
0012	M16A4 Rifle Alternate One Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	25%	FFP		$ - 0
			5,001 - 15,000	30%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				7,500
			Weighted Average CLIN Price - Alternate One Yr. 1				$ - 0
0013	M16A4 Rifle Alternate Two Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	25%	FFP		$ - 0
			5,001 - 15,000	30%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				7,500
			Weighted Average CLIN Price - Alternate Two Yr. 1				$ - 0
0061	First Article Test (FAT)	EA	12	N/A	FFP		$ - 0

Ordering Year 2
CLIN	Description	Unit of Issue	Quantity	Weighting	CLIN Type	Unit Price	Amount
0021	M16A4 Rifles Standard Configuration Production	EA	1 - 1,000	10%	FFP		$ - 0
			1,001 - 5,000	15%	FFP		$ - 0
			5,001 - 15,000	20%	FFP		$ - 0
			15,001 - 30 000	25%	FFP		$ - 0
			30,001 - 50,000	30%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				35,000
			Weighted Average CLIN Price - Standard Yr. 2				$ - 0
0022	M16A4 Rifle Alternate One Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	25%	FFP		$ - 0
			5,001 - 15,000	30%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				7,500
			Weighted Average CLIN Price - Alternate One Yr. 2				$ - 0
0023	M16A4 Rifle Alternate Two Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	25%	FFP		$ - 0
			5,001 - 15,000	30%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				7,500
			Weighted Average CLIN Price - Alternate Two Yr. 2				$ - 0

Ordering Year 3
CLIN	Description	Unit of Issue	Quantity	Weighting	CLIN Type	Unit Price	Amount
0031	M16A4 Rifles Standard Configuration Production	EA	1 - 1,000	10%	FFP		$ - 0
			1,001 - 5,000	15%	FFP		$ - 0
			5,001 - 15,000	20%	FFP		$ - 0
			15,001 - 30 000	25%	FFP		$ - 0
			30,001 - 50,000	30%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				35,000
			Weighted Average CLIN Price - Standard Yr. 3				$ - 0
0032	M16A4 Rifle Alternate One Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	25%	FFP		$ - 0
			5,001 - 15,000	30%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				7,500
			Weighted Average CLIN Price - Alternate One Yr. 3				$ - 0
0033	M16A4 Rifle Alternate Two Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	25%	FFP		$ - 0
			5,001 - 15,000	30%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				7,500
			Weighted Average CLIN Price - Alternate Two Yr. 3				$ - 0

Ordering Year 4
CLIN	Description	Unit of Issue	Quantity	Weighting	CLIN Type	Unit Price	Amount
0041	M16A4 Rifles Standard Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	20%	FFP		$ - 0
			5,001 - 15,000	25%	FFP		$ - 0
			15,001 - 30 000	30%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				24,500
			Weighted Average CLIN Price - Standard Yr. 4				$ - 0
0042	M16A4 Rifle Alternate One Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	30%	FFP		$ - 0
			5,001 - 15,000	25%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				5,250
			Weighted Average CLIN Price - Alternate One Yr. 4				$ - 0
0043	M16A4 Rifle Alternate Two Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	25%	FFP		$ - 0
			5,001 - 15,000	30%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				5,250
			Weighted Average CLIN Price - Alternate Two Yr. 4				$ - 0

Ordering Year 5
CLIN	Description	Unit of Issue	Quantity	Weighting	CLIN Type	Unit Price	Amount
0051	M16A4 Rifles Standard Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	20%	FFP		$ - 0
			5,001 - 15,000	25%	FFP		$ - 0
			15,001 - 30 000	30%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				21,000
			Weighted Average CLIN Price - Standard Yr. 5				$ - 0
0052	M16A4 Rifle Alternate One Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	30%	FFP		$ - 0
			5,001 - 15,000	25%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				4,500
			Weighted Average CLIN Price - Alternate One Yr. 5				$ - 0
0053	M16A4 Rifle Alternate Two Configuration Production	EA	1 - 1,000	15%	FFP		$ - 0
			1,001 - 5,000	30%	FFP		$ - 0
			5,001 - 15,000	25%	FFP		$ - 0
			15,001 - 30 000	20%	FFP		$ - 0
			30,001 - 50,000	10%	FFP		$ - 0
			Weighted Average Ceiling Unit Price				$ - 0
			Evaluated Quantity				4,500
			Weighted Average CLIN Price - Alternate Two Yr. 5				$ - 0

Not Separately Price (NSP)

CLIN	Description	Unit Price
0071	CDRLs - Ordering Year 1	NSP
A001	Meeting, Agenda, and Minutes	NSP
A002	Compliance Certification/Data Report	NSP
A003	Quality Program Plan (QPP)	NSP
A004	Acceptance and Inspection Equipment (AIE)	NSP
A005	First Article Inspection Report	NSP
A006	First Article Test (FAT) Plan	NSP
A007	First Article Test (FAT) Report	NSP
A008	Phosphate Coating Procedures/Test Plan	NSP
A009	Test Procedures - Magnetic Particle Inspection	NSP
A010	Liquid Dye Penetrant Inspection Procedures/Test Plan	NSP
A011	Chromium Plating Procedures	NSP
A012	Lot Acceptance Test Report	NSP
A013	Engineering Failure Analysis And Correction Report	NSP
A014	Quality Assessment Report	NSP
A015	Unique Identification Requirements	NSP
A016	Engineering Change Proposals (ECPs) and Value Engineering Change Proposals (VECPs)	NSP
A017	Notice of Revision (NOR)	NSP
A018	Request for Variance (RFV)	NSP
A019	Serial Number Tracking	NSP
A020	Accident Incident Report	NSP
A021	Security Verification Process Report	NSP
A022	Government Furnished Material (GFM) Consumption	NSP
A023	Defective Government Furnished Material (GFM)	NSP
A024	Reports of Receipts, Inventory, Adjustments, and Shipments of Government Property	NSP
A025	Quality Deficiency Report	NSP
A026	Shipping and Packaging Discrepency Report	NSP

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