Pricing Matrix.xlsx

30 KB Posted

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

View the file

Other files

File Type Posted
SPRWA119R0052_______0004.pdf PDF
SPRWA119R0052_______0003.pdf PDF
SPRWA119R0052_______0002.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
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-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) Amendment 002Ordering 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 CalculationsSub Totals
CLINNSNEstimated Annual Contract QTYPriced Quantity RangeUNIT 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-713230$ - 0$ - 0$ - 0
Housing, Machine Gun P/N:205F120$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
Production$ - 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
First Article Subtotal$ 67,121.37$ 67,121.37
Production Subtotal$ - 0$ - 0$ - 0$ - 0
Weighted Subtotal$ - 0$ - 0$ - 0$ - 0
Data Subtotal$ - 0$ - 0TOTAL EVALUATED PRICE$67,121.37
Total Evaluated Price$ 67,121.37$ - 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 2 (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 1 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 .333. (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 below the Annual Estimated quanitities in order to provide flexibility to accomodate actual future production requirements. The quantities in Column C for First Articles and Data are One Time Quantities.
6 If Quantity ranges are proposed and there are multiple years for a unit price for a Specific Quantity and not a Range. Please enter the number below the Specific Quantity in Column C (FROM) and the Specific Quantity in Column D (TO): For example and unit price for a quantity of 1 would be entered as Column C (0) and Column D (1); A unit price for a quantity of 2 would be entered as Column C (1) and Column D (1) and so on. This make the formula in Column G function correctly.
7 Do not make changes/additions in Areas of Matrix that are shaded in Grey

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