Attach 0016 - M829A4 Pricing Matrix_rev.xlsx

XLSX spreadsheet 38 KB Posted Jan 24, 2023

Attached to: M829A4 120mm, Armor Piercing, Fin Stabilized, Discarding Sabot with Tracer (APFSDS-T) Cartridge
Solicitation number: W15QKN23R0007
Issued by: Department of the Army Materiel Command Contracting Command Picatinny Arsenal

View the file

Other files

File	Type	Posted
W15QKN23R0007-0007.pdf	PDF	Apr 14, 2023
Attach 0016 - M829A4 Pricing Matrix_rev2- 05 Apr 2023.xlsx	XLSX spreadsheet	Apr 14, 2023
W15QKN23R0007-0006.pdf	PDF	Mar 31, 2023
W15QKN23R0007-0005.pdf	PDF	Mar 14, 2023
W15QKN23R0007-0004.pdf	PDF	Mar 3, 2023
W15QKN23R0007-0003.pdf	PDF	Feb 27, 2023
Attach 0010 - Solicitation Quality Requirements_rev2.pdf	PDF	Feb 27, 2023
W15QKN23R0007-0002.pdf	PDF	Feb 16, 2023
Attach 0016 - M829A4 Pricing Matrix_rev1 15 Feb 2023.xlsx	XLSX spreadsheet	Feb 16, 2023
Attach 0008 - Non Disclosure and Non Use Agreement_rev2.docx	DOCX document	Feb 2, 2023
W15QKN23R0007-0001_FINAL.pdf	PDF	Feb 2, 2023
A009 Signed Audits.pdf	PDF	Jan 24, 2023
A002 Signed Minutes.pdf	PDF	Jan 24, 2023
Attach 0014 - CCDC-AC Procedure 203.03.2 Dimensional Modeling Standards.pdf	PDF	Jan 24, 2023
Attach 0009 - SFAE-AMO 3002 Form PEO Ammo Public Release Clearance Review.pdf	PDF	Jan 24, 2023
A028 TDP Signed.pdf	PDF	Jan 24, 2023
A020 EMHCFOR Signed_rev.pdf	PDF	Jan 24, 2023
Attach 0013 - Past Performance Questionnaire_rev1.pdf	PDF	Jan 24, 2023
A027 RFV Analysis Signed.pdf	PDF	Jan 24, 2023
A022 CMP Signed_rev.pdf	PDF	Jan 24, 2023
A014 Signed Rework.pdf	PDF	Jan 24, 2023
A017 AIR Signed.pdf	PDF	Jan 24, 2023
A018 POP Signed.pdf	PDF	Jan 24, 2023
Attach 0007 - AMSTA-AR 1350 - Technical Data Request Questionnaire.pdf	PDF	Jan 24, 2023
A015 Test Plan Signed_rev.pdf	PDF	Jan 24, 2023
A003 PCDL Signed_rev.pdf	PDF	Jan 24, 2023
A006 Signed CCCP.pdf	PDF	Jan 24, 2023
A025 RFV Signed.pdf	PDF	Jan 24, 2023
A005 Signed ITP_rev.pdf	PDF	Jan 24, 2023
Attach 0008 - Non Disclosure and Non Use Agreement_rev1.pdf	PDF	Jan 24, 2023
A007 Signed CICL.pdf	PDF	Jan 24, 2023
Attach 0011 - Additional Solicitation and Contract Requirements.pdf	PDF	Jan 24, 2023
A008 Signed CPOA.pdf	PDF	Jan 24, 2023
Attach 0012 - DD 2345 Militarily Critical Technical Data Agreement.pdf	PDF	Jan 24, 2023
A012 ADC Signed.pdf	PDF	Jan 24, 2023
A023 ECP Signed.pdf	PDF	Jan 24, 2023
A016 Signed TIR.pdf	PDF	Jan 24, 2023
Attach 0015 - SF LLL - Disclosure of Lobbying Activities.pdf	PDF	Jan 24, 2023
A011 Signed QDR.pdf	PDF	Jan 24, 2023
A026 ECP Analysis Signed.pdf	PDF	Jan 24, 2023
A004 Signed MSE.pdf	PDF	Jan 24, 2023
A019 EMHCUS Signed_rev.pdf	PDF	Jan 24, 2023
A013 Signed PDS.pdf	PDF	Jan 24, 2023
A001 Agenda Signed.pdf	PDF	Jan 24, 2023
Attach 0005 - DD254_M829A4 PY6_solicitation.pdf	PDF	Jan 24, 2023
Attach 0010 - Solicitation Quality Requirements_rev1.pdf	PDF	Jan 24, 2023
A029 OPSEC Signed_rev.pdf	PDF	Jan 24, 2023
Attach 0006 - Government Furnished Property Approved for Use.xlsx	XLSX spreadsheet	Jan 24, 2023
A021 EMQR Signed_rev.pdf	PDF	Jan 24, 2023
A010 Signed PCA.pdf	PDF	Jan 24, 2023

Show 40 more

Latest 50 of 51 listed here. See the rest on GovTribe.

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.

Production CLINs

OFFEROR NAME:		FORMULA DESCRIPTION AND EXAMPLE
Solicitation No. W15QKN-23-R-0007	= Offeror Must Fill-In Cells	* Using a best fit power curve methodology, the general formula used in the pricing matrix is:	Y=Ax^b
Price Matrix	= Cells Include Formulas; Do Not Change	* Y = Unit Price to be calculated;

A = T-1: the theoretical unit price for the first unit (quantity of 1) based upon the associated curve formula;

x = Quantity to be ordered;

b = Slope for the applicable quantity curve between two specified quantities Production CLINs

OFFEROR: ASSERT WHETHER YOUR OFFER IS / IS NOT PREDICATED UPON THE USE OF GOVERNMENT PROPERTY IN YOUR POSSESSION OR ONE OF YOUR SUBCONTRACTOR'S POSSESSION: (Select response from Drop Down Menu)
	* Using the example data and quantities below, for 2,900 items being ordered, the formula is:	Unit price = $142,439.49*2,900^-0.2350
	* The calculated unit price for 2,900 items is:	$21,880.13

IF YOU RESPONDED "IS" PREDICATED ON USE OF GOVERNMENT PROPERTY, COMPLETE THIS TAB and "Production Gov Property", "FAT Govt Property" TABS IN THIS WORKBOOK

	PROPOSED FFP PRODUCTION UNIT PRICES
(excluding rental value of Gov't property, if any)				Curve Data used to Calculate Unit Prices for Quantities between Specified Quantities;
Power Curve Formula: Y=Ax^b				Curved Pricing Calculator
	Example	CLIN	Description	Quantity	M829A4 Unit Price	Curve Applies to		M829A4			Quantity	Unit Price	Total Price
								Slope (b)	T-1 (A)	Formula
		0001	M829A4	2,700	$22,250.62	2,700	2,999	-0.23498	$142,439.49	Y = 142439.49 x ^-0.235	2,900	$21,880.13	$63,452,364.93
				3,000	$21,706.52	3,000	3,399	-0.23498	$142,439.58	Y = 142439.58 x ^-0.235	3,300	$21,225.79	$70,045,114.51
				3,400	$21,077.42

	PROPOSED FFP PRODUCTION UNIT PRICES
(excluding rental value of Gov't property, if any)		Curve Data used to Calculate Unit Prices for Quantities between Specified Quantities;

Power Curve Formula: Y=Ax^b

	CLIN	Description	Quantity	M829A4 Unit Price	Curve Applies to		M829A4 Unit Cost Curves
							Slope (b)	T-1 (A)	Formula
Ordering Period 1	0003	M829A4	2,700		2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000		3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400

Ordering Period 2	0006	M829A4	2,700	2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000	3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400

Ordering Period 3	0009	M829A4	2,700	2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000	3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400

Ordering Period 4	0012	M829A4	2,700	2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000	3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400

Ordering Period 5	0015	M829A4	2,700	2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000	3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400	3,400	4,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			5,000	5,000	9,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			10,000	10,000	14,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			15,000

EXAMPLE

Production Govt Property

OFFEROR NAME:	= Offeror Must Fill-In Cells
Solicitation No. W15QKN-23-R-0007	= Cells Include Formulas; Do Not Change
Price Matrix
Production CLINS Govt Property

This worksheet shall only be completed if the Offeror's proposal "IS" predicated on the use of Government property already in its possession.

Offerors shall input only the PER UNIT RENTAL VALUE on this tab, if applicable.

Should rental value be shown below for the Production CLINs, the equivalent rental value applicable to FAT CLINs MUST be provided on the applicable tab.

Values are only needed for the referenced quantities. The curves from the production CLINs are used to calculate the other quantities.

PER UNIT RENTAL VALUE OF GOVERNMENT PROPERTY Curve Data used to Calculate Per Unit Rental Value for Quantities between Specified Quantities;

Power Curve Formula: Y=Ax^b

	CLIN	Description	Quantity	M829A4	Curve Applies to		M829A4 Unit Cost Curves
				Per Unit Rental Value			Slope (b)	T-1 (A)	Formula
Ordering Period 1	0003	M829A4	2,700		2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000		3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400

Ordering Period 2	0006	M829A4	2,700	2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000	3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400

Ordering Period 3	0009	M829A4	2,700	2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000	3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400

Ordering Period 4	0012	M829A4	2,700	2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000	3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400

Ordering Period 5	0015	M829A4	2,700	2,700	2,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,000	3,000	3,399	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			3,400	3,400	4,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			5,000	5,000	9,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			10,000	10,000	14,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			15,000

FAT CLINs

OFFEROR NAME:	= Offeror Must Fill-In Cells
Solicitation No. W15QKN-23-R-0007
Price Matrix
Component and Ballistic FAT CLINs

PROPOSED FFP FAT PRICES (excluding rental value of Gov't property, if any)

M829A4 FAAT
DESCRIPTION	Quantity	CLIN
		0001 / OP1	0004 / OP2	0007 / OP3	0010 / OP4	0013/ OP5
M829A4 Component FAT	1 Lot
		0002 / OP1	0005 / OP2	0008 / OP3	0011 / OP4	0014 / OP5
M829A4 Ballistic FAT	55

FAT Govt Property

OFFEROR NAME:	= Offeror Must Fill-In Cells
Solicitation No. W15QKN-23-R-0007
Price Matrix
Government Property Per Unit Rental Value for FAT CLINs

This worksheet shall only be completed if the Offeror's proposal IS predicated on the use of Government property already in its possession.

Offerors shall input only the PER UNIT RENTAL VALUE on this tab, if applicable.

Should rental value be shown below for the Production CLINs, the equivalent rental value applicable to FAT CLINs MUST be provided on this tab.

PER UNIT RENTAL VALUE OF GOVERNMENT PROPERTY

M829A4
DESCRIPTION	Quantity	CLIN
		0001 / OP1	0004 / OP2	0007/ OP3	0010 / OP4	0013 / OP5
M829A4 Component FAT	1 Lot
		0002 / OP1	0005 / OP2	0008 / OP3	0011 / OP4	0014 / OP5
M829A4 Ballistic FAT	55

File details come from the government source that posted it. Updated Feb 2, 2023.