Technology Newsmaker Q&A Tom Muck

April 16, 2015
Timken's Demand Insight leverages sales and industry data to improve forecasts and reduce costs. Timken's catalog team matches parts and vehicles, and combines that information with vehicle registration and replacement/failure rates, along with internal sales data.

Several years ago, Timken launched Demand Insight, a solution that leverages sales and industry data to improve forecasts and reduce costs. Timken's catalog team matches parts and vehicles, and combines that information with vehicle registration and replacement/failure rates, along with internal sales data.

Crunching that data using proprietary algorithms helps them predict how many parts will be needed in a given geography. Tom Muck, Timken's principal systems analyst, spoke to Aftermarket Business World, about the forecasting solution.

What was the biggest challenge you faced in launching Demand Insight?

Back in 2010, when we first took this on, the first real challenge we met was trying to mesh the registration information with our catalog data. That's pretty significant, because it goes beyond year, make and model. You have to think about drive type, ABS, and a lot of parts are specific on their ACES attributes. We had to come up with a solution that took into account all of those situations. The second piece was then applying basic replacement rates.

Did you build the Demand Insight solution internally?

Yes. We went outside for some of the data, but as far as putting the solution together we used internal resources. We are a Microsoft shop, and we developed it on the .Net platform. That uses a back-end SQL database that is robust and quite large to manage all of the data needed for the solution.

How successful has adoption been?

There are more than 300 distributors and power users that are on the system today, and that includes some of our sales team, both internal and external. We're projecting demand for more than 4,000 parts with vehicle applications. From a technical perspective, there are more than 1 billion records in that back-end database, which provides the forecast. It's a lot of data.

Subscribe to Aftermarket Business World and receive articles like this every month….absolutely free. Click here.

About the Author

Brian Albright

Brian Albright is a freelance journalist based in Columbus, Ohio, who has been writing about manufacturing, technology and automotive issues since 1997. As an editor with Frontline Solutions magazine, he covered the supply chain automation industry for nearly eight years, and he has been a regular contributor to both Automotive Body Repair News and Aftermarket Business World.

Sponsored Recommendations

AIRCAT Solutions - Small Ratchets With Enormous Power

Experience the power of AIRCAT's diverse ratchet selection. Each designed with a unique transmission gear for faster torque buildup and unbeatable performance. Their compact sizes...

Unmatched Power and Comfort: AIRCAT Grinders for Every Workspace

AIRCAT grinders deliver powerful performance with high RPM and efficient, quiet operation. Designed for comfort and control, they feature ergonomic handles, extended reach, and...

What Are the Advantages of Air Tools Over Cordless Tools?

Discover the advantages of air tools over cordless tools.

AIRCAT Tool Reviews: The Nitrocat 1056-XL Compact

Hear what senior autotechs have to say about the AIRCAT Nitrocat 1056-XL compact impact wrench. They’ll provide their reviews on tools they own and have been using every day on...

Voice Your Opinion!

To join the conversation, and become an exclusive member of Vehicle Service Pros, create an account today!