Attachment 6 Historical Workload Service Orders.xlsx

XLSX spreadsheet 18 KB Posted

Attached to
Facility Maintenance Services at Fort McCoy, WI
Solicitation number
W912ES22R0011
Issued by

About this file

This document contains historical service order data and details of a federal contract opportunity for facility maintenance services at Fort McCoy in Wisconsin. The historical service order data from 2017 to 2020 provides information on the quantities, average time per service order, and total hours for emergency, urgent, routine, and RFP service orders across areas such as carpentry, plumbing, HVAC, electrical, and appliances. The federal contract opportunity solicitation seeks a contractor to provide maintenance, repairs, and preventive maintenance for facilities, utilities, equipment, and areas identified by service orders or preventive maintenance schedules at Fort McCoy. The work includes maintenance, repair, and installation of all facility and building components, devices, equipment, and associated subsystems in accordance with manufacturer manuals. The solicitation is issued by the Department of the Army Corps of Engineers Engineering District St Paul.

View the file

Other files

File Type Posted
Amendment 0003 .pdf PDF
Amendment 0002.pdf PDF
Amendment 0002 Site Visit List .pdf PDF
Amendment 0001.pdf PDF
CBA Fort McCoy July 1 2021 - June 30 2024 .pdf PDF
Attachment 9 Available Automation Equipment.xlsx XLSX spreadsheet
Attachment 3.7 Cathodic Protection.xlsx XLSX spreadsheet
Attachment 10 Form TR-WM-118.pdf PDF
Attachment 7 Government Furnished Facilities.xlsx XLSX spreadsheet
Attachment 3.3 Fire Suppression (Wet Pipe).xlsx XLSX spreadsheet
Attachment 3.1 Fire Suppression (Ansul-Chemical).xlsx XLSX spreadsheet
Attachment 8 Facility Maintenance Repair ATOPSEC Cover Sheet.pdf PDF
Attachment 3.8 Cathodic Protection WWTP.pdf PDF
Attachment 4 Ice Melt Monthly Report.xlsx XLSX spreadsheet
Attachment 3.11 Water Meters Calibration.xlsx XLSX spreadsheet
Attachment 13 Facility Activation.xlsx XLSX spreadsheet
Attachment 1 Performance Requirements Summary.docx DOCX document
Blank Price Schedule - FM Services 15 FEB 2022.xlsx XLSX spreadsheet
Attachment 15 DD Form 254.pdf PDF
Attachment 3.5 Fire Alarm System.docx DOCX document
Attachment 16 Wisconsin HVAC Qualifier Application.pdf PDF
Attachment 18 Water System Valves Lines and Hydrants.pdf PDF
Attachment 10.1 Aboveground Storage Tank Inspection Form 372.xlsx XLSX spreadsheet
Attachment 21 FMF452 Installation Access Pass Request .pdf PDF
Attachment 3.4 Fire Suppression (Dry Pipe).xlsx XLSX spreadsheet
Attachment 20 FMF451 Installation Access NCIC-III Check Request .pdf PDF
Attachment 3.10 Runway Lighting.pdf PDF
Attachment 3.2 Fire Suppression (Kitchen Hood Cleaning).xlsx XLSX spreadsheet
Attachment 2 Fort McCoy Base Data.xlsx XLSX spreadsheet
Solicitation Fort McCoy Fac Maint Services .pdf PDF
Attachment 12 Generator Log.xlsx XLSX spreadsheet
Attachment 3.6 Earth Bond Testing.xlsx XLSX spreadsheet
Attachment 3.9 Elevators and Lifts.xlsx XLSX spreadsheet
Attachment 14 Facility Deactivation.docx DOCX document
Attachment 3.7.1 TR-WM-141 UST Corrosion Protection Test Form.pdf PDF
Attachment 19 POL System Block Book.pdf PDF
Past Performance Questionnaire.pdf PDF
Attachment 6.1 Historical Workload Service Orders.xlsx XLSX spreadsheet
Attachment 11 Facility Standards.docx DOCX document
Attachment 3 PM Task and Frequency Chart.xlsx XLSX spreadsheet
Show all 40

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

Sheet1

Attachment 6 Historical Workload Service Orders
Attachment 6 is a representative of historical data of a three year period from 1 November 2017 thru 31 October 2020. This data is to give the Contractor an understanding of historical facility maintenance and repair service order quantities. This Attachment has no correlation with individual Contract Line Item Numbers (CLIN) and is not an indication of what the requirements will be per Base Period or Option Periods. Services per year can be higher or lower depending on Installation mission requirements.
CLINDescription1 NOV 2017 - 31 OCT 20181 NOV 2018 - 31 OCT 20191 NOV 2019 - 31 OCT 20203 YEAR AVERAGE
QuantityAverage Time per SOTotal HoursQuantityAverage Time per SOTotal HoursQuantityAverage Time per SOTotal HoursQuantityAverage Time per SOTotal Hours
0002Emergency Service Orders
0002AACARPENTRY1102.11231.701332.45326.50942.09196.501122.24251.57
0002ABPLUMBING6372.161,376.606652.101,396.455302.211,172.256112.151,315.10
0002ACHVAC9241.961,815.556392.321,481.354662.10978.306762.111,425.07
0002ADELECTRIC8161.811,475.858801.911,683.206351.781,132.217771.841,430.42
0002AEFULL ACTIVATION EMERGENCY55.7528.7500.000.0021.002.0024.3910.25
0002AFACTIVATE HVAC ONLY32.758.2521.503.0012.252.2522.254.50
0002AGACTIVATE WATER ONLY00.000.0081.2810.250ERROR:#DIV/0!0.0031.283.42
0002AHLOCATES521.2665.50941.44135.251041.37142.00831.37114.25
0002AIAPPLIANCES152.2734.00812.63213.251062.17229.50672.36158.92
0002Emergency Service Order Totals2,5621.975,036.202,5022.105,249.251,9381.993,855.012,3342.024,713.49
0003Urgent Service Orders
0003AACARPENTRY5013.031,516.207773.322,580.607994.033,220.006923.522,438.93
0003ABPLUMBING9922.001,984.051,0482.132,237.357832.411,884.979412.162,035.46
0003ACHVAC6442.381,532.676032.801,690.033882.43943.505452.551,388.73
0003ADELECTRIC1,0132.252,283.559822.512,460.458322.602,162.759422.442,302.25
0003AEDEACTIVATE HVAC ONLY40.692.7512.502.5000.000.0021.051.75
0003AFDEACTIVATE WATER ONLY44.1916.7552.8514.2523.507.0043.4512.67
0003AGACTIVATE HVAC ONLY11.501.5043.4413.7512.002.0022.885.75
0003AHACTIVATE WATER ONLY73.2923.0031.424.2592.9426.5062.8317.92
0003AILOCATES6012.141,284.926981.951,360.935592.011,123.756192.031,256.53
0003AJAPPLIANCES902.27204.702342.91680.702342.35550.501862.57478.63
0003Urgent Service Order Totals3,8572.298,850.094,3552.5411,044.813,6072.759,920.973,9402.529,938.62
0004Routine Service Orders
0004AACARPENTRY1,5382.403,686.951,4092.603,660.751,4983.284,918.701,4822.764,088.80
0004ABPLUMBING5332.051,090.705232.861,497.909342.682,501.336632.561,696.64
0004ACHVAC5022.701,357.414183.091,292.095382.171,169.674862.621,273.06
0004ADELECTRIC1,8262.023,689.271,7602.424,255.111,8642.254,185.251,8172.234,043.21
0004AEFULL ACTIVATION NON EMERGENCY2673.821,020.253093.881,199.003223.941,267.252993.881,162.17
0004AFFULL DEACTIVATIONS3073.471,064.723667.862,876.702793.751,046.753175.241,662.72
0004Routine Service Order Totals4,9732.3911,909.304,7853.0914,781.555,4352.7815,088.955,0642.7513,926.60

0005 RFP Service Orders 20 19 13 17

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