Work Orders are input into the CityWorks system used mainly by the Department of Public Works and Chattanooga Department of Transportation (CDOT). These work orders contain critical data on the cost of projects, estimated start dates, types of projects, and locations of projects among other descriptors. Using this data, the City of Chattanooga can monitor how it's performing in term of work order completion and where it may expect delays. The data can proactively drive changes in work order management to shift priorities on projects and deliver the highest value to citizens.
What We're Tracking
- Where are work orders occurring? Are certain work orders being completed in certain areas?
- How long do work orders take to complete and are we on time? Should we shift expectations based on the data?
- How much do these work orders cost? How might we budget based on these assumptions?
Work Order Location
Location, location, location. What matters greatly is where the work orders are performed to maximize value to citizens in that area. Whether it's resurfacing a street, installing a new drainage ditch, or trimming some trees, location matters as it often has a direct impact on Chattanoogans nearby. The below map shows where recent work orders have been completed for the STREETS asset group. Different color dots indicate different types of work orders and larger dots indicate the project cost more dollars. Select any of the drop downs to change the selection to your own liking.
Late Work Order Heat Map
To the right is a heat map of late work orders completed in the past 90 days. This information is imperative to determine if there are areas that the City of Chattanooga is completing work orders on a consistently late time frame. Using data, we can adjust prioritized work orders to ensure on time delivery before an area consistently receives late work orders.
Work Order Timing
Timing is everything. What often matters to citizens is that a work order is completed when the City says it will be. Completing work orders in a timely manner demonstrates the City of Chattanooga is effectively managing it's resources to deliver services to the citizens. By using the data, we can effectively measure how often we complete work orders on time as well as how long it takes to complete the work. Below is a measure of the percent of completed work orders completed on time in the past month.
Average Days to Complete
The chart below contains information on completed work orders in the past 180 days broken down by asset group. The green bars represent the amount of completed work orders while the orange line is the average days to complete for those work orders. The most common work order asset groups are for the Waste Water Treatment Plant and the average time to complete varies widely.
Average Days to Complete Over Time
Work order average days for completion shown below demonstrates it takes approximately 4 to 6 days to complete a work order on average. There is a spike in February of 2018 where a minor data cleanup of work orders that had been left open when the work was actually completed much earlier had to be closed.
Work Order Cost
By using data on the historical cost of the work order, the City of Chattanooga can accurately estimate what a work order will cost when a request is made by a citizen. We can then use this data to prioritize work order projects and move resources when needed. As expected below, Streets work orders typically cost the most as this involves heavy equipment usage, labor, and materials to resurface or repair a street. Storms Sewer asset group work orders cost the second highest as this often involves similar aspects to Streets. The two most common asset groups do not cost as much as these work orders typically deal with preventative maintenance and jobs that require only labor and cheaper materials.
Average Cost Over Time
The below measure is the average closed work order cost over time. This average fluctuates greatly based on the type of work orders performed and changes in material costs. Overall, it is safe to say the typical work order will cost between $750 and $1,500 dollars, but amounts shift significantly based on the work order type and asset group as seen above.