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

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:

ItemCLINProposed Price
Production and FAT for Tank, Fabric, Collapsible 3K Fuel Assembly
3KFUELASSY FIRST ARTICLE TEST REPORT (FATR)0010$0.00
FIRST ORDERING YEAR - 3K0011$0.00
SECOND ORDERING YEAR - 3K0012$0.00
THIRD ORDERING YEAR - 3K0013$0.00
FOURTH ORDERING YEAR - 3K0014$0.00
FIFTH ORDERING YEAR - 3K0015$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 - 20K0021$0.00
SECOND ORDERING YEAR - 20K0022$0.00
THIRD ORDERING YEAR - 20K0023$0.00
FOURTH ORDERING YEAR - 20K0024$0.00
FIFTH ORDERING YEAR - 20K0025$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 - 50K0031$0.00
SECOND ORDERING YEAR - 50K0032$0.00
THIRD ORDERING YEAR - 50K0033$0.00
FOURTH ORDERING YEAR - 50K0034$0.00
FIFTH ORDERING YEAR - 50K0035$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 - 210K0041$0.00
SECOND ORDERING YEAR - 210K0042$0.00
THIRD ORDERING YEAR - 210K0043$0.00
FOURTH ORDERING YEAR - 210K0044$0.00
FIFTH ORDERING YEAR - 210K0045$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

CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00105430-01-473-2318N/A3KFUELASSY FIRST ARTICLE TEST REPORT (FATR)1N/AN/A$0.00
CLIN 00115430-01-473-23183KFUELASSYFIRST ORDERING YEAR - 3K201-910%
10-2480%
25-7410%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00205430-01-473-2321N/A20KFUELASSY FIRST ARTICLE TEST REPORT (FATR)1N/AN/A$0.00
CLIN 00215430-01-473-232120KFUELASSYFIRST ORDERING YEAR - 20K2211-910%
10-2410%
25-7410%
75-15010%
151-52160%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00305430-01-473-2320N/A50KFUELASSY FIRST ARTICLE TEST REPORT (FATR)1N/AN/A$0.00
CLIN 00315430-01-473-232050KFUELASSYFIRST ORDERING YEAR - 50K3681-910%
10-2410%
25-7410%
75-15010%
151-84860%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00405430-01-546-3725N/A210K-IPDS FIRST ARTICLE TEST REPORT (FATR)1N/AN/A$0.00
CLIN 00415430-01-546-3725210K-IPDSFIRST ORDERING YEAR - 210K1281-910%
10-2410%
25-9910%
100-35970%
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

CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00125430-01-473-23183KFUELASSYSECOND ORDERING YEAR - 3K71-970%
10-2420%
25-7410%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00225430-01-473-232120KFUELASSYSECOND ORDERING YEAR - 20K751-910%
10-2410%
25-7450%
75-15020%
151-52110%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00325430-01-473-232050KFUELASSYSECOND ORDERING YEAR - 50K1201-910%
10-2410%
25-7410%
75-15060%
151-84810%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00425430-01-546-3725210K-IPDSSECOND ORDERING YEAR - 210K871-910%
10-2420%
25-9960%
100-35910%
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

CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00135430-01-473-23183KFUELASSYTHIRD ORDERING YEAR - 3K61-970%
10-2420%
25-7410%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00235430-01-473-232120KFUELASSYTHIRD ORDERING YEAR - 20K751-910%
10-2410%
25-7450%
75-15020%
151-52110%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00335430-01-473-232050KFUELASSYTHIRD ORDERING YEAR - 50K1201-910%
10-2410%
25-7410%
75-15060%
151-84810%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00435430-01-546-3725210K-IPDSTHIRD ORDERING YEAR - 210K501-910%
10-2420%
25-9960%
100-35910%
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

CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00145430-01-473-23183KFUELASSYFOURTH ORDERING YEAR - 3K61-970%
10-2420%
25-7410%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00245430-01-473-232120KFUELASSYFOURTH ORDERING YEAR - 20K751-910%
10-2410%
25-7450%
75-15020%
151-52110%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00345430-01-473-232050KFUELASSYFOURTH ORDERING YEAR - 50K1201-910%
10-2410%
25-7410%
75-15060%
151-84810%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00445430-01-546-3725210K-IPDSFOURTH ORDERING YEAR - 210K501-910%
10-2420%
25-9960%
100-35910%
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

CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00155430-01-473-23183KFUELASSYFIFTH ORDERING YEAR - 3K61-970%
10-2420%
25-7410%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00255430-01-473-232120KFUELASSYFIFTH ORDERING YEAR - 20K751-910%
10-2410%
25-7450%
75-15020%
151-52110%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00355430-01-473-232050KFUELASSYFIFTH ORDERING YEAR - 50K1201-910%
10-2410%
25-7410%
75-15060%
151-84810%
Weighted Average Unit Price$0.00$0.00
CLINNSNPart #DescriptionQuantityQuantity
RangesWeightingsProposed
Unit PriceProposed

Extended Price

CLIN 00455430-01-546-3725210K-IPDSFIFTH ORDERING YEAR - 210K441-910%
10-2420%
25-9960%
100-35910%
Weighted Average Unit Price$0.00$0.00

File details come from the government source that posted it. Updated .