November 2022 Fuel Adjustment WI State Agency Contract.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
Prime Vendor Food Contract
Contract number
435820-O16-FoodIndHd---01
Issued by
Wisconsin

About this file

This document is a fuel cost adjustment mechanism for a Wisconsin State Agency contract, establishing a systematic approach to adjusting contract prices based on fluctuations in diesel fuel costs. The adjustment system references the U.S. Energy Information Administration (EIA) Weekly Retail Gasoline and Diesel Prices for the Midwest region (PADD 2), using a base fuel index of $3.104 per gallon established on March 29, 2021.

The contract includes a dual-tier pricing adjustment structure where increases above $3.17 per gallon result in a $0.01 per case fee for each $0.10 increment in fuel cost increases, while decreases below $2.34 per gallon provide a $0.005 per case credit for each $0.10 decrement in fuel cost reductions. The document tracks monthly fuel price data from June 2021 through October 2022, showing significant price volatility ranging from approximately $3.23 to $5.78 per gallon, with corresponding per-case adjustments ranging from $0.01 to $0.27. Adjustments are applied to invoices in the month following the fuel price measurement, with the cost modification calculated at the bottom of each invoice based on the number of cases and the monthly fuel cost adjustment rate.

View the file

Other files

File Type Posted
July 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
January 2022 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
March 2019 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
July 2022 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
October 2019 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
January 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
February 2019 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
April 2022 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
November 2019 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
Department of Wisconsin Incident Report - Food Quality Concern.pdf PDF
Product Quality Report.pdf PDF
Department of Wisconsin Incident Report - Food Harm.pdf PDF
February 2022 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
Contract Renewal 5.doc.pdf PDF
December 2019 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
November 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
December 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
September 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
October 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
April 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
July 2019 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
March 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
September 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
December 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
August 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
June 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
October 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
August 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
May 2022 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
May 2019 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
Food product dates and codes.pdf PDF
3253_0.PDF PDF
Product Incident Report.pdf PDF
August 2022 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
July 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
February 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
April 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
January 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
February 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
September 2022 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
May 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
June 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
December 2022 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
June 2022 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
May 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
435820-O16-FoodIndHd---01 M1.docx.pdf PDF
November 2021 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
March 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
June 2019 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
August 2019 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
Show all 50

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

WI State Agency

Wisconsin State Agency Fuel Cost Adjustment
Each time the average price* exceeds $3.17 per gallon, a per case cost of $ 0.01 for each $ 0.10 increase in diesel fuel over $3.17 per gallon will be added to invoices billed in the following month, beginning at the first day of the month. This adjustment Base Fuel Index is based on U.S. Energy Information Administration (EIA) Weekly Retail Gasoline and Diesel Prices; Diesel (On-Highway) - All Types Price in the Midwest (PADD 2) 03/29/2021 at $ 3.104/gallon. Alternatively, each time the average price* falls below $2.34 per gallon, a per case reduction of $ 0.005 for each $ 0.10 decrease in diesel fuel below $2.34 per gallon will be deducted from invoices billed in the following month, beginning at the first day of the month. The cost adjustment will be made at the bottom of each invoice calculating the cases and the monthly fuel cost adjustment rate.
Add Per CaseCredit Per Case
Fuel Cost RangePer case FeeFuel Cost RangePer case creditDateAverage PricePer case FeeEffective
6/21/21$ 3.231$ 0.0107/1/21
$ 3.17$ 3.2699$ 0.01$ 2.3399$ 2.240$ (0.005)7/19/21$ 3.264$ 0.0108/1/21
$ 3.27$ 3.3699$ 0.02$ 2.2399$ 2.140$ (0.010)8/16/21$ 3.259$ 0.0109/1/21
$ 3.37$ 3.4699$ 0.03$ 2.1399$ 2.040$ (0.015)9/20/21$ 3.290$ 0.02010/1/21
$ 3.47$ 3.5699$ 0.04$ 2.0399$ 1.940$ (0.020)10/18/21$ 3.615$ 0.05011/1/21
$ 3.57$ 3.6699$ 0.05$ 1.9399$ 1.840$ (0.025)11/15/21$ 3.631$ 0.05012/1/21
$ 3.67$ 3.7699$ 0.06$ 1.8399$ 1.740$ (0.030)12/20/21$ 3.492$ 0.0401/1/21
$ 3.77$ 3.8699$ 0.07$ 1.7399$ 1.640$ (0.035)1/17/22$ 3.603$ 0.0502/1/22
$ 3.87$ 3.9699$ 0.08$ 1.6399$ 1.540$ (0.040)2/21/22$ 3.905$ 0.0803/1/22
$ 3.97$ 4.0699$ 0.09$ 1.5399$ 1.440$ (0.045)3/21/22$ 4.959$ 0.1804/1/22
$ 4.07$ 4.1699$ 0.10$ 1.4399$ 1.340$ (0.050)4/18/22$ 4.921$ 0.1805/1/22
$ 4.17$ 4.2699$ 0.11$ 1.3399$ 1.240$ (0.055)5/16/22$ 5.346$ 0.2206/1/22
$ 4.27$ 4.3699$ 0.126/20/22$ 5.780$ 0.2707/1/22
$ 4.37$ 4.4699$ 0.137/18/22$ 5.409$ 0.2308/1/22
$ 4.47$ 4.5699$ 0.148/15/22$ 4.872$ 0.1809/1/22
$ 4.57$ 4.6699$ 0.159/19/22$ 4.995$ 0.19010/1/22
$ 4.67$ 4.7699$ 0.1610/17/22$ 5.346$ 0.22011/1/22
$ 4.77$ 4.8699$ 0.17
$ 4.87$ 4.9699$ 0.18
$ 4.97$ 5.0699$ 0.19
$ 5.07$ 5.1699$ 0.20
$ 5.17$ 5.2699$ 0.21
$ 5.27$ 5.3699$ 0.22
$ 5.37$ 5.4699$ 0.23
$ 5.47$ 5.5699$ 0.24
$ 5.57$ 5.6699$ 0.25
$ 5.67$ 5.7699$ 0.26
$ 5.77$ 5.8699$ 0.27
$ 5.87$ 5.9699$ 0.28

Each time the average price* exceeds $3.17 per gallon, a per case cost of $ 0.01 for each $ 0.10 increase in diesel fuel over $3.17 per gallon will be added to invoices billed in the following month, beginning at the first day of the month. This adjustment Base Fuel Index is based on U.S. Energy Information Administration (EIA) Weekly Retail Gasoline and Diesel Prices; Diesel (On-Highway) - All Types Price in the Midwest (PADD 2) 03/29/2021 at $ 3.104/gallon. Alternatively, each time the average price* falls below $2.34 per gallon, a per case reduction of $ 0.005 for each $ 0.10 decrease in diesel fuel below $2.34 per gallon will be deducted from invoices billed in the following month, beginning at the first day of the month

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