ATTACHMENT 6 PRICING MATRIX_SPRWA1-25-R-0003.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- B-1B AN/ALQ-161 Band 8 Driver/Transmitter Federal contract opportunity
- Solicitation number
- SPRWA1-25-R-0003
- Issued by
- Defense Logistics Agency Aviation
About this file
This is a pricing matrix template for RFP SPRWA1-25-R-0003 that provides the structure for bidding on AN/ALQ-161 Band 8 Driver/Transmitter units (NSN 5865-01-240-0092) over three ordering periods. The matrix requires vendors to provide unit pricing across different quantity ranges for a total estimated quantity of 153 units split across three years (90 units in year 1, 32 units in year 2, and 31 units in year 3).
The template includes columns for unit pricing, quantity ranges, and price calculations across three 12-month ordering periods. Vendors must provide pricing for all quantities from 1 up to the total estimated quantity, with the ability to establish their own quantity ranges. The total evaluated price will be calculated by multiplying each quantity range's unit price by the quantity difference plus one, then multiplying the sum within each pricing period by 0.33. The solicitation is being issued as a sole-source procurement to Northrop Grumman Corp (CAGE: 1LTU5) as an addition to contract SPE4AX-18-D-9443.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| ATTACHMENT 3 SPI.pdf | ||
| ATTACHMENT 4 CDRLs (A001 - A006).pdf | ||
| SPRWA1-25-R-0003 (3 Feb 25).pdf | ||
| ATTACHMENT 1 TRANSPORTATION.pdf | ||
| ATTACHMENT 2 PACKAGING.pdf | ||
| ATTACHMENT 5 PERFORMANCE WORK STATEMENT.pdf |
On GovTribe
Work with this file on GovTribe
- 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-SAMP | 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)". |
EXAMPLE
PRICING MATRIX (PROPOSE HERE)
| ATTACHMENT 6 - PRICING MATRIX | |||||||||||||
| RFP Number: SPRWA1-25-R-0003 | Ordering Periods1 | Contract Maximum Calculation3 | |||||||||||
| 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 | ||||||||||||
| CLIN | NSN | Estimated Total Contract QTY | Priced Quantity Range2 | UNIT PRICE | UNIT PRICE | UNIT PRICE | |||||||
| From | To | ||||||||||||
| 0001 | 5865-01-240-0092 | 90 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 1001 | 5865-01-240-0092 | 32 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 2001 | 5865-01-240-0092 | 31 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 0002 | 5865-01-240-0092 | TBD | $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 1002 | 5865-01-240-0092 | TBD | $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 2002 | 5865-01-240-0092 | TBD | $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 0003 | 5865-01-240-0092 | TBD | $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 1003 | 5865-01-240-0092 | TBD | $ - 0 | ||||||||||
| $ - 0 | |||||||||||||
| $ - 0 | |||||||||||||
| $ - 0 | |||||||||||||
| 2003 | 5865-01-240-0092 | TBD | $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Subtotal | $ - 0 | $ - 0 | $ - 0 | Contract Maximum | $0.00 | ||||||||
| Weighted Subtotal | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| TOTAL EVALUATED PRICE3 | $0.00 |
| NOTES: |
| 1 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. |
| 2 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 .33. The sum of these products will be the Total Evaluated Price. |
| 3 The calculation of the maximum contract value, 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)". |
File details come from the government source that posted it. Updated .