Attachment 5_Historical Data_Apr 2021-Mar 2025.xlsx

This is a historical workload data spreadsheet documenting labor hours from April 2021 through March 2025 for Base Test Support Services at Fort Hood and Fort Bragg (Airborne). The data aggregates straight-time (ST) and overtime (OT) hours across four contract years for 47 distinct labor categories, ranging from administrative positions such as Accounting Clerk III and General Clerk positions to skilled trades including Automotive Mechanics, Electricians, and HVAC Mechanics, as well as specialized technical roles like Computer Operators, Electronics Technicians, and Software Engineers. The total four-year workload encompasses 815,648.6 straight-time hours and 60,523.3 overtime hours, with year-over-year variations reflecting operational demands, including a notably higher Computer Operator I requirement (272,001.5 total hours across four years) and significant General Clerk II utilization (63,574.8 hours in Year 3 alone).

The data demonstrates fluctuating labor requirements across the performance period, with Year 1 totaling 219,571.5 hours, Year 2 at 218,107.9 hours, Year 3 at 181,686.8 hours, and Year 4 at 196,282.4 hours. Overtime hours increased substantially in Years 3 and 4, suggesting increased operational intensity or scheduling demands. This historical baseline serves as a reference for the follow-on Base Test Support Services contract (W51EW726RA004) with the U.S. Army Operational Evaluation Command, informing the government's labor cost estimates and resource planning for future competitive procurement.