Asphalt Adjustment 2026.xlsx

This is an asphalt adjustment pricing spreadsheet for Kentucky state and local contract opportunities, specifically related to Bridge Maintenance & Repair for State Projects D 1-8 & 10-11 under Master Agreements effective March 1, 2026. The spreadsheet is designed to track monthly asphalt deliveries and calculate price adjustments based on fluctuating asphalt costs. The document provides a template for recording delivery order information, including the month placed, quantity of tons, asphalt content percentages, and threshold determinations across all twelve months of the contract year. The spreadsheet is configured to calculate total asphalt adjustment quantities automatically using the specified formula.

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 adjustment percentage is determined by comparing the current month's KAPI price (PC) against the base month KAPI price from February 2026 (PL), with a threshold determination included to trigger adjustments only when specified conditions are met. The spreadsheet references the Kentucky Transportation Cabinet's Fuel and Asphalt Adjustments page for obtaining current KAPI pricing data, enabling contractors to accurately calculate cost adjustments throughout the contract period.