Attachment 6 Historical Workload Service Orders.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Facility Maintenance Services at Fort McCoy, WI
- Solicitation number
- W912ES22R0011
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
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. | |||||||||||||
| CLIN | Description | 1 NOV 2017 - 31 OCT 2018 | 1 NOV 2018 - 31 OCT 2019 | 1 NOV 2019 - 31 OCT 2020 | 3 YEAR AVERAGE | ||||||||
| Quantity | Average Time per SO | Total Hours | Quantity | Average Time per SO | Total Hours | Quantity | Average Time per SO | Total Hours | Quantity | Average Time per SO | Total Hours | ||
| 0002 | Emergency Service Orders | ||||||||||||
| 0002AA | CARPENTRY | 110 | 2.11 | 231.70 | 133 | 2.45 | 326.50 | 94 | 2.09 | 196.50 | 112 | 2.24 | 251.57 |
| 0002AB | PLUMBING | 637 | 2.16 | 1,376.60 | 665 | 2.10 | 1,396.45 | 530 | 2.21 | 1,172.25 | 611 | 2.15 | 1,315.10 |
| 0002AC | HVAC | 924 | 1.96 | 1,815.55 | 639 | 2.32 | 1,481.35 | 466 | 2.10 | 978.30 | 676 | 2.11 | 1,425.07 |
| 0002AD | ELECTRIC | 816 | 1.81 | 1,475.85 | 880 | 1.91 | 1,683.20 | 635 | 1.78 | 1,132.21 | 777 | 1.84 | 1,430.42 |
| 0002AE | FULL ACTIVATION EMERGENCY | 5 | 5.75 | 28.75 | 0 | 0.00 | 0.00 | 2 | 1.00 | 2.00 | 2 | 4.39 | 10.25 |
| 0002AF | ACTIVATE HVAC ONLY | 3 | 2.75 | 8.25 | 2 | 1.50 | 3.00 | 1 | 2.25 | 2.25 | 2 | 2.25 | 4.50 |
| 0002AG | ACTIVATE WATER ONLY | 0 | 0.00 | 0.00 | 8 | 1.28 | 10.25 | 0 | ERROR:#DIV/0! | 0.00 | 3 | 1.28 | 3.42 |
| 0002AH | LOCATES | 52 | 1.26 | 65.50 | 94 | 1.44 | 135.25 | 104 | 1.37 | 142.00 | 83 | 1.37 | 114.25 |
| 0002AI | APPLIANCES | 15 | 2.27 | 34.00 | 81 | 2.63 | 213.25 | 106 | 2.17 | 229.50 | 67 | 2.36 | 158.92 |
| 0002 | Emergency Service Order Totals | 2,562 | 1.97 | 5,036.20 | 2,502 | 2.10 | 5,249.25 | 1,938 | 1.99 | 3,855.01 | 2,334 | 2.02 | 4,713.49 |
| 0003 | Urgent Service Orders | ||||||||||||
| 0003AA | CARPENTRY | 501 | 3.03 | 1,516.20 | 777 | 3.32 | 2,580.60 | 799 | 4.03 | 3,220.00 | 692 | 3.52 | 2,438.93 |
| 0003AB | PLUMBING | 992 | 2.00 | 1,984.05 | 1,048 | 2.13 | 2,237.35 | 783 | 2.41 | 1,884.97 | 941 | 2.16 | 2,035.46 |
| 0003AC | HVAC | 644 | 2.38 | 1,532.67 | 603 | 2.80 | 1,690.03 | 388 | 2.43 | 943.50 | 545 | 2.55 | 1,388.73 |
| 0003AD | ELECTRIC | 1,013 | 2.25 | 2,283.55 | 982 | 2.51 | 2,460.45 | 832 | 2.60 | 2,162.75 | 942 | 2.44 | 2,302.25 |
| 0003AE | DEACTIVATE HVAC ONLY | 4 | 0.69 | 2.75 | 1 | 2.50 | 2.50 | 0 | 0.00 | 0.00 | 2 | 1.05 | 1.75 |
| 0003AF | DEACTIVATE WATER ONLY | 4 | 4.19 | 16.75 | 5 | 2.85 | 14.25 | 2 | 3.50 | 7.00 | 4 | 3.45 | 12.67 |
| 0003AG | ACTIVATE HVAC ONLY | 1 | 1.50 | 1.50 | 4 | 3.44 | 13.75 | 1 | 2.00 | 2.00 | 2 | 2.88 | 5.75 |
| 0003AH | ACTIVATE WATER ONLY | 7 | 3.29 | 23.00 | 3 | 1.42 | 4.25 | 9 | 2.94 | 26.50 | 6 | 2.83 | 17.92 |
| 0003AI | LOCATES | 601 | 2.14 | 1,284.92 | 698 | 1.95 | 1,360.93 | 559 | 2.01 | 1,123.75 | 619 | 2.03 | 1,256.53 |
| 0003AJ | APPLIANCES | 90 | 2.27 | 204.70 | 234 | 2.91 | 680.70 | 234 | 2.35 | 550.50 | 186 | 2.57 | 478.63 |
| 0003 | Urgent Service Order Totals | 3,857 | 2.29 | 8,850.09 | 4,355 | 2.54 | 11,044.81 | 3,607 | 2.75 | 9,920.97 | 3,940 | 2.52 | 9,938.62 |
| 0004 | Routine Service Orders | ||||||||||||
| 0004AA | CARPENTRY | 1,538 | 2.40 | 3,686.95 | 1,409 | 2.60 | 3,660.75 | 1,498 | 3.28 | 4,918.70 | 1,482 | 2.76 | 4,088.80 |
| 0004AB | PLUMBING | 533 | 2.05 | 1,090.70 | 523 | 2.86 | 1,497.90 | 934 | 2.68 | 2,501.33 | 663 | 2.56 | 1,696.64 |
| 0004AC | HVAC | 502 | 2.70 | 1,357.41 | 418 | 3.09 | 1,292.09 | 538 | 2.17 | 1,169.67 | 486 | 2.62 | 1,273.06 |
| 0004AD | ELECTRIC | 1,826 | 2.02 | 3,689.27 | 1,760 | 2.42 | 4,255.11 | 1,864 | 2.25 | 4,185.25 | 1,817 | 2.23 | 4,043.21 |
| 0004AE | FULL ACTIVATION NON EMERGENCY | 267 | 3.82 | 1,020.25 | 309 | 3.88 | 1,199.00 | 322 | 3.94 | 1,267.25 | 299 | 3.88 | 1,162.17 |
| 0004AF | FULL DEACTIVATIONS | 307 | 3.47 | 1,064.72 | 366 | 7.86 | 2,876.70 | 279 | 3.75 | 1,046.75 | 317 | 5.24 | 1,662.72 |
| 0004 | Routine Service Order Totals | 4,973 | 2.39 | 11,909.30 | 4,785 | 3.09 | 14,781.55 | 5,435 | 2.78 | 15,088.95 | 5,064 | 2.75 | 13,926.60 |
0005 RFP Service Orders 20 19 13 17
File details come from the government source that posted it. Updated .