Dr Peter Catt is a Supply Chain Solution Manager at Soltius and is receiving his Doctor of Computing degree – the first ever to be awarded the qualification – at Unitec’s graduation ceremony in Auckland.
Soltius is a leading implementer of SAP enterprise resource planning (ERP) systems and Dr Catt’s doctoral work looked at the use of these solutions in sales forecasting. He says that forecasting models are an important business tool, but the way in which they are often used can have a negative impact on business profitability.
“SAP ERP solutions are used by many of the world’s most successful companies and have comprehensive forecasting functionality, but most companies don’t use the right models because they don’t know what the real forecasting error costs are.”
This is because most businesses use basic statistics to show the difference between the sales forecasts and actual sales – information that is of little use in aiding decision-making, says Dr Catt.
“Learning that they sold a few percent more or less of a particular product line than the forecast tells a business absolutely nothing. This statistical data doesn’t take into account the margins on a product line or the costs of having safety stock.”
And with many businesses ordering stock from overseas months in advance, getting their predictions right is crucial.
For example, if a business sells 20 percent more of a product than forecasted they would take that into account when making their next order. But if the margin on that product is very low, the cost of having safety stock on hand may be more than the profits realised from the sales.
“Conversely, on a high margin product line the cost of having additional safety stock on hand may be worth it. Traditional forecast error metrics simply do not reveal the financial impact in the real world. And as a result, the business can never be sure if they are using the right forecast model.”
Dr Catt has developed a new approach – the Cost of Forecast Error metric – which he says is a better guide for businesses, not only in calculating forecast error, but in choosing the right IT solution in the first place. “SAP alone has nine different forecasting models and most businesses are using the wrong ones – if they’re not, it’s probably a fluke.
“Running a few simulations using the cost of error metric will quickly tell a business which IT solution to purchase to meet their specific needs.”
His work has already been published in a leading US journal and has had positive responses from a number of US academics, including an MIT professor.
Dr Catt, who has previously completed an MBA from Henley Management College in the UK, says that getting the forecast model right will pay off in the long run. “Businesses have been operating in the dark to a large extent when setting their stock levels and placing orders with their suppliers.
“This cost to forecast error calculation is a relatively simple method that can have a significantly beneficial impact on the bottom line.”