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

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 HoursOvertime (OT) Hours
Labor Category202220232024*TotalLabor Category202220232024*Total
Administrative Assistant11,8686,4705,82924,166Administrative Assistant - OT6842597
Air Monitoring Technician-1,5481,8113,359Air Monitoring Technician - OT-7457131
Assistant Scientist I9,3394,0983,74617,183Assistant Scientist I - OT5552482541,057
Assistant Scientist II4,7161,440736,229Assistant Scientist II - OT--99
Associate Scientist I3,1054,7682,38310,255Associate Scientist I - OT8028170431
Associate Scientist II3,9713,4212,87510,266Associate Scientist II - OT358317186860
Business Manager2--2Chemist I - OT1,1346958622,690
Chemist I18,45610,82816,79346,077Chemist II - OT9723682331,573
Chemist II6,1342,9823,33512,451Drafter - OT2681246
Drafter2,9471,7611,6926,399Electronic Technician - OT70--70
Electronic Technician2,9411,7201,1175,778Explosive Handler - OT-96-96
Explosive Handler1580-95Facilities Project Manager - OT80951140
Facilities Project Manager3,9202,3693,76510,054Facility Security Officer - OT63--63
Facility Security Officer702802651,046Field Technician - OT5,1243,3992,69211,215
Field Technician60,85935,71233,217129,787Flight Operations/Aviation Tec - OT4132543741,041
Flight Operations/Aviation Tec5,3823,2593,26811,909GIS Technician - OT14--14
GIS Technician2,1422302252,597Heavy Duty Equipment Operator - OT4943603911,245
Heavy Duty Equipment Operator8,3124,9815,45118,743Junior Project Manager - OT1,1162641241,504
HVAC Technician3,0671,7661,6386,471Laboratory Analyst I - OT8087174011,926
Junior Project Manager8,4893,3253,86515,679Laboratory Analyst II - OT2184021279
Laboratory Analyst I26,27917,21511,12554,618Laboratory Technician I - OT9634274971,887
Laboratory Analyst II9,5277,8378,79526,158Laboratory Technician II - OT1,7284461472,321
Laboratory Technician I10,9313,3074,39218,630Master Mechanical Technician - OT86350161597
Laboratory Technician II6,7691,6841,0199,472Mechanical Technician - OT1,5098581562,523
Master Mechanical Technician6323,0843,6277,343Photographer - OT25112197334
Mechanical Technician11,8585,2921,95319,103POL/Hazardous Waste Technician - OT22240169431
NULL4021153Principle Engineer - OT--88
Photographer5,3053,6763,63712,618Project Manager - BTD - OT188--188
POL/Hazardous Waste Technician2,9243191,8575,100Project Manager - CTD - OT4--4
Principle Engineer2,9251,6681,7496,342Project Manager - SPD - OT34--34
Program Manager621-27Project Scientist I - OT51324014767
Project Manager8,9366,4205,43320,788Project Scientist II - OT--77
Project Manager - BTD1,792--1,792Project Scientist III - OT--99
Project Manager - CTD2,8701,1721,8065,848Property Clerk - OT1,712219601,991
Project Manager - OT3,0761,2941,0555,425Range Controller - OT-23-23
Project Manager - SPD772--772SAC / ASSO - OT1691-170
Project Scientist I7,0794,5153,70715,300Safety Officer - OT31-2152
Project Scientist II--535535Senior Electronic Technician - OT3105710377
Project Scientist III--549549Senior Mechanical Technician - OT7,3242,54591710,786
Property Clerk55,99433,8147,48297,289Senior Test Manager - OT1,5526394382,629
Range Controller-92720947Supply Technician - OT-23323346
SAC / ASSO2,4641,7981,7746,035Test Manager - OT2,8521,4889465,285
Safety Officer2,7171,8221,1725,710Test MINICAMS Operator - OT-32118150
Scientific Programmer5231139Training Coordinator - OT4194492,6233,491
Senior Administrative Associat3371151Training Coordinator II - OT--2828
Senior Business Manager-4-4Total31,23115,08112,60758,918
Senior Electronic Technician13,7055,9145,65125,270
Senior Mechanical Technician44,95720,14416,99082,091
Senior Test Manager18,3799,60410,74738,730
Supply Technician-6,20635,14441,349
Test Manager16,4609,79912,68838,947
Test MINICAMS Operator301,4851,5773,091
Training Coordinator2,6729307,14310,745
Training Coordinator II--8080
Total415,467240,844243,078899,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 .