June 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 schedule for a Wisconsin State Agency contract that establishes a mechanism for adjusting pricing based on diesel fuel price fluctuations. The adjustment system is tied to the U.S. Energy Information Administration's 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 tiered fuel adjustment system where costs increase by $0.01 per case for every $0.10 increase in diesel fuel prices above $3.17 per gallon, with adjustments applied to invoices in the following month. Conversely, when fuel prices fall below $2.34 per gallon, customers receive a credit of $0.005 per case for every $0.10 decrease below that threshold. The document tracks historical fuel prices and corresponding per-case adjustments from June 2021 through May 2022, showing prices ranging from $3.231 to $5.346 per gallon with per-case fees escalating from $0.01 to $0.22. The adjustment schedule extends up to $5.97 per gallon with a maximum per-case fee of $0.28, providing a comprehensive framework for managing fuel cost volatility in contract pricing.

View the file

Other files

File Type Posted
July 2020 Fuel Adjustment WI State Agency Contract.xlsx XLSX spreadsheet
November 2022 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
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.12
$ 4.37$ 4.4699$ 0.13
$ 4.47$ 4.5699$ 0.14
$ 4.57$ 4.6699$ 0.15
$ 4.67$ 4.7699$ 0.16
$ 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 .