TE 02 Workload History CY20.xlsx

42 KB Posted

Attached to
BASE OPERATION SUPPORT SERVICES (BASOPS) FOR YUMA PROVING GROUND (YPG)
Solicitation number
W5168W23R0004
Issued by

About this file

Written by GovTribe AI ·

This document contains a technical exhibit detailing workload history data for various facility maintenance shops from January to December 2020. It includes labor hours, material costs, and Purchased Maintenance Order details for each shop across multiple facility service lines. The largest volumes of work were in HVAC, plumbing, electrical, carpentry, facilities maintenance, pest management, and grounds maintenance. Total labor hours exceeded 90,000 across Detailed Maintenance Orders, Outside Work Orders, and PMO tasks. Material costs totaled over $1.6 million. This workload data is likely intended to support a contractor's capabilities statement or past performance submission for the Base Operation Support Services solicitation from the Department of the Army for Yuma Proving Ground.

View the file

Other files

File Type Posted
TE_02_Workload_History_CY20_Revised.xlsx XLSX spreadsheet
TE_02_Workload_History_CY22_Revised.xlsx XLSX spreadsheet
25JAN2024 YPG QandA-W5168W-23-R-0004.xlsx XLSX spreadsheet
W5168W23R0004_Amendment_0005.pdf PDF
Attachment Z- YUMA Proving Ground Solicitation QA-W5168W-23-R-0004- 05JAN2024-Final.xlsx XLSX spreadsheet
TE_51_Storm_Sewer_and_Drainage_Features-05JAN2024.pdf PDF
TE_02 _Workload_History_CY20_05JAN2024.xlsx XLSX spreadsheet
TE_41_Recurring_OWO_05JAN2024.xlsx XLSX spreadsheet
TE_0_Table_of_Contents-05JAN2024.xlsx XLSX spreadsheet
Attachment H - YUMA Annex J CLS 420 Facilities Maintenance Horizontal 05JAN2024.pdf PDF
YUMA Proving Ground Solicitation QA-W5168W-23-R-0004- 05JAN2024-Final.xlsx XLSX spreadsheet
W5168W-23-R-0004-Amendment3.pdf PDF
W5168W-23-R-0004-Amendment0002-1NOV2023.pdf PDF
YPG Question and Answer from Draft RFP W5168W 23 R 0004 15JUNE2023.xlsx XLSX spreadsheet
TE 31 Disposal of Hazardous Material Combined.pdf PDF
TE 43 Builder Inventory Guide.pdf PDF
TE 02 Workload History CY22.xlsx XLSX spreadsheet
TE 02 Workload History CY21 (1).xlsx XLSX spreadsheet
TE 33 Uninterrupted Power Supply.xlsx XLSX spreadsheet
TE 32 Heavy Equipment List.xlsx XLSX spreadsheet
TE 09 - ICE Monthly Visible Emissions Checklist.xlsx XLSX spreadsheet
TE 21 GSA Fleet Vehicles.xlsx XLSX spreadsheet
TE 10.1 - Boiler Tune-Up Form.xlsx XLSX spreadsheet
TE 08 - ICE Maintenance CK List.xlsx XLSX spreadsheet
TE 04 - Contractor Occupied Facilities.xlsx XLSX spreadsheet
TE 49 ARC Equipment and Containers.xlsx XLSX spreadsheet
TE 37 PWO-IJO History.xlsx XLSX spreadsheet
Attachment M - Collective Bargaining Agreement 2021.2024 fully executed 8.10.2021.pdf PDF
Attachment N - Davis-Bacon Heavy.pdf PDF
Attachment P - Davis-Bacon Highway.pdf PDF
Attachment O - Davis-Bacon Building.pdf PDF
Attachment G - YUMA Annex H CLS 411 Facilities Maintenance Vertical 11-23-21.docx DOCX document
Attachment W - YPG Site Visit Question and Answer W5168W-23-R-0004-15JUNE2023.xlsx XLSX spreadsheet
Attachment I - YUMA Annex M CLS 510 Pest Management 11-23-21.docx DOCX document
TE 46 Builder Component Catalog.pdf PDF
TE 01 Real Property Inventory.xlsx XLSX spreadsheet
TE 36 Excavation Permit Form.pdf PDF
TE 15 Grounds Inventory.xlsx XLSX spreadsheet
TE 35 Pavement Sweeping Areas.xlsx XLSX spreadsheet
TE 14 - Ground Water Wells.xlsx XLSX spreadsheet
TE 30 Wash Racks.xlsx XLSX spreadsheet
TE 42 Incidental Property.xlsx XLSX spreadsheet
TE 0 Table of Contents.xlsx XLSX spreadsheet
TE 39 PWO Format.xlsx XLSX spreadsheet
TE 40 GFEBS Transaction Codes.xlsx XLSX spreadsheet
TE 38 Preventative Maintenance Checklist.xlsx XLSX spreadsheet
Attachment I3 - Government Furnished Property Provided Under FAR Clause 52.245-2.xlsx XLSX spreadsheet
Attachment Q - Davis-Bacon Residential.pdf PDF
Attachment F - YUMA Annex G CLS 408 Sand Removal 11-23-21.docx DOCX document
Attachment K - Staffing Matrix.xlsx XLSX spreadsheet
Show 40 more

50 files listed here. See the rest on GovTribe.

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

2020 # of Orders

Technical Exhibit 2
Workload History
COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2020 to 12.31.2020
SHOP CODESCLS CODES
CLS 200SHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009H1002HVAC200QHFMUEPH
Number of Servies'sA001A001A001A001A001A001A001A001J1003PLMB400QDEHFACILITIES ENGINEERING SVCS MGMT
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTALK1004ELEC404QMUNGROUNDS MAINTENANCE
SDO Call Outs/After Hours320000005X1005H VOLT408QMUNSAND, SNOW, ICE REMOVAL
Priority #1530000008M1006CARP411QRPAFACILITIES MAINT. VERTICAL
Priority #2230000005P1007PEST417MEDICAL AND HOSPITAL
Priority #38201602000064R1008GRND420QRPAFACILITIES MAINT. HORIZONTAL
TOTAL18281602000082V1009H EQUPT510QMUNPEST MANAGEMENT
T1010HOUSING
A002A002A002A002A002A002A002A002V1009H EQUPT
PMO's16712807000194T1010HOUSING
CLS 400SHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
Number of ServicesA004A004A004A004A004A004A004A004
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
SDO Call Outs/After Hours11
Priority #12818123364
Priority #212326124
Priority #311147136174561134785
TOTAL15148147204852174874
A004A004A004A004A004A004A004A004
OWO/SJO11122536152487624
CLS 404SHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
Number of ServicesA004A004A004A004A004A004A004A004
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
A004A004A004A004A004A004A004A004
OWO/SJO--2--736610385
CLS 408SHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
Number of ServicesA004A004A004A004A004A004A004A004
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
OWO/SJO000000000
CLS 411A001A001A001A001A001A001A001A001
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours214109301048
Priority #1200621241454200456
Priority #2574776818002208
Priority #3425561781516172852,450
TOTAL703674991826924903,162
A002A002A002A002A002A002A002A002
PMO's3,7652,3311,5481,0380001,1719,853
CLS 417A001A001A001A001A001A001A001A001
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours100000001
Priority #1200000002
Priority #2001000001
Priority #34210600013
TOTAL7220600017
A002A002A002A002A002A002A002A002
PMO's506120200070
CLS 420A001A001A001A001A001A001A001A001
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours000000000
Priority #1000010001
Priority #2000000000
Priority #312103708453
TOTAL12103808454
A002A002A002A002A002A002A002A002
PMO's0000000205205
CLS 510
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
SDO Call Outs/After Hours33
Priority #1166166
Priority #222
Priority #3226226
TOTAL0000039700397
A002A002A002A002A002A002A002A002
PMO's0000023000230
TOTAL NUMBER OF SERVICESSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
Number of Servies'sA001A001A001A001A001A001A001A001
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours256109341058
Priority #123566132157816830697
Priority #27150801024212240
Priority #3549632935681,13622929133,591
TOTAL8807541,1571021,24140334154,586
A004A004A004A004A004A004A004A004
OWO/SJO11122703684184971,009
A002A002A002A002A002A002A002A002
PMO's3,9822,3491,5681,0389001,37610,322

15,917

DMO's OWO's -HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2020 to 12.31.2020
DMO's & OWO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
LABOR HOURSA001 & A004A001 & A004A001 & A004A001 & A004A001 & A004A001 & A004A001 & A004A001 & A004# OF ORDERS
DMO/OWODMO/OWODMO/OWODMO/OWODMO/OWODMO/OWODMO/OWODMO/OWOTOTAL
CLS 20010615986-111---462
CLS 400954408108224926881170775629
CLS 404--------0
CLS 408--------0
CLS 41149754784577986945153642021010
CLS 41747114-13---74
CLS 42084713-271-7840457
CLS 510-----737--737
TOTAL60905409696311177598431213727631
DMO's & OWO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
MATERIAL COSTA001 & A004A001 & A004A001 & A004A001 & A004A001 & A004A001 & A004A001 & A004A001 & A004# OF ORDERS
DMO/OWODMO/OWODMO/OWODMO/OWODMO/OWODMO/OWODMO/OWODMO/OWOTOTAL
CLS 200$692$1,925$475-$857---$3,949
CLS 400$23,754$4,775$21,627$223$36,344$0$263$0$86,984
CLS 404--------$0
CLS 408--------$0
CLS 411$198,324$105,457$146,806$30,471$46,597$0$671$0$528,326
CLS 417$1,070$194$22-$15---$1,300
CLS 420$0$387$0-$1,570-$732$0$2,689
CLS 510-----5240--$5,240
TOTAL$223,840$112,737$168,929$30,694$85,383$0$1,666$0$623,249

OWO's HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2020 to 12.31.2020
DMO's & OWO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
LABOR HOURSA004A004A004A004A004A004A004A004TOTAL HOURS
OWOOWOOWOOWOOWOOWOOWOOWOTOTAL
CLS 4002642221392-2591416941221718383
CLS 404--20--161129626613208
CLS 408--------0
CLS 510-----1204--1204
TOTAL2642221412025911369146561228332796
DMO's & OWO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
MATERIAL COSTA004A004A004A004A004A004A004A004TOTAL MATERIAL
OWOOWOOWOOWOOWOOWOOWOOWOTOTAL
CLS 400$0.00$1,006.96$0.00-$4,753.88$10.59$8,672.14$133.26$14,576.83
CLS 404--$0.00--$0.00$10,486.72$0.00$10,486.72
CLS 408--------$0.00
CLS 510-----$3,421.50--$3,421.50
TOTAL$0.00$1,006.96$0.00$0.00$4,753.88$3,432.09$19,158.86$133.26$28,485.05

PMO's HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2020 to 12.31.2020
PMO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
LABOR HOURSA002A002A002A002A002A002A002A002LABOR
PMOPMOPMOPMOPMOPMOPMOPMOTOTAL
CLS 200357.914.57-5.3---385
CLS 4115,8893,5573,8143,5141,215---17,989
CLS 417183915-2---209
CLS 420-------6,1386,138
TOTAL6,4303,5803,8363,5141,222006,13824,721
PMO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
MATERIAL COSTA002A002A002A002A002A002A002A002MATERIALS
PMOPMOPMOPMOPMOPMOPMOPMOTOTAL
CLS 200$3,044.23$0.00$0.00-$0.00---$3,044.23
CLS 411$29,740.48$5,648.54$7,006.37$0.00$124.20---$42,519.59
CLS 417$297.91$0.00$0.00-$0.00---$297.91
CLS 420-------$0.00$0.00
TOTAL$33,082.62$0.00$7,006.37$0.00$124.20$0.00$0.00$0.00$45,861.73

File details come from the government source that posted it. Updated .