Pricing Matrix_26R0016_Two Year OP I.xlsx

XLSX spreadsheet 28 KB Posted

Attached to
C-5 Avionics Regulated Transformer Rectifier Unit (RTRU) 400 AMP
Solicitation number
SPRWA1-26-R-0016
Issued by

About this file

This is a Pricing Matrix template and example for RFP SPRWA1-26-R-0016, a Requirements Indefinite Delivery Contract for the C-5 Avionics Regulated Transformer Rectifier Unit (RTRU) 400 AMP. The contract covers a 60-month performance period divided into four pricing periods: Pricing Period 1 (Months 1-24), Pricing Period 2 (Months 25-36), Pricing Period 3 (Months 37-48), and Pricing Period 4 (Months 49-60). The solicitation is for NSN 6120-01-524-9044, with an estimated total contract quantity of 58 units including 2 first articles. The matrix requires offerors to provide tiered unit pricing for different quantity ranges within each pricing period, with pricing that must extend from 1 unit through the maximum estimated contract quantity.

The pricing structure uses a weighted evaluation methodology in which each quantity range's unit price is multiplied by the quantity within that range, then each pricing period's subtotal is multiplied by 0.2 to calculate the weighted subtotal. The sum of weighted subtotals equals the Total Evaluated Price for evaluation purposes. Offerors must provide pricing for all four complete pricing periods or face ineligibility; format compliance is mandatory with no deviations permitted. The contract maximum is calculated separately for informational purposes by multiplying the maximum estimated quantity by the maximum unit price for each pricing period. The example matrix provided demonstrates the required format using six CLINs with varying quantity ranges and tiered pricing across all four periods.

View the file

Other files

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
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)".

EXAMPLE

PRICING MATRIX (PROPOSE HERE)

PRICING MATRIX
RFP Number: SPRWA1-26-R-0016Pricing Periods1Contract Maximum Calculation3
Pricing Period 1:
Date of Award 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
CLINNSNEstimated Total Contract QTYPriced Quantity Range2UNIT PRICEUNIT PRICEUNIT PRICEUNIT PRICE
FromTo
0001First Article2$ - 0$ - 0$ - 0$ - 0
0002Production
6120-01-524-904428$ - 0$ - 0$ - 0$ - 0
$ - 0
$ - 0
$ - 0
$ - 0$ - 0$ - 0$ - 0
1002Production
6120-01-524-904410$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
2002Production
6120-01-524-904410$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
3002Production
6120-01-524-904410$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0$ - 0Contract Maximum$0.00
Weighted Subtotal$ - 0$ - 0$ - 0$ - 0
TOTAL EVALUATED PRICE2$0.00
NOTES:
1Quantity 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.
2 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" quanitities, plus one. The sum of each of these calculations within each pricing period will be multiplied by .2. The sum of these products will be the Total Evaluated Price.
3 The calculation of the maximum contract value (Max Estimated Quantity X Max Unit Price for each PP) will be reflected in the column "Contract Maximum Calculation." See Example Pricing Matrix Tab.

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