Parts_Market_Basket_12-9-24.xlsx

The file is a Parts Market Basket spreadsheet for the City of Tampa's Fleet Maintenance Division, detailing a comprehensive parts inventory and pricing opportunity. The document covers a market basket of vehicle parts for various makes and models, including multiple vehicle types such as Ford, Peterbilt, Freightliner, Pierce, and Dodge vehicles. The spreadsheet contains 53 line items representing different parts with historical usage quantities, ranging from brake components, tires, filters, and electrical parts to fluids and miscellaneous vehicle maintenance items.

The contract opportunity involves outsourcing vehicle and equipment parts supply and distribution for the City's Logistics & Asset Management Department, with the current contractor being Management Consulting Inc. (Mancon). The City currently spends approximately $8 million annually on parts, with Mancon managing about $1.5 million in stocked parts inventory. The project coincides with the Fleet Maintenance Division's decentralization from two outdated sites to five new state-of-the-art maintenance facilities in the first quarter of FY2024. The primary objectives include improving inventory management, increasing stock availability, reducing administrative overhead, and enhancing overall fleet efficiency. The market basket spreadsheet provides a template for vendors to propose their parts markup percentage, with the expectation that the successful proposer will effectively manage inventory across the new maintenance facility stockrooms.