Asphalt Adjustment 2025- Liquid Asphalt.xlsx

This file is a liquid asphalt pricing adjustment spreadsheet for master agreements effective March 1, 2025, used by the Commonwealth of Kentucky Department of Transportation. The document outlines the methodology for calculating monthly asphalt price adjustments based on the KAPI (Kentucky Asphalt Price Index) for the 2025 calendar year. The spreadsheet provides a template for tracking delivery orders, with columns for delivery order number, type, month placed, gallons of material, threshold met indicators, and adjustment percentages. Monthly data fields are included for each month from January through December, with an established baseline adjustment rate of 0.6 percent across all periods.

Pricing adjustments are calculated using the formula: Asphalt Adjustment Quantity = (G × 0.6)/240 × (PC - PL), where G represents gallons of material picked up or delivered, PL represents the KAPI for the month the contract is let, and PC represents the KAPI for the month of adjustment. The spreadsheet includes a reference link to the Kentucky Transportation Cabinet's website for obtaining current PC (KAPI) values. The total asphalt adjustment quantity is currently displayed as $0.0000, indicating that the spreadsheet serves as a blank template for contractors and the state to populate with actual delivery and pricing data as transactions occur throughout 2025.