Fuel Index Worksheet for Salt.xlsx

This is a Fuel Index Reconciliation Worksheet for Salt Deliveries used by the Missouri Department of Transportation (MoDOT) in connection with a statewide sodium chloride replenishment contract. The worksheet serves as a monthly adjustment mechanism to account for fluctuations in fuel costs that impact the delivery and handling of salt. Contractors must complete designated cells to calculate the monthly fuel index adjustment factor by comparing the starting fuel index established at contract inception with the current monthly fuel index published by MoDOT. The contract period extends from the Notice of Contract Award through April 30, 2027, and applies to deliveries of both regular and treated sodium chloride across Missouri.

The fuel adjustment calculation is based on a straightforward methodology: the difference between the starting and monthly fuel indices is multiplied by the tonnage delivered in each month, with adjustments made in $0.10 increments following standard rounding rules. If fuel prices increase or decrease by $0.10 per gallon, the salt price adjusts by $0.10 per ton accordingly. Contractors must identify the starting fuel index from the Price Adjustment for Fuel attachment included in their bid contract and obtain the monthly fuel index from MoDOT's bid opening information website. The worksheet contains embedded formulas to automatically calculate the fuel adjustment amount once the required data fields are populated, ensuring consistent and transparent pricing adjustments throughout the contract term. Bidders interested in submitting hard copy bids must contact the buyer of record, Nanci.Grannemann@modot.mo.gov, at least five business days before the bid closing deadline.