Liquid Asphalt Adjustment 2023.xlsx

This is a pricing adjustment spreadsheet for Liquid Asphalt Master Agreements under the Kentucky Transportation Cabinet, effective March 1, 2023. The document establishes a mechanism for monthly price adjustments on liquid asphalt deliveries throughout the contract year. The adjustment applies to gallons of material picked up or delivered across all twelve months, with a baseline adjustment percentage of 0.6 percent established in February 2023.

The pricing adjustment is calculated using the formula: Asphalt Adjustment Quantity = (G x 0.6)/240 x (PC - PL), where G represents gallons of material, PL represents the KAPI (Kentucky Asphalt Price Index) for the month the contract was let, and PC represents the KAPI for the month of adjustment. A threshold mechanism is included to determine whether adjustments apply in any given month. The spreadsheet provides columns for tracking delivery order numbers, placement dates, gallon quantities, and whether the threshold has been met (indicated by 1 for yes or 0 for no). The document references the Kentucky Transportation Cabinet's Fuel and Asphalt Adjustments webpage for accessing current KAPI pricing data, allowing for real-time price index monitoring throughout the contract term.