Pricing_Matrix_.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- AMPLIFIER, RADIO FRE
- Solicitation number
- SPRWA1-18-R-0031
About this file
This document contains a pricing matrix and federal contract opportunity for the procurement of radio frequency amplifiers, attenuators, and related data items by the Department of the Air Force Materiel Command Lifecycle Management Center located at Robins Air Force Base. The pricing matrix outlines the government's estimated quantities of the amplifiers and attenuators to be ordered over five potential one-year pricing periods. Offerors are instructed to provide unit pricing for the items across the different periods in the specified format. The federal contract opportunity provides additional details on the National Stock Numbers, part numbers, descriptions, quantities, and delivery dates for the first article and production items. The opportunity is for a multiple award IDIQ contract with a duration of five one-year ordering periods.
Price Matrix
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SPRWA118R00310004.pdf | ||
| DD_FM_254_OPSEC_Addendum_(002).pdf | ||
| SPRWA118R00310003.pdf | ||
| DD_Form_254_-_FD2060-18-00562.pdf | ||
| SPRWA118R00310002.pdf | ||
| SPRWA118R00310001.pdf | ||
| RFPATTACHMENTS.PDF | ||
| SPRWA118R0031.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-18-R-SAMPLE | 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 | QTY Range EXAMPLE 1 | 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 | QTY Range EXAMPLE 2 | 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 | QTY Range EXAMPLE 3 | 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 | QTY Range EXAMPLE 4 | 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 | QTY Range EXAMPLE 5 | 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 | QTY Range EXAMPLE 6 | 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 1" 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)
| ATTACHMENT 17 - PRICING MATRIX | ||||||||||||
| RFP Number: SPRWA1-18-R-0031 | Pricing Periods1 | |||||||||||
| Pricing Period I: | ||||||||||||
| Date of Award Thru 12 Calendar Months | Pricing Period I Evaluated Price Calculations | Pricing Period II: | ||||||||||
| 13 Calendar Months Thru 24 Calendar Months | Pricing Period II Evaluated Price Calculations | Pricing Period III: | ||||||||||
| 25 Calendar Months Thru 36 Calendar Months | Pricing Period III Evaluated Price Calculations | Pricing Period IV: | ||||||||||
| 37 Calendar Months Thru 48 Calendar Months | Pricing Period IV Evaluated Price Calculations | Pricing Period V: | ||||||||||
| 49 Calendar Months Thru 60 Calendar Months | Pricing Period V 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 | First Article* 5996-01-351-3796 | 2 | 2 | 2 | $ - 0 | $ - 0 | ||||||
| 0002 | First Article* 5985-01-390-2369 | 2 | 2 | 2 | $ - 0 | |||||||
| $ - 0 |
| 0005 | Production 5996-01-351-3796 | 1-56 | $ - 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 | ||||||
| 0006 | Production 5985-01-390-2396 | 1-37 | $ - 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 | ||||||
| 0005 | Data | 1 Lot | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 0005AA | Item Unique Identification Marking Plan (IUID) (A001) | 1 Lot | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 0005AB | IUID Marking Activity and Verification Report (A002) | 1 Lot | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 0005AC | Counterfeit Prevention Plan (A003) | 1 Lot | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 0005AD | Test Procedure ATP (A004) | 1 Lot | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 0005AE | Test/Inspection Report ATR (A005) | 1 Lot | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 0005AF | Test Procedure QTP (A006) | 1 Lot | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | TOTAL EVALUATED PRICE3 | $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. If available rows are exceeded, please contact PCO for additional rows to be added to pricing matrix. 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 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. 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. |
| *Note that the estimated cost of Government testing/inspection evaluation is $3,000.00. This estimated amount is included in the offeror's proposed FA pricing. Median Quantity ordered for CLIN 0003 may be 7 ea per pricing period, Median Quantitiy for CLIN 0004 may be 11 ea per pricing period. |
File details come from the government source that posted it. Updated .