Attachment 0001-Price Matrix-SRTA 18JUL23.xlsx

XLSX spreadsheet 57 KB Posted Aug 21, 2023

Attached to: 5. 56mm and 7. 62mm Short Range Training Ammunition (SRTA) Federal contract opportunity
Solicitation number: W15QKN23R0005
Issued by: Department of the Army Materiel Command Contracting Command Picatinny Arsenal

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains a price matrix for a federal contract solicitation for 5.56mm and 7.62mm Short Range Training Ammunition from the Department of the Army Materiel Command Contracting Command at Picatinny Arsenal. The price matrix includes unit pricing curves and formulas for determining prices for quantities between specified points based on best fit power curve methodologies, with examples provided for 5.56mm and 7.62mm ammunition. The price matrix requires bidders to fill in unit prices for quantities across five ordering periods. It also includes templates for firm fixed prices for future delivery orders. The solicitation seeks ammunition for short-range training and sets baseline prices and pricing curves to determine prices for various order quantities across multiple future ordering periods.

View the file

Other files for this federal contract opportunity

Other files attached to 5. 56mm and 7. 62mm Short Range Training Ammunition (SRTA), newest first.
File	Type	Posted
W15QKN-23-R-0005 Amendment 02.pdf	PDF	Oct 18, 2023
W15QKN23R0005-0001.pdf	PDF	Sep 8, 2023
Attachment 0009 - GFPW15QKN23R0005_rev 29AUG2023.pdf	PDF	Sep 8, 2023
Attachment 0004 - PERFORMANCE SPECIFICATION MIL-PRF-32409 with AMD. 2 - 5.56mm SRTA M1037.pdf	PDF	Aug 21, 2023
Exibit A - CDRLs Package.pdf	PDF	Aug 21, 2023
Attachment 0005 - PERFORMANCE SPECIFICATION MIL-PRF-71167C with AMD. 3 - 7.62mm SRTA M973-M974.pdf	PDF	Aug 21, 2023
Attachment 0006 - AMSTA-AR 1350 - Technical Data Request Questionnaire.pdf	PDF	Aug 21, 2023
Attachment 0007 - Non-Disclosure and Non-Use Agreement.docx	DOCX document	Aug 21, 2023
Attachment 0002 - DD 2345 Military Critial Technical Data Agreement.pdf	PDF	Aug 21, 2023
W15QKN-23-R-0005.pdf	PDF	Aug 21, 2023
Attachment 0003 - FORM 3002 PUBLIC RELEASE.pdf	PDF	Aug 21, 2023
Attachment 0008 - STANDARD FORM LLL - Disclosure of Lobbying Activities.pdf	PDF	Aug 21, 2023
Attachment 0010-Additional Solicitation and Contract Requirements.pdf	PDF	Aug 21, 2023
Attachment 0011 - Contract Quality Requirements.docx	DOCX document	Aug 21, 2023
Attachment 0009-GFP W15QKN23R0005.pdf	PDF	Aug 21, 2023

Show all 15

On GovTribe

Work with this file on GovTribe

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 - 5.56mm

W15QKN-23-R-0005 - Price Matrix	= Contractor Required Fill-In Cells
	= Cells Include Formulas; Do Not Change

FORMULA DESCRIPTION AND EXAMPLE
* Using a best fit power curve methodology, the general formula is:	Y=Ax^b
* 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

* Using the example below, for 150,000 items being ordered, the formula is:	Unit price = $2.56*150,000^-0.0377
* The calculated unit price for 150,000 items is:	$1.63

	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	Unit Price	Curve Applies to		5.56mm & 7.62mm SRTA			Quantity	Unit Price	Total Price
								Slope (b)	T-1 (A)	Formula
		AC10	5.56mm SRTA M1037 Linked	50,000	$1.70	50,000	249,999	-0.03767	$2.56	Y = 2.56 x ^-0.0377	150,000	$1.63	$244,662.77
				250,000	$1.60	250,000	499,999	-0.09311	$5.09	Y = 5.09 x ^-0.0931	275,000	$1.59	$436,112.59
				500,000	$1.50

	Unit Prices		Curve Data used to Calculate Unit Prices for Quantities between Specified Quantity Points;
Power Curve Formula: Y=Ax^b		Production Unit Prices- Other than Price Points- For Future Delivery Orders

Ordering Period	CLIN	Description	Quantity	Unit Price	Curve Formula Applies to		SRTA Unit Price Curves			Quantity	Unit Price
							Slope (b)	T-1 (A)	Formula
Ordering Period 1	0001	5.56mm SRTA, M1037 Linked, (AC10)	50,000		50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000		250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000		500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000		1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000		2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000		4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0002	5.56mm SRTA, M1037 Clipped, (AB67)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

Ordering Period 2	0009	5.56mm SRTA, M1037 Linked, (AC10)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0010	5.56mm SRTA, M1037 Clipped, (AB67)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

Ordering Period 3	0017	5.56mm SRTA, M1037 Linked, (AC10)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0018	5.56mm SRTA, M1037 Clipped, (AB67)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

Ordering Period 4	0025	5.56mm SRTA, M1037 Linked, (AC10)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0026	5.56mm SRTA, M1037 Clipped, (AB67)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

Ordering Period 5	0033	5.56mm SRTA, M1037 Linked, (AC10)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0034	5.56mm SRTA, M1037 Clipped, (AB67)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

EXAMPLE

Production - 7.62mm

W15QKN-23-R-0005 - Price Matrix	= Contractor Required Fill-In Cells
	= Cells Include Formulas; Do Not Change

FORMULA DESCRIPTION AND EXAMPLE
* Using a best fit power curve methodology, the general formula is:	Y=Ax^b
* 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

* Using the example below, for 150,000 items being ordered, the formula is:	Unit price = $2.39*150,000^-0.0429
* The calculated unit price for 150,000 items is:	$1.43

	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	Unit Price	Curve Applies to		5.56mm & 7.62mm SRTA			Quantity	Unit Price	Total Price
								Slope (b)	T-1 (A)	Formula
		AA37	7.62mm SRTA, M973/M974 Tracer, 4:1	50,000	$1.50	50,000	249,999	-0.04287	$2.39	Y = 2.39 x ^-0.0429	150,000	$1.43	$214,649.28
				250,000	$1.40	250,000	499,999	-0.10692	$5.29	Y = 5.29 x ^-0.1069	275,000	$1.39	$381,096.73
				500,000	$1.30

	Unit Prices		Curve Data used to Calculate Unit Prices for Quantities between Specified Quantity Points;
Power Curve Formula: Y=Ax^b		Production Unit Prices- Other than Price Points- For Future Delivery Orders

Ordering Period	CLIN	Description	Quantity	Unit Price	Curve Formula Applies to		SRTA Unit Price Curves			Quantity	Unit Price
							Slope (b)	T-1 (A)	Formula
Ordering Period 1	0003	7.62mm SRTA, M973/M974 Tracer, 4:1 (AA37)	50,000		50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000		250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000		500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000		1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000		2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000		4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0004	7.62mm SRTA, M973 Ball, Linked (AB60)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

Ordering Period 2	0011	7.62mm SRTA, M973/M974, 4:1 Tracer, (AA37)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0012	7.62mm SRTA, M973 Ball, Linked (AB60)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

Ordering Period 3	0019	7.62mm SRTA, M973/M974 Tracer, 4:1 (AA37)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0020	7.62mm SRTA, M973 Ball, Linked (AB60)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

Ordering Period 4	0027	7.62mm SRTA, M973/M974 Tracer, 4:1 (AA37)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0028	7.62mm SRTA, M973 Ball, Linked (AB60)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

Ordering Period 5	0035	7.62mm SRTA, M973/M974 Tracer, 4:1 (AA37)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
			6,500,000

0036	7.62mm SRTA, M973 Ball, Linked (AB60)	50,000	50,000	249,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		250,000	250,000	499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		500,000	500,000	999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		1,000,000	1,000,000	1,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		2,000,000	2,000,000	3,999,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		4,000,000	4,000,000	6,499,999	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
		6,500,000

EXAMPLE

FAT

W15QKN-23-R-0005 - Price Matrix

= Contractor Required Fill-In Cells

Ordering Period (OP)	CLIN	Description	Price
OP1	0005	5.56mm SRTA, M1037 Linked
	0006	5.56mm SRTA, M1037 Clipped
	0007	7.62mm SRTA, M974 Tracer
	0008	7.62mm SRTA, M973 Ball
OP2	0013	5.56mm SRTA, M1037 Linked
	0014	5.56mm SRTA, M1037 Clipped
	0015	7.62mm SRTA, M974 Tracer
	0016	7.62mm SRTA, M973 Ball
OP3	0021	5.56mm SRTA, M1037 Linked
	0022	5.56mm SRTA, M1037 Clipped
	0023	7.62mm SRTA, M974 Tracer
	0024	7.62mm SRTA, M973 Ball
OP4	0029	5.56mm SRTA, M1037 Linked
	0030	5.56mm SRTA, M1037 Clipped
	0031	7.62mm SRTA, M974 Tracer
	0032	7.62mm SRTA, M973 Ball
OP5	0037	5.56mm SRTA, M1037 Linked
	0038	5.56mm SRTA, M1037 Clipped
	0039	7.62mm SRTA, M974 Tracer
	0040	7.62mm SRTA, M973 Ball

File details come from the government source that posted it. Updated Aug 21, 2023.