19786_submittal.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Tankwagon/Transport Fuels
Solicitation number
26IFB19786
Issued by
South Dakota

About this file

This submittal document details fuel supply locations and estimated consumption volumes across South Dakota state agencies, including the Department of Transportation (DOT), Department of Game, Fish and Parks (GFP), and various educational institutions. The spreadsheet identifies 88 primary fuel storage locations plus 8 transport load distribution points and 6 additional fuel delivery hubs throughout the state. The contract encompasses the supply of multiple fuel types including undyed diesel (Categories 1 and 2), dyed diesel (Categories 1 and 2), E10/gasoline blends, and E30 fuel, with estimated annual gallons ranging from under 1,000 gallons at smaller locations to over 200,000 gallons at major distribution centers. Primary users span state agencies, educational facilities including South Dakota State University (SDSU) and Dakota State University, state parks, fish hatcheries, correctional facilities, and recreational areas. Estimated total consumption across all locations approaches several million gallons annually based on the aggregate volumes listed.

The submittal reflects a comprehensive statewide fuel procurement structure with significant variation in consumption patterns by location and fuel type. Major consumption centers include Sioux Falls, Rapid City, Pierre, Watertown, Yankton, Vermillion, and Winner for E10/gasoline products, with E10/gasoline volumes representing the primary fuel demand across the network. Dyed diesel and undyed diesel categories are supplied in tiered quantities (Category 1 and Category 2) at most locations, with smaller facilities receiving significantly reduced volumes. The document indicates a margin terminal supply model with wagon load delivery mechanisms, suggesting a contract structure utilizing both terminal and direct delivery logistics. Custer State Park is noted as a "KEEP FULL BASIS" location, indicating continuous replenishment requirements. The pricing structure appears based on fuel type and delivery methodology, though specific pricing terms are not detailed in this submittal document.

View the file

Other files

File Type Posted
SDVendorManual_20240822.pdf PDF
19786_specs.pdf PDF

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

Sheet1

Loc #LocationPrimary UsersFuel TypeEstimated GallonsMarginTerminal
Tank Wagon Loads
1AberdeenAll State AgenciesUndyed 1
Richmond LakeUndyed 2
Mina LakeDyed 15,900
NSUDyed 24,500
DOTE10/Gas14,000
E306,000
2ArlingtonLake PoinsettUndyed 1
Undyed 2
Dyed 1500
Dyed 2500
E10/Gas2,000
3ArmourDOTUndyed 1
Undyed 2
Dyed 18,300
Dyed 22,700
E10/Gas11,300
4Belle FourcheDOTUndyed 1
Rocky Point Rec AreaUndyed 2
Dyed 110,300
Dyed 24,000
E10/Gas31,500
5BeresfordSESD Research FarmUndyed 1
Undyed 2
Dyed 1800
Dyed 24,000
E10/Gas1,500
6BeresfordDOTUndyed 1
Undyed 2
Dyed 19,500
Dyed 23,100
E10/Gas22,700
7BisonDOTUndyed 1
Undyed 2
Dyed 19,700
Dyed 23,200
E10/Gas12,500
8BonesteelDOTUndyed 1
Undyed 2
Dyed 17,300
Dyed 22,400
E10/Gas7,800
9BrittonDOTUndyed 1
Undyed 2
Dyed 110,700
Dyed 23,500
E10/Gas9,700
10BrookingsDOTUndyed 1200
SDSUUndyed 2
Dyed 114,400
Dyed 232,000
E10/Gas6,500
11BruceOakwood LakeUndyed 1
Undyed 2
Dyed 1750
Dyed 2750
E10/Gas2,500
12BuffaloDOTUndyed 1
Undyed 2
Dyed 16,300
Dyed 22,100
E10/Gas7,600
13CantonNewton HillsUndyed 1
Undyed 2
Dyed 11,500
Dyed 21,500
E10/Gas9,000
14ChamberlainDOTUndyed 1
GFPUndyed 2
Dyed 113,700
Dyed 24,500
E10/Gas73,200
E302,500
15ClarkDOTUndyed 1
Undyed 2
Dyed 110,000
Dyed 23,400
E10/Gas14,500
16Clear LakeDOTUndyed 1
Undyed 2
Dyed 113,200
Dyed 24,400
E10/Gas18,200
17CoronaHartford BeachUndyed 1
Undyed 2
Dyed 1500
Dyed 2
E10/Gas700
18CusterCuster State ParkUndyed 12,500
Undyed 211,500
KEEP FULL BASISDyed 1
Dyed 2
E10/Gas36,500
19CusterDOTUndyed 1
Undyed 2
Dyed 116,500
Dyed 25,500
E10/Gas26,000
20DeadwoodDOTUndyed 1
Undyed 2
Dyed 122,000
Dyed 27,300
E10/Gas15,600
21DeSmetDOTUndyed 1
Undyed 2
Dyed 16,600
Dyed 22,200
E10/Gas6,600
22Eagle ButteDOTUndyed 1
Undyed 2
Dyed 17,600
Dyed 22,500
E10/Gas7,500
23EdgemontDOTUndyed 1
Undyed 2
Dyed 14,200
Dyed 21,400
E10/Gas2,700
24FaithDOTUndyed 1
Undyed 2
Dyed 16,300
Dyed 22,100
E10/Gas11,200
25FaulktonDOTUndyed 1
Undyed 2
Dyed 110,200
Dyed 23,400
E10/Gas9,200
26FlandreauDOTUndyed 1
Undyed 2
Dyed 18,900
Dyed 22,900
E10/Gas16,100
27GarretsonPalisadesUndyed 1
Undyed 2
Dyed 1
Dyed 2750
E10/Gas1,000
28GettysburgDOTUndyed 1
West WhitlockUndyed 2
Dyed 16,800
Dyed 22,400
E10/Gas12,900
29GrenvillePickeral LakeUndyed 1
Undyed 2
Dyed 1175
Dyed 2300
E10/Gas1,910
30HayesDOTUndyed 1
Undyed 2
Dyed 17,500
Dyed 22,500
E10/Gas7,500
31HaytiDOTUndyed 1
Undyed 2
Dyed 19,100
Dyed 23,000
E10/Gas20,000
32HerreidDOTUndyed 1
Undyed 2
Dyed 18,300
Dyed 22,700
E10/Gas4,000
33HighmoreDOTUndyed 1
Undyed 2
Dyed 18,500
Dyed 22,800
E10/Gas11,800
34Hill CityDOTUndyed 1
County ShopUndyed 2
Dyed 11,000
Dyed 21,000
E10/Gas1,000
35Hot SpringsAll State AgenciesUndyed 1
Undyed 21,000
Dyed 18,500
Dyed 24,800
E10/Gas24,800
36HuronAll State AgenciesUndyed 1700
DOTUndyed 2700
Federal SurplusDyed 118,600
Dyed 24,800
E10/Gas50,300
E303,400
37IpswichDOTUndyed 1
Undyed 2
Dyed 17,800
Dyed 22,600
E10/Gas12,000
38IsabelDOTUndyed 1
Undyed 2
Dyed 17,200
Dyed 22,400
E10/Gas4,100
39Junction CityDOTUndyed 1
Undyed 2
Dyed 14,000
Dyed 22,000
E10/Gas
40KadokaDOTUndyed 1
Undyed 2
Dyed 113,500
Dyed 24,500
E10/Gas26,400
41Lake AndesNorth PointUndyed 1
Undyed 2
Dyed 11,000
Dyed 21,200
E10/Gas8,500
42Lake CityRoy LakeUndyed 1
Fort SissetonUndyed 2
Dyed 1
Dyed 21,200
E10/Gas3,000
43Lake PrestonLake ThompsonUndyed 1
Undyed 2
Dyed 1450
Dyed 2560
E10/Gas1,600
44LeadGFPUndyed 1
Hardy Work CenterUndyed 2
Hobart RanchDyed 1
Dyed 217,500
E10/Gas14,100
45LemmonDOTUndyed 1
Undyed 2
Dyed 14,100
Dyed 21,300
E10/Gas6,900
46LennoxDOTUndyed 1
Undyed 2
Dyed 111,500
Dyed 23,800
E10/Gas15,000
47LeolaDOTUndyed 1
Undyed 2
Dyed 17,700
Dyed 22,500
E10/Gas5,500
48MadisonDOTUndyed 1200
Lake HermanUndyed 21,300
Dakota StateDyed 14,800
Dyed 22,500
E10/Gas26,600
49MartinDOTUndyed 1
Undyed 2
Dyed 19,700
Dyed 23,200
E10/Gas6,300
50McIntoshDOTUndyed 1
Undyed 2
Dyed 16,400
Dyed 22,100
E10/Gas5,500
51MennoDOTUndyed 1
Undyed 2
Dyed 18,800
Dyed 22,900
E10/Gas7,400
52MilbankDOTUndyed 1
Undyed 2
Dyed 112,000
Dyed 24,000
E10/Gas11,000
53MillerLake LouiseUndyed 1
Undyed 2
Dyed 1
Dyed 2500
E10/Gas400
54MillerDOTUndyed 1
Undyed 2
Dyed 111,200
Dyed 23,700
E10/Gas16,900
55MissionDOTUndyed 1
Undyed 2
Dyed 110,300
Dyed 23,400
E10/Gas11,000
56MobridgeDOTUndyed 1
GFPUndyed 22,400
Indian CreekDyed 113,000
Dyed 26,000
E10/Gas31,000
57MurdoDOTUndyed 1
Undyed 2
Dyed 111,300
Dyed 23,700
E10/Gas1,800
58NewellDOTUndyed 1
Undyed 2
Dyed 113,200
Dyed 24,400
E10/Gas10,100
59OelrichsDOTUndyed 1
Undyed 2
Dyed 17,000
Dyed 22,300
E10/Gas6,300
60PhilipDOTUndyed 1
Cottonwood StationUndyed 2
Dyed 18,400
Dyed 23,200
E10/Gas10,350
61PiedmontGFP Shooting RangeUndyed 1
Undyed 2500
Dyed 1
Dyed 21,500
E10/Gas1,500
62Pierre - Fort PierreDOTUndyed 11,500
Fleet & TravelUndyed 26,000
Oahe DownstreamDyed 15,600
Spring CreekDyed 24,600
E10/Gas31,900
E3035,000
63PierreDakota Lakes ResearchUndyed 1
Undyed 2
Dyed 11,000
Dyed 24,500
E10/Gas600
64PierreFarm Island Rec AreaUndyed 1
West BendUndyed 2
Dyed 1300
Dyed 21,700
E10/Gas1,050
65PlankintonDOTUndyed 1
Undyed 2
Dyed 111,500
Dyed 23,800
E10/Gas32,100
66PlatteDOTUndyed 1
Snake CreekUndyed 2
Dyed 111,200
Dyed 24,700
E10/Gas16,100
67PreshoDOTUndyed 1
Undyed 2
Dyed 19,900
Dyed 23,300
E10/Gas11,500
68Rapid CityAll State AgenciesUndyed 1
Undyed 211,000
Dyed 18,000
Dyed 24,500
E10/Gas26,000
69RedfieldDOTUndyed 1
Developmental Ctr.Undyed 2
Dyed 113,900
Dyed 24,200
E10/Gas34,700
70SalemDOTUndyed 1
Lake VermillionUndyed 2
Dyed 110,200
Dyed 23,900
E10/Gas13,800
71SelbyDOTUndyed 1
Undyed 2
Dyed 15,200
Dyed 21,700
E10/Gas6,300
72ShadehillShadehill Rec AreaUndyed 1400
Undyed 21,000
Dyed 1
Dyed 2
E10/Gas8,000
73Sioux FallsAll State AgenciesUndyed 1
Undyed 2
Dyed 18,000
Dyed 22,750
E10/Gas6,700
E3015,200
74SissetonDOTUndyed 1
Undyed 2
Dyed 124,200
Dyed 28,000
E10/Gas23,000
75SpearfishAll State AgenciesUndyed 1
BHSUUndyed 2
Dyed 111,500
Dyed 21,700
E10/Gas8,220
76SpringfieldDurfee State PrisonUndyed 1
Undyed 2
Dyed 1
Dyed 2
E10/Gas18,500
77SturgisBear Butte State ParkUndyed 1
Undyed 2
Dyed 1
Dyed 2500
E10/Gas
78SturgisDOTUndyed 1
Undyed 2
Dyed 119,000
Dyed 26,300
E10/Gas95,500
79TyndallDOTUndyed 1
Undyed 2
Dyed 17,800
Dyed 22,600
E10/Gas11,200
80VermillionDOTUndyed 1
Fleet & TravelUndyed 2
Dyed 1
Dyed 2
E10/Gas75,000
E303,000
81WallDOTUndyed 1
Undyed 2
Dyed 19,100
Dyed 23,000
E10/Gas13,000
82WatertownDOTUndyed 11,500
GFPUndyed 28,000
Pelican LakeDyed 120,000
Dyed 27,000
E10/Gas75,000
E301,500
83WaubayBlue Dog Fish HatcheryUndyed 1
Undyed 2
Dyed 1400
Dyed 2400
E10/Gas3,500
84WebsterDOTUndyed 1
GFPUndyed 2
Dyed 113,900
Dyed 24,600
E10/Gas40,350
E303,200
85White RiverDOTUndyed 1
Undyed 2
Dyed 18,100
Dyed 22,700
E10/Gas5,700
86WinnerDOTUndyed 1
Undyed 2
Dyed 118,500
Dyed 26,100
E10/Gas55,000
87WoonsocketDOTUndyed 1
Undyed 2
Dyed 16,600
Dyed 22,200
E10/Gas7,400
88YanktonAll State AgenciesUndyed 1
Undyed 2
Dyed 111,900
Dyed 23,900
E10/Gas72,500
E302,700
Transport Loads
201AberdeenDOTUndyed 1
Undyed 2
Dyed 128,000
Dyed 29,300
202BrookingsDOTUndyed 1
SDSUUndyed 2
Dyed 119,000
Dyed 212,000
203Junction CityDOTUndyed 1
Undyed 2
Dyed 117,800
Dyed 26,000
204MitchellDOTUndyed 1
Undyed 2
Dyed 127,000
Dyed 29,000
205PierreDOTUndyed 1
Undyed 2
Dyed 141,700
Dyed 213,900
206Rapid CityDOTUndyed 1
Undyed 2
Dyed 165,000
Dyed 222,000
207Sioux FallsDOTUndyed 1
Undyed 2
Dyed 159,300
Dyed 220,000
208SpringfieldDurfee State PrisonUndyed 1
Undyed 2
Dyed 1
Dyed 2200,000

301 Aberdeen DOT E10/Gas 68,200

302BrookingsDOTE10/Gas121,200
SDSU/FleetE3018,000
303MitchellDOTE10/Gas121,000
E307,200

304 Pierre DOT E10/Gas 285,000

305Rapid CityDOTE10/Gas219,500
E308,500

306 Sioux Falls DOT E10/Gas 222,000

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