Asphalt Adjustment Spreadsheet 2020.xlsx

This is an Asphalt Adjustment Spreadsheet for Liquid Asphalt Master Agreements under the Kentucky Transportation Cabinet, effective March 1, 2020. The document serves as a calculation tool for tracking liquid asphalt deliveries and associated price adjustments across a twelve-month period from January through December. The spreadsheet is designed to record delivery order numbers, the month each order was placed, the quantity of gallons (G) of material picked up or delivered, and whether the adjustment threshold was met. The document provides a standardized format for monthly tracking with consistent adjustment percentages of 0.6 applied throughout the year.

The pricing mechanism utilizes the KAPI (Kentucky Asphalt Pavement Association Price Index) to calculate monthly adjustments based on the formula: Asphalt Adjustment Quantity = (G x 0.6)/240 x (PC - PL), where PL represents the KAPI for the month the contract was let and PC represents the KAPI for the month of adjustment. The spreadsheet includes a reference to the Kentucky Transportation Cabinet's Fuel and Asphalt Adjustments webpage for obtaining current KAPI values. The total asphalt adjustment quantity shown is $0.0000, indicating this is a blank template ready for data entry. This adjustment mechanism allows for automatic price modifications based on market fluctuations in asphalt pricing, protecting both the state and contractors from significant price volatility during the contract term.