From Paper Trails to Smarter Planning: The Tool That Turned Complexity Into Efficiency

PennDOT’s maintenance planning process once involved managing many moving pieces at the same time. Flip charts, paper calendars, giant Excel spreadsheets and Gantt charts covered walls like wallpaper. Any time a plan changed maintenance staff had to manually update a number of documents in several different places to reflect the changes. It worked, but only in the same way assembling furniture without instructions “works.” You get there eventually, but no one enjoys the process. 

The implementation of the online Maintenance Planning and Resource Balancing (MPRB) tool changed that often times tedious and labor-intensive process. What began as a straightforward attempt to reduce paperwork quickly became a statewide tool that maintenance staff across PennDOT are describing as clear, fast and reliable, and “something that updates without arguing.”  

The tool’s strength is providing structure without the struggle. Instead of hunting through scattered spreadsheets, supervisors can see personnel availability, equipment capacity, planned activities and materials on one screen. There is no scavenger hunt. There are no mystery tabs. There is just one place that understands schedules are only as predictable as Pennsylvania weather. 

“The tool is very user friendly and easy to use, allowing teams to build sharper plans much faster than previous Excel versions,” said Peter Sinkler, a maintenance manager in PennDOT Engineering District 6, located in southeastern Pennsylvania.    

Developed by the Operations and Performance Division (OPD) in PennDOT’s Bureau of Maintenance, in collaboration with the Infrastructure and Economic Development (IED) IT Delivery Center, the MPRB tool solved a longstanding problem – plans change often. In the past, one small update could trigger hours of cleanup across multiple documents. Now, one change updates the entire system instantly. The interactive Gantt chart makes overlaps, gaps and equipment conflicts visible in seconds, which helps to prevent some typical scenarios of two crews arriving for the same job, not having enough personnel to complete a job, or unavailable equipment. 

Another aspect of the MPRB tool is the Resource Analysis Report. Rather than scrolling through long spreadsheets trying to figure out what personnel and equipment have been booked, managers are able to access this report to view staffing and equipment needs clearly to ensure each activity can be completed. This helps counties reduce rental costs and use their teams more effectively.  

“Use of the Resource Analysis Report even simplified bidding,” said Ian Shedlock, roadway programs coordinator in Monroe County, PennDOT Engineering District 5. “I can quickly see when we are going to the next job, and it saves a lot of time and stress.”