25-273 - BID WORKSHEET.XLSX

This document is a Bid Worksheet for the City of Naperville, Illinois, detailing a solicitation for medium-heavy duty truck and off-road equipment repairs. The City is seeking qualified service vendors to provide comprehensive repair services for its fleet, which consists of approximately 110 medium and heavy-duty trucks and 35 pieces of off-road equipment/vehicles. The bid is structured into two primary categories: Category 1 focuses on medium to heavy-duty truck repairs, and Category 2 covers off-road equipment repairs. The worksheet includes provisions for regular and after-hours labor rates, with estimated annual hours for each category, though the actual hourly rates are currently listed as $0.00.

The bid worksheet outlines estimated material markup costs, with Category 1 having an annual parts spend of $26,000 and Category 2 having an annual parts spend of $15,000. These amounts are based on historical spend analysis and are explicitly noted as estimated quantities for bid award purposes, not guaranteed service amounts. The document indicates that vendors will be evaluated on their years of experience servicing commercial, industrial, government, or large corporate user accounts. The total base bid for Category 1 is $26,000.00, and for Category 2 is $15,000.00, with a combined potential contract value of $41,000.00 annually. The bid worksheet provides a template for vendors to submit their pricing and markup details for potential contract award.