TE 02 Workload History CY21 (1).xlsx

XLSX spreadsheet 39 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 shops within a technical exhibit for base operation support services at Yuma Proving Ground. The report details the number of work orders, labor hours, and material costs for each shop from January 2021 through December 2021. The largest volume of work was for vertical facilities maintenance, with over 24,000 labor hours and $702,324 in material costs. Pest management incurred $132,522 in material costs on 298 work orders requiring 2,068 labor hours. Grounds maintenance accounted for 11,334 labor hours costing $10,669. The related federal contract opportunity is a solicitation from the Department of the Army for base operation support services at Yuma Proving Ground. The solicitation number is W5168W23R0004 and it is an indefinite delivery/indefinite quantity contract for services including facilities operations and maintenance.

View the file

Other files

File Type Posted
Conformed W5168W-23-R-0004.pdf PDF
TE_05_Installed_Building_Equipment_and_Equipment In Place.xlsx XLSX spreadsheet
Attachment K - Staffing Matrix-19JAN2024-W5168W-23-R-0004-YPG.xlsx XLSX spreadsheet
TE_02_Workload_History_CY21_Revised.xlsx XLSX spreadsheet
YPG Attachment List-05JAN2024.xlsx XLSX spreadsheet
TE_02_Workload_History_CY22_05JAN2024.xlsx XLSX spreadsheet
TE_02_Workload_History_CY21_05JAN2024.xlsx XLSX spreadsheet
TE_01_Real_Property_Inventory-05JAN2024.xlsx XLSX spreadsheet
TE 15 Grounds Inventory-05JAN2024.xlsx XLSX spreadsheet
TE_16_Roads_and_Test_Courses_05JAN2024.xlsx XLSX spreadsheet
Attachment_P_Davis_Bacon_Highway_29NOV2023.pdf PDF
Attachment I - YUMA Annex M CLS 510 Pest Management 05JAN2024.pdf PDF
Attachment E - YUMA Annex F CLS 404 Grounds 05JAN2024.pdf PDF
W5168W-23-R-0004-Solicitation Closing Date Extened-Formal Amendment ForthComing-29DEC2023.pdf PDF
Attachment T - Past Performance Questionnaire.docx DOCX document
TE 17 - Petroleum-Oil-Lubricant Facility Locations and Equipment.xlsx XLSX spreadsheet
TE 18 - Petroleum-Oil-Lubricant Facility BI-Monthly Checklist.xlsx XLSX spreadsheet
TE 29 Stormwater Pollution Prevention Plan.pdf PDF
TE 45 Builder Inventory and Assessment.pdf PDF
TE 44 Builder Condition Manual for components.pdf PDF
TE 05 - Installed Building Equipment and Equipment In Place.xlsx XLSX spreadsheet
TE 25 GFEBS Field Requirments.pdf PDF
TE 22 - Labor Category per Functional Area.xlsx XLSX spreadsheet
TE 19 - Cathodic Protection System Locations.xlsx XLSX spreadsheet
TE 20 - Cathodic Protection System Preventive Maintenance Checklist.xlsx XLSX spreadsheet
TE 12 - Water Storage Tank.xlsx XLSX spreadsheet
TE 41 Recurring OWO.xlsx XLSX spreadsheet
TE 06 Deliverables.docx DOCX document
TE 48 ATEC - Mission Non-Real Property Work Load Data History (1).pdf PDF
Attachment U - PIEE CCM Vendor Training.pdf PDF
Attachment E - YUMA Annex F CLS 404 Grounds 11-23-21.docx DOCX document
Attachment D - YUMA Annex E CLS 403 Waste Management 11-23-21.docx DOCX document
Attachment T3 - Specific Relevant Contracts Reference Sheet.docx DOCX document
Attachment J - Yuma Pricing Matrix CLIN Structure as of 06-21-2023.xlsx XLSX spreadsheet
Attachment T2 - Consent Form for Release of Past Performance Information.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 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
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

2021 # of Orders

Technical Exhibit 2
Workload History
COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2021 to 12.31.2021
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'sA001A001A001A001A001A001A001A001J1003PLMB
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOHOURSTOTALK1004ELEC
SDO Call Outs/After Hours0000000000X1005H VOLT
Priority #10000000000M1006CARP
Priority #20000000000P1007PEST
Priority #300000000344344R1008GRND
TOTAL000000000344T1010HOUSING
V1009H EQUPT
CLS 404 - GROUNDS MAINTENANCESHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009SHOP (T) 1010
Number of ServicesA004A004A004A004A004A004A004A004A004
OWOOWOOWOOWOOWOOWOOWOOWOOWOTOTAL
OWO/SJO00000056920571
CLS 408 - SAND REMOVALSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009SHOP (T) 1010
Number of ServicesA004A004A004A004A004A004A004A004
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
OWO/SJO000000000
CLS 411 - FACILITIES MAINT. VERTICALA001A001A001A001A001A001A001A001
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009SHOP (T) 1010
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours161810155000064
Priority #125611212715800200592
Priority #2811359810700110396
Priority #3377548955567263141602,695
TOTAL7308131,19096881316003,747
A002A002A002A002A002A002A002A002A002
PMO's4,0981,9381,4771,0001,16200009,675
CLS 420 - FACILITIES MAINT. HORIZONTALA001A001A001A001A001A001A001A001
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009SHOP (T) 1010
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours0000000000
Priority #10000001001
Priority #20000200002
Priority #3011023082035
TOTAL011025092038
A002A002A002A002A002A002A002A002A002
PMO's00000002370237
CLS 510 - PEST MANAGEMENT
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009SHOP (T) 1010
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
SDO Call Outs/After Hours000002002
Priority #100000930093
Priority #2000005005
Priority #30000018400184
TOTAL0000028400284
A004A004A004A004A004A004A004A004
OWO's0000029800298
TOTAL NUMBER OF SERVICESSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009SHOP (T) 1010
DMO/SO'sA001A001A001A001A001A001A001A001
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours161810155200066
Priority #1256112127158093300686
Priority #2811359810725110403
Priority #33775499565674918722183442,914
TOTAL7308141,1919690628726194,069
A004A004A004A004A004A004A004A004
OWO/SJO0000029856920869
A002A002A002A002A002A002A002A002
PMO's4,0981,9381,4771,0001,1620023709,912

DMO's OWO's - HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2021 to 12.31.2021
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 408 - SAND REMOVAL0
CLS 411 - FACILITIES MAINT. VERTICAL48735495667789958121819910524077
CLS 420 - FACILITIES MAINT. HORIZONTAL-811-266-11512412
CLS 510 - PEST MANAGEMENT-----00-0
TOTAL48735503668889960781831411724489
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 408 - SAND REMOVAL$0.00
CLS 411 - FACILITIES MAINT. VERTICAL$285,135.71$132,058.81$174,321.51$27,275.03$81,776.20$0.00$1,757.15$0.00$702,324.41
CLS 420 - FACILITIES MAINT. HORIZONTAL-$0.00$0.00-$5,304.90-$542.10$0.00$5,847.00
CLS 510 - PEST MANAGEMENT$0.00$0.00$0.00
TOTAL$285,135.71$132,058.81$174,321.51$27,275.03$87,081.10$0.00$2,299.25$0.00$708,171.41

OWO's - HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2021 to 12.31.2021
OWO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
LABOR HOURSA004A004A004A004A004A004A004A004TOTAL HOURS
OWOOWOOWOOWOOWOOWOOWOOWOTOTAL
CLS 404 - GROUNDS11334.517.511352
CLS 408 - SAND REMOVAL0
CLS 510 - PEST MANAGEMENT-----20653-2068
TOTAL0000020653013420
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$10,669.57$10,669.57
CLS 408 - SAND REMOVAL$0.00
CLS 510 - PEST MANAGEMENT-----$132,522.45$0.00-$132,522.45
TOTAL$0.00$0.00$0.00$0.00$0.00$132,522.45$10,669.57$0.00$143,192.02

PMO's HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2021 to 12.31.2021
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. VERTICAL10,1632,6303,2442,7361,274---20,047
CLS 420 - FACILITIES MAINT. HORIZONTAL-------4,5324,532
TOTAL10,1632,6303,2442,7361,274004,53224,578
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$36,178.69$3,521.00$5,247.53$308.46$613.77---$45,869.45
CLS 420 - FACILITIES MAINT. HORIZONTAL-------$0.00$0.00
TOTAL$36,178.69$0.00$5,247.53$308.46$613.77$0.00$0.00$0.00$45,869.45

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