RFP_Attachment 5_Historical Hours_21Feb2025.xlsx
XLSX spreadsheet 20 KB Posted
- Solicitation number
- W51EW725RA001
- Issued by
-
Department of the Army
About this file
The file is an Excel spreadsheet (RFP_Attachment 5_Historical Hours_21Feb2025.xlsx) containing historical labor hours data for the West Desert Test Center (WDTC) Mission Support Services (MSS) contract. The spreadsheet provides a detailed breakdown of regular and overtime hours for 48 distinct labor categories from 2022-2024, with total hours tracked at 899,389. The most significant labor categories by total hours include Field Technician (129,787 hours), Laboratory Analyst I (54,618 hours), Chemist I (46,077 hours), and Property Clerk (97,289 hours).
The data appears to support the Department of the Army's solicitation (W51EW725RA001) for a follow-on Mission Support Services contract at the West Desert Test Center. The historical hours document offers potential offerors insight into the anticipated workforce composition and labor hour requirements across scientific, technical, administrative, and operational roles. The spreadsheet notes that 2024 data excludes hours from December 14-31, with a final RFP expected to include complete calendar year 2024 data, suggesting this is a preparatory document for an upcoming contract procurement.
View the file
Other files
Show all 34
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
MSS Historical - Regular & OT
| Regular Hours | Overtime (OT) Hours | ||||||||
| Labor Category | 2022 | 2023 | 2024* | Total | Labor Category | 2022 | 2023 | 2024* | Total |
| Administrative Assistant | 11,868 | 6,470 | 5,829 | 24,166 | Administrative Assistant - OT | 68 | 4 | 25 | 97 |
| Air Monitoring Technician | - | 1,548 | 1,811 | 3,359 | Air Monitoring Technician - OT | - | 74 | 57 | 131 |
| Assistant Scientist I | 9,339 | 4,098 | 3,746 | 17,183 | Assistant Scientist I - OT | 555 | 248 | 254 | 1,057 |
| Assistant Scientist II | 4,716 | 1,440 | 73 | 6,229 | Assistant Scientist II - OT | - | - | 9 | 9 |
| Associate Scientist I | 3,105 | 4,768 | 2,383 | 10,255 | Associate Scientist I - OT | 80 | 281 | 70 | 431 |
| Associate Scientist II | 3,971 | 3,421 | 2,875 | 10,266 | Associate Scientist II - OT | 358 | 317 | 186 | 860 |
| Business Manager | 2 | - | - | 2 | Chemist I - OT | 1,134 | 695 | 862 | 2,690 |
| Chemist I | 18,456 | 10,828 | 16,793 | 46,077 | Chemist II - OT | 972 | 368 | 233 | 1,573 |
| Chemist II | 6,134 | 2,982 | 3,335 | 12,451 | Drafter - OT | 26 | 8 | 12 | 46 |
| Drafter | 2,947 | 1,761 | 1,692 | 6,399 | Electronic Technician - OT | 70 | - | - | 70 |
| Electronic Technician | 2,941 | 1,720 | 1,117 | 5,778 | Explosive Handler - OT | - | 96 | - | 96 |
| Explosive Handler | 15 | 80 | - | 95 | Facilities Project Manager - OT | 80 | 9 | 51 | 140 |
| Facilities Project Manager | 3,920 | 2,369 | 3,765 | 10,054 | Facility Security Officer - OT | 63 | - | - | 63 |
| Facility Security Officer | 702 | 80 | 265 | 1,046 | Field Technician - OT | 5,124 | 3,399 | 2,692 | 11,215 |
| Field Technician | 60,859 | 35,712 | 33,217 | 129,787 | Flight Operations/Aviation Tec - OT | 413 | 254 | 374 | 1,041 |
| Flight Operations/Aviation Tec | 5,382 | 3,259 | 3,268 | 11,909 | GIS Technician - OT | 14 | - | - | 14 |
| GIS Technician | 2,142 | 230 | 225 | 2,597 | Heavy Duty Equipment Operator - OT | 494 | 360 | 391 | 1,245 |
| Heavy Duty Equipment Operator | 8,312 | 4,981 | 5,451 | 18,743 | Junior Project Manager - OT | 1,116 | 264 | 124 | 1,504 |
| HVAC Technician | 3,067 | 1,766 | 1,638 | 6,471 | Laboratory Analyst I - OT | 808 | 717 | 401 | 1,926 |
| Junior Project Manager | 8,489 | 3,325 | 3,865 | 15,679 | Laboratory Analyst II - OT | 218 | 40 | 21 | 279 |
| Laboratory Analyst I | 26,279 | 17,215 | 11,125 | 54,618 | Laboratory Technician I - OT | 963 | 427 | 497 | 1,887 |
| Laboratory Analyst II | 9,527 | 7,837 | 8,795 | 26,158 | Laboratory Technician II - OT | 1,728 | 446 | 147 | 2,321 |
| Laboratory Technician I | 10,931 | 3,307 | 4,392 | 18,630 | Master Mechanical Technician - OT | 86 | 350 | 161 | 597 |
| Laboratory Technician II | 6,769 | 1,684 | 1,019 | 9,472 | Mechanical Technician - OT | 1,509 | 858 | 156 | 2,523 |
| Master Mechanical Technician | 632 | 3,084 | 3,627 | 7,343 | Photographer - OT | 25 | 112 | 197 | 334 |
| Mechanical Technician | 11,858 | 5,292 | 1,953 | 19,103 | POL/Hazardous Waste Technician - OT | 222 | 40 | 169 | 431 |
| NULL | 40 | 2 | 11 | 53 | Principle Engineer - OT | - | - | 8 | 8 |
| Photographer | 5,305 | 3,676 | 3,637 | 12,618 | Project Manager - BTD - OT | 188 | - | - | 188 |
| POL/Hazardous Waste Technician | 2,924 | 319 | 1,857 | 5,100 | Project Manager - CTD - OT | 4 | - | - | 4 |
| Principle Engineer | 2,925 | 1,668 | 1,749 | 6,342 | Project Manager - SPD - OT | 34 | - | - | 34 |
| Program Manager | 6 | 21 | - | 27 | Project Scientist I - OT | 513 | 240 | 14 | 767 |
| Project Manager | 8,936 | 6,420 | 5,433 | 20,788 | Project Scientist II - OT | - | - | 7 | 7 |
| Project Manager - BTD | 1,792 | - | - | 1,792 | Project Scientist III - OT | - | - | 9 | 9 |
| Project Manager - CTD | 2,870 | 1,172 | 1,806 | 5,848 | Property Clerk - OT | 1,712 | 219 | 60 | 1,991 |
| Project Manager - OT | 3,076 | 1,294 | 1,055 | 5,425 | Range Controller - OT | - | 23 | - | 23 |
| Project Manager - SPD | 772 | - | - | 772 | SAC / ASSO - OT | 169 | 1 | - | 170 |
| Project Scientist I | 7,079 | 4,515 | 3,707 | 15,300 | Safety Officer - OT | 31 | - | 21 | 52 |
| Project Scientist II | - | - | 535 | 535 | Senior Electronic Technician - OT | 310 | 57 | 10 | 377 |
| Project Scientist III | - | - | 549 | 549 | Senior Mechanical Technician - OT | 7,324 | 2,545 | 917 | 10,786 |
| Property Clerk | 55,994 | 33,814 | 7,482 | 97,289 | Senior Test Manager - OT | 1,552 | 639 | 438 | 2,629 |
| Range Controller | - | 927 | 20 | 947 | Supply Technician - OT | - | 23 | 323 | 346 |
| SAC / ASSO | 2,464 | 1,798 | 1,774 | 6,035 | Test Manager - OT | 2,852 | 1,488 | 946 | 5,285 |
| Safety Officer | 2,717 | 1,822 | 1,172 | 5,710 | Test MINICAMS Operator - OT | - | 32 | 118 | 150 |
| Scientific Programmer | 5 | 23 | 11 | 39 | Training Coordinator - OT | 419 | 449 | 2,623 | 3,491 |
| Senior Administrative Associat | 3 | 37 | 11 | 51 | Training Coordinator II - OT | - | - | 28 | 28 |
| Senior Business Manager | - | 4 | - | 4 | Total | 31,231 | 15,081 | 12,607 | 58,918 |
| Senior Electronic Technician | 13,705 | 5,914 | 5,651 | 25,270 | |||||
| Senior Mechanical Technician | 44,957 | 20,144 | 16,990 | 82,091 | |||||
| Senior Test Manager | 18,379 | 9,604 | 10,747 | 38,730 | |||||
| Supply Technician | - | 6,206 | 35,144 | 41,349 | |||||
| Test Manager | 16,460 | 9,799 | 12,688 | 38,947 | |||||
| Test MINICAMS Operator | 30 | 1,485 | 1,577 | 3,091 | |||||
| Training Coordinator | 2,672 | 930 | 7,143 | 10,745 | |||||
| Training Coordinator II | - | - | 80 | 80 | |||||
| Total | 415,467 | 240,844 | 243,078 | 899,389 | |||||
| *Excludes hours from 14-31 December 2024. Final RFP shall include complete calendar year 2024 data |
File details come from the government source that posted it. Updated .