Iowa Department of Transportation
INDEX  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
You need to upgrade your Flash Player
Download the most recent Flash plugin here.

Fuel Adjustment Worksheets


Fuel Adjustment for Earthwork Items for Contracts Let On or After 10/18/05


The specification for Fuel Adjustment, Section 2103 of the Standard Specifications, applies to a contract only when specified in the Proposal with the appropriate note. When specified, all categories (i.e. Roadway & Borrow, Unsuitable, Waste, Channel, etc.) of the following items are subject to fuel adjustment:
  • Class 10, 12 & 13 excavation
  • Select backfill
  • Topsoil
  • Embankment-in-place
The Current Price Index (CPI) will be printed in the Office of Contracts' Weekly Letting Report . The Letting Reports list CPI’s for several past months. The Base Price Index (BPI) for fuel adjustment calculations will be the CPI listed for the month prior to the letting date of the contract.

Fuel Adjustment Calculation

In accordance with Article 2103.04, the contractor shall provide to the Engineer, on a monthly basis, a spreadsheet with quantities and the calculated amount of fuel adjustment for the month. Payment will be processed with a Contract Modification.
Standardized Fuel Adjustment spreadsheets have been developed by the Office of Construction and are available in EXCEL format in English or Metric units (E105-English and M105-Metric).

Instructions for Fuel Adjustment Calculation Spreadsheet

Download the appropriate spreadsheet (English or Metric units) and save file to user’s computer.

Worksheets

English
Metric

  1. Complete contract information in header of spreadsheet.
  2. Obtain BPI, from the Weekly Letting Report by selecting Price Index for month previous to month of the letting. (For example: Letting Date is October 18, select CPI for September)
  3. Enter the BPI in the designated space (Cell K5-English or Cell J5-Metric). Form M105 will convert the BPI to the metric equivalent ($/GAL to $/Liter).
  4. Enter the contract quantity of the items in the designated rows in the “Estimated Project Quantities”. Other items included in the contract, but not listed, shall be added.
  5. Obtain the Current Price Index (CPI) for a month from the Weekly Letting Report
  6. Enter the CPI in the column “CPI” for the designated month. Form M105 will convert the CPI to the metric equivalent ($/GAL to $/Liter).
  7. Enter the quantities that have been hauled in the appropriate item columns and month row. For example, Selected Backfill and Class 10 Excavation were hauled in June. In the June row, the Selected Backfill quantity is entered in column 1 and Class 10 Excavation quantity in column 3. The total quantity for the month will be automatically computed and shown in the column labeled “Total CY” (or “Total M ³ ”).
  8. The fuel adjustment amount for the month will be automatically computed and shown in the column “NFA” (Net Fuel Adjustment).
  9. Submit a copy of the completed form to the Project Engineer. Payment or credit will be made by processing a Contract Modification. The form shall be completed and submitted on a monthly basis. The monthly quantities shall be added to the previous month’s spreadsheet.
  10. The Contractor and Project Engineer shall agree upon the frequency of payment or credit.

For assistance, contact the Project Engineer or the Office of Construction (515-239-1453)