Pricing Matrix rev. 1.xlsx

XLSX spreadsheet 34 KB Posted Oct 7, 2020

Attached to: MANUFACTURE OF NSN 5996-01-365-4599EW LOG VIDEO AMPLIFIER/DETECTOR
Solicitation number: SPRWA1-20-R-0032
Issued by: Defense Logistics Agency Aviation

View the file

Other files

File	Type	Posted
SPRWA120R0032_______0006.pdf	PDF	Nov 4, 2020
SPRWA120R0032_______0004.pdf	PDF	Oct 26, 2020
Pricing Matrix rev. 3.xlsx	XLSX spreadsheet	Oct 26, 2020
SPRWA120R0032_______0005.pdf	PDF	Oct 26, 2020
Pricing Matrix rev. 2.xlsx	XLSX spreadsheet	Oct 26, 2020
Document 1- QA Revised 01 Oct 2020.docx	DOCX document	Oct 7, 2020
SPRWA120R0032_______0003.pdf	PDF	Oct 7, 2020
SPRWA120R0032_______0002.pdf	PDF	Sep 21, 2020
Document 1- QA Revised 21 Sep 2020.docx	DOCX document	Sep 21, 2020
Document 1- QA Revised 27 Aug 2020.docx	DOCX document	Aug 31, 2020
SPRWA120R0032_______0001.pdf	PDF	Aug 21, 2020
AFMC260FirstArticle_amd01.pdf	PDF	Aug 21, 2020
Document 1- QA.docx	DOCX document	Aug 21, 2020
SPRWA120R0032.pdf	PDF	Aug 10, 2020
AFMC 158 Packaging.pdf	PDF	Aug 10, 2020
DD FORM 1653 Transportation.pdf	PDF	Aug 10, 2020
PricingMatrix.xlsx	XLSX spreadsheet	Aug 10, 2020
AFMC 260 First Article.pdf	PDF	Aug 10, 2020
CDRLS.pdf	PDF	Aug 10, 2020

Show all 19

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.

EXAMPLE PRICING MATRIX

	ATTACHMENT 1 - PRICING MATRIX
	RFP Number: SPRWA1-19-R-0030					Pricing Periods1										Contract Maximum Calculation4
						Pricing Period 1:
Date of Award Thru 12 Calendar Months	Pricing Period 1 Evaluated Price Calculations	Pricing Period 2:
13 Calendar Months Thru 24 Calendar Months	Pricing Period 2 Evaluated Price Calculations	Pricing Period 3:
25 Calendar Months Thru 36 Calendar Months	Pricing Period 3 Evaluated Price Calculations	Pricing Period 4:
37 Calendar Months Thru 48 Calendar Months	Pricing Period 4 Evaluated Price Calculations	Pricing Period 5:
49 Calendar Months Thru 60 Calendar Months	Pricing Period 5 Evaluated Price Calculations
	CLIN	NSN	Estimated Total Contract QTY	Priced Quantity Range2		UNIT PRICE		UNIT PRICE		UNIT PRICE		UNIT PRICE		UNIT PRICE
				From	To
	0001	XXX-XX-XXX-XXXX UC	80	1	20	$100.00	$ 2,000.00	$102.00	$ 2,040.00	$102.00	$ 2,040.00	$103.00	$ 2,060.00	$105.00	$ 2,100.00	$8,400.00
				21	40	$75.00	$ 1,500.00	$77.00	$ 1,540.00	$78.00	$ 1,560.00	$78.00	$ 1,560.00	$79.00	$ 1,580.00
				41	60	$50.00	$ 1,000.00	$52.00	$ 1,040.00	$55.00	$ 1,100.00	$57.00	$ 1,140.00	$58.00	$ 1,160.00
				61	80	$25.00	$ 500.00	$27.00	$ 540.00	$29.00	$ 580.00	$30.00	$ 600.00	$30.00	$ 600.00
	0002	XXX-XX-XXX-XXXX UC	72	1	72	$100.00	$ 7,200.00	$105.00	$ 7,560.00	$110.00	$ 7,920.00	$110.00	$ 7,920.00	$113.00	$ 8,136.00	$8,136.00
							$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
							$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
							$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
	0003	XXX-XX-XXX-XXXX UC	165	1	100	$100.00	$ 10,000.00	$100.00	$ 10,000.00	$103.00	$ 10,300.00	$103.00	$ 10,300.00	$105.00	$ 10,500.00	$17,325.00
				101	165	$90.00	$ 5,850.00	$90.00	$ 5,850.00	$95.00	$ 6,175.00	$95.00	$ 6,175.00	$98.00	$ 6,370.00
							$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
							$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
	0004	XXX-XX-XXX-XXXX UC	192	1	15	$106.00	$ 1,590.00	$108.00	$ 1,620.00	$110.00	$ 1,650.00	$112.00	$ 1,680.00	$114.00	$ 1,710.00	$21,888.00
				16	49	$95.00	$ 3,230.00	$97.00	$ 3,298.00	$99.00	$ 3,366.00	$101.00	$ 3,434.00	$103.00	$ 3,502.00
				50	80	$93.00	$ 2,883.00	$95.00	$ 2,945.00	$97.00	$ 3,007.00	$99.00	$ 3,069.00	$101.00	$ 3,131.00
				81	100	$90.00	$ 1,800.00	$91.00	$ 1,820.00	$92.00	$ 1,840.00	$93.00	$ 1,860.00	$94.00	$ 1,880.00
				101	149	$85.00	$ 4,165.00	$90.00	$ 4,410.00	$95.00	$ 4,655.00	$100.00	$ 4,900.00	$105.00	$ 5,145.00
				150	192	$83.00	$ 3,569.00	$85.00	$ 3,655.00	$87.00	$ 3,741.00	$89.00	$ 3,827.00	$91.00	$ 3,913.00
	0005	XXX-XX-XXX-XXXX UC	100	1	50	$100.00	$ 5,000.00	$110.00	$ 5,500.00	$120.00	$ 6,000.00	$130.00	$ 6,500.00	$140.00	$ 7,000.00	$14,000.00
				51	100	$80.00	$ 4,000.00	$80.00	$ 4,000.00	$89.00	$ 4,450.00	$95.00	$ 4,750.00	$95.00	$ 4,750.00
							$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
							$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
	0006	XXX-XX-XXX-XXXX UC	25	1	2	$100.00	$ 200.00	$100.00	$ 200.00	$100.00	$ 200.00	$100.00	$ 200.00	$100.00	$ 200.00	$2,500.00
				3	5	$98.00	$ 294.00	$98.00	$ 294.00	$98.00	$ 294.00	$98.00	$ 294.00	$98.00	$ 294.00
				6	8	$97.00	$ 291.00	$97.00	$ 291.00	$97.00	$ 291.00	$97.00	$ 291.00	$97.00	$ 291.00
				9	11	$95.00	$ 285.00	$95.00	$ 285.00	$95.00	$ 285.00	$95.00	$ 285.00	$95.00	$ 285.00
				12	15	$92.00	$ 368.00	$92.00	$ 368.00	$92.00	$ 368.00	$92.00	$ 368.00	$92.00	$ 368.00
				16	20	$90.00	$ 450.00	$90.00	$ 450.00	$90.00	$ 450.00	$90.00	$ 450.00	$90.00	$ 450.00
				21	25	$86.00	$ 430.00	$86.00	$ 430.00	$86.00	$ 430.00	$86.00	$ 430.00	$86.00	$ 430.00
						Subtotal	$ 56,605.00		$ 58,136.00		$ 60,702.00		$ 62,093.00		$ 63,795.00	Contract Maximum	$72,249.00
						Weighted Subtotal	$ 11,321.00		$ 11,627.20		$ 12,140.40		$ 12,418.60		$ 12,759.00
																TOTAL EVALUATED PRICE3	$60,266.20

NOTES:

1 Failure to provide pricing for 60 consecutive months may result in offer being determined ineligible for award.

2 Quantity Ranges within each Pricing Period are to be established by the offeror, but pricing must be provided for every unit from 1 EA to the Estimated Total Contract Quantity. Offerors may add rows as necessary to accommodate proposed quantity ranges. However, no other format changes are permitted. Failure to submit a proposal in the format of this sheet may result in offer being determined ineligible for award.

PRICNG MATRIX (Housings)

	ATTACHMENT 1 - PRICING MATRIX
	RFP Number: SPRWA1-20-R-0032					Ordering Periods
						Basic Ordering Period:
Date of Award Thru 12 Calendar Months	Basic Ordering Period Evaluated Price Calculations	Ordering Period 1:
13 Calendar Months Thru 24 Calendar Months	Ordering Period 1 Evaluated Price Calculations	Ordering Period 2:
25 Calendar Months Thru 36 Calendar Months	Ordering Period 2 Evaluated Price Calculations	Ordering Period 3:
37 Calendar Months Thru 48 Calendar Months	Ordering Period 3 Evaluated Price Calculations	Ordering Period 4:
49 Calendar Months Thru 60 Calendar Months	Ordering Period 4 Evaluated Price Calculations	Sub Totals
	CLIN	NSN	Best Estimated QTY (BEQ)	Priced Quantity Range		UNIT PRICE		UNIT PRICE	UNIT PRICE	UNIT PRICE	UNIT PRICE
				From	To
	0001	5996-01-365-4599	2	N/A	N/A		$ - 0
	Amplifier, Electronic
	FIRST ARTICLE

FIRST ARTICLE Test Costs (Do Not Alter)					$3,000.00	$ 3,000.00
0002	5996-01-365-4599	32	1	32		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Amplifier, Electronic						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Production						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0003
DATA, A001 - Acceptance Test Procedure (ATP)		1 Lot				$ - 0
DATA, A002 - Acceptance Test Report (ATR)		1 Lot				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
DATA, A003 - IUID Marking Plan		1 Lot				$ - 0
DATA, A004 - IUID Marking Activity and Verification Report		1 Lot				$ - 0
DATA, A005- Counterfeit Prevention Plan		1 Lot				$ - 0
DATA, A006- First Article Qualification Test Procedures (QTP)		1 Lot				$ - 0
DATA, A007- First Article Qualification Test Reprt (QTR)		1 Lot				$ - 0
1001	5996-01-365-4599	10	1	10		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Amplifier, Electronic						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Production						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
2001	5996-01-365-4599	10	1	10		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Amplifier, Electronic						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Production						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3001	5996-01-365-4599	10	1	10		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Amplifier, Electronic						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Production						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4001	5996-01-365-4599	10	1	10		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Amplifier, Electronic						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Production						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

		$ - 0	$ - 0	$ - 0	$ - 0
First Article Subtotal	$ 3,000.00					$ 3,000.00
Production Subtotal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Subtotal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Data Subtotal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	TOTAL EVALUATED PRICE	$3,000.00
Total Evaluated Price	$ 3,000.00	$ - 0	$ - 0	$ - 0	$ - 0	$ 3,000.00

NOTES:

1 Failure to provide pricing for every Ordering Period may result in offer being determined ineligible for award.

2 For First Articles, the Unit Price will be multiplied by 2 (Column C times Column F) to calculate the extended price. This sum will be added to the First Article Test Costs shown in cells F10, F15 and F20 (Do not alter these cells) to calculate a First Article Sub-Total.

3 Production Best Estimated Quantities (BEQ's) within each Ordering Period may be broken into multiple ranges by the offeror, but pricing must be provided for every unit up to the Best Estimated Quantity for each CLIN. Offerors may add rows as necessary to accomodate proposed quantity ranges. However, no other format changes are permitted. Failure to submit a proposal in the format of this sheet may result in offer being determined ineligible for award.

4 For each Production Quantity Range for which a unit price is proposed, the unit price will be multiplied by a quantity equal to the absolute difference between the "To" and "From" quantities, plus one (1). The sum of these calculations within each Ordering Period will be multiplied by .20 (Factor ONLY applies to the Production Subtotal.). The sum of these Ordering Period calculations will be added to the First Article Subtotal and the Data Subtotal to arrive at the Total Evaluated Price.

5 The Best Estimated Quantity (BEQ) is reflected in Column C. The quantities in Column C for A003-A007 are One Time Quantities.

6 Do not make changes/additions in Areas of Matrix that are shaded in Grey

File details come from the government source that posted it. Updated Oct 8, 2020.