DRFP Attachment 5_Historical Hours_14Jan2025.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- Dugway Proving Ground (DPG) West Desert Test Center (WDTC) Mission Support Services (MSS)
- Solicitation number
- W51EW725RA001
- Issued by
-
Department of the Army
About this file
This file is a historical hours spreadsheet showing regular and overtime hours worked across various labor categories from 2022-2024 for the Dugway Proving Ground West Desert Test Center Mission Support Services contract. The data covers 46 distinct labor categories ranging from administrative to technical roles, with Field Technician (129,787 regular hours), Property Clerk (97,289 regular hours), and Senior Mechanical Technician (82,091 regular hours) representing the highest volume positions over the three-year period.
The total regular hours worked decreased from 415,467 in 2022 to 243,078 in 2024 (partial year), while overtime hours declined from 31,231 in 2022 to 12,607 in 2024 (partial). The document notes that 2024 data excludes hours from December 14-31, with the final RFP to include complete calendar year 2024 data. This historical workload data appears to be provided as Attachment 5 to inform bidders' proposals for the follow-on DPG WDTC MSS contract solicitation W51EW725RA001.
View the file
Other files
Show all 19
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 .