Addendum 1 2025 LRA Quantity Worksheet.xlsx

This is an Addendum 1 to a 2025 Local Resurfacing Agreement (LRA) Quantity Worksheet for a municipality's road maintenance and repair program. The addendum details estimated quantities for pavement work across numerous streets and roads within the jurisdiction. The scope of work includes patchwork, deep patching, asphalt application (both 12.5mm and 9.5mm), tack material, milling, manhole and water valve installations with risers, street striping, traffic loops, painted arrows and crosswalks, stop bars, railroad symbols, hatching, reflective paint markers (RPM), and grass shoulder clipping. The worksheet lists 128 individual street segments ranging from 0.01 to 0.54 miles in length, with total estimated quantities including 12,457.96 square yards of patchwork, 8,533.71 tons of asphalt (combined grades), 180 manhole installations, 142 manhole risers, 142 water valve installations, 6.10 miles of milling, and 467 linear feet of painted crosswalks, among other line items. All contract amounts, prices, and actual cost columns show zero values, indicating this is a quantity framework document prior to pricing.

The worksheet employs asphalt conversion factors of 0.0685 for 1.25" asphalt and 0.0825 for 1.5" asphalt to calculate tonnage from measured square yards. Street widths vary from 20 to 45 feet, with the majority between 22 and 30 feet. The document tracks estimated (E) and actual (A) quantities for each line item with corresponding columns for pricing and cost differentials. The total pavement area across all segments is 124,579.65 square yards. No pricing information, funding sources, incumbent contractor details, contract term, or award dates are included in this addendum, as it serves solely as a quantity estimation and tracking tool for the resurfacing work program.