TE A-23_Historical Data_Preventive Maintenance Schedule.xlsx

This is a technical exhibit containing historical preventive maintenance (PM) order data for U.S. Army Garrison (USAG) Stuttgart for fiscal years 2022, 2023, and 2024. The spreadsheet tracks preventive maintenance orders released by the Government, with three primary tabs: a detailed preventive maintenance log, a pivot table for workload analysis, and a 2024 scheduling overview.

The preventive maintenance data encompasses multiple service categories including HVAC system inspections, auxiliary generator load tests, transformer inspections, oil separator maintenance, main sewer pump operations, air heater system servicing, grease separator and hot water maintenance, sump pump inspections, septic tank inspections, lift station operations, and gutter cleaning. Maintenance frequency varies from daily to annual intervals, with monthly and bi-monthly services comprising the majority of work. Orders are categorized by trade type (HVAC Worker, General Maintenance Worker, Electrician, Generator Mechanic), funding source (OMA for non-housing, UPH for unaccompanied quarters, AFH for Army family housing, GFOQ for single family homes), and building/functional locations across the garrison. The Government creates and releases PMOs on the first of each month, with weekly PMOs generated every Monday. Completion timeliness for weekly orders is evaluated based on creation date, while all other orders are evaluated based on release date. Equipment records are being transitioned to include equipment numbers for all PMOs going forward, with the Government responsible for uploading remaining equipment data.