Attachment S - Options Pricing Submission Spreadsheet UPDATED.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
AMENDMENT SPE605-25-R-0208-0004 (ALASKA, POSTS, CAMPS & STATIONS (PC&S) PP 3. 9)
Solicitation number
SPE60525R02080004
Issued by

About this file

Written by GovTribe AI ·

The file is an Options Pricing Submission Spreadsheet for solicitation SPE60525R0208, detailing fuel pricing and quantities for various locations in Alaska. The spreadsheet covers multiple fuel types including automotive gasoline, aviation gasoline, turbine fuel, diesel fuel, and fuel oil, with specific line items for locations such as Anchorage, Fairbanks, and Seattle. Each line item includes option quantities (10% of base quantity), pricing based on daily OPIS or PLATTS indexes, and specific product codes.

The solicitation is issued by the Defense Logistics Agency Energy and represents an amendment to a previous Request for Proposal, which removed several line items for locations like Eareckson AFB, Petersburg Federal Building, and Coast Guard Exchange Buildings. The option line items have an ordering period from 10/01/2030 to 03/31/2031, are awarded as fixed price with economic price adjustment, and use a 9.0% escalator. Pricing varies by location and fuel type, ranging from $2.4215 for jet fuel to $3.3677 for diesel fuel from Seattle, reflecting the complexity of regional fuel supply and pricing variations.

View the file

Other files

File Type Posted
SF30_SPE60525R02080004.PDF PDF
Attachment U Pricing Submission Spreadsheet.xlsx XLSX spreadsheet

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.

SPE60525R0208 OPTION

Option Line Item NumberCorrelating Base (5-Year) Line Item NumberProduct CodeDescriptionCorrelating Base
(5-Year) Line Item Quantity per USG)Option Quantity per USG
(10% of the Base Quantity)Escalator NameOption Offer Price per USGOption Total PriceBase Reference Price 01/02/2025Option Line Item DifferentialLocal Taxes and Fees "$ Price Per Gallon Included in Offer Price"
(List one type of tax per line in Column M)Name of Tax Included in Offer Price

(One type of tax per line in Column M)

Example:AXXAXXXA10,0001000OPIS DAILY FAIRBANKS AK UNL 9.0$2.50$2,500.00$2.1774$0.32
10010001MURGASOLINE, AUTOMOTIVE100001000OPIS DAILY FAIRBANKS AK UNL 9.0$2.6038
10020002MURGASOLINE, AUTOMOTIVE120001200OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10030003MURGASOLINE, AUTOMOTIVE1000100OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10040004MURGASOLINE, AUTOMOTIVE7000700OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10050005MURGASOLINE, AUTOMOTIVE1000100OPIS DAILY FAIRBANKS AK UNL 9.0$2.6038
10060006MURGASOLINE, AUTOMOTIVE2000200OPIS DAILY SEATTLE WA UNL HG 9.0$2.5762
10070007MURGASOLINE, AUTOMOTIVE630006300OPIS DAILY SEATTLE WA UNL HG 9.0$2.5762
10080008MURGASOLINE, AUTOMOTIVE20300020300OPIS DAILY FAIRBANKS AK UNL 9.0$2.6038
10090009MURGASOLINE, AUTOMOTIVE10600010600OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10100010MURGASOLINE, AUTOMOTIVE1000100OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10110011MURGASOLINE, AUTOMOTIVE470004700OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10120012MURGASOLINE, AUTOMOTIVE8000800OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10130013MURGASOLINE, AUTOMOTIVE2000200OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10150015MURGASOLINE, AUTOMOTIVE73500073500OPIS DAILY FAIRBANKS AK UNL 9.0$2.6038
10160016MURGASOLINE, AUTOMOTIVE45000045000OPIS DAILY FAIRBANKS AK UNL 9.0$2.6038
10170017MURGASOLINE, AUTOMOTIVE26000026000OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10180018MURGASOLINE, AUTOMOTIVE1239000123900OPIS DAILY ANCHORAGE UNL 9.0$2.3582
10190019MURGASOLINE, AUTOMOTIVE26400026400OPIS DAILY FAIRBANKS AK UNL 9.0$2.6038
10200020130GASOLINE,AVIATION220002200OPIS ANCHORAGE AK PUL 9.0$2.6647
10210021130GASOLINE,AVIATION1000100OPIS ANCHORAGE AK PUL 9.0$2.6647
10220022130GASOLINE,AVIATION560005600OPIS ANCHORAGE AK PUL 9.0$2.6647
10230023130GASOLINE,AVIATION700007000OPIS ANCHORAGE AK PUL 9.0$2.6647
10240024130GASOLINE,AVIATION220002200OPIS ANCHORAGE AK PUL 9.0$2.6647
10250025130GASOLINE,AVIATION240002400OPIS ANCHORAGE AK PUL 9.0$2.6647
10260026130GASOLINE,AVIATION220002200OPIS ANCHORAGE AK PUL 9.0$2.6647
10270027130GASOLINE,AVIATION7000700OPIS ANCHORAGE AK PUL 9.0$2.6647
10280028130GASOLINE,AVIATION1000100OPIS ANCHORAGE AK PUL 9.0$2.6647
10290029130GASOLINE,AVIATION1000100OPIS DAILY FAIRBANKS AK PUL 9.0$2.8950
10300030130GASOLINE,AVIATION1000100OPIS ANCHORAGE AK PUL 9.0$2.6647
10310031FS2FUEL OIL,BURNER84900084900OPIS DAILY SEATTLE NO2 ULS$2.8237
10320032FS2FUEL OIL,BURNER360003600OPIS DAILY SEATTLE NO2 ULS$2.8237
10330033FS2FUEL OIL,BURNER95800095800OPIS DAILY SEATTLE NO2 ULS$2.8237
10340034FS2FUEL OIL,BURNER200002000OPIS DAILY ANCHORAGE AK NO2 ULS$2.5563
10350035FS1FUEL OIL,BURNER170001700OPIS DAILY FAIRBANKS NO1$2.8700
10360036FS1FUEL OIL,BURNER19400019400OPIS DAILY ANCHORAGE AK NO1$2.6500
10370037FS1FUEL OIL,BURNER14800014800OPIS DAILY ANCHORAGE AK NO1$2.6500
10380038FS1FUEL OIL,BURNER390003900OPIS DAILY ANCHORAGE AK NO1$2.6500
10390039FS1FUEL OIL,BURNER12300012300OPIS DAILY FAIRBANKS NO1$2.8700
10400040FS1FUEL OIL,BURNER100001000OPIS DAILY FAIRBANKS NO1$2.8700
10410041FS1FUEL OIL,BURNER13000013000OPIS DAILY FAIRBANKS NO1$2.8700
10420042FS1FUEL OIL,BURNER850008500OPIS DAILY ANCHORAGE AK NO1$2.6500
10430043FS1FUEL OIL,BURNER34200034200OPIS DAILY ANCHORAGE AK NO1$2.6500
10440044FS1FUEL OIL,BURNER23000023000OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
10450045FS1FUEL OIL,BURNER530005300OPIS DAILY ANCHORAGE AK NO1$2.6500
10460046FS1FUEL OIL,BURNER10200010200OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
10470047FS1FUEL OIL,BURNER1000100OPIS DAILY FAIRBANKS NO1$2.8700
10480048FS1FUEL OIL,BURNER280002800OPIS DAILY FAIRBANKS NO1$2.8700
10490049FS1FUEL OIL,BURNER52700052700OPIS DAILY FAIRBANKS NO1$2.8700
10500050FS1FUEL OIL,BURNER1000100OPIS DAILY ANCHORAGE AK NO1$2.6500
10510051FS1FUEL OIL,BURNER15600015600OPIS DAILY ANCHORAGE AK NO1$2.6500
10520052FS1FUEL OIL,BURNER4404000440400OPIS DAILY ANCHORAGE AK NO1$2.6500
10530053FS1FUEL OIL,BURNER150001500OPIS DAILY FAIRBANKS NO1$2.8700
10540054FS1FUEL OIL,BURNER19300019300OPIS DAILY ANCHORAGE AK NO1$2.6500
10550055FS1FUEL OIL,BURNER24900024900OPIS DAILY ANCHORAGE AK NO1$2.6500
10560056FS1FUEL OIL,BURNER330003300OPIS DAILY ANCHORAGE AK NO1$2.6500
10570057FS1FUEL OIL,BURNER180001800OPIS DAILY ANCHORAGE AK NO1$2.6500
10580058FS1FUEL OIL,BURNER980009800OPIS DAILY ANCHORAGE AK NO1$2.6500
10590059FS1FUEL OIL,BURNER6000600OPIS DAILY ANCHORAGE AK NO1$2.6500
10600060FS1FUEL OIL,BURNER1000100OPIS DAILY FAIRBANKS NO1$2.8700
10610061FS1FUEL OIL,BURNER460004600OPIS DAILY ANCHORAGE AK NO1$2.6500
10620062FS1FUEL OIL,BURNER14700014700OPIS DAILY ANCHORAGE AK NO1$2.6500
10630063FS1FUEL OIL,BURNER24300024300OPIS DAILY ANCHORAGE AK NO1$2.6500
10640064FS1FUEL OIL,BURNER10800010800OPIS DAILY ANCHORAGE AK NO1$2.6500
10650065FS1FUEL OIL,BURNER14600014600OPIS DAILY FAIRBANKS NO1$2.8700
10660066FS1FUEL OIL,BURNER12200012200OPIS DAILY FAIRBANKS NO1$2.8700
10670067FS1FUEL OIL,BURNER10300010300OPIS DAILY ANCHORAGE AK NO1$2.6500
10680068FS1FUEL OIL,BURNER12600012600OPIS DAILY ANCHORAGE AK NO1$2.6500
10690069FS1FUEL OIL,BURNER150001500OPIS DAILY FAIRBANKS NO1$2.8700
10700070FS1FUEL OIL,BURNER90300090300OPIS DAILY FAIRBANKS NO1$2.8700
10710071FS1FUEL OIL,BURNER360003600OPIS DAILY FAIRBANKS NO1$2.8700
10720072FS1FUEL OIL,BURNER1000100OPIS DAILY ANCHORAGE AK NO1$2.6500
10730073JA1TURBINE FUEL,AVIATION950009500PLATTS DAILY SEATTLE JET$2.4215
10740074JA1TURBINE FUEL,AVIATION11400011400PLATTS DAILY SEATTLE JET$2.4215
10750075JP8TURBINE FUEL,AVIATION520005200PLATTS DAILY SEATTLE JET$2.4215
10770077J50TURBINE FUEL,AVIATION, J501231000123100PLATTS DAILY SEATTLE JET$2.4215
10780078J50TURBINE FUEL,AVIATION, J501787000178700PLATTS DAILY SEATTLE JET$2.4215
10790079J50TURBINE FUEL,AVIATION, J503059000305900PLATTS DAILY SEATTLE JET$2.4215
10800080DS2DIESEL FUEL3000300OPIS DAILY SEATTLE NO2 ULS$2.8237
10810081DS2DIESEL FUEL24100024100OPIS DAILY SEATTLE NO2 ULS$2.8237
10820082DS2DIESEL FUEL610006100OPIS DAILY SEATTLE NO2 ULS$2.8237
10830083DS2DIESEL FUEL1000100OPIS DAILY SEATTLE NO2 ULS$2.8237
10840084DS2DIESEL FUEL860008600OPIS DAILY SEATTLE NO2 ULS$2.8237
10850085DS2DIESEL FUEL1000100OPIS DAILY FAIRBANKS NO2 ULS$2.7975
10860086DS2DIESEL FUEL62500062500OPIS DAILY SEATTLE NO2 ULS$2.8237
10870087DS2DIESEL FUEL47100047100OPIS DAILY ANCHORAGE AK NO2 ULS$2.5563
10880088DS2DIESEL FUEL12500012500OPIS DAILY SEATTLE NO2 ULS$2.8237
10890089DS2DIESEL FUEL35200035200OPIS DAILY ANCHORAGE AK NO2 ULS$2.5563
10900090DS2DIESEL FUEL1000100OPIS DAILY ANCHORAGE AK NO2 ULS$2.5563
10910091DS2DIESEL FUEL1000100OPIS DAILY ANCHORAGE AK NO2 ULS$2.5563
10920092DS1DIESEL FUEL300003000OPIS DAILY FAIRBANKS NO1 ULS$2.7833
10930093DS1DIESEL FUEL940009400OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
10940094DS1DIESEL FUEL620006200OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
10950095DS1DIESEL FUEL1000100OPIS DAILY FAIRBANKS NO1 ULS$2.7833
10960096DS1DIESEL FUEL160001600OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
10970097DS1DIESEL FUEL250002500OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
10990099DS1DIESEL FUEL55900055900OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
11000100DS1DIESEL FUEL120001200OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11010101DS1DIESEL FUEL800008000OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11020102DS1DIESEL FUEL51300051300OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11030103DS1DIESEL FUEL14700014700OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
11040104DS1DIESEL FUEL150001500OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11050105DS1DIESEL FUEL650006500OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11060106DS1DIESEL FUEL2000200OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11070107DS1DIESEL FUEL9000900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11080108DS1DIESEL FUEL7000700OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
11090109DS1DIESEL FUEL2684000268400OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11100110DS1DIESEL FUEL1000100OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11110111DS1DIESEL FUEL30900030900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11120112DS1DIESEL FUEL85600085600OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11130113DS1DIESEL FUEL21800021800OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11140114DS1DIESEL FUEL1000100OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11150115DS1DIESEL FUEL56700056700OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11160116DS1DIESEL FUEL79000079000OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11170117DS1DIESEL FUEL25500025500OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11180118DS1DIESEL FUEL34000034000OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11190119DS1DIESEL FUEL73200073200OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11200120DS1DIESEL FUEL190001900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11210121DS1DIESEL FUEL21200021200OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11220122DS1DIESEL FUEL16400016400OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11230123DS1DIESEL FUEL1024000102400OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11240124DS1DIESEL FUEL3000300OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
11250125DS1DIESEL FUEL120001200OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
11260126DS1DIESEL FUEL590005900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11270127DS1DIESEL FUEL120001200OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11280128DS1DIESEL FUEL210002100OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11290129DS1DIESEL FUEL28700028700OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11300130DS1DIESEL FUEL1021000102100OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11310131DS1DIESEL FUEL32200032200OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11320132DS1DIESEL FUEL340003400OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11330133DS1DIESEL FUEL10000010000OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11340134DS1DIESEL FUEL21800021800OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11350135DS1DIESEL FUEL1389000138900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11360136DS1DIESEL FUEL590005900OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
11370137DS1DIESEL FUEL760007600OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11380138DS1DIESEL FUEL910009100OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11390139DS1DIESEL FUEL7000700OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11400140DS1DIESEL FUEL990009900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11410141DS1DIESEL FUEL2000200OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11420142DS1DIESEL FUEL6000600OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
11430143DS1DIESEL FUEL6000600OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11440144DS1DIESEL FUEL490004900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11450145DS1DIESEL FUEL9000900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11460146DS1DIESEL FUEL6000600OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11470147DS1DIESEL FUEL32500032500OPIS DAILY FAIRBANKS NO1$2.8700
11480148DS1DIESEL FUEL12600012600OPIS DAILY SEATTLE WAS NO1 ULS$3.3677
11490149DS1DIESEL FUEL2000200OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11500150DS1DIESEL FUEL290002900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11510151DS1DIESEL FUEL1000100OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11520152DS1DIESEL FUEL6000600OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11530153DS1DIESEL FUEL4000400OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11540154DS1DIESEL FUEL31900031900OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11550155DS1DIESEL FUEL1241000124100OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11560156DS1DIESEL FUEL15400015400OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11570157DS1DIESEL FUEL58300058300OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11580158DS1DIESEL FUEL2234000223400OPIS DAILY ANCHORAGE AK NO1ULS$2.5563
11590159DS1DIESEL FUEL8762000876200OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11630163DS1DIESEL FUEL21000021000OPIS DAILY FAIRBANKS NO1 ULS$2.7833
11640164DS1DIESEL FUEL1000000100000OPIS DAILY FAIRBANKS NO1 ULS$2.7833
Attachment S - Solicitation SPE60525R0208 - Options Pricing Submission Spreadsheet
NOTES TO OFFERORS:
1).Due to system limitations, FAR 52.217-6 is being addressed here and it will be a 10% increase of the quantity of the base line item in column F. The 10% quantity is reflected in column G.
2).In accordance with FAR 52.217-7, the option line items (as reflected in this spreadsheet) have an ordering period of 10/01/2030- 03/31/2031.
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 G by the option price in column I.

Sheet1

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