Attachment_0013_-_EHP_Roller_Production_Pricing_Workbook.xlsx
XLSX spreadsheet 36 KB Posted
- Attached to
- Explosive Hazard Pre-detonation Roller System
- Solicitation number
- W56HZV-16-R-0007
About this file
This document provides pricing instructions and templates for an indefinite-delivery, indefinite-quantity contract solicitation for the Explosive Hazard Pre-detonation Roller System. The Army Contracting Command - Warren intends to issue a competitive set-aside solicitation on or after January 29, 2019 for the production of 40 to 370 EHP Roller units over five ordering periods, as well as associated first article test assets and support part packages. Offerors must complete the provided pricing templates to propose firm-fixed unit prices for each contract line item by quantity range, and escalation percentages for out-year ordering periods, in accordance with the instructions. The government will evaluate offers based on the total evaluated price calculated from the completed templates. The solicitation will require production of the EHP Roller System to a government Level III Technical Data Package, which is export controlled.
Attachment 0013
View the file
Other files
Show all 19
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
Instruction To Offeror
| Solicitation W56HZV-16-R-0007 |
| Attachment 0013 - EHP Roller Production Pricing Workbook |
| Instructions |
INSTRUCTION TO OFFEROR
| Cells that require inputs are highlighted in light-blue |
| All cells highlighted in light-blue must be completed |
| Do not adjust formulas or otherwise manipulate any of the non light-blue cells |
| Do not alter or make changes to this attachment except for inputting values in those cells highlighted in light-blue |
| The Attachment will calculate the Total Evaluated Price IAW Section M of the Solicitation |
| *NOTE* |
| First Article Test (FAT) - System Support Package (SSP) |
| The FAT price and SSP price shall be input in worksheet "Summary" cells D14 and D18 respectively. The offeror shall input the unit price into the applicable cell. The worksheet will multiply the unit price by the required quantity (5) to get the extended price. |
| Worksheet "CLIN 0011-0015 PRODUCTION" |
| For worksheet "CLIN 0011-0015 PRODUCTION", offerors shall populate all light-blue cells on worksheet "CLIN 0011 Production Breakout" which will be the offerors proposed price for Ordering Period 1 Quantity Range 1 - 10. For the remaining quantity ranges in Ordering Period 1, offerors shall input a discount percentage in Cells E14, E15, and E16. The attachment will multiply the discount percentage by the unit price in the previous quantity range to calculate the proposed unit price for that range. If an offeror is proposing the same unit price that is proposed in the previous quantity range, enter a discount percentage of 0.00%. |
| Worksheets "CLIN 0021-0025 ASL KITS", "CLIN 0031-0035 PLL KITS", "CLIN 0041-0045 BII KITS": |
| Within these worksheets, for Ordering Period 1, offerors shall input the proposed unit price for the lowest quantity range within Cell G13. For the remaining quantity ranges in Ordering Period 1, offerors shall input a discount percentage in Cells E14, E15, and E16. The attachment will multiply the discount percentage by the unit price in the previous quantity range to calculate the proposed unit price for that range. If an offeror is proposing the same unit price that is proposed in the previous quantity range, enter a discount percentage of 0.00%. |
| Worksheets "CLIN 0011-0015 PRODUCTION", "CLIN 0021-0025 ASL KITS", "CLIN 0031-0035 PLL KITS", "CLIN 0041-0045 BII KITS": |
| Within these worksheets, offerors shall input proposed escalation rates for Ordering Period 2 - 5 in the applicable cells highlighted in light-blue. The attachment will multiply the previous ordering period unit price for the same quantity range by the escalation percentage to claculate the proposed unit price for that range. If an offeror is proposing the same unit price that is proposed in the previous ordering period, enter an escalation percentage of 0.00%. If an offerors projected production costs are lower in future ordering periods, the offeror may enter negative escalation rates. |
Summary
| Solicitation W56HZV-16-R-0007 |
| Attachment 0013 - EHP Roller Production Pricing Workbook |
| Summary |
Offeror: Cage:
Price Summary
| Unit Price | QTY | Extended Price | |
| First Article Test (FATS) | $ - 0 | 5 | $ - 0 |
Production $ - 0
SSP Kits $ - 0 5 $ - 0
ASL Kits $ - 0
PLL Kits $ - 0
BII Kits $ - 0
Total Evaluated Price $ - 0
CLIN 0011 Production Breakout
| Solicitation W56HZV-16-R-0007 |
| Attachment 0013 - EHP Roller Production Pricing Workbook |
| CLIN0011 Production Breakout |
| Labor | Estimated Hours | |
| Per Unit | Total Labor Cost |
Per Unit 0 $ - 0
Material Total Material Cost Per Unit $ - 0
Other Direct Costs Total ODCs Per Unit $ - 0
Indirect Costs Total Indirect Cost Per Unit (e.g. G&A, M&H, FCCOM) $ - 0
Profit Profit Rate Profit Dollars Per Unit 0% $ - 0
Total Unit Cost for Quantity Range 1 - 10 $ - 0
CLIN 0011-0015 PRODUCTION
| Solicitation W56HZV-16-R-0007 |
| Attachment 0013 - EHP Roller Production Pricing Workbook |
| CLIN 0011-0015 PRODUCTION |
| CLIN 0011-0015: EHP ROLLER |
Offeror: 0 Cage: 0
| Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | |||||||||||||
| Quantity Ranges | Discount Schedule | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | ||
| 1 | - | 10 | 10% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 50% | $ - 0 | 0.00% | 50% | $ - 0 | |
| 11 | - | 50 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 |
| 51 | - | 150 | 0.00% | 40% | $ - 0 | 0.00% | 40% | $ - 0 | 0.00% | 40% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 |
| 151 | - | 370 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 |
| . | |||||||||||||||||
| WEIGHTED AVERAGE UNIT PRICE (WAUP) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Evaluated Order Period Quantity | 110 | 110 | 110 | 20 | 20 |
| Evaluated Order Period Value | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
EVALUATED CLIN PRICE $ - 0
CLIN 0021-0025 ASL KITS
| Solicitation W56HZV-16-R-0007 |
| Attachment 0013 - EHP Roller Production Pricing Workbook |
| CLIN 0021-0025 ASL KITS |
| CLIN 0021-0025 ASL KITS |
Offeror: 0 Cage: 0
| Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | |||||||||||||
| Quantity Ranges | Discount Schedule | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | ||
| 1 | - | 10 | 10% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 50% | $ - 0 | 0.00% | 50% | $ - 0 | |
| 11 | - | 20 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 |
| 21 | - | 50 | 0.00% | 40% | $ - 0 | 0.00% | 40% | $ - 0 | 0.00% | 40% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 |
| 51 | - | 78 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 |
| . | |||||||||||||||||
| WEIGHTED AVERAGE UNIT PRICE (WAUP) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Evaluated Order Period Quantity | 22 | 22 | 22 | 6 | 6 |
| Evaluated Order Period Value | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
EVALUATED CLIN PRICE $ - 0
CLIN 0031-0035 PLL KITS
| Solicitation W56HZV-16-R-0007 |
| Attachment 0013 - EHP Roller Production Pricing Workbook |
| CLIN 0031-0035 PLL KITS |
| CLIN 0031-0035 PLL KITS |
Offeror: 0 Cage: 0
| Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | |||||||||||||
| Quantity Ranges | Discount Schedule | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | ||
| 1 | - | 15 | 10% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 50% | $ - 0 | 0.00% | 50% | $ - 0 | |
| 16 | - | 30 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 |
| 31 | - | 60 | 0.00% | 40% | $ - 0 | 0.00% | 40% | $ - 0 | 0.00% | 40% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 |
| 61 | - | 121 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 |
| . | |||||||||||||||||
| WEIGHTED AVERAGE UNIT PRICE (WAUP) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Evaluated Order Period Quantity | 33 | 33 | 33 | 11 | 11 |
| Evaluated Order Period Value | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
EVALUATED CLIN PRICE $ - 0
CLIN 0041-0045 BII KITS
| Solicitation W56HZV-16-R-0007 |
| Attachment 0013 - EHP Roller Production Pricing Workbook |
| CLIN 0041-0045 BII KITS |
| CLIN 0041-0045 BII KITS |
Offeror: 0 Cage: 0
| Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | |||||||||||||
| Quantity Ranges | Discount Schedule | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | Escalation | Weight | Unit Price | ||
| 1 | - | 10 | 10% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 50% | $ - 0 | 0.00% | 50% | $ - 0 | |
| 11 | - | 50 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 20% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 |
| 51 | - | 150 | 0.00% | 40% | $ - 0 | 0.00% | 40% | $ - 0 | 0.00% | 40% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 |
| 151 | - | 370 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 30% | $ - 0 | 0.00% | 10% | $ - 0 | 0.00% | 10% | $ - 0 |
WEIGHTED AVERAGE UNIT PRICE (WAUP) $0.00 $0.00 $0.00 $0.00 $0.00
| Evaluated Order Period Quantity | 110 | 110 | 110 | 20 | 20 |
| Evaluated Order Period Value | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
EVALUATED CLIN PRICE $ - 0
File details come from the government source that posted it. Updated .