Asphalt Adjustment 2026.xlsx

This is an asphalt price adjustment worksheet for Kentucky master agreements effective March 1, 2026, used to calculate monthly cost adjustments for asphalt materials and mixtures. The document applies to bridge maintenance and repair projects across FHWA ER eligible districts 1-12 in Kentucky. The adjustment mechanism is designed to account for fluctuations in asphalt prices throughout the contract year, with calculations performed on a monthly basis from January through December 2026.

The asphalt adjustment is calculated using the formula: Asphalt Adjustment Quantity = (Q x 5.6)/100 x (PC - PL), where Q represents tons of material or mixture 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 includes a threshold requirement that must be met to trigger adjustments, with a binary indicator (1=Yes, 0=No) determining whether adjustments apply. Reference is provided to the Kentucky Transportation Cabinet's website for current KAPI pricing data, allowing contractors to obtain the necessary monthly index values for accurate adjustment calculations. The total asphalt adjustment quantity currently displays $0.00, pending the input of actual tonnage data and applicable index values.