Pricing_Matrix_Final.xlsx

XLSX spreadsheet 26 KB Posted Jun 14, 2023

Attached to: 5-Year Requirements Contract in support of the C-5 Left and Right Wing Tip Closure Assembly
Solicitation number: SPRWA1-23-R-0013
Issued by: Defense Logistics Agency Aviation

View the file

Other files

File	Type	Posted
Form_1653-1.pdf	PDF	Jun 14, 2023
A004_Technical_Data_Package_Review_Report.pdf	PDF	Jun 14, 2023
Form_260.pdf	PDF	Jun 14, 2023
A008_IUID_Marking_Activity_Validation_and_Verification_Report.pdf	PDF	Jun 14, 2023
A002_Conference_Minutes.pdf	PDF	Jun 14, 2023
EDL_8786.pdf	PDF	Jun 14, 2023
A005_Product_Drawings_3D_Model_and_Associated_Lists.pdf	PDF	Jun 14, 2023
SPRWA1-23-R-0013.pdf	PDF	Jun 14, 2023
A006_Request_for_Variance.pdf	PDF	Jun 14, 2023
EDL_8787.pdf	PDF	Jun 14, 2023
Form_158-1.pdf	PDF	Jun 14, 2023
A003_Status_Report.pdf	PDF	Jun 14, 2023
Revised_A001_Conference_Agenda.pdf	PDF	Jun 14, 2023
A007_IUID_Marking_Plan.pdf	PDF	Jun 14, 2023

Show all 14

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.

Pricing Matrix (Propose Here)

	ATTACHMENT 1 - PRICING MATRIX
	RFP Number: SPRWA1-23-R-0013					Ordering Periods1
						Basic Contract :
Date of Award Thru 12 Calendar Months	Basic Contract Evaluated Price Calculations	Ordering Period II:
13 Calendar Months Thru 24 Calendar Months	Ordering Period II Evaluated Price Calculations	Ordering Period III:
25 Calendar Months Thru 36 Calendar Months	Ordering Period III Evaluated Price Calculations	Ordering Period IV:
37 Calendar Months Thru 48 Calendar Months	Ordering Period IV Evaluated Price Calculations	Ordering Period V:
49 Calendar Months Thru 60 Calendar Months	Ordering Period V Evaluated Price Calculations
	CLIN	NSN	Quantity Range	Priced Quantity Range2		UNIT PRICE		UNIT PRICE	UNIT PRICE	UNIT PRICE	UNIT PRICE
				From	To
	0001AA	1560-00-486-8786	1	1	1		$ - 0
		Aircraft Tip - Left Wing
		Bid A
		FIRST ARTICLE

0002	1560-00-486-8787	1 to 20		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Aircraft Tip - Right Wing			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Bid B			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	PRODUCTION UNITS			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0003	1560-00-486-8786	1 to 20		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Aircraft Tip - Left Wing			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	PRODUCTION UNITS			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004	DATA - Bid A & Bid B	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	A001: Conference Agenda
	A002: Conference Minutes
	A003: Status Report
	A004: Technical Data Package Review Report
	A005: Product Drawing/3D Models & Associated Lists
	A006: Request for Variance
	A007: IUID Marking Plan
	A008: IUID Marling Activity & Verification Report
			Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00	Total Evaluated Price (TEP)	$0.00
			Weighted Subtotal3	$0.00	$0.00	$0.00	$0.00	$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 Ordering 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. 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. 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 Weighted Subtotal is used for evaluation purposes of the Total Evaluated Price. The sum of the Subtotal is multiplied by a factor of 0.20 for each of the five pricing periods. THIS IS APPLICABLE ONLY TO PRODUCTION QUANTITIES. The sum of these products will be the Total Evaluated Price.

Example Pricing Matrix

	ATTACHMENT 1 - PRICING MATRIX
	RFP Number: SPRWA1-17-R-SAMP					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 .20. The sum of these products will be the Total Evaluated Price.

4 The calculation of the maximum contract value, referenced in Schedule Note: "Note 4" 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

File details come from the government source that posted it. Updated Jun 14, 2023.