Smart OTEA
November 1, 2023
November 1, 2023


Optimizing an automotive wholesaler stock management
Modelling, Simulating and Optimizing the stock of a spare parts wholesaler.

SARI S.A. (NORS Group)

Service Management

Nors is one of the largest Portuguese groups in the automotive sector, acting worldwide. With around 8 M€ in stock, around 200 K parts numbers, and more than 120 suppliers with different logistic setups, a company from the Nors group needed a efficient way to manage its order system, regarding its spare part business.

  • To guarantee an excellent service level.
  • To reduce logistic costs.
    To optimize the return of available budget.
  • To implement the model as an external layer to the existing ERP.

In 2013 the Engineering Mathematical Lab (LEMA) from Oporto School of Engineering (ISEP IPP) was challenged to develop a tailor made mathematical tool to control the stock management in the companies of NORS group that operate on the aftermarket sector. To do so, firstly were defined which were the best metrics to meet the managers goals. Afterwards, data analysis techniques were applied to detect which type of patterns were present on sales. With this information, an automatic forecasting model with seve-ral prediction methods was built. Simulating different scenarios, the forecasting model was then tuned. Finally, to take advantage of the group sales volume, an optimization model (MMORS) was implemented in order to minimize logistical costs.

One year after MMORS fully implementation, the Mean Daily Stock was reduced around 18%, while the Service level was increased around 1%. All of those in a year where the gross sales were increased by 9%. All the model was implemented in a tailor made software that, although being nowadays the core of the company ordering system, didn’t imply any major changes on their existing ERP.

Stichting European Service Network of Mathematics For Industry and Innovation.

5052 Goirle, Netherlands