Asphalt Adjustment 2026.xlsx

This is an asphalt price adjustment spreadsheet for the Kentucky Department of Transportation applicable to Master Agreements effective March 1, 2026, and related to Bridge Maintenance & Repair State Projects D 1-8 & 10-11. The document provides a template for calculating monthly asphalt adjustments across all twelve months of the year, with line items for delivery order specifications including quantity in tons, asphalt content, and threshold determination. The spreadsheet is designed to track asphalt material usage and associated price fluctuations throughout the contract period, with columns designated for recording tons of material, the KAPI (Kentucky Asphalt Price Index) for the month bid (PL), and the KAPI for the month of pickup or delivery (PC).

The adjustment calculation follows a specific formula: Asphalt Adjustment Quantity equals (Q x 5.6)/100 multiplied by (PC - PL), where Q represents the total tons of material or mixture used. A threshold met indicator (1 for yes, 0 for no) must be recorded for each month to determine eligibility for adjustment. The spreadsheet currently shows a total asphalt adjustment quantity of $0.00, with the perpetual rate factor of 5.6 applied consistently across all months. Contractors and the state can obtain current PC (KAPI) values through the Kentucky Transportation Cabinet's Fuel and Asphalt Adjustments webpage, enabling real-time price adjustment calculations based on prevailing material costs.