Attachment_0001-Price_Matrix_W52P1J-17-R-3019.xlsx

XLSX spreadsheet 15 KB Posted Mar 29, 2017

Attached to: 60mm & 81mm Cushion and Pad
Solicitation number: W52P1J-17-R-3019
Issued by: Department of the Army Materiel Command Joint Munitions Command

About this file

From the source

Attachment 0001 - Price Matrix

View the file

Other files

File	Type	Posted
W52P1J-17-R-3019-0002.pdf	PDF	May 2, 2017
W52P1J-17-R-3019_Amend_0001.pdf	PDF	Apr 27, 2017
W52P1J-17-R-3019.pdf	PDF	Mar 29, 2017
Exhibit_A_CDRL_W52P1J-17-R-3019.pdf	PDF	Mar 29, 2017
9390715F.pdf	PDF	Mar 29, 2017

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.

Matrix

OFFEROR:											Contractor Fill-In
CAGE CODE:
							PRICE MATRIX
							W52P1J-17-R-3019
CLIN 0001: 60MM Cushioning Pad
P/N: 13027373:19200
			Ordering Period 1		Ordering Period 2		Ordering Period 3		Ordering Period 4		Ordering Period 5
Quantity Ranges			Unit Price	Weight	Unit Price	Weight	Unit Price	Weight	Unit Price	Weight	Unit Price	Weight
4,000	-	9,999		10%		10%	$ - 0	10%	$ - 0	40%	$ - 0	10%
10,000	-	29,999	$ - 0	10%	$ - 0	20%	$ - 0	20%	$ - 0	30%	$ - 0	20%
30,000	-	49,999	$ - 0	20%	$ - 0	50%	$ - 0	50%	$ - 0	20%	$ - 0	50%
50,000	-	70,000	$ - 0	60%	$ - 0	20%	$ - 0	20%	$ - 0	10%	$ - 0	20%
			$ - 0		$ - 0	20%	$ - 0	20%		100%		100%
				100%		100%		100%		100%		100%
Ordering Period Evaluated Price			$ - 0		$ - 0		$ - 0		$ - 0		$ - 0

EVALUATED CLIN PRICE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ - 0

CLIN 0002: 60MM Cushion
P/N: 9390715:19200
			Ordering Period 1		Ordering Period 2		Ordering Period 3		Ordering Period 4		Ordering Period 5
Quantity Ranges			Unit Price	Weight	Unit Price	Weight	Unit Price	Weight	Unit Price	Weight	Unit Price	Weight
2,000	-	6,999	$ - 0	10%	$ - 0	20%	$ - 0	20%	$ - 0	50%	$ - 0	20%
7,000	-	14,999	$ - 0	10%	$ - 0	60%	$ - 0	50%	$ - 0	30%	$ - 0	60%
15,000	-	24,999	$ - 0	20%	$ - 0	10%	$ - 0	20%	$ - 0	10%	$ - 0	10%
25,000	-	40,000	$ - 0	60%	$ - 0	10%	$ - 0	10%	$ - 0	10%	$ - 0	10%
				100%		100%		100%		100%		100%
Ordering Period Evaluated Price			$ - 0		$ - 0		$ - 0		$ - 0		$ - 0

EVALUATED CLIN PRICE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ - 0

CLIN 0003: 81MM Cushion Padding
P/N:9362799-2:19200
			Ordering Period 1		Ordering Period 2		Ordering Period 3		Ordering Period 4		Ordering Period 5
Quantity Ranges			Unit Price	Weight	Unit Price	Weight	Unit Price	Weight	Unit Price	Weight	Unit Price	Weight
2,000	-	7,999	$ - 0	35%	$ - 0	20%	$ - 0	20%	$ - 0	20%	$ - 0	10%
8,000	-	15,999	$ - 0	50%	$ - 0	50%	$ - 0	50%	$ - 0	50%	$ - 0	20%
16,000	-	29,999	$ - 0	10%	$ - 0	20%	$ - 0	20%	$ - 0	20%	$ - 0	50%
30,000	-	50,000	$ - 0	5%	$ - 0	10%	$ - 0	10%	$ - 0	10%	$ - 0	20%
				100%		100%		100%		100%		100%
Ordering Period Evaluated Price			$ - 0		$ - 0		$ - 0		$ - 0		$ - 0

EVALUATED CLIN PRICE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ - 0

TOTAL EVALUATED PRICE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ - 0

The offeror is required to fill in only the blue shaded boxes The Total Evaluated Price is calculated as follows:

1. For each CLIN, the Ordering Period Evaluated Price is the sum of the following calculations at each quantity range: for each quantity range the unit price will be multiplied by the upper limit of the quantity range then multiplied by the respective weight for each Ordering Period.

2. For each CLIN, the Evaluated CLIN price is the sum of all Ordering Period Evaluated Prices.

3. The Total Evaluated Price is the sum of the Evaluated CLIN Prices.

File details come from the government source that posted it. Updated Nov 14, 2017.