TE A-23_Historical Data - DMO_OWO.xlsx

This file contains historical maintenance and repair order data for USAG Stuttgart facilities during fiscal year 2022. The spreadsheet documents work orders closed during October 2021, capturing detailed information about base operations and maintenance activities across multiple facility types including family housing, administrative buildings, dining facilities, maintenance shops, and support structures. Each work order entry includes the order number, user status, work center designation, priority level, description of work performed, functional location, equipment details, actual release and completion dates, contract work type (primarily BASOPS DMO), funding source, total hours expended, and material costs incurred.

The data reflects the scope and nature of services required under the Base Operations USAG Stuttgart contract, encompassing preventative and on-demand maintenance performed by various skilled trades including plumbers, electricians, carpenters, HVAC workers, locksmiths, painters, and general maintenance workers. Work orders span routine repairs (fixture replacement, light bulb changes, lock repairs), emergency responses (no heat/hot water situations, flooding, electrical outages), and minor construction activities (door repairs, window replacements, blinds installation). The order data demonstrates a high volume of service requests processed monthly, with material costs ranging from minimal (under $10) to substantial ($30,000+) for major system replacements such as oil burners and boiler systems, providing baseline cost and labor metrics for evaluating contractor performance and resource requirements under the ongoing base operations support contract.