1.__Pricing_Matrix_01.xlsx

XLSX spreadsheet 28 KB Posted Apr 16, 2019

Attached to: Radio Frequency (RF) Switches spares applicable to the AN/ALQ-131 Electronic Attack Pod
Solicitation number: SPRWA1-18-R-0033
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Robins Air Force Base

About this file

From the source

Attachment 1. Pricing Matrix 01.

View the file

Other files

File	Type	Posted
SPRWA1-18-R-0033-0003.pdf	PDF	Apr 17, 2019
SPRWA1-18-R-0033-0002.pdf	PDF	Apr 16, 2019
Questions_Responses_Round2.pdf	PDF	Apr 9, 2019
Questions_Responses_Round1.pdf	PDF	Apr 4, 2019
SPRWA1-18-R-0033-0001.pdf	PDF	Mar 25, 2019
7.__DD_Form_254.pdf	PDF	Mar 4, 2019
1.__Pricing_Matrix.xlsx	XLSX spreadsheet	Mar 4, 2019
SPRWA1-18-R-0033.pdf	PDF	Mar 4, 2019
5.__DD_Form_1653.pdf	PDF	Mar 4, 2019
6._CDRLs.pdf	PDF	Mar 4, 2019
2.__AFMC_Form_260s.pdf	PDF	Mar 4, 2019
4.__AFMC_807.pdf	PDF	Mar 4, 2019
3.__AFMC_158.pdf	PDF	Mar 4, 2019

Show all 13

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-18-R-SAMPLE					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	1560-00-661-1561LG	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	1560-00-670-2062LG	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	1560-00-442-4750LG	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	1560-00-442-4755LG	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	1560-00-670-2060LG	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	1560-00-670-2059LG	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.

3 For each quanrity 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" quanitities, plus one. The sum of each of these calculations within each pricing period will be multiplied by .02. The sum of these products will be the Total Evaluated Price.

4 The calculation of the maximum contract value, referenced in Schedule Note: "Note 1" is reflected in the column "Contract Maximum Calculation". This calculation is for explantory pursposes only, and will not be included on the tab titled "PRICING MATRIX (Propose Here)".

EXAMPLE

PRICING MATRIX (Propose Here)

	ATTACHMENT 17 - PRICING MATRIX
	RFP Number: SPRWA1-18-R-0033					Pricing Periods1
						Pricing Period I:
Date of Award Thru 12 Calendar Months	Pricing Period I Evaluated Price Calculations	Pricing Period II:
13 Calendar Months Thru 24 Calendar Months	Pricing Period II Evaluated Price Calculations	Pricing Period III:
25 Calendar Months Thru 36 Calendar Months	Pricing Period III Evaluated Price Calculations	Pricing Period IV:
37 Calendar Months Thru 48 Calendar Months	Pricing Period IV Evaluated Price Calculations	Pricing Period V:
49 Calendar Months Thru 60 Calendar Months	Pricing Period V 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	First Article*	2	2	2		$ - 0
	0002	First Article*	2	2	2		$ - 0
	0003	First Article*	2	2	2		$ - 0

0004	Data	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004AA	Test Procedure QTP	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004AB	Test/Inspection Report QTR	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004AC	Test Procedure ATP	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004AD	Test/Inspection Report ATR	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004AE	Counterfeit Prevention Plan	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004AF	Item Unique Identification Marking Plan (IUID)	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004AG	IUID Marking Activity and Verification Report	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004AH	Monthly Status Report	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0005	Production Units for NSN 5985-01-560-8710EW	1-10		$ - 0
				$ - 0
				$ - 0
		1-10			$ - 0
					$ - 0
					$ - 0
		1-10				$ - 0
						$ - 0
						$ - 0
		1-10		$ - 0			$ - 0
							$ - 0
							$ - 0
		1-10						$ - 0
								$ - 0
								$ - 0
0006	Production Units for NSN 5895-01-393-3618EW	60-90		$ - 0
				$ - 0
				$ - 0
				$ - 0
		10-30			$ - 0
					$ - 0
					$ - 0
		10-30				$ - 0
						$ - 0
						$ - 0
		10-30					$ - 0
							$ - 0
							$ - 0
		10-30						$ - 0
								$ - 0
								$ - 0
0007	Production Units for NSN 5985-01-543-9384EW	1-10		$ - 0
				$ - 0
				$ - 0
		1-10			$ - 0
					$ - 0
					$ - 0
		1-10				$ - 0
						$ - 0
						$ - 0
		1-10					$ - 0
							$ - 0
							$ - 0
		1-10						$ - 0
								$ - 0
								$ - 0
			Subtotal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Weighted Subtotal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

TOTAL EVALUATED PRICE3 $0.00

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. If available rows are exceeded, please contact PCO for additional rows to be added to pricing matrix. 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.

3 For each 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. The sum of each of these calculations within each pricing period will be multiplied by .02. The sum of these products will be the Total Evaluated Price.

*Note that the estimated cost of Government testing/inspection evaluation is $10,000.00. This estimated amount is included in the offeror's proposed FA pricing.

File details come from the government source that posted it.