Pricing_Matrix_19-R-0052.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Gun Housings
Solicitation number
SPRWA1-19-R-0052
Issued by

About this file

XL Pricing Matrix

View the file

Other files

File Type Posted
SPRWA119R0052_Amended.pdf PDF
19-R-0052_Attachments.pdf PDF
SPRWA1-19-R-0052.pdf PDF
CDRLs_A001-_A004.pdf PDF
FA_-_AFMC_260.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-19-R-0030Pricing 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
0001XXX-XX-XXX-XXXX UC80120$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
0002XXX-XX-XXX-XXXX UC72172$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
0003XXX-XX-XXX-XXXX UC1651100$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
0004XXX-XX-XXX-XXXX UC192115$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
0005XXX-XX-XXX-XXXX UC100150$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
0006XXX-XX-XXX-XXXX UC2512$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.

PRICNG MATRIX (Housings)

ATTACHMENT 1 - PRICING MATRIX
RFP Number: SPRWA1-19-R-0052 (Housings)Ordering Periods
Ordering Period 1:
Date of Award Thru 12 Calendar MonthsOrdering Period 1 Evaluated Price CalculationsOrdering Period 2:
13 Calendar Months Thru 24 Calendar MonthsOrdering Period 2 Evaluated Price CalculationsOrdering Period 3:
25 Calendar Months Thru 36 Calendar MonthsOrdering Period 3 Evaluated Price CalculationsOrdering Period 4:
37 Calendar Months Thru 48 Calendar MonthsOrdering Period 4 Evaluated Price CalculationsOrdering Period 5:
49 Calendar Months Thru 60 Calendar MonthsOrdering Period 5 Evaluated Price CalculationsSub Totals
CLINNSNEstimated Annual Contract QTYPriced Quantity Range2UNIT PRICEUNIT PRICEUNIT PRICEUNIT PRICEUNIT PRICE
FromTo
00011005-00-126-71322N/AN/A$ - 0
Housing, Machine Gun P/N:205F120
FIRST ARTICLE
FIRST ARTICLE Test Costs (Do Not Alter)$67,121.37$ 67,121.37
00021005-00-126-713230530$ - 0$ - 0$ - 0$ - 0$ - 0
Housing, Machine Gun P/N:205F120$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
Production$ - 0$ - 0$ - 0$ - 0$ - 0
0003
DATA, A001 - Item Unique Identification Plan1 Lot$ - 0
DATA, A002 - IUID Marking Activity and Verification Report1 Lot$ - 0
DATA, A003 - First Article Qualification Test Plan and Procedures1 Lot$ - 0
DATA, A004 - First Article Qualification Test Report1 Lot$ - 0
$ - 0$ - 0$ - 0$ - 0
First Article Subtotal$ 67,121.37$ 67,121.37
Production Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Data Subtotal$ - 0$ - 0TOTAL EVALUATED PRICE$67,121.37
Total Evaluated Price$ 67,121.37$ - 0$ - 0$ - 0$ - 0$ 67,121.37
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 .20. (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.