Asphalt Adjustment 2026.xlsx

This is an asphalt price adjustment spreadsheet for master agreements effective March 1, 2026, administered by the Kentucky Department of Transportation in conjunction with the Bridge Maintenance & Repair program for FHWA ER Eligible Districts 1-12. The document provides a template for calculating monthly asphalt adjustments based on fluctuations in asphalt pricing throughout the contract year. The spreadsheet is designed to track delivery orders by month from January through December, with columns for recording tons of material used, asphalt content percentages, and adjustment calculations. No specific quantities, response dates, due dates, or contract term information is provided in this adjustment schedule template.

Pricing for asphalt adjustments is calculated using the formula: Asphalt Adjustment Quantity = (Q x 5.6)/100 x (PC - PL), where Q represents tons of material, PL is the KAPI (Kentucky Asphalt Pavement Index) for the month the contract is bid, and PC is the KAPI for the month of pickup or delivery. The threshold determination (indicated by a 1 for yes or 0 for no) and corresponding adjustment percentages are applied monthly to account for volatile asphalt pricing. The spreadsheet includes a link to the Kentucky Transportation Cabinet's Fuel and Asphalt Adjustments page for obtaining current KAPI pricing data. The template shows a total asphalt adjustment quantity of $0.00, indicating this is a blank form ready for population with actual project data and pricing information.