Asphalt Adjustment 2026.xlsx

This is an asphalt adjustment calculation spreadsheet for Kentucky state transportation contracts, effective March 1, 2026, related to bridge maintenance and repair projects. The document serves as a tool for calculating price adjustments on asphalt materials used under master agreements. The spreadsheet is organized by delivery order, with monthly tracking from January through December, and records key variables including tons of material quantity (Q), asphalt content, the KAPI (Kentucky Asphalt Price Index) for the month the contract was bid (PL), and the KAPI for the month of pickup or delivery (PC). A threshold met indicator determines whether adjustments apply, with adjustment percentages calculated and tracked by delivery date.

The asphalt adjustment calculation formula multiplies the tons of material by 5.6, divides by 100, and multiplies the result by the difference between the current month's KAPI and the bid month's KAPI: Asphalt Adjustment Quantity = (Q x 5.6)/100 x (PC - PL). This mechanism allows contractors to receive price adjustments when asphalt costs fluctuate between the bid date and delivery date, protecting against material cost volatility. The total asphalt adjustment quantity is calculated and displayed as a dollar amount, with current totals shown as $0.00. The spreadsheet references the Kentucky Transportation Cabinet's Fuel and Asphalt Adjustments page for current KAPI values, enabling real-time price index lookups necessary for accurate adjustment calculations under these state master agreements.