The holy grail of inventory control is the ability to forecast what customers are going to buy and when, order those parts from the supplier, and sell them to the customer before you pay the invoice to your supplier. And to never ever carry excess stock.
For 10 years or so now c8/c9 has offered some basic tooling that provides dealers an estimate of what stock re-order levels should be; i.e. max checker. It generates reasonable numbers based on analysing the sales figures for up to 12 months, but there are a number of things that cause it to generate poor results under some circumstances; such as sporadic/slow moving parts or seasonal stock.
With advent of c9 and some very powerful enabling technologies available to us, we are now exploring and testing more sophisticated statistical approaches to the problem of providing more material support to spare parts managers in their task of tuning restocking levels. We are testing statistical models that encompass a dozen different variables and considerations, and we are tuning these models against 'flight simulators', that test how variation in different pre-set biases affect business profitability when it comes to stock control.
Read more...