Attachment_F-Budget_Template.xlsx

The file is a budget template Excel spreadsheet for Fleet Maintenance Services involving the City of Pittsburgh and the Pittsburgh Water and Sewer Authority (PWSA). The document outlines target cost budgets and non-target cost hourly rates for fleet maintenance services from 2024-2033, with historical budget data from 2017-2021. The contract solicits proposals for comprehensive fleet management and maintenance services aimed at reducing fleet downtime and costs while increasing vehicle reliability and protecting the city's fleet investment.

The budget template provides a structured framework for pricing fleet maintenance services, with line items including wages and salaries, fringe benefits, parts and supplies, subcontractor services, overhead, capital expenditures, and other miscellaneous costs. The hourly rates section details technician compensation for base, overtime, and holiday work. While specific budget amounts are not populated in the template, the document suggests a comprehensive approach to budgeting that allows for detailed financial planning and tracking of fleet maintenance expenses across multiple years. The contract appears to be structured to provide flexibility in cost management while maintaining transparency in service delivery.