Pricing_Matrix_1_RFP.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Pre-Award Qualification Notice for 20MM Gun Housings
Solicitation number
SPRWA1-22-R-0019
Issued by

View the file

Other files

File Type Posted
SPRWA1-22-R-00019-0001.pdf PDF
AF_260.pdf PDF
IUID_Checklist.pdf PDF
AF_158.pdf PDF
SPRWA1-22-R-0019.pdf PDF
Pre_Qual_Requirements.pdf PDF
CDRLsA001_A004.pdf PDF
AF_1653.pdf PDF
EDL.pdf PDF
AF_807.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

EXAMPLE PRICING MATRIX_

ATTACHMENT 1 - PRICING MATRIX
RFP Number: SPRWA1-17-R-SAMPPricing Periods1Contract Maximum Calculation4
Pricing Period 1:
Date of Award Thru 12 Calendar MonthsPricing Period 1 Evaluated Price CalculationsPricing Period 2:
13 Calendar Months Thru 24 Calendar MonthsPricing Period 2 Evaluated Price CalculationsPricing Period 3:
25 Calendar Months Thru 36 Calendar MonthsPricing Period 3 Evaluated Price CalculationsPricing Period 4:
37 Calendar Months Thru 48 Calendar MonthsPricing Period 4 Evaluated Price CalculationsPricing Period 5:
49 Calendar Months Thru 60 Calendar MonthsPricing Period 5 Evaluated Price Calculations
CLINNSNEstimated Total Contract QTYPriced Quantity Range2UNIT PRICEUNIT PRICEUNIT PRICEUNIT PRICEUNIT PRICE
FromTo
00011560-00-661-1561LG80120$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
2140$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
4160$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
6180$25.00$ 500.00$27.00$ 540.00$29.00$ 580.00$30.00$ 600.00$30.00$ 600.00
00021560-00-670-2062LG72172$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
00031560-00-442-4750LG1651100$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
101165$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
00041560-00-442-4755LG192115$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
1649$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
5080$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
81100$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
101149$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
150192$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
00051560-00-670-2060LG100150$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
51100$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
00061560-00-670-2059LG2512$100.00$ 200.00$100.00$ 200.00$100.00$ 200.00$100.00$ 200.00$100.00$ 200.00$2,500.00
35$98.00$ 294.00$98.00$ 294.00$98.00$ 294.00$98.00$ 294.00$98.00$ 294.00
68$97.00$ 291.00$97.00$ 291.00$97.00$ 291.00$97.00$ 291.00$97.00$ 291.00
911$95.00$ 285.00$95.00$ 285.00$95.00$ 285.00$95.00$ 285.00$95.00$ 285.00
1215$92.00$ 368.00$92.00$ 368.00$92.00$ 368.00$92.00$ 368.00$92.00$ 368.00
1620$90.00$ 450.00$90.00$ 450.00$90.00$ 450.00$90.00$ 450.00$90.00$ 450.00
2125$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.00Contract 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

EXAMPLE

PRICING MATRIX (Propose Here)

ATTACHMENT 1 - PRICING MATRIX
RFP Number: SPRWA1-22-R-0019Pricing Periods1
Basic Pricing Period:
Date of Award Thru 12 Calendar MonthsBasic Pricing Period Evaluated Price CalculationsPricing Period 1:
13 Calendar Months Thru 24 Calendar MonthsPricing Period 1 Evaluated Price CalculationsPricing Period 2:
25 Calendar Months Thru 36 Calendar MonthsPricing Period 2 Evaluated Price CalculationsPricing Period 3:
37 Calendar Months Thru 48 Calendar MonthsPricing Period 3 Evaluated Price CalculationsPricing Period 4:
49 Calendar Months Thru 60 Calendar MonthsPricing Period 4 Evaluated Price Calculations
CLINNSNBest Estimated QTY (BEQ)Priced Quantity Range2UNIT PRICEUNIT PRICEUNIT PRICEUNIT PRICEUNIT PRICE
FromTo
0001 First Article1005-01-505-21842$0.00
0002 Production Units
Basic Pricing Period10$0.00
$0.00
$0.00
$0.00
$0.00
Ordering Period I5$0.00
$0.00
$0.00
$0.00
$0.00
Ordering Period II5$0.00
$0.00
$0.00
$0.00
$0.00
Ordering Periond III5$0.00
$0.00
$0.00
$0.00
$0.00
Ordering Period IV5$0.00
$0.00
$0.00
$0.00
$0.00
0003Data$0.00$0.00$0.00$0.00$0.00
0003AAA001 Counter Prevention Plan$0.00$0.00$0.00$0.00$0.00
0003ABA0002 Item Unique Identification (IUID) Marking Activity,
Validation and Verification Report$0.00$0.00$0.00$0.00$0.00
0003ACA0003 First Article Qualification Test Plan and Procedures$0.00$0.00$0.00$0.00$0.00
0003ADA0004 Test/Inspection Report$0.00$0.00$0.00$0.00$0.00
Subtotal$0.00$0.00$0.00$0.00$0.00$0.00TOTAL$0.00
Weighted Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
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 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.

File details come from the government source that posted it. Updated .