Asphalt Adjustment Calculator Spreadsheet 2019.xlsx

This is an asphalt adjustment calculator spreadsheet for Liquid Asphalt Master Agreements administered by the Kentucky Transportation Cabinet, effective March 1, 2019. The spreadsheet provides a monthly tracking mechanism for liquid asphalt deliveries and associated price adjustments throughout a contract year. Users input delivery order information, including the number of gallons picked up or delivered, and the spreadsheet calculates adjustment percentages based on monthly Kansas Asphalt Pavement Association (KAPI) pricing indices. The template tracks deliveries across all twelve months and includes a threshold indicator to identify when adjustment conditions are met.

The asphalt adjustment quantity is calculated using the formula: (G × 0.6)/240 × (PC - PL), where G represents gallons of material, PL represents the KAPI index for the month the contract was let, and PC represents the KAPI index for the month of adjustment. A baseline adjustment percentage of 0.6 percent is applied across all months, with the actual dollar adjustment determined by comparing current month KAPI values to the baseline contract month KAPI values. The spreadsheet references the Kentucky Transportation Cabinet's Fuel and Asphalt Adjustments webpage for obtaining current PC (KAPI) values, enabling contractors to calculate real-time price adjustments tied to market conditions.