Attachment 0001 Pricing Workbook.xlsx
XLSX spreadsheet 45 KB Posted
- Attached to
- Solicitation W912CH-25-R-0176 - Collapsible Fabric Tanks (3k, 20k, 50k, 210k US gallon) - AMENDED
- Solicitation number
- W912CH-25-R-0176
- Issued by
-
Department of the Army
About this file
This is a Pricing Workbook template for Solicitation W912CH-25-R-0176, a firm-fixed-price, 5-year Indefinite Delivery Indefinite Quantity (IDIQ) contract for collapsible fabric tanks. The workbook requires offerors to input proposed unit prices and extended prices across four product lines: 3,000-gallon tanks (NSN 5430-01-473-2318), 20,000-gallon tanks (NSN 5430-01-473-2321), 50,000-gallon tanks (NSN 5430-01-473-2320), and 210,000-gallon tank assemblies (NSN 5430-01-546-3725). Pricing must be submitted for First Article Test Reports (FATR) for each product line and for production quantities across five ordering years, with the Summary worksheet auto-calculating the Total Proposed Price from all completed line items.
The workbook structure requires offerors to provide weighted average unit prices based on tiered quantity ranges specified for each CLIN (Contract Line Item Number). The first ordering year quantities are 20 units for 3K tanks, 221 for 20K tanks, 368 for 50K tanks, and 128 for 210K tanks, with subsequent years requiring pricing for reduced quantities. All yellow-highlighted cells must be completed or the proposal may be rejected; offerors are explicitly prohibited from modifying formulas or non-yellow cells, adding worksheets, or making any unauthorized changes to the attachment. This is a total small business set-aside procurement managed by the Department of the Army.
View the file
Other files
Show all 15
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
| Solicitation W912CH-25-R-0176 |
| Attachment 0001 - Pricing Workbook |
| Instructions |
| 1) Cells that require inputs are highlighted in yellow |
| 2) All cells that are highlighted in yellow must be completed |
| 3) Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells. |
| 4) The required inputs are used to auto calculate the Total Proposed Price on the "Summary" Worksheet |
| 5) Do not make any changes or modifications to this attachment except for those cells highlighted in yellow |
| 6) Do not add Worksheets to this Attachment |
| 7) If all cells highlighted in yellow are not completed, the proposal may be rejected IAW Section M - Rejection of Offers. |
Summary
| Solicitation W912CH-25-R-0176 |
| Attachment 0001 - Pricing Workbook |
| Summary |
Offeror:
| Item | CLIN | Proposed Price |
| Production and FAT for Tank, Fabric, Collapsible 3K Fuel Assembly | ||
| 3KFUELASSY FIRST ARTICLE TEST REPORT (FATR) | 0010 | $0.00 |
| FIRST ORDERING YEAR - 3K | 0011 | $0.00 |
| SECOND ORDERING YEAR - 3K | 0012 | $0.00 |
| THIRD ORDERING YEAR - 3K | 0013 | $0.00 |
| FOURTH ORDERING YEAR - 3K | 0014 | $0.00 |
| FIFTH ORDERING YEAR - 3K | 0015 | $0.00 |
| Subtotal | $0.00 | |
| Production and FAT for Tank, Fabric, Collapsible 20K Fuel Assembly | ||
| 20KFUELASSY FIRST ARTICLE TEST REPORT (FATR) | 0020 | $0.00 |
| FIRST ORDERING YEAR - 20K | 0021 | $0.00 |
| SECOND ORDERING YEAR - 20K | 0022 | $0.00 |
| THIRD ORDERING YEAR - 20K | 0023 | $0.00 |
| FOURTH ORDERING YEAR - 20K | 0024 | $0.00 |
| FIFTH ORDERING YEAR - 20K | 0025 | $0.00 |
| Subtotal | $0.00 | |
| Production and FAT for Tank, Fabric, Collapsible 50K Fuel Assembly | ||
| 50KFUELASSY FIRST ARTICLE TEST REPORT (FATR) | 0030 | $0.00 |
| FIRST ORDERING YEAR - 50K | 0031 | $0.00 |
| SECOND ORDERING YEAR - 50K | 0032 | $0.00 |
| THIRD ORDERING YEAR - 50K | 0033 | $0.00 |
| FOURTH ORDERING YEAR - 50K | 0034 | $0.00 |
| FIFTH ORDERING YEAR - 50K | 0035 | $0.00 |
| Subtotal | $0.00 | |
| Production and FAT for Tank, Fabric, Collapsible 210K Fuel Assembly | ||
| 210K-IPDS FIRST ARTICLE TEST REPORT (FATR) | 0040 | $0.00 |
| FIRST ORDERING YEAR - 210K | 0041 | $0.00 |
| SECOND ORDERING YEAR - 210K | 0042 | $0.00 |
| THIRD ORDERING YEAR - 210K | 0043 | $0.00 |
| FOURTH ORDERING YEAR - 210K | 0044 | $0.00 |
| FIFTH ORDERING YEAR - 210K | 0045 | $0.00 |
| Subtotal | $0.00 | |
| Total Proposed Price: | $0.00 |
1st YR Prod.&FAT CLINs
| Solicitation W912CH-25-R-0176 |
| Attachment 0001 - Pricing Workbook |
| First Ordering Year |
Offeror: See Summary Tab
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0010 | 5430-01-473-2318 | N/A | 3KFUELASSY FIRST ARTICLE TEST REPORT (FATR) | 1 | N/A | N/A | $0.00 | |
| CLIN 0011 | 5430-01-473-2318 | 3KFUELASSY | FIRST ORDERING YEAR - 3K | 20 | 1-9 | 10% | ||
| 10-24 | 80% | |||||||
| 25-74 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0020 | 5430-01-473-2321 | N/A | 20KFUELASSY FIRST ARTICLE TEST REPORT (FATR) | 1 | N/A | N/A | $0.00 | |
| CLIN 0021 | 5430-01-473-2321 | 20KFUELASSY | FIRST ORDERING YEAR - 20K | 221 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 10% | |||||||
| 75-150 | 10% | |||||||
| 151-521 | 60% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0030 | 5430-01-473-2320 | N/A | 50KFUELASSY FIRST ARTICLE TEST REPORT (FATR) | 1 | N/A | N/A | $0.00 | |
| CLIN 0031 | 5430-01-473-2320 | 50KFUELASSY | FIRST ORDERING YEAR - 50K | 368 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 10% | |||||||
| 75-150 | 10% | |||||||
| 151-848 | 60% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0040 | 5430-01-546-3725 | N/A | 210K-IPDS FIRST ARTICLE TEST REPORT (FATR) | 1 | N/A | N/A | $0.00 | |
| CLIN 0041 | 5430-01-546-3725 | 210K-IPDS | FIRST ORDERING YEAR - 210K | 128 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-99 | 10% | |||||||
| 100-359 | 70% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
2nd YR Prod. CLINs
| Solicitation W912CH-25-R-0176 |
| Attachment 0001 - Pricing Workbook |
| Second Ordering Year |
Offeror: See Summary Tab
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0012 | 5430-01-473-2318 | 3KFUELASSY | SECOND ORDERING YEAR - 3K | 7 | 1-9 | 70% | ||
| 10-24 | 20% | |||||||
| 25-74 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0022 | 5430-01-473-2321 | 20KFUELASSY | SECOND ORDERING YEAR - 20K | 75 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 50% | |||||||
| 75-150 | 20% | |||||||
| 151-521 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0032 | 5430-01-473-2320 | 50KFUELASSY | SECOND ORDERING YEAR - 50K | 120 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 10% | |||||||
| 75-150 | 60% | |||||||
| 151-848 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0042 | 5430-01-546-3725 | 210K-IPDS | SECOND ORDERING YEAR - 210K | 87 | 1-9 | 10% | ||
| 10-24 | 20% | |||||||
| 25-99 | 60% | |||||||
| 100-359 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
3rd YR Prod. CLINs
| Solicitation W912CH-25-R-0176 |
| Attachment 0001 - Pricing Workbook |
| Third Ordering Year |
Offeror: See Summary Tab
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0013 | 5430-01-473-2318 | 3KFUELASSY | THIRD ORDERING YEAR - 3K | 6 | 1-9 | 70% | ||
| 10-24 | 20% | |||||||
| 25-74 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0023 | 5430-01-473-2321 | 20KFUELASSY | THIRD ORDERING YEAR - 20K | 75 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 50% | |||||||
| 75-150 | 20% | |||||||
| 151-521 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0033 | 5430-01-473-2320 | 50KFUELASSY | THIRD ORDERING YEAR - 50K | 120 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 10% | |||||||
| 75-150 | 60% | |||||||
| 151-848 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0043 | 5430-01-546-3725 | 210K-IPDS | THIRD ORDERING YEAR - 210K | 50 | 1-9 | 10% | ||
| 10-24 | 20% | |||||||
| 25-99 | 60% | |||||||
| 100-359 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
4th YR Prod. CLINs
| Solicitation W912CH-25-R-0176 |
| Attachment 0001 - Pricing Workbook |
| Fourth Ordering Year |
Offeror: See Summary Tab
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0014 | 5430-01-473-2318 | 3KFUELASSY | FOURTH ORDERING YEAR - 3K | 6 | 1-9 | 70% | ||
| 10-24 | 20% | |||||||
| 25-74 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0024 | 5430-01-473-2321 | 20KFUELASSY | FOURTH ORDERING YEAR - 20K | 75 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 50% | |||||||
| 75-150 | 20% | |||||||
| 151-521 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0034 | 5430-01-473-2320 | 50KFUELASSY | FOURTH ORDERING YEAR - 50K | 120 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 10% | |||||||
| 75-150 | 60% | |||||||
| 151-848 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0044 | 5430-01-546-3725 | 210K-IPDS | FOURTH ORDERING YEAR - 210K | 50 | 1-9 | 10% | ||
| 10-24 | 20% | |||||||
| 25-99 | 60% | |||||||
| 100-359 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
5th YR Prod. CLINs
| Solicitation W912CH-25-R-0176 |
| Attachment 0001 - Pricing Workbook |
| Fifth Ordering Year |
Offeror: See Summary Tab
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0015 | 5430-01-473-2318 | 3KFUELASSY | FIFTH ORDERING YEAR - 3K | 6 | 1-9 | 70% | ||
| 10-24 | 20% | |||||||
| 25-74 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0025 | 5430-01-473-2321 | 20KFUELASSY | FIFTH ORDERING YEAR - 20K | 75 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 50% | |||||||
| 75-150 | 20% | |||||||
| 151-521 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0035 | 5430-01-473-2320 | 50KFUELASSY | FIFTH ORDERING YEAR - 50K | 120 | 1-9 | 10% | ||
| 10-24 | 10% | |||||||
| 25-74 | 10% | |||||||
| 75-150 | 60% | |||||||
| 151-848 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
| CLIN | NSN | Part # | Description | Quantity | Quantity | |
| Ranges | Weightings | Proposed | ||||
| Unit Price | Proposed |
Extended Price
| CLIN 0045 | 5430-01-546-3725 | 210K-IPDS | FIFTH ORDERING YEAR - 210K | 44 | 1-9 | 10% | ||
| 10-24 | 20% | |||||||
| 25-99 | 60% | |||||||
| 100-359 | 10% | |||||||
| Weighted Average Unit Price | $0.00 | $0.00 |
File details come from the government source that posted it. Updated .