Pricing_Matrix_19_R_0030.xlsx

XLSX spreadsheet 28 KB Posted May 2, 2019

Attached to: C-5 Wingtip Components
Solicitation number: SPRWA1-19-R-0030
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Robins Air Force Base

About this file

From the source

Pricing Matrix 19-R-0030

View the file

Other files

File	Type	Posted
SPRWA1-19-R-0030_(Amend_01).pdf	PDF	Aug 21, 2019
SPRWA1-19-R-0030.pdf	PDF	May 2, 2019
19-R-0030_Attachments.pdf	PDF	May 2, 2019
Requirements_Description_Statement.pdf	PDF	May 2, 2019
19-00203_FA_260s.pdf	PDF	May 2, 2019
FD20601900203-CDRL_(Revised).pdf	PDF	May 2, 2019

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 (Wingtip Comp)

	ATTACHMENT 1 - PRICING MATRIX
	RFP Number: SPRWA1-19-R-0030 (Wingtip Components)					Ordering Periods
						Ordering Period 1:
Date of Award Thru 12 Calendar Months	Ordering Period 1 Evaluated Price Calculations	Ordering Period 2:
13 Calendar Months Thru 24 Calendar Months	Ordering Period 2 Evaluated Price Calculations	Ordering Period 3:
25 Calendar Months Thru 36 Calendar Months	Ordering Period 3 Evaluated Price Calculations	Ordering Period 4:
37 Calendar Months Thru 48 Calendar Months	Ordering Period 4 Evaluated Price Calculations	Ordering Period 5:
49 Calendar Months Thru 60 Calendar Months	Ordering Period 5 Evaluated Price Calculations	Sub Totals
	CLIN	NSN	Estimated Annual Contract QTY	Priced Quantity Range2		UNIT PRICE		UNIT PRICE	UNIT PRICE	UNIT PRICE	UNIT PRICE
				From	To
	0001	1560-00-439-3248 UC	1	N/A	N/A		$ - 0
	Fairing, Aircraft P/N:4J22069-102B
	FIRST ARTICLE

FIRST ARTICLE Test Costs (Do Not Alter)					$9,550.00	$ 9,550.00
0002	1560-00-439-3249 UC	1	N/A	N/A		$ - 0
Fairing, Aircraft P/N:4J22069-101B
FIRST ARTICLE

FIRST ARTICLE Test Costs (Do Not Alter)					$9,550.00	$ 9,550.00
0003	1560-00-439-6568 UC	1	N/A	N/A		$ - 0
Leading Edge, Aircraft P/N:4J20112-104A
FIRST ARTICLE

FIRST ARTICLE Test Costs (Do Not Alter)		$9,550.00	$ 9,550.00
0004
DATA, A001 - Bi-Monthly Status Report	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
DATA, A002 - Technical Data Review Report	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
DATA, A003 - Product Drawings/Models and Associated Lists	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
DATA, A004 - Request for Variance	1 Lot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
DATA, A005 - Conference Agenda	1 Lot		$ - 0
DATA, A006 - Conference Minutes	1 Lot		$ - 0

0005	1560-00-439-3248 UC	5	1	5	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fairing, Aircraft P/N:4J22069-102B					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
PRODUCTION					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0006	1560-00-439-3249 UC	4	1	4	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fairing, Aircraft P/N:4J22069-101B					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
PRODUCTION					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0007	1560-00-439-6568 UC	2	1	2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Leading Edge, Aircraft P/N:4J20112-104A					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
PRODUCTION					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0008	1560-00-224-3098 UC	1	1	1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Leading Edge, Aircraft P/N:4J20112-103A					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
PRODUCTION					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

First Article Subtotal	$ 28,650.00					$ 28,650.00
Production Subtotal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Subtotal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Data Subtotal	$ - 0	$ - 0

BARWICK, LOREY M CIV USAF: BARWICK, LOREY M CIV DLA:

For Ordering Periods 2 -5, It is expected that CDRLs A005 and A006 will not be needed.

$ - 0

BARWICK, LOREY M CIV USAF: BARWICK, LOREY M CIV DLA:

For Ordering Periods 2 -5, It is expected that CDRLs A005 and A006 will not be needed.

$ - 0

BARWICK, LOREY M CIV USAF: BARWICK, LOREY M CIV DLA:

For Ordering Periods 2 -5, It is expected that CDRLs A005 and A006 will not be needed.

$ - 0

BARWICK, LOREY M CIV USAF: BARWICK, LOREY M CIV DLA:

For Ordering Periods 2 -5, It is expected that CDRLs A005 and A006 will not be needed.

$ - 0	TOTAL EVALUATED PRICE	$28,650.00
			Total Evaluated Price	$ 28,650.00	$ - 0	$ - 0	$ - 0	$ - 0	$ 28,650.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 1 (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 Quantity Ranges within each Ordering Period may be broken into multiple ranges by the offeror, but pricing must be provided for every unit from 5 EA (From Qty) to the "To" 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 .50. (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 Estimated Annual Quantity is reflected in Column C. The Pricing Ranges in Columns D & E are established at FROM/TO quantities above and below the Annual Estimated quanitities in order to provide flexibility to accomodate actual future production requirements.

File details come from the government source that posted it.