Liquid Asphalt Adjustment 2024.xlsx

This is a Liquid Asphalt Adjustment spreadsheet for Liquid Asphalt Master Agreements effective March 1, 2024, issued by the Kentucky state transportation authority. The document establishes the framework for adjusting liquid asphalt pricing under existing master agreements through monthly delivery orders. The adjustment mechanism applies to gallons of material picked up or delivered across a full calendar year from January through December 2024, with a standard adjustment factor of 0.6 applied uniformly throughout the contract period.

Pricing adjustments are 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 determination mechanism exists to identify when adjustments apply, though the specific threshold criteria are not detailed in this spreadsheet. Current pricing shows a zero adjustment ($0.0000) based on the data provided. The adjustment process references Kentucky's Transportation Cabinet Fuel and Asphalt Adjustments guidelines, with contractors required to obtain the current PC (KAPI) value through the provided online resource portal to calculate monthly adjustments accurately.