Asphalt Adjustment 2026.xlsx

This is an asphalt price adjustment worksheet for master agreements with the Kentucky Transportation Cabinet, effective March 1, 2026, related to Bridge Maintenance & Repair services for FHWA-eligible districts 1-12. The document provides a template for calculating monthly asphalt adjustments across a 12-month period (January through December) based on tonnage of material used and fluctuations in asphalt prices. The worksheet accommodates delivery order numbers, item quantities measured in tons, asphalt content percentages, and threshold determinations to establish whether price adjustments are warranted.

The adjustment calculation follows a specific formula: Asphalt Adjustment Quantity = (Q x 5.6)/100 x (PC - PL), where Q represents tons of material used, PL represents the KAPI (Kentucky Asphalt Price Index) for the month the contract was bid, and PC represents the KAPI for the month of pickup or delivery. The worksheet uses a baseline asphalt content factor of 5.6 and requires monthly KAPI values to be obtained from the Kentucky Transportation Cabinet's fuel and asphalt adjustments portal. The total asphalt adjustment amount is calculated at $0.00 in the template, with adjustments applied only when threshold requirements are met, enabling contractors to receive compensation for asphalt price fluctuations during contract performance.