A02 - PRICING MATRIX - V2.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- W91CRB-20-R-0003 NEXT GENERATION HUB (NGH)
- Solicitation number
- W91CRB-20-R-0003
View the file
Other files
Show all 27
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
PRICING MATRIX
NGH PRICING MATRIX
| The purpose of this matrix is to establish contractual IDIQ step ladder range/unit prices, weighted average, and total evaluated prices (TEP) for CLINs 0001 & 0002. The calculated amounts are the basis for the proposed prices in Section B. |
| Enter unit price in blue shaded cell for CLIN 0001. For CLIN 0002 enter ranges up to max order quantity of 33,420 and corresponding unit prices in blue shaded areas. |
| Grey shaded cells show calculated amounts. |
CLIN DESCRIPTION QTY / RANGE Unit Price Year 1 Total Price Total for CLIN 0001
| 0001 | Minimum Next Generation Hub | 100 | $0.00 | $0.00 | $0.00 | TEP Price To Section B |
| (Year 1 Only) |
Maximum Order Qty:
| Next Generation Hub | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Weighted Average Calculation | Total | |||||||||||||||||||
| CLIN | DESCRIPTION | Max Order Qty: | 33420 | QTY/RANGE | Unit Price | QTY/RANGE | Unit Price | QTY/RANGE | Unit Price | QTY/RANGE | Unit Price | QTY/RANGE | Unit Price | Range Price | ||||||||||||
| Year 1 | Range Price | |||||||||||||||||||||||||
| Year 2 | Range Price | |||||||||||||||||||||||||
| Year 3 | Range Price | |||||||||||||||||||||||||
| Year 4 | Range Price | |||||||||||||||||||||||||
| Year 5 | IDIQ Price | |||||||||||||||||||||||||
| Annual Quatitites: | 6,684 | 6,684 | 6,684 | 6,684 | 6,684 | |||||||||||||||||||||
| 0002 | Establish Ranges Up to the Max Order Quantity To The Right - Ranges Will Vary From Offeror To Offeror | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | 1 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| 1 | 6,684 | $ - 0 | 1 | 6,684 | $ - 0 | 1 | 6,684 | $ - 0 | 1 | 6,684 | $ - 0 | 1 | 6,684 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | TEP Price To Section B | ||||||||||||||||||||
| Weighted Average Rate: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
SAMPLE
NGH PRICING MATRIX
| The purpose of this matrix is to establish contractual IDIQ step ladder range/unit prices, weighted average, and total evaluated prices (TEP) for CLINs 0001 & 0002. The calculated amounts are the basis for the proposed prices in Section B. |
| Enter unit price in blue shaded cell for CLIN 0001. For CLIN 0002 enter ranges up to max order quantity of 33,420 and corresponding unit prices in blue shaded areas. |
| Grey shaded cells show calculated amounts. |
CLIN DESCRIPTION QTY / RANGE Unit Price Year 1 Total Price Total for CLIN 0001
| 0001 | Minimum Next Generation Hub | 100 | $90.00 | $9,000.00 | $9,000.00 | TEP Price To Section B |
| (Year 1 Only) |
Maximum Order Qty:
| Next Generation Hub | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Weighted Average Calculation | Total | |||||||||||||||||||
| CLIN | DESCRIPTION | Max Order Qty: | 33420 | QTY/RANGE | Unit Price | QTY/RANGE | Unit Price | QTY/RANGE | Unit Price | QTY/RANGE | Unit Price | QTY/RANGE | Unit Price | Range Price | ||||||||||||
| Year 1 | Range Price | |||||||||||||||||||||||||
| Year 2 | Range Price | |||||||||||||||||||||||||
| Year 3 | Range Price | |||||||||||||||||||||||||
| Year 4 | Range Price | |||||||||||||||||||||||||
| Year 5 | IDIQ Price | |||||||||||||||||||||||||
| Annual Quatitites: | 6,684 | 6,684 | 6,684 | 6,684 | 6,684 | |||||||||||||||||||||
| 0002 | Establish Ranges Up to the Max Order Quantity To The Right - Ranges Will Vary From Offeror To Offeror | 1 | 700 | $ 3.00 | 1 | 700 | $ 3.06 | 1 | 700 | $ 3.12 | 1 | 700 | $ 3.15 | 1 | 700 | $ 3.20 | $ 2,100.00 | $ 2,142.00 | $ 2,184.00 | $ 2,205.00 | $ 2,240.00 | |||||
| 701 | 1,400 | $ 2.75 | 701 | 1,400 | $ 2.81 | 701 | 1,400 | $ 2.87 | 701 | 1,400 | $ 2.90 | 701 | 1,400 | $ 2.94 | $ 1,925.00 | $ 1,967.00 | $ 2,009.00 | $ 2,030.00 | $ 2,058.00 | |||||||
| 1,401 | 2,100 | $ 2.50 | 1,401 | 2,100 | $ 2.55 | 1,401 | 2,100 | $ 2.60 | 1,401 | 2,100 | $ 2.63 | 1,401 | 2,100 | $ 2.67 | $ 1,750.00 | $ 1,785.00 | $ 1,820.00 | $ 1,841.00 | $ 1,869.00 | |||||||
| 2,101 | 2,800 | $ 2.25 | 2,101 | 2,800 | $ 2.30 | 2,101 | 2,800 | $ 2.35 | 2,101 | 2,800 | $ 2.37 | 2,101 | 2,800 | $ 2.41 | $ 1,575.00 | $ 1,610.00 | $ 1,645.00 | $ 1,659.00 | $ 1,687.00 | |||||||
| 2,801 | 3,500 | $ 2.00 | 2,801 | 3,500 | $ 2.04 | 2,801 | 3,500 | $ 2.08 | 2,801 | 3,500 | $ 2.10 | 2,801 | 3,500 | $ 2.13 | $ 1,400.00 | $ 1,428.00 | $ 1,456.00 | $ 1,470.00 | $ 1,491.00 | |||||||
| 3,501 | 4,200 | $ 1.75 | 3,501 | 4,200 | $ 1.79 | 3,501 | 4,200 | $ 1.83 | 3,501 | 4,200 | $ 1.85 | 3,501 | 4,200 | $ 1.88 | $ 1,225.00 | $ 1,253.00 | $ 1,281.00 | $ 1,295.00 | $ 1,316.00 | |||||||
| 4,201 | 4,900 | $ 1.50 | 4,201 | 4,900 | $ 1.53 | 4,201 | 4,900 | $ 1.56 | 4,201 | 4,900 | $ 1.58 | 4,201 | 4,900 | $ 1.60 | $ 1,050.00 | $ 1,071.00 | $ 1,092.00 | $ 1,106.00 | $ 1,120.00 | |||||||
| 4,901 | 5,600 | $ 1.25 | 4,901 | 5,600 | $ 1.28 | 4,901 | 5,600 | $ 1.31 | 4,901 | 5,600 | $ 1.32 | 4,901 | 5,600 | $ 1.34 | $ 875.00 | $ 896.00 | $ 917.00 | $ 924.00 | $ 938.00 | |||||||
| 5,601 | 6,684 | $ 1.00 | 5,601 | 6,684 | $ 1.02 | 5,601 | 6,684 | $ 1.04 | 5,601 | 6,684 | $ 1.05 | 5,601 | 6,684 | $ 1.07 | $ 1,084.00 | $ 1,105.68 | $ 1,127.36 | $ 1,138.20 | $ 1,159.88 | |||||||
| $ 12,984.00 | $ 13,257.68 | $ 13,531.36 | $ 13,668.20 | $ 13,878.88 | $ 67,320.12 | TEP Price To Section B | ||||||||||||||||||||
| Weighted Average Rate: | $ 1.94 | $ 1.98 | $ 2.02 | $ 2.04 | $ 2.08 | $ 2.01 |
File details come from the government source that posted it. Updated .