Industry: Automotive, Manufacturing
Technology Platforms: JD Edwards, MS Excel,
TransPro Increases Accuracy of Sales Forecasts by 15-20 Percent With John Galt
TransPro Inc. designs, manufactures and markets radiators, radiator cores, heater cores, air conditioning parts and other heat transfer products for the automotive and light truck aftermarket. The company’s line of complete radiators is produced for automobile and light and heavy truck applications. With more than 800 models, the company is able to service approximately 95 percent of the automobiles and light trucks in the U.S.
Transpro was using JD Edwards to produce its product forecasts; however, the system was limited to producing a bottom-up forecast using product line and customer. The planners at Transpro were not getting sufficient accuracy out of this process to control inventory and maintain customer service. After careful consideration and an online demonstration by John Galt Solutions, Transpro chose the John Galt ForecastX Wizard™ as its base forecasting solution, citing its high value, flexibility and ease-of-implementation.
Transpro’s demand and forecasting manager said: “Being an Excel-based tool, the John Galt Wizard is easy and intuitive to use, and the pivot table reports it produces are excellent. That feature really makes it easy to share the sales forecasts with our product managers.”
“We now have some solid numbers to base our decisions on,” added the demand manager. “Since implementing John Galt, Transpro has increased its forecast accuracy by 15 percent overall, and up to 20 percent on selected months. We now have the ability to pull our actual demand a few days before the end of the month from Access into Excel. We then filter out any special demand, and apply the business knowledge our sales and product managers have that the tool doesn’t see. I am done with my forecast in the first few days of a month and I can concentrate on managing our demand plan, not putting together the numbers.”