15018 Form D2 - Pricing.xlsx

This is a pricing form for the City of Madison's Generator Service contract (15018-0-2026-BP), which outlines the cost structure for generator maintenance and support services across a five-year period from 2026 through 2030. The contract encompasses four service tiers based on generator capacity: Tier 1 (Small, 0-100 kW) with 16 units, Tier 2 (Mid, 101-250 kW) with 3 units, Tier 3 (Large, 251-500 kW) with 2 units, and Tier 4 (Heavy, 501+ kW) with 1 unit, plus Fire Station 01 with a 500 kW generator. The pricing form requires bidders to provide unit costs for three primary service categories: Oil Analysis (performed yearly), Load Testing & Major Preventive Maintenance (performed yearly and replacing one scheduled Basic PM service), and Basic Preventive Maintenance. Service requirements vary by year, with specific unit allocations for each tier and service type documented for 2026, 2027, 2028, 2029, and 2030. The form notes that Bartillon and Truax generators are excluded from 2026 service, with only basic PM scheduled that year.

Bidders must also provide pricing for ancillary services including Standard Service Calls (flat fee plus hourly rate for labor beyond the first hour), Emergency Service Calls (separate flat fee and hourly rate), Parts Markup (expressed as a fixed percentage over vendor invoice cost), and Diesel Fueling services (including fuel delivery/labor fee and fuel stabilizer/additive costs). All pricing cells in the form are currently blank with placeholder values of "$-0," indicating that bidders are required to complete these fields with actual pricing. The contract structure allows formulas to automatically calculate yearly subtotals and totals based on the unit quantities and single service costs provided by bidders.