Attachment 5_Historical Data_Apr 2021-Mar 2025_03Mar2026.xlsx

This is a historical workload data spreadsheet documenting labor hours for Base Test Support Services (BTSS) at Fort Hood and Fort Bragg (Airborne) from April 2021 through March 2025. The data captures actual work performance across four contract years, broken down by position classification and separated into straight-time (ST) and overtime (OT) hours.

The spreadsheet details staffing requirements across 43 distinct position categories, ranging from administrative roles such as Accounting Clerk III and General Clerk positions to technical positions including Computer Operators (Levels I-III), Electronics Technicians, and Software Engineers, as well as maintenance and logistics roles such as Automotive Mechanics, HVAC Mechanics, Electricians, and Warehouse Specialists. Total labor hours across the four-year period reached 815,648.6 straight-time hours and 60,523.3 overtime hours, for a combined total of 876,171.9 hours. Year-over-year workload demonstrates variability, with Year 1 at 219,571.5 total hours, Year 2 at 218,107.9 hours, Year 3 at 181,686.8 hours, and Year 4 at 196,282.4 hours. Computer Operator I represents the highest volume position with 272,001.5 total hours across the four years, while positions such as Carpenter and Plumber represent minimal resource utilization. This historical data serves as the baseline for estimating resource requirements and labor costs for the follow-on BTSS contract to support the Operational Evaluation Command's mission.