Newswise — AMES, Iowa – It’s a common dilemma for any business or government agency that manages a large fleet of vehicles – what is the optimal window for replacement? Iowa State University researchers have found an answer to that question that could potentially save millions.

Sree Nilakanta and Kevin Scheibe, both associate professors of information systems in ISU’s College of Business, partnered with the Iowa Department of Transportation to tackle the problem. They analyzed 10 years of maintenance records for DOT snow plow trucks – more than a million pieces of data – to determine when the DOT should replace old ones.

Nilakanta and Scheibe then created a simulation-based decision support system using the maintenance records, purchase price and resale estimates in yearly increments. Basically, it’s an efficient way to process big data in real time to project when it’ll cost more to maintain than buy a new snow plow truck. Nilakanta and Scheibe say it’s a system that any government agency or company with a large transportation fleet can utilize.

“Many DOTs have the same problem and each one is trying a different approach. The system we’ve created is an easier way of doing the estimations and predictions,” Nilakanta said.

For the two different snow plow trucks the DOT operates, ISU researchers found the best timeframe was six to seven years. That’s a dramatic difference than the DOT’s current 15-year replacement window, which means the DOT is paying more to repair and maintain old trucks than it would cost to replace them. Buying new trucks after six or seven years could save $2 million to $5 million annually.

Word about the simulation system is spreading. Other state DOTs and private businesses have already contacted Nilakanta and Scheibe about conducting similar projects, as well as how they might use the system to analyze their own data.

Data to support decision making

In the age of big data, more and more business leaders are interested in using analytics to operate more efficiently and improve the bottom line. Scheibe says the tools and methodologies have long existed, but today the data is easier to access and process.

“We collect so much data, but we don’t know what to do with it,” Scheibe said. “To be able to apply different analytic methods allows us to go through massive amounts of data and create a series of options that enables decision makers to make better choices.”

David May, fleet manager for the Iowa DOT for nearly two decades, says the ISU research is the best case he’s had to significantly change how the DOT invests in its fleet. He has long suspected they were spending more to maintain trucks, but never had the data to support that conclusion.

“This research bore out what we suspected to be true. In fact, it’s the most solid evidence that we have to show that we really need to reduce the amount of time that we keep our snow plow trucks,” May said.

Nilakanta and Scheibe have presented the findings to several DOT leaders. May says the DOT plans to change the length of time that it keeps plows and adjust its snow plow budget accordingly.

Growing interest from industry and at ISU

The DOT partnership is just one example of the work Iowa State researchers are conducting on behalf of businesses in Iowa and across the country. Not only do businesses see value, but so do students. Nilakanta and Scheibe say since starting the project their analytics research team has grown from one to 20 graduate students, who are part ISU’s master of science in information systems, and specialize in analytics.

The team is looking at other applications and uses, such as inventory management, machine failure predictions and process improvement. Researchers say they designed the simulation system so that the DOT can modify as it collects new data. This is beneficial because as manufacturers develop new equipment technology, the optimal replacement window may change. It is important to continuously monitor maintenance records to recommend the best time to replace older equipment.