A07 ATTACHMENT 0013 TE 1.2 Estimated Workload Data Summary.pdf
PDF 743 KB Posted
- Solicitation number
- W52P1J-21-R-5001
About this file
This document provides estimated workload data and number of orders for base operations support services on the Rock Island Arsenal in Rock Island, Illinois. The data includes averages of 178 project work orders per year totaling $4,984,688 annually from FY2013 to FY2018, with 73% under $33,000. Demand maintenance orders averaged 4,521 per year totaling $2,939,894, with 60% under $500 and 44% under $250. By organization, the Army family housing portion averaged $914,710 annually, the customer segment $7,622,202, and garrison services $9,102,453. The number of orders by type and organization from FY2013 to FY2018 are also provided.
View the file
Other files
Show 40 more
Latest 50 of 109 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
History of: PROJECT WORK ORDERS (PWOs) referred to as IJOs The following data was compiled from Work Management System (WMS) data as of 05 Jul 2019. The Data was pulled with a search and download of IJOs from Oct. 2012 to Sept 2018. This includes Customer and Garrison PWOs.
• Average, 178 PWOs per year
• Cost of $4,984,688.05 Annually
• Average price $27,951.52
Stratifying the information tells us that 73% of the IJOs are under $33,000.00
History of: DEMAND MAINTENANCE ORDERS (DMOs) referred to as Service Orders The following data was compiled from Work Management System (WMS) data as of 05 Jul 2019. The Data was pulled using the Standard Report named “Discretionary Service Order Customer’s Charges”.
Both discretionary and nondiscretionary Service Orders were pulled, for FY13 to FY18 (Oct. 2012 to Sept 2018). Only those marked complete with a final price were used. (34 of 27,162 were removed from data because they did not have final prices, and were not marked complete)
DMOs are services costing less than $2,500.00.
• Average, 4,521 DMOS each year
• Cost of $2,939,894.36 Annually
• Average price $650.23 per DMO.
60% of the DMOs are under $500.00, 44% under $250.00
TE 1.2 Estimated Workload Data.xlsx Total Dollars per Year 5/10/2020
TE 1.2 Estimated Workload Data.xlsx Total Dollars per Year
Sum of Cost Column Labels Row Labels AFH Customer Garrison Grand Total 2013 $221,052.40 $1,030,609.18 $1,190,594.84 $2,442,256.42 2014 $215,608.14 $1,120,117.12 $1,555,259.58 $2,890,984.84 2015 $111,090.73 $1,244,978.91 $1,686,051.69 $3,042,121.33 2016 $121,317.57 $1,421,216.66 $1,763,855.57 $3,306,389.80 2017 $123,354.96 $1,591,881.72 $1,690,139.23 $3,405,375.91 2018 $122,287.09 $1,213,398.91 $1,216,551.88 $2,552,237.88 Grand Total $914,710.89 $7,622,202.50 $9,102,452.79 $17,639,366.18
$0.00 $200,000.00 $400,000.00 $600,000.00 $800,000.00
$1,000,000.00 $1,200,000.00 $1,400,000.00 $1,600,000.00 $1,800,000.00 $2,000,000.00
2013 2014 2015 2016 2017 2018
AFH
Customer
Garrison
Garrison_or_Customer
Year
Sum of Cost
TE 1.2 Estimated Workload Data.xlsx Yearly $$$ and TYPES of Orders 5/10/2020
TE 1.2 Estimated Workload Data.xlsx Yearly $$$ and TYPES of Orders
Sum of Cost Column Labels Row Labels 2013 2014 2015 2016 2017 2018 Grand Total
AFH
AFH-DMO $177,611.46 $195,878.82 $106,470.71 $109,337.76 $113,154.78 $112,277.35 $814,730.88 AFH-OWO $43,440.94 $19,729.32 $4,620.02 $11,979.81 $10,200.18 $10,009.74 $99,980.01
AFH Total $221,052.40 $215,608.14 $111,090.73 $121,317.57 $123,354.96 $122,287.09 $914,710.89 Customer
DMO $481,088.01 $654,006.84 $741,422.10 $737,250.59 $792,591.08 $664,569.30 $4,070,927.92 OWO $549,521.17 $466,110.28 $503,556.81 $683,966.07 $799,290.64 $548,829.61 $3,551,274.58
Customer Total $1,030,609.18 $1,120,117.12 $1,244,978.91 $1,421,216.66 $1,591,881.72 $1,213,398.91 $7,622,202.50 Garrison
DMO $981,331.15 $1,280,291.49 $1,486,651.26 $1,545,995.02 $1,520,306.26 $1,062,401.96 $7,876,977.14 OWO $209,263.69 $274,968.09 $199,400.43 $217,860.55 $169,832.97 $154,149.92 $1,225,475.65
Garrison Total $1,190,594.84 $1,555,259.58 $1,686,051.69 $1,763,855.57 $1,690,139.23 $1,216,551.88 $9,102,452.79 Grand Total $2,442,256.42 $2,890,984.84 $3,042,121.33 $3,306,389.80 $3,405,375.91 $2,552,237.88 $17,639,366.18
TE 1.2 Estimated Workload Data.xlsx Number of Orders Gar-AFH-Cust 5/10/2020
TE 1.2 Estimated Workload Data.xlsx Number of Orders Gar-AFH-Cust
Count of Cost Column Labels Row Labels 2013 2014 2015 2016 2017 2018 Grand Total
AFH
AFH-DMO 411 391 202 192 158 138 1,492
AFH-OWO 74 53 18 19 18 25 207
AFH Total 485 444 220 211 176 163 1,699 Customer
DMO 1,388 1,629 1,640 1,721 1,845 1,539 9,762
OWO 821 710 842 970 1,085 854 5,282
Customer Total 2,209 2,339 2,482 2,691 2,930 2,393 15,044 Garrison
DMO 1,268 1,511 1,648 1,676 1,687 1,263 9,053
OWO 248 287 211 231 187 168 1,332
Garrison Total 1,516 1,798 1,859 1,907 1,874 1,431 10,385 Grand Total 4,210 4,581 4,561 4,809 4,980 3,987 27,128
| Total Dollars per Year |
| Yearly $$$ and TYPES of Orders |
| Number of Orders Gar-AFH-Cust |
File details come from the government source that posted it. Updated .