Attachment 0007 - Pricing Template.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Overhaul of the CH-47 Drive Adapter Assembly
- Solicitation number
- W58RGZ-20-R-0068
View the file
Other files
Show all 23
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
INSTRUCTIONS
CH-47 Chinook Drive Adapter Assembly Pricing Template Instructions: Enter the requested data in the yellow shaded cells.
Do not hard key calculated numbers. It is requested that the general format of this attachment be maintained as much as possible for evaluation and contract administration purposes.
STEP 1: The offeror shall propose a total FFP for CLIN 0001AA Product Verification Audit (PVA) and FFP unit prices by ordering period for CLINs 0002 through 0005 in the Price Table worksheet.
STEP 2: In the CLIN Summary for Evaluation Purposes worksheets, input/update formulas to apply the proposed FFP amounts from the Price Table worksheet to the Government's RFP evaluation quantities by CLIN and ordering period. Use formulas to link the Price Table FFP proposed amounts to the CLIN Summary for Evaluation worksheet.
STEP 3: The offeror shall provide additional worksheets within the Pricing Template to show the calculation/build-up of the Price Table proposed FFP amounts. Input formulas to show the calculation of the proposed FFP amounts, linking the supporting calculation worksheets to the FFP prices in the Price Table.
The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's proposed prices.
1. Price Table
| Price Table | |
| CH-47 Chinook Drive Adapter Assembly | |
| Prime Contractor Name: | |
| Prime Contractor CAGE Code: | |
| CLIN Number/CLIN Description | Proposed Prices |
| 0001AA- PVA (Total FFP) | |
| 0002AA- Overhaul/Repair (US QTY) | |
| Ordering Period 1 Unit Price | |
| Ordering Period 2 Unit Price | |
| Ordering Period 3 Unit Price | |
| Ordering Period 4 Unit Price | |
| Ordering Period 5 Unit Price | |
| 0003AA- Overhaul/Repair (FMS QTY) | |
| Ordering Period 1 Unit Price | |
| Ordering Period 2 Unit Price | |
| Ordering Period 3 Unit Price | |
| Ordering Period 4 Unit Price | |
| Ordering Period 5 Unit Price | |
| 0004AA- Scrap | |
| Ordering Period 1 Unit Price | |
| Ordering Period 2 Unit Price | |
| Ordering Period 3 Unit Price | |
| Ordering Period 4 Unit Price | |
| Ordering Period 5 Unit Price | |
| 0005AA-Contractor Furnished Containers | |
| Ordering Period 1 Unit Price | |
| Ordering Period 2 Unit Price | |
| Ordering Period 3 Unit Price | |
| Ordering Period 4 Unit Price | |
| Ordering Period 5 Unit Price | |
| 0006- Contracts Data Requirements List (CDRL) | NSP |
"Price Table" worksheet:
Enter the requested data in the yellow highlighted cells. The offeror shall propose a total FFP price for CLIN 0001AA PVA and FFP unit prices by ordering period for CLINs 0002AA through 0005AA. In the Pricing Template, the offeror shall include additional worksheets that show the build-up/calculations of its FFP PVA price and FFP unit prices by ordering period for CLINs 0002 through 0005. The offeror shall input formulas to show the calculation of the proposed FFP prices, linking the supporting calculation worksheets to the FFP prices in the Price Table worksheet.
The offeror shall ensure that all calculations in this worksheet are accurate and reflective of the offeror's proposed prices.
2. CLIN Summary for Evaluation
| CLIN Summary for Evaluation | |||
| CH-47 Chinook Drive Adapter Assembly | |||
| Prime Contractor Name: | |||
| Prime Contractor CAGE Code: | |||
| CLIN Number/CLIN Description | Proposed Prices | Quantities for Evaluation Purposes | Total Proposed Price For Evaluation Purposes |
| 0001AA- PVA (Total Price) | 1 | $ - 0 | |
| 0002AA- Overhaul/Repair (US QTY) | |||
| Ordering Period 1 Unit Price | 20 | $ - 0 | |
| Ordering Period 2 Unit Price | 50 | $ - 0 | |
| Ordering Period 3 Unit Price | 50 | $ - 0 | |
| Ordering Period 4 Unit Price | 50 | $ - 0 | |
| Ordering Period 5 Unit Price | 50 | $ - 0 | |
| 0003AA- Overhaul/Repair (FMS QTY) | |||
| Ordering Period 1 Unit Price | 0 | $ - 0 | |
| Ordering Period 2 Unit Price | 11 | $ - 0 | |
| Ordering Period 3 Unit Price | 11 | $ - 0 | |
| Ordering Period 4 Unit Price | 11 | $ - 0 | |
| Ordering Period 5 Unit Price | 11 | $ - 0 | |
| 0004AA- Scrap | |||
| Ordering Period 1 Unit Price | 1 | $ - 0 | |
| Ordering Period 2 Unit Price | 1 | $ - 0 | |
| Ordering Period 3 Unit Price | 1 | $ - 0 | |
| Ordering Period 4 Unit Price | 1 | $ - 0 | |
| Ordering Period 5 Unit Price | 1 | $ - 0 | |
| 0005AA-Contractor Furnished Containers | |||
| Ordering Period 1 Unit Price | 1 | $ - 0 | |
| Ordering Period 2 Unit Price | 1 | $ - 0 | |
| Ordering Period 3 Unit Price | 1 | $ - 0 | |
| Ordering Period 4 Unit Price | 1 | $ - 0 | |
| Ordering Period 5 Unit Price | 1 | $ - 0 | |
| 0006- Contracts Data Requirements List (CDRL) | NSP | NSP | NSP |
| $ - 0 |
"CLIN Summary for Evaluation" worksheet:
Enter the requested data in the yellow highlighted cells. Input/update formulas to apply the proposed FFP amounts from the Price Table worksheet to the Government's RFP evaluation quantities by CLIN and ordering period. Use formulas to link the Price Table FFP proposed amounts to the CLIN Summary for Evaluation worksheet.
The CLIN Summary for Evaluation should be modified accordingly to reflect the offeror's total proposed price at the evaluation quantities.
This offeror shall ensure that all calculations in this worksheet are accurate and reflective of the offeror's proposed prices.
3. Supporting worksheets
The offeror shall include additional worksheets to show the build-up of the proposed FFP amounts in the Price Table worksheet. The offeror shall insert as many worksheets as needed to fully support the calculation of the FFP amounts in the Price Table.
The offeror shall ensure that all calculations in any additional worksheets included within the Pricing Template are accurate and reflective of the offeror's proposed prices.
File details come from the government source that posted it. Updated .