PartsUsageHistory.xlsx

This is a parts usage history document associated with a four-year list-less purchasing agreement for Cummins engine parts issued by the Southwest Ohio Regional Transit Authority (SORTA). The document provides a comprehensive usage pivot table tracking historical consumption patterns for over 1,000 distinct Cummins parts used in the running repair and rebuild of internal combustion platforms, including engines that may be acquired during the contract term. The usage data spans multiple time periods, including year-to-date figures as of July 30, 2026, along with historical consumption data from the previous year, two years ago, and three years ago. The highest-demand items include hex flange head cap screws for exhaust manifolds (1,446 units year-to-date), valve tappets for ISL big bore engines (1,105 units), and crankcase breather filters (797 units), with consumption patterns indicating steady demand across various engine components and subsystems.

The detailed inventory listing tracks individual storeroom locations and last issue dates for each catalogued part, enabling SORTA to maintain visibility of parts availability and usage trends for procurement planning purposes. Many parts show consistent utilization across the four-year historical period, with certain high-wear items such as gaskets, seals, sensors, and fasteners demonstrating regular consumption. The data includes both standard replacement components and specialized subsystem kits, reflecting the comprehensive maintenance requirements for Cummins engine platforms. The file serves as the baseline demand forecast and parts specification reference that would inform the vendor's pricing, inventory commitment, and delivery performance requirements under the proposed purchasing agreement with SORTA.