Asphalt Adjustment 2021 - Liquid Asphalt.xlsx

This is a liquid asphalt pricing adjustment spreadsheet for Kentucky state contracts, specifically documenting asphalt adjustment mechanisms for Master Agreements effective March 1, 2021. The document outlines a monthly tracking system for liquid asphalt deliveries, with adjustment calculations applied across a twelve-month period from January through December. The spreadsheet is designed to accommodate delivery order numbers, monthly placement records, and gallons of material picked up or delivered, with a standard adjustment factor of 0.6 applied uniformly across all months.

Pricing adjustments are calculated using the formula: Asphalt Adjustment Quantity = (G × 0.6)/240 × (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. The adjustment mechanism includes a threshold requirement that must be met before adjustments are triggered. Contractors can access current PC (KAPI) values through the Kentucky Transportation Cabinet's Fuel and Asphalt Adjustments webpage. The spreadsheet provides a total asphalt adjustment quantity field showing $0.0000, indicating that no adjustment was warranted during this period. This pricing structure allows for monthly fluctuations in asphalt costs to be reflected in contract payments while maintaining price stability through indexed adjustment mechanisms.