TE A-23_Historical Data - BOM.xlsx

This is a historical bill of materials and work order data file containing detailed records of maintenance and repair activities completed across multiple facilities within USAG Stuttgart during fiscal year 2022. The spreadsheet documents over 1,000 individual work orders spanning from October 2021 through March 2022, capturing comprehensive information on preventative and corrective maintenance operations performed on Government housing, administrative buildings, and support facilities.

Each work order record includes the order number, release date, functional location identifier, facility description, detailed operation tasks, work center assignments, trade classifications (carpentry, plumbing, electrical, painting, cleaning, HVAC, locksmith services, and carpet/flooring work), activity codes, completion dates, and actual labor hours expended. The data reveals a systematic approach to managing facility maintenance with operations categorized by trade discipline, including routine cleaning operations (0501), specialized carpentry tasks for doors, windows, and cabinets (0171, 0182, 0168), plumbing services (0178), electrical work (0140), painting tasks (0170), locksmith services (0177), and carpet/flooring maintenance (0174). Labor hours typically range from under one hour for minor tasks to over 100 hours for comprehensive painting and facility preparation projects. The work orders are tracked against a WBS code (M.0090729.18.2.1 for AFH and M.0090729.12 for UPH designations) and funded through designated accounts, reflecting ongoing base operations and housing turnover maintenance requirements across the Stuttgart garrison.