December 2021 Fuel Adjustment WI State Agency Contract.xlsx

XLSX spreadsheet 24 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 adjustment pricing mechanism for a Wisconsin State Agency contract, outlining how per case costs will be adjusted based on diesel fuel price fluctuations. The adjustment system uses the U.S. Energy Information Administration's Weekly Retail Gasoline and Diesel Prices for the Midwest region as the pricing benchmark, with a base fuel index established at $3.104 per gallon as of March 29, 2021.

The contract establishes a tiered pricing structure where per case costs increase by $0.01 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 diesel prices fall below $2.34 per gallon, per case costs are reduced by $0.005 for every $0.10 decrease. The document tracks actual fuel prices and corresponding adjustments from June through November 2021, showing prices ranging from $3.231 to $3.631 per gallon, resulting in per case fees between $0.01 and $0.05. The adjustment schedule includes predetermined fee structures extending up to $3.87 per gallon for increases and down to $1.24 per gallon for reductions, ensuring comprehensive coverage for fuel price volatility.

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
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
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)
$ 3.77$ 3.8699$ 0.07$ 1.7399$ 1.640$ (0.035)
$ 3.87$ 3.9699$ 0.08$ 1.6399$ 1.540$ (0.040)
$ 1.5399$ 1.440$ (0.045)
$ 1.4399$ 1.340$ (0.050)
$ 1.3399$ 1.240$ (0.055)

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 .