Attachment_0002_-_Price_Evaluation_Sheet.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- 5 Axis Milling Machines for Watervliet Arsenal
- Solicitation number
- W911PT-18-R-0002
About this file
Attachment 0002 - Price Evaluation Sheet
View the file
Other files
| File | Type | Posted |
|---|---|---|
| W911PT-18-R-0002_-_Amendment_0001_Signed.pdf | ||
| WVA_5_Axis_Milling_Machine__QA_Log_2-15-18.xlsx | XLSX spreadsheet | |
| W911PT-18-R-0002_Signed.pdf | ||
| Attachment_0001_-_Compliance_Sheet_5_Axis_Mill_-_Spec___20-17-3....xls | XLS spreadsheet |
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
Price Sheet Offeror:
Supply / Service: 5 Axis Milling Machine
CLIN 0101 0201
| Ordering Period 1 | Ordering Period 2 | |||||
| Quantity Ranges | Unit Price | Weight* | Unit Price | Weight* | ||
| Minimum Qty | Maximum Qty | |||||
| 1 | - | 4 | 20% | 60% | ||
| 5 | - | 8 | 60% | 20% | ||
| 9 | 12 | 20% | 20% | |||
| 100% | 100% | |||||
| Weighted Evaluation Price | $ - 0 | $ - 0 |
TOTAL EVALUATED PRICE . . . . . . . . . . . . . . . . . . . . . . $ - 0
| Proposed unit prices in each quantity range will be used to calculate the Total Evaluated Price. See Sample Calculations on Example Sheet Tab below. |
| Weight* = The percent likelihood that an order will be placed within a range during the Ordering Year |
| NOTE: The unit price proposed per machine shall include all costs for that machine including installation. |
| Total Evaluated Price is used for evaluation purposes only. |
Example Sheet Offeror: Sample
Supply / Service: Sample
CLIN 0101 0201
| Ordering Period 1 | Ordering Period 2 | |||||
| Quantity Ranges | Unit Price | Weight | Unit Price | Weight | ||
| Minimum Qty | Maximum Qty | |||||
| 1 | - | 4 | $ 100.00 | 20% | $ 100.00 | 60% |
| 5 | - | 8 | $ 80.00 | 60% | $ 80.00 | 20% |
| 9 | 12 | $ 60.00 | 20% | $ 60.00 | 20% | |
| 100% | 100% | |||||
| Weighted Evaluation Price | $ 608.00 | $ 512.00 |
TOTAL EVALUATED PRICE . . . . . . . . . . . . . . . . . . . . . . $ 1,120.00
Proposed unit prices in each quantity range will be used to calculate the Total Evaluated Price. The Total Evaluated Price is calculated as follows:
CLIN 0101
| Range 1 Maximum Qty (4) x Unit Price ($100) x Weight (0.2) | → | 4 x $100 x .2 = $80.00 |
| + Range 2 Maximum Qty (8) x Unit Price ($80) x Weight (0.6) | → + 8 x $80 x .6 = $384.00 |
+ Range 3 Maximum Qty (12) x Unit Price ($60) x Weight (0.2) → + 12 x $60 x .2 = $144.00 Weighted Evaluation Price for Ordering Period 1 $608.00
CLIN 0201
Range 1 Maximum Qty (4) x Unit Price ($100) x Weight (0.6) → 4 x $100 x .6 = $240.00 + Range 2 Maximum Qty (8) x Unit Price ($80) x Weight (0.2) → + 8 x $80 x .2 = $128.00 + Range 3 Maximum Qty (12) x Unit Price ($60) x Weight (0.2) → + 12 x $60 x .2 = $144.00 Weighted Evaluation Price for Ordering period 2 $512.00
Total Evaluation Price = Weighted Evaluation Price (Ordering Year 1) + Weighted Evaluation Price (Ordering Year 2) $1,120.00 = $608 + $512
Weight = The percent likelihood that an order will be placed within a range during the Ordering Year
Total Evaluated Price is used for evaluation purposes only.
File details come from the government source that posted it.