TE 02 Workload History CY19.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 workload data from 2019 for various shops performing base operation support services at Yuma Proving Ground. The data includes the number of work orders completed monthly by shop code and class of work, along with the associated labor hours and material costs. The shops provided services such as HVAC, plumbing, electrical work, facilities maintenance, pest management, and grounds maintenance. In 2019 the total work orders completed across all shops was over 16,000, with over 40,000 labor hours and material costs exceeding $418,000.

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 seeks to acquire services such as facilities maintenance, utilities operations, and transportation support. However, the document provided does not specify pricing terms, response dates, or other details typically included in a solicitation.

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
Try for free Login

Text version

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

2019 # ORDERS

Technical Exhibit 2
Workload History
COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2019 to 12.31.2019
SHOP CODESCLS CODES
CLS 200SHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009H1002HVAC200QHFMUEPH
Number of Servies'sA001A001A001A001A001A001A001A001# OF ORDERSJ1003PLMB400QDEHFACILITIES ENGINEERING SVCS MGMT
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTALK1004ELEC404QMUNGROUNDS MAINTENANCE
SDO Call Outs/After Hours000000000X1005H VOLT408QMUNSAND, SNOW, ICE REMOVAL
Priority #1010000001M1006CARP411QRPAFACILITIES MAINT. VERTICAL
Priority #2621000009P1007PEST417MEDICAL AND HOSPITAL
Priority #38151101200046R1008GRND420QRPAFACILITIES MAINT. HORIZONTAL
Priority #4000000000V1009H EQUPT510QMUNPEST MANAGEMENT
TOTAL14181201200056T1010HOUSING
A002A002A002A002A002A002A002A002V1009H EQUPT
PMO's1289550000147T1010HOUSING
A001 & A002 COMBINED TOTAL1422717512000203
CLS 400SHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
Number of ServicesA004A004A004A004A004A004A004A004# OF ORDERS
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
SDO Call Outs/After Hours211000004
Priority #1121111401030
Priority #293216000030
Priority #31244319774864218890
OWO13624116254442558
TOTAL16054225255166764501,512
CLS 404SHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
Number of ServicesA004A004A004A004A004A004A004A004# OF ORDERS
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
SDO Call Outs/After Hours000000202
Priority #1000000101
Priority #2000000101
Priority #3000000325
Priority #40000003993402
TOTAL0000004065411
CLS 408SHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
Number of ServicesA004A004A004A004A004A004A004A004# OF ORDERS
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
SDO Call Outs/After Hours000000000
Priority #1000000000
Priority #2000000000
Priority #3000000101
Priority #4000000505
TOTAL000000606
CLS 411A001A001A001A001A001A001A001A001
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009# OF ORDERS
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours1020143200049
Priority #1973967245000250
Priority #2215115198947020586
Priority #3365609857526521862,554
Priority #4000000000
TOTAL6877831,1366674611063,439
A002A002A002A002A002A002A002A002
PMO's3,9802,2881,5751,0381,15700110,039
A001 & A002 COMBINED TOTAL4,6673,0712,7111,1041,903110713,474
CLS 417A001A001A001A001A001A001A001A001
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009# OF ORDERS
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours100010002
Priority #1100000001
Priority #2801000009
Priority #346701200029
Priority #4000000000
TOTAL146801300041
A002A002A002A002A002A002A002A002
PMO's428120200064
A001 & A002 COMBINED TOTAL561420015000105
CLS 420A001A001A001A001A001A001A001A001
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009# OF ORDERS
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours000000000
Priority #1000000000
Priority #2000000101
Priority #3000023010336
Priority #4000000000
TOTAL000023011337
A002A002A002A002A002A002A002A002
PMO's0000000384384
A001 & A002 COMBINED TOTAL000023011387421
CLS 510
Number of ServicesSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009# OF ORDERS
OWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOOWO/SJOTOTAL
SDO Call Outs/After Hours000000000
Priority #100000720072
Priority #200000200020
Priority #30000027410275
Priority #40000028100281
TOTAL0000064710648
SHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
Number of Servies'sA001A001A001A001A001A001A001A001# OF ORDERS
DMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SODMO/SOTOTAL
SDO Call Outs/After Hours1321153302057
Priority #111041683597220355
Priority #223812020225472040656
Priority #3501673107259118527944193,832
Priority #4136241162834584451,246
TOTAL8758611,381911,3106545104646,146
A002A002A002A002A002A002A002A002
PMO's4,1502,3051,5921,0431,1590038510,634
A001 & A002 COMBINED TOTAL5,0253,1662,9731,1342,46965451084916,780

DMO's-OWO's - HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2019 to 12.31.2019
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 2006710146-57---271
CLS 400116987319ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
CLS 404---8-6153328515431
CLS 408------55-55
CLS 41116723000000189
CLS 417276932230-542---3573
CLS 420----1452-2439163907
CLS 510-----26765-2681
TOTAL147017474ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
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$629$511$32-$120---$1,292
CLS 400$13,540$4,164ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
CLS 404------$10,247-$10,247
CLS 408$0$0$0$0$0$0$0$0$0
CLS 411$135,552$109,299$98,531$26,293$29,051$0$391$0$399,117
CLS 417$139$735$1,224-$1,552---$3,650
CLS 420----$2,023-$1,183-$3,206
CLS 510-----$967--$967
TOTAL$149,859$114,709ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

PMO's HRS-MAT

COMPLETED SHOP WORK LOAD DATA REPORTING
01.01.2019 to 12.31.2019
PMO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
LABOR HOURSA002A002A002A002A002A002A002A002# OF ORDERS
PMOPMOPMOPMOPMOPMOPMOPMOTOTAL
CLS 200481.113503.5000503
CLS 41120,8065,5766,4075,7581,515005740,119
CLS 417192131303000221
CLS 420000000000
TOTAL21,47906,4255,7581,521005740,842
PMO'sSHOP (H) 1002SHOP (J) 1003SHOP (K) 1004SHOP (X) 1005SHOP (M) 1006SHOP (P) 1007SHOP (R) 1008SHOP (V) 1009
MATERIAL COSTA002A002A002A002A002A002A002A002# OF ORDERS
PMOPMOPMOPMOPMOPMOPMOPMOTOTAL
CLS 200$827.32$0.00$0.00$0.00$0.00$0.00$0.00$0.00$827.32
CLS 411$16,161.68$3,699.14$4,252.50$936.60$290.60$0.00$0.00$0.00$25,340.52
CLS 417$169.03$0.00$0.00$0.00$0.00$0.00$0.00$0.00$169.03
CLS 420$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL$17,158.03$0.00$4,252.50$936.60$290.60$0.00$0.00$0.00$26,336.87

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