May 2025 Fuel Adjustment WI State Agency Contract.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Prime Vendor Food Distributor
- Contract number
- 505ENT-M22-FOODDISTRIB-01
- Issued by
- Wisconsin
About this file
This document is a fuel cost adjustment schedule for a Wisconsin State Agency contract, tracking diesel fuel price fluctuations and corresponding per-case fee adjustments from June 2021 through May 2025. The adjustment mechanism is tied to the U.S. Energy Information Administration's weekly retail diesel prices for the Midwest region (PADD 2), 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 fees increase by $0.01 for each $0.10 increment that average diesel prices exceed $3.17 per gallon, with adjustments applied to invoices in the following month. Conversely, when prices fall below $2.34 per gallon, per-case credits of $0.005 are applied for each $0.10 decrease below that threshold. The historical data shows significant price volatility, with diesel costs ranging from $3.45 to $5.78 per gallon over the contract period, resulting in per-case adjustments from $0.03 to $0.27. The most recent adjustment for May 2025 shows diesel at $3.475 per gallon with a corresponding $0.04 per-case fee, demonstrating the contract's mechanism for protecting both parties against fuel price fluctuations in what appears to be a goods delivery or transportation-related service contract.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1. User Guide 505ENT-M22-FOODDISTRIB-01 20240619.docx | DOCX document | |
| July 2025 Fuel Adjustment WI State Agency Contract.xlsx | XLSX spreadsheet | |
| Smuckers recall 5-23-22.pdf | ||
| August 2025 Fuel Adjustment WI State Agency Contract.xlsx | XLSX spreadsheet | |
| Frozen Prod in Prod 2021 09082021 FINAL.xlsx | XLSX spreadsheet | |
| 28326-JB_RFB_Prime_Vendor_Food.pdf | ||
| RFB 28326-JB Amendments 1-4.pdf | ||
| Prime Vendor Food Distributor Contract RFB 28326.doc.pdf | ||
| June 2025 Fuel Adjustment WI State Agency Contract.xlsx | XLSX spreadsheet |
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 Case | Credit Per Case | ||||||||
| Fuel Cost Range | Per case Fee | Fuel Cost Range | Per case credit | Date | Average Price | Per case Fee | Effective | ||
| 6/21/21 | $ 3.231 | $ 0.010 | 7/1/21 | ||||||
| $ 3.17 | $ 3.2699 | $ 0.01 | $ 2.3399 | $ 2.240 | $ (0.005) | 7/19/21 | $ 3.264 | $ 0.010 | 8/1/21 |
| $ 3.27 | $ 3.3699 | $ 0.02 | $ 2.2399 | $ 2.140 | $ (0.010) | 8/16/21 | $ 3.259 | $ 0.010 | 9/1/21 |
| $ 3.37 | $ 3.4699 | $ 0.03 | $ 2.1399 | $ 2.040 | $ (0.015) | 9/20/21 | $ 3.290 | $ 0.020 | 10/1/21 |
| $ 3.47 | $ 3.5699 | $ 0.04 | $ 2.0399 | $ 1.940 | $ (0.020) | 10/18/21 | $ 3.615 | $ 0.050 | 11/1/21 |
| $ 3.57 | $ 3.6699 | $ 0.05 | $ 1.9399 | $ 1.840 | $ (0.025) | 11/15/21 | $ 3.631 | $ 0.050 | 12/1/21 |
| $ 3.67 | $ 3.7699 | $ 0.06 | $ 1.8399 | $ 1.740 | $ (0.030) | 12/20/21 | $ 3.492 | $ 0.040 | 1/1/21 |
| $ 3.77 | $ 3.8699 | $ 0.07 | $ 1.7399 | $ 1.640 | $ (0.035) | 1/17/22 | $ 3.603 | $ 0.050 | 2/1/22 |
| $ 3.87 | $ 3.9699 | $ 0.08 | $ 1.6399 | $ 1.540 | $ (0.040) | 2/21/22 | $ 3.905 | $ 0.080 | 3/1/22 |
| $ 3.97 | $ 4.0699 | $ 0.09 | $ 1.5399 | $ 1.440 | $ (0.045) | 3/21/22 | $ 4.959 | $ 0.180 | 4/1/22 |
| $ 4.07 | $ 4.1699 | $ 0.10 | $ 1.4399 | $ 1.340 | $ (0.050) | 4/18/22 | $ 4.921 | $ 0.180 | 5/1/22 |
| $ 4.17 | $ 4.2699 | $ 0.11 | $ 1.3399 | $ 1.240 | $ (0.055) | 5/16/22 | $ 5.346 | $ 0.220 | 6/1/22 |
| $ 4.27 | $ 4.3699 | $ 0.12 | 6/20/22 | $ 5.780 | $ 0.270 | 7/1/22 | |||
| $ 4.37 | $ 4.4699 | $ 0.13 | 7/18/22 | $ 5.409 | $ 0.230 | 8/1/22 | |||
| $ 4.47 | $ 4.5699 | $ 0.14 | 8/15/22 | $ 4.872 | $ 0.180 | 9/1/22 | |||
| $ 4.57 | $ 4.6699 | $ 0.15 | 9/19/22 | $ 4.995 | $ 0.190 | 10/1/22 | |||
| $ 4.67 | $ 4.7699 | $ 0.16 | 10/17/22 | $ 5.346 | $ 0.220 | 11/1/22 | |||
| $ 4.77 | $ 4.8699 | $ 0.17 | 11/21/22 | $ 5.231 | $ 0.210 | 12/1/22 | |||
| $ 4.87 | $ 4.9699 | $ 0.18 | 12/19/22 | $ 4.477 | $ 0.140 | 1/1/23 | |||
| $ 4.97 | $ 5.0699 | $ 0.19 | 1/16/23 | $ 4.374 | $ 0.130 | 2/1/23 | |||
| $ 5.07 | $ 5.1699 | $ 0.20 | 2/20/23 | $ 4.194 | $ 0.110 | 3/1/23 | |||
| $ 5.17 | $ 5.2699 | $ 0.21 | 3/20/23 | $ 4.021 | $ 0.090 | 4/1/23 | |||
| $ 5.27 | $ 5.3699 | $ 0.22 | 4/17/23 | $ 4.027 | $ 0.090 | 5/1/23 | |||
| $ 5.37 | $ 5.4699 | $ 0.23 | 5/15/23 | $ 3.823 | $ 0.070 | 6/1/23 | |||
| $ 5.47 | $ 5.5699 | $ 0.24 | 6/19/23 | $ 3.739 | $ 0.060 | 7/1/23 | |||
| $ 5.57 | $ 5.6699 | $ 0.25 | 7/17/23 | $ 3.726 | $ 0.060 | 8/1/23 | |||
| $ 5.67 | $ 5.7699 | $ 0.26 | 8/21/23 | $ 4.302 | $ 0.120 | 9/1/23 | |||
| $ 5.77 | $ 5.8699 | $ 0.27 | 9/18/23 | $ 4.492 | $ 0.140 | 10/1/23 | |||
| $ 5.87 | $ 5.9699 | $ 0.28 | 10/16/23 | $ 4.304 | $ 0.120 | 11/1/23 | |||
| 11/20/23 | $ 4.207 | $ 0.110 | 12/1/23 | ||||||
| 12/18/23 | $ 3.806 | $ 0.070 | 1/1/24 | ||||||
| 1/15/24 | $ 3.729 | $ 0.060 | 2/1/24 | ||||||
| 2/19/24 | $ 4.010 | $ 0.090 | 3/1/24 | ||||||
| 3/18/24 | $ 3.955 | $ 0.080 | 4/1/24 | ||||||
| 4/15/24 | $ 3.965 | $ 0.080 | 5/1/24 | ||||||
| 5/20/24 | $ 3.685 | $ 0.060 | 6/1/24 | ||||||
| 6/17/24 | $ 3.621 | $ 0.050 | 7/1/24 | ||||||
| 7/15/24 | $ 3.745 | $ 0.060 | 8/1/24 | ||||||
| 8/19/24 | $ 3.674 | $ 0.060 | 9/1/24 | ||||||
| 9/16/24 | $ 3.481 | $ 0.040 | 10/1/24 | ||||||
| 10/21/24 | $ 3.543 | $ 0.040 | 11/1/24 | ||||||
| 11/18/24 | $ 3.466 | $ 0.030 | 12/1/24 | ||||||
| 12/16/24 | $ 3.450 | $ 0.030 | 1/1/25 | ||||||
| 1/20/25 | $ 3.648 | $ 0.050 | 2/1/25 | ||||||
| 2/17/25 | $ 3.602 | $ 0.050 | 3/1/25 | ||||||
| 3/17/25 | $ 3.463 | $ 0.030 | 4/1/25 | ||||||
| 4/21/25 | $ 3.475 | $ 0.040 | 5/1/25 |
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 .