The file's text, extracted by GovTribe without its formatting.
EXAMPLE PRICING MATRIX
| ATTACHMENT 1 - PRICING MATRIX | | | | | | | | | | | | | | | | |
| RFP Number: SPRWA1-18-R-00XX | | | | | Pricing Periods1 | | | | | | | | | | Contract Maximum Calculation4 | |
| | | | | | Pricing Period 1: | | | | | | | | | | | |
| Date of Award Thru 12 Calendar Months | Pricing Period 1 Evaluated Price Calculations | Pricing Period 2: | | | | | | | | | | | | | | | |
| 13 Calendar Months Thru 24 Calendar Months | Pricing Period 2 Evaluated Price Calculations | Pricing Period 3: | | | | | | | | | | | | | | | |
| 25 Calendar Months Thru 36 Calendar Months | Pricing Period 3 Evaluated Price Calculations | Pricing Period 4: | | | | | | | | | | | | | | | |
| 37 Calendar Months Thru 48 Calendar Months | Pricing Period 4 Evaluated Price Calculations | Pricing Period 5: | | | | | | | | | | | | | | | |
| 49 Calendar Months Thru 60 Calendar Months | Pricing Period 5 Evaluated Price Calculations | | | | | | | | | | | | | | | | |
| CLIN | NSN | Estimated Total Contract QTY | Priced Quantity Range2 | | UNIT PRICE | | UNIT PRICE | | UNIT PRICE | | UNIT PRICE | | UNIT PRICE | | | |
| | | | From | To | | | | | | | | | | | | |
| 0001 | 1560-00-661-1561LG | 80 | 1 | 20 | $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 | |
| | | | 21 | 40 | $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 | | |
| | | | 41 | 60 | $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 | | |
| | | | 61 | 80 | $25.00 | $ 500.00 | $27.00 | $ 540.00 | $29.00 | $ 580.00 | $30.00 | $ 600.00 | $30.00 | $ 600.00 | | |
| 0002 | 1560-00-670-2062LG | 72 | 1 | 72 | $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 | | |
| 0003 | 1560-00-442-4750LG | 165 | 1 | 100 | $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 | |
| | | | 101 | 165 | $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 | | |
| 0004 | 1560-00-442-4755LG | 192 | 1 | 15 | $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 | |
| | | | 16 | 49 | $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 | | |
| | | | 50 | 80 | $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 | | |
| | | | 81 | 100 | $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 | | |
| | | | 101 | 149 | $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 | | |
| | | | 150 | 192 | $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 | | |
| 0005 | 1560-00-670-2060LG | 100 | 1 | 50 | $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 | |
| | | | 51 | 100 | $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 | | |
| 0006 | 1560-00-670-2059LG | 25 | 1 | 2 | $100.00 | $ 200.00 | $100.00 | $ 200.00 | $100.00 | $ 200.00 | $100.00 | $ 200.00 | $100.00 | $ 200.00 | $2,500.00 | |
| | | | 3 | 5 | $98.00 | $ 294.00 | $98.00 | $ 294.00 | $98.00 | $ 294.00 | $98.00 | $ 294.00 | $98.00 | $ 294.00 | | |
| | | | 6 | 8 | $97.00 | $ 291.00 | $97.00 | $ 291.00 | $97.00 | $ 291.00 | $97.00 | $ 291.00 | $97.00 | $ 291.00 | | |
| | | | 9 | 11 | $95.00 | $ 285.00 | $95.00 | $ 285.00 | $95.00 | $ 285.00 | $95.00 | $ 285.00 | $95.00 | $ 285.00 | | |
| | | | 12 | 15 | $92.00 | $ 368.00 | $92.00 | $ 368.00 | $92.00 | $ 368.00 | $92.00 | $ 368.00 | $92.00 | $ 368.00 | | |
| | | | 16 | 20 | $90.00 | $ 450.00 | $90.00 | $ 450.00 | $90.00 | $ 450.00 | $90.00 | $ 450.00 | $90.00 | $ 450.00 | | |
| | | | 21 | 25 | $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.00 | Contract 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)". |
PRICNG MATRIX (Rotors)
| ATTACHMENT 1 - PRICING MATRIX | | | | | | | | | | |
| RFP Number: SPRWA1-17-R-0039 | | | | | Ordering Periods1 | | | | | |
| | | | | | Ordering Period 1: | | | | | |
| Date of Award Thru 12 Calendar Months | Ordering Period 1 Evaluated Price Calculations | Ordering Period 2: | | | | | | | | | |
| 13 Calendar Months Thru 24 Calendar Months | Ordering Period 2 Evaluated Price Calculations | Ordering Period 3: | | | | | | | | | |
| 25 Calendar Months Thru 36 Calendar Months | Ordering Period 3 Evaluated Price Calculations | Ordering Period 4: | | | | | | | | | |
| 37 Calendar Months Thru 48 Calendar Months | Ordering Period 4 Evaluated Price Calculations | Ordering Period 5: | | | | | | | | | |
| 49 Calendar Months Thru 60 Calendar Months | Ordering Period 5 Evaluated Price Calculations | Sub Totals | | | | | | | | | |
| CLIN | NSN | Estimated Annual Contract QTY | Priced Quantity Range2 | | UNIT PRICE | | UNIT PRICE | UNIT PRICE | UNIT PRICE | UNIT PRICE |
| | | | From | To | | | | | | |
| 0001 | 1005-00-419-7188 | 2 | N/A | N/A | | $ - 0 | | | | |
| Rotor, Gun P/N:B7790672 | | | | | | | | | | |
| FIRST ARTICLE | | | | | | | | | | |
| FIRST ARTICLE Test Costs | | | | | $67,914.19 | $ 67,914.19 |
| 0002 | 1005-01-351-2131 | 2 | N/A | N/A | | $ - 0 |
| Rotor, Gun P/N: 12599988 | | | | | | |
| FIRST ARTICLE | | | | | | |
| FIRST ARTICLE Test Costs | | | | | $67,914.19 | $ 67,914.19 | | | | |
| X001 | 1005-00-419-7188 | 55 | 5 | 110 | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Rotor, Gun P/N:B7790672 | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| PRODUCTION | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X002 | 1005-01-351-2131 | 20 | 5 | 40 | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Rotor, Gun P/N: 12599988 | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| PRODUCTION | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X004 | | | | | | | | | | |
| DATA, A001 - IUID Marking Plan | | 1 Lot | | | | $ - 0 | | | | |
| DATA, A002 - IUID Marking Activity & Verification Report | | 1 Lot | | | | $ - 0 | $ - 0 | | | |
BARWICK, LOREY M CIV USAF AFMC AFLCMC/WMKA: BARWICK, LOREY M CIV DLA:
For Ordering Periods 2 -5, it is expected that only CDRL A002 will be needed.
$ - 0 $ - 0 $ - 0
| | | First Article Subtotal | $ 135,828.38 | | | | | | $ 135,828.38 |
| | | Production Subtotal | $ - 0 | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | Weighted Subtotal | $ - 0 | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | Data Subtotal | $ - 0 | | $ - 0 | | | | |
| BARWICK, LOREY M CIV USAF AFMC AFLCMC/WMKA: BARWICK, LOREY M CIV DLA: For Ordering Periods 2 -5, It is expected that only CDRL A002 will be needed. | $ - 0 | $ - 0 | $ - 0 | $ - 0 | TOTAL EVALUATED PRICE | $135,828.38 | | | | |
| | | Total Evaluated Price | $ 135,828.38 | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 135,828.38 |
| 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 time Column F) to calculate the extended price. This sum will be added to the First Article Test Costs shown in cells F10 and F15 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 .50. (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. |
PRICING MATRIX (Housings)
| ATTACHMENT 1 - PRICING MATRIX | | | | | | | | | | |
| RFP Number: SPRWA1-17-R-0039 | | | | | Ordering Periods1 | | | | | |
| | | | | | Ordering Period 1: | | | | | |
| Date of Award Thru 12 Calendar Months | Ordering Period 1 Evaluated Price Calculations | Ordering Period 2: | | | | | | | | | |
| 13 Calendar Months Thru 24 Calendar Months | Ordering Period 2 Evaluated Price Calculations | Ordering Period 3: | | | | | | | | | |
| 25 Calendar Months Thru 36 Calendar Months | Ordering Period 3 Evaluated Price Calculations | Ordering Period 4: | | | | | | | | | |
| 37 Calendar Months Thru 48 Calendar Months | Ordering Period 4 Evaluated Price Calculations | Ordering Period 5: | | | | | | | | | |
| 49 Calendar Months Thru 60 Calendar Months | Ordering Period 5 Evaluated Price Calculations | Sub Totals | | | | | | | | | |
| CLIN | NSN | Estimated Annual Contract QTY | Priced Quantity Range2 | | UNIT PRICE | | UNIT PRICE | UNIT PRICE | UNIT PRICE | UNIT PRICE |
| | | | From | To | | | | | | |
| 0003 | 1005-01-008-6283 | 2 | N/A | N/A | | $ - 0 | | | | |
| Housing, Machine Gun P/N:12007363 | | | | | | | | | | |
| FIRST ARTICLE | | | | | | | | | | |
| FIRST ARTICLE Test Costs | | | | | $42,639.48 | $42,639.48 | | | | |
| X003 | 1005-01-008-6283 | 395 | 5 | 79 | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Housing, Machine Gun P/N:12007363 | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| PRODUCTION | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X004 | | | | | | | | | | |
| DATA, A001 - IUID Marking Plan | | 1 Lot | | | | $ - 0 | | | | |
| DATA, A002 - IUID Marking Activity & Verification Report | | 1 Lot | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| DATA, A003 - First Article Test Plan & Procedures | | 1 Lot | | | | $ - 0 | | | | |
| DATA, A004 - First Article Qualification Test Report | | 1 Lot | | | | $ - 0 | | | | |
| | | First Article Subtotal | $ 42,639.48 | | | | | | $ 42,639.48 |
| | | Production Subtotal | $ - 0 | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | Weighted Subtotal | $ - 0 | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | Data Subtotal | $ - 0 | | $ - 0 | | | | |
| BARWICK, LOREY M CIV USAF AFMC AFLCMC/WMKA: BARWICK, LOREY M CIV DLA: For Ordering Periods 2 -5, It is expected that only CDRL A002 will be needed. | $ - 0 | $ - 0 | $ - 0 | $ - 0 | TOTAL EVALUATED PRICE | $42,639.48 | | | | |
| | | Total Evaluated Price | $ 42,639.48 | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 42,639.48 |
| 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 time Column F) to calculate the extended price. This sum will be added to the First Article Test Costs shown in cells F10 and F15 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 .50. (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. |
