Attachment N - Hawaii Options Pricing Submission Spreadsheet.xlsx

19 KB Posted

Attached to
SOLICITATION: SPE605-25-R-0220 (HAWAII, POSTS, CAMPS & STATIONS (PC&S) PP 3. 10)
Solicitation number
SPE605-25-R-0220
Issued by

About this file

Written by GovTribe AI ·

This is a pricing submission spreadsheet (Attachment N) for a federal fuel procurement solicitation (SPE605-25-R-0220) by the Defense Logistics Agency Energy for fuel products in Hawaii. The document details option line items for various fuel types including diesel, unleaded gasoline, jet fuel, and E85, with quantities ranging from 1,000 to 2,000,000 gallons per line item. The option period runs from 01/01/2029 to 06/30/2029, with option quantities set at 25% of the base quantities, and pricing based on different market indices like Platts and OPIS.

The solicitation covers fuel procurement for Department of Defense and Federal Civilian Agencies in Hawaii, with an ordering period from 01 July 2026 through 30 June 2029 and a delivery period of 01 July 2026 through 31 July 2029. Responses are due by 23 December 2025 at 8:00 AM EST, and the procurement is for commercial items prepared in accordance with FAR guidelines. The pricing spreadsheet shows a consistent pricing strategy using market-based indices with most diesel line items priced at $1.972 per gallon and other fuel types like unleaded gasoline priced between $2.30 and $2.84 per gallon.

View the file

Other files

File Type Posted
Attachment H - Fuel Sourcing Data Sheet.pdf PDF
Attachment F - Quality Assurance Provisions C-QAPs.pdf PDF
Attachment C -Hawaii Govt Preferred BRP Indexes and Escalators.pdf PDF
Attachment B -Hawaii Small Business Set-Asides.pdf PDF
Solicitation Hawaii_SPE60525R0220.pdf PDF
Attachment J - Requesting the OET Vendor Role in AMPS Guide.pdf PDF
Attachment I - AMPS Role Guide.pdf PDF
Attachment G - Quality Assurance Provisions E-QAPs.pdf PDF
SF1449_SPE60525R0220.pdf PDF
Attachment M- Small Business Subcontracting Plan Form (Dec 23).pdf PDF
Attachment K - PCS OET Vendor Guide.pdf PDF
Attachment E - Alt Escalator Company Posting 12 Month History Spreadsheet.xlsx XLSX spreadsheet
Attachment L - Sample Letter of Commitment and Instructions.pdf PDF
Attachment D - Alt Escalator Posting History Instruction Worksheet.pdf PDF
Attachment A - Schedule Of Supplies.pdf PDF
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Sheet1

Line ItemName of Location (City)CountryProductQuantityName of EscalatorOffer Price per US GallonTotalBase Reference Price for Base Reference Date of Oct 16, 2024.Line Item DifferentialLocal Taxes and Fees "$ Price Per Gallon Included in Offer Price"
(List one type of tax per line in Column N)Name of Tax Included in Offer Price

(One type of tax per line in Column O)

Sheet2

NOTES TO OFFERORS:
1).Due to system limitations, FAR 52.217-6 is being addressed here and it will be a 25% increase of the quantity of the base line item. The 25% quantity is reflected in column E.Attachment N
2).In accordance with FAR 52.217-7, the option line items (as reflected in this spreadsheet) have an ordering period of 01/01/2029- 06/30/2029
3).All option line items are awarded as fixed price with economic price adjustment.
4).The option line item description/narrative is the same description/narrative as its correlating line item.
Example: The description/narrative for option line item 1001 is the same as the decription/narrative for line item 0001 in Attachment "A - Schedule of Supplies".
5).The option total Price will be calculated by multiplying the option quantity in column E by the option price in column G.
SPE605-25-R-0220Option Line Item NumberCorrelating Base (3-Year) Line Item NumberCorrelating Base
(3-Year) Line Item Quantity per USG)Option Quantity per USG
(25% of the Base Quantity)Name of EscalatorOption Offer Price per USGOption Total PriceBase Reference Price for Base Reference Date of May 01, 2025Option Line Item DifferentialLocal Taxes and Fees "$ Price Per Gallon Included in Offer Price"
(List one type of tax per line in Column K)Name of Tax Included in Offer Price

(One type of tax per line in Column K) Example: AXXA XXXA 25,000 6250 Platts Gasoil .001%S (10ppm) FOB Spore Cargo AAOVC00 Prior Weekly Average Updated Monday $2.50 $15,625.00 $2.177381 $0.32

10011271,000.00067750Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1002266,000.00016500Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
100336,000.0001500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10044257,000.00064250Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
10055905,000.000226250Platts Westcoast Waterborne Jet Fuel PJABI00$0.00$1.952000($1.95)
10066160,000.00040000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10077 will not be usedN/AN/AN/AN/AN/AN/AN/A
1008810,000.0002500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1009996,000.00024000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1010101,000.000250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
101111 will not be usedN/AN/AN/AN/AN/AN/AN/A
10121217,000.0004250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
101313 will not be usedN/AN/AN/AN/AN/AN/AN/A
1014144,000.0001000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10151575,000.00018750Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1016161,000.000250Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
1017172,000.000500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1018181,000.000250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
101919434,000.000108500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1020201,000.000250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
102121118,000.00029500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
102222220,000.00055000Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
10232335,000.0008750OPIS Tacoma WA E85$0.00$2.838000($2.84)
10242449,000.00012250AXXIS Portland OR ULB20$0.00$2.483000($2.48)
102525440,000.000110000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10262632,000.0008000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10272744,000.00011000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
102828417,000.000104250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
102929172,000.00043000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
103030224,000.00056000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
103131300,000.00075000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
103232214,000.00053500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10333392,000.00023000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
103434299,000.00074750Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
10353546,000.00011500AXXIS Portland OR ULB20$0.00$2.483000($2.48)
1036369,000.0002250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1037379,000.0002250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1038381,000.000250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10393922,000.0005500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
104040365,000.00091250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
104141138,000.00034500Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
1042422,000,000.000500000Platts Westcoast Waterborne Jet Fuel PJABI00$0.00$1.952000($1.95)
104343172,000.00043000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1044441,282,000.000320500Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
1045451,721,000.000430250OPIS Tacoma WA E85$0.00$2.838000($2.84)
104646909,000.000227250Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10474754,000.00013500Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
10484810,000.0002500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10494966,000.00016500Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
105050368,000.00092000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10515134,000.0008500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10525214,000.0003500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10535332,000.0008000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10545416,000.0004000Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
105555679,000.000169750Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1056563,000.000750Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
10575726,000.0006500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10585870,000.00017500Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
10595915,000.0003750Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
10606067,000.00016750Platts Los Angeles Pipeline ULS (EPA) Diesel POAET00$0.00$1.972000($1.97)
1061613,000.000750Platts Westcoast Waterborne Unleaded 87 PGADI00$0.00$2.299200($2.30)
10626221,000.0005250Platts Los Angeles Pipeline Premium Unleaded 90 PGABG00$0.00$2.499200($2.50)

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