A02 - Pricing Matrix.xls
XLS spreadsheet 57 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 | 1 | 1 | 1 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| 1 | 1 | 1 | 1 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| 1 | 1 | 1 | 1 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| 1 | 1 | 1 | 1 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| 1 | 1 | 1 | 1 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| 1 | 1 | 1 | 1 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| 1 | 1 | 1 | 1 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| 1 | 1 | 1 | 1 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| 1 | 1 | 1 | 1 | 1 | $ - 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 |
EXAMPLE
| CLIN | DESCRIPTION | QTY / RANGE | Unit Price Year 1 | Unit Price Year 2 | Unit Price Year 3 | Unit Price Year 4 | Unit Price Year 5 | Weighted Average Calculation | Total | |||||
| EXAMPLE FOR PROVIDING WEIGHTED AVERAGE PRICING | 1-500 | Range Price Year 1 | Range Price Year 2 | Range Price Year 3 | Range Price Year 4 | Range Price Year 5 | ||||||||
| 1 | 100 | $ 80.00 | $ 85.00 | $ 90.00 | $ 95.00 | $ 100.00 | $ 8,000.00 | $ 8,500.00 | $ 9,000.00 | $ 9,500.00 | $ 10,000.00 | |||
| 101 | 200 | $ 75.00 | $ 80.00 | $ 85.00 | $ 90.00 | $ 95.00 | $ 7,500.00 | $ 8,000.00 | $ 8,500.00 | $ 9,000.00 | $ 9,500.00 | |||
| 201 | 300 | $ 70.00 | $ 75.00 | $ 80.00 | $ 85.00 | $ 90.00 | $ 7,000.00 | $ 7,500.00 | $ 8,000.00 | $ 8,500.00 | $ 9,000.00 | |||
| 301 | 400 | $ 65.00 | $ 70.00 | $ 75.00 | $ 80.00 | $ 85.00 | $ 6,500.00 | $ 7,000.00 | $ 7,500.00 | $ 8,000.00 | $ 8,500.00 | |||
| 401 | 500 | $ 60.00 | $ 65.00 | $ 70.00 | $ 75.00 | $ 80.00 | $ 6,000.00 | $ 6,500.00 | $ 7,000.00 | $ 7,500.00 | $ 8,000.00 | |||
| max order qty= | 500 | $ 35,000.00 | $ 37,500.00 | $ 40,000.00 | $ 42,500.00 | $ 45,000.00 | $ 200,000.00 | |||||||
| Average Unit Price | $ 70.00 | $ 75.00 | $ 80.00 | $ 85.00 | $ 90.00 | |||||||||
| Step 1: Multiply Each Range Unit Price by the quantity in that respective range for the particular hardware item. | ||||||||||||||
| Step 1: Sum the range prices in each range. | ||||||||||||||
| Step 3: Divide the summed unit price in each range by the maximum allowed quantity. The result will be the weighted range average unit price |
File details come from the government source that posted it. Updated .