TE 02 Workload History CY22.xlsx

XLSX spreadsheet 40 KB Posted

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

About this file

This document contains a workload history report for various facility maintenance shops at Yuma Proving Ground for calendar year 2022. It provides details on the number of work orders completed between January 1st and December 31st 2022 across multiple service lines including HVAC, plumbing, electrical, carpentry, pest management, grounds maintenance, sand removal and facilities maintenance. For each shop code, it lists the total number of direct mission orders, operation work orders, preventative maintenance orders and after hours calls completed. It also includes the total labor hours and material costs for DMOs, OWOs and PMOs by service line.

The related federal contract opportunity is a solicitation for base operation support services at Yuma Proving Ground. Solicitation number W5168W23R0004 was issued by the Department of the Army for base operation support services to be provided at Yuma Proving Ground. The document provides workload history data that would be relevant for offerors to understand the scope and volume of services required under the contract.

View the file

Other files

File Type Posted
Attachment K - Staffing Matrix-27DEC2023-W5168W-23-R-0004-YPG.xlsx XLSX spreadsheet
TE_50_Landfill_Permit-05JAN2024.pdf PDF
TE_15_Grounds_Inventory_05JAN2024.xlsx XLSX spreadsheet
Attachment G - YUMA Annex H CLS 411 Facilities Maintenance Vertical-04JAN2024.pdf PDF
Attachment V-W5168W-23-R-0004-YPG-ServiceContract-WageDetermination.pdf PDF
Attachment_Q_Davis_Bacon_Residential_29NOV2023.pdf PDF
Attachment D - YUMA Annex E CLS 403 Waste Management 05JAN2024.pdf PDF
Attachment F - YUMA Annex G CLS 408 Sand Removal 05JAN2024.pdf PDF
Attachment J- Yuma Pricing Matrix CLIN Structure-W5168W-23-R-0004-4JAN2024.xlsx XLSX spreadsheet
YUMA Proving Ground Solicitation QA-W5168W-23-R-0004- 05JAN2024-Final.xlsx XLSX spreadsheet
W5168W-23-R-0004-Amendment0002-1NOV2023.pdf PDF
YPG Question and Answer from Draft RFP W5168W 23 R 0004 15JUNE2023.xlsx XLSX spreadsheet
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 02 Workload History CY20.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
TE 28 Spill Prevention Control and Countermeasures Plan.pdf PDF
TE 24 Septic Tank and locations.xlsx XLSX spreadsheet
TE 31 Disposal of Hazardous Material Combined.pdf PDF
TE 43 Builder Inventory Guide.pdf PDF
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
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

Text version

2022 # of Orders

Technical Exhibit 2
Workload History
COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2022 to 12.31.2022
SHOP CODES
CLS 200 - UEPHSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009SHOP (T) 1010H1002HVAC
Number of Services'sA001A001A001A001A001A001A001A001A004J1003PLMB
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOHOURSTOTALK1004ELEC
SDO Call Outs/After Hours0000000000X1005H VOLT
Priority #10000000000M1006CARP
Priority #20000000000P1007PEST
Priority #30000000000R1008GRND
OWO/SJO00000000365365V1009H EQUPT
TOTAL000000000365T1010HOUSING
CLS 404 - GROUNDS MAINTENANCESHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
Number of ServicesA004A004A004A004A004A004A004A004
OWOOWOOWOOWOOWOOWOOWOOWOTOTAL
OWO/SJO0012006001604
CLS 408 - SAND REMOVALSHOP (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/SJO00000010010
CLS 411 - FACILITIES MAINT. VERTICALA001A001A001A001A001A001A001A001
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 Hours1622915300065
Priority #134015411261106000773
Priority #23910871238000258
Priority #34186268864483004142,822
TOTAL8139101,07812297701603,918
A002A002A002A002A002A002A002A002
PMO's4,4032,4672,0701,1461,26300311,352
CLS 420 - FACILITIES MAINT. HORIZONTALA001A001A001A001A001A001A001A001
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 #100101200013
Priority #2000010001
Priority #310113806047
TOTAL10215106061
A002A002A002A002A002A002A002A002
PMO's0000000365365
CLS 510 - PEST MANAGEMENTA004A004A004A004A004A004A004A004
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 Hours000000000
Priority #100000920092
Priority #2000002002
Priority #30000022000220
TOTAL0000031400314
A004A004A004A004A004A004A004A004
OWO's0000026600266
TOTAL NUMBER OF SERVICESSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
DMO/SO'sA001A001A001A001A001A001A001A001
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours1622915300065
Priority #1340154113611189200878
Priority #23910871239200261
Priority #34196268874586822010143,089
TOTAL8149101,0801231,02831410144,293
A004A004A004A004A004A004A004A004
OWO/SJO001202666101880
A002A002A002A002A002A002A002A002
PMO's4,4032,4672,0701,1461,2630036811,717

DMO's - HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2022 to 12.31.2022
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
DMODMODMODMODMODMODMODMOTOTAL
CLS 411 - FACILITIES MAINT. VERTICAL625257896416114670420475826748
CLS 420 - FACILITIES MAINT. HORIZONTAL680825910550723
TOTAL6320578964231148763301025827472
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 411 - FACILITIES MAINT. VERTICAL$373,059.63$175,497.05$221,668.16$20,188.95$165,135.75$0.00$6.58$0.00$955,556.12
CLS 420 - FACILITIES MAINT. HORIZONTAL$0.00$0.00$0.00$0.00$7,511.72$0.00$2,345.75$0.00$9,857.47
TOTAL$373,059.63$175,497.05$221,668.16$20,188.95$172,647.47$0.00$2,352.33$0.00$965,413.59

OWO's - HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2022 to 12.31.2022
OWO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
LABOR HOURSA004A004A004A004A004A004A004A004TOTAL HOURS
OWOOWOOWOOWOOWOOWOOWOOWOTOTAL
CLS 404 - GROUNDS00930011655.6511672.6
CLS 408 - SAND REMOVAL00000017017
CLS 510 - PEST MANAGEMENT000001836001836
TOTAL00000183617013525
OWO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
MATERIAL COSTA004A004A004A004A004A004A004A004TOTAL MATERIAL
OWOOWOOWOOWOOWOOWOOWOOWOTOTAL
CLS 404 - GROUNDS$0.00$0.00$0.00$0.00$0.00$0.00$12,368.75$0.00$12,368.75
CLS 408 - SAND REMOVAL$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
CLS 510 - PEST MANAGEMENT$0.00$0.00$0.00$0.00$0.00$10,907.21$0.00$0.00$10,907.21
TOTAL$0.00$0.00$0.00$0.00$0.00$10,907.21$12,368.75$0.00$23,275.96

PMO's HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2022 to 12.31.2022
PMO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
LABOR HOURSA002A002A002A002A002A002A002A002# OF ORDERS
PMOPMOPMOPMOPMOPMOPMOPMOTOTAL
CLS 411 - FACILITIES MAINT. VERTICAL8,3812,5143,8233,1381,421002619,302
CLS 420 - FACILITIES MAINT. HORIZONTAL00000006,4366,436
TOTAL8,3812,5143,8233,1381,421006,46225,738
PMO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
MATERIAL COSTA002A002A002A002A002A002A002A002# OF ORDERS
PMOPMOPMOPMOPMOPMOPMOPMOTOTAL
CLS 411 - FACILITIES MAINT. VERTICAL$43,802.83$5,455.49$7,324.40$277.48$315.96$0.00$0.00$0.00$57,176.16
CLS 420 - FACILITIES MAINT. HORIZONTAL$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL$43,802.83$0.00$7,324.40$277.48$315.96$0.00$0.00$0.00$57,176.16

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