CATERPILLAR_HISTORICAL_SPENDING.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
Authorized Caterpillar Service, Repair and OEM Parts
Solicitation number
2026-IFB-LM-0409
Issued by
Los Angeles County, California

About this file

This is a historical spending document related to the City of Pasadena Department of Public Works, Building Systems and Fleet Management Division's procurement of authorized Caterpillar equipment service, repair, maintenance, and Original Equipment Manufacturer (OEM) parts. The City is establishing a vendor contract for ongoing service needs to support its fleet of heavy-duty Caterpillar equipment, beginning in Fiscal Year 2027 and continuing for five years. Services will encompass preventative maintenance, diagnostics, repairs, and parts supply on an as-needed basis. The parts list identifies 15 specific Caterpillar components required, including fuel filters, oil filters, hydraulic filters, air filters, hydraulic hoses, door handles, and wheel rims, with estimated labor quantities derived from FY24-26 service invoices showing individual service events ranging from 8 to 40 labor hours.

Historical spending data demonstrates consistent procurement activity over the three-year period from 2023 to 2025, with a three-year average annual expenditure of $8,618.39 and cumulative spending of $25,855.18. Spending increased significantly from $244.09 in 2023 to $19,269.77 in 2025. The City has previously procured these services from multiple authorized Caterpillar dealers, including Rush Truck Centers of California Inc., Quinn Company, Harbor Diesel & Equipment Inc., and Los Angeles Truck Centers LLC. Six purchase orders totaling approximately $93,759.77 are documented across the three fiscal years, with all orders closed and fully expensed. The incumbent vendors have provided both parts and maintenance services through authorized Caterpillar channels.

View the file

Other files

Show all 14

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

QTY EXPLANATION

Estimated labor quantities were developed based on FY24-26 service invoices, which show individual service events ranging from 8-40 labor hours. Annual quantities were established to reflect a reasonable number of service occurrences.

PARTS LIST

PART NUMBERNAMEQTY
360-8958Ultra High Efficiency Fuel Filter1
479-4131Water Separator Element1
462-1171: Standard Efficiency Engine Oil Filter1
421-5481: Advanced Efficiency Hydraulic Filter1
222-9020: Primary Standard Efficiency Engine Air Filter1
365-7606: Cabin Air Filter1
353-5058: Element-Filter1
382-2374: Pushbutton Door Handle1
382-2375: Cab Door Handle Gasket1
252-1864: Cab Door Left Hand Rotary Latch1
193-8334: 1-14 Thread Quick Disconnect Male Nipple2
153-2994: 7/8" STOR Hydraulic Hoses Coupling2
241-8368: Switch Assembly1
606-3210: 13"x20" Wheel Rim1
571-6876: Water Tank Kit1

HISTORICAL SPENDING

Row LabelsSum of Expensed
2023$ 244.09
2024$ 6,341.32
2025$ 19,269.77
Grand Total$ 25,855.18
3YR AVG$ 8,618.39

Purchase Orders

PO NumberFiscal YearDescriptionStatusOpen AmountExpensedTotal AmountVendorVendor NameDepartment
12506502025OEM CATERPILLAR ENGINE PARTS, SUPPLIES/ACCESSORIESClosed$0.00$ 9,919.40$14,919.4014080RUSH TRUCK CENTERS OF CALIFORNIA INCPUBLIC WORKS DEPT - FLEET
12503102025AUTHORIZED CATERPILLAR MAINTENANCE & REPAIRClosed$0.00$ 9,350.37$18,850.3714080RUSH TRUCK CENTERS OF CALIFORNIA INCPUBLIC WORKS DEPT - FLEET
12416722024AUTHORIZED CATERPILLAR MAINTENANCE AND REPAIRClosed$0.00$ 1,290.00$24,995.00100037QUINN COMPANYPUBLIC WORKS DEPT - FLEET
12408892024OEM Caterpillar Parts, Supplies and AccessoriesClosed$0.00$ 2,981.39$24,995.0011519HARBOR DIESEL & EQUIPMENT INCPUBLIC WORKS DEPT - FLEET
12407652024OEM Caterpillar Loader Parts, Supplies & AccessoriClosed$0.00$ 2,069.93$5,000.008LOS ANGELES TRUCK CENTERS LLCPUBLIC WORKS DEPT - FLEET
12306732023CATERPILLAR LOADER PARTS AND SUPPLIESClosed$0.00$ 244.09$5,000.008LOS ANGELES TRUCK CENTERS LLCPUBLIC WORKS DEPT - FLEET

https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/purchaseordercentral/?Id=31968https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/vendorcentral/?Id=5338https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/purchaseordercentral/?Id=26325https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/vendorcentral/?Id=5338https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/vendorcentral/?Id=1013https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/purchaseordercentral/?Id=31610https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/vendorcentral/?Id=1013https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/purchaseordercentral/?Id=30668https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/vendorcentral/?Id=5110https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/purchaseordercentral/?Id=29649https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/vendorcentral/?Id=17521https://munisapp.cityofpasadena.net/prod/munis/munisnet/AppHost/purchaseordercentral/?Id=29521

File details come from the government source that posted it. Updated .