Pricing_Matrix_.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
Bladder Fuel Cells C-130
Solicitation number
SPRWA1-17-R-0005
Issued by

About this file

Attachment 9 Pricing Matrix

View the file

Other files

File Type Posted
SPRWA117R0005_EDL2062.pdf PDF
SPRWA117R0005_Transportation.pdf PDF
SPRWA117R0005_EDL4755.pdf PDF
SPRWA117R0005_EDL4750.pdf PDF
SPRWA117R0005_Packaging.pdf PDF
SPRWA117R0005.RTF RTF text file
SPRWA117R0005_2059EDL.pdf PDF
SPRWA117R0005_EDL2060.pdf PDF
SPRWA117R0005_EDL1561.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-0005Pricing 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
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 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)".

PRICING MATRIX (Propose Here)

ATTACHMENT 1 - PRICING MATRIX
RFP Number: SPRWA1-17-R-0005Pricing Periods1
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-1561LG80$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
00021560-00-670-2062LG72$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
00031560-00-442-4750LG165$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
00041560-00-442-4755LG192$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
00051560-00-670-2060LG100$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
00061560-00-670-2059LG25$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0TOTAL EVALUATED PRICE$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 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.

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