DISKOVER optimizes inventories

Increased stock turnover

High delivery readiness often comes at the price of high inventories. That doesn’t have to be the case. Würth Belux succeeded in reducing stocks of pilot articles by 50 percent. This was made possible by the use of the DISKOVER optimization and scheduling tool.

The Würth Group operates worldwide with over 330 companies in 80 countries trading in fastening and assembly materials. 2.65 million customers place their trust in Würth’s products and service. Thanks to its global logistics network, Würth stands for quality and perfect logistics. The latter is characterized by a delivery reliability of 98.5 percent and places the highest demands on employees, organization and systems.

However, the Würth Belux N.V. branch in Turnhout, Belgium, still had some homework to do to further optimize its procurement processes, as the Group management set a new logistics target of nine stock turnovers per year for each country branch. However, stock turnover in Belgium was only 5.6 per year, which was far from the target.

For this reason, Abels & Kemmner was commissioned to accelerate the stock turnover in order to achieve this new goal as quickly and efficiently as possible for almost 17,000 articles traded by Würth Belux.

The 17,000 articles are primarily procured from the sister companies in Bratislava (SLO) and Landquart (CH) as well as the parent company Adolf Würth GmbH & Co. KG (AWKG for short). While AWKG in Künzelsau already supplies the articles in small quantities in packaging units suitable for acceptance, the minimum order quantities at the sister companies are significantly higher. On the other hand, the articles of the Group’s sister companies are cheaper than the small quantities of AWKG, which should play a significant role in the later investigations. Out of a total of 17,000 items, around 13,500 items are in stock and are sold from the inventory. The other items are procured on an order-related basis and are generally delivered directly from the supplier to the customer.

The project results had a positive impact after just a short time. The results for the pilot articles procured with Diskover are more significant than for the conventionally procured articles, which also fell due to the reduction in minimum order quantities and delivery times: Over 50 percent reduction in stock after five months.

It quickly became apparent that the goal was only possible with a corresponding change to the software-supported scheduling. Although the items in stock were planned and ordered by the buyers once or twice a week, the TT system only provided rudimentary support for the planners: although MRP lists with all the relevant information were issued, the buyers had to view them all and create the orders manually if necessary. For easily plannable items, the existing system was also extended to include an automatic function with a reorder point procedure and target ranges of coverage, but these do not take into account the individual consumption behavior of the items and can therefore only be set on a flat-rate basis. There was therefore a clear need for action and the decision was made to use the Diskover optimization and scheduling tool, initially as a stand-alone optimization tool and now also integrated into the ERP landscape (in this case the Unix system MSP) for daily operations. Before Diskover went live, a number of preparatory analyses were required:

  • ABC and XYZ analysis for structuring the range of articles.
  • Trend and seasonal analysis.
  • Definition of stockpiling strategies and target delivery readiness levels.
  • Simulation of various scenarios with different logistical parameters.

The analyses were accompanied by optimizing measures to reduce logistical parameters such as replenishment time, minimum purchase quantities and batch sizes, which Purchasing was able to renegotiate with the suppliers. The evaluation of stocks as part of the ABC/XYZ analysis clearly showed that the purchasers understood very well how to hold stocks in the AB-XY range in order to achieve a high level of readiness to deliver for these items, while at the same time not taking a high risk due to regular consumption and avoiding stocks in the Z and Z2 ranges, which are difficult to plan. Further analysis showed that only an insignificant proportion of the articles (< 1 percent) had a trend character, but five percent of the articles showed seasonal behavior. The purchasers were aware of this, but the items were not previously eligible for automated replenishment.

The project results had a positive impact after just a short time. The results for the pilot articles planned with DISKOVER were more significant than for the conventionally procured articles, which also fell due to the reduction in minimum order quantities and delivery times: Over 50% reduction in stock after 5 months

For the simulation and optimization runs, it is necessary to define the stocking strategies, which specify which items are to be stocked and which delivery readiness levels are targeted. As the order-related items were already excluded from the analyses in advance, all of the remaining 13,500 items must be in stock. Using the ABC/XYZ matrix, the project team set the target delivery readiness levels with the aim of maintaining the very high value of 98.5 percent.

The ability to purchase from different suppliers played a key role in defining the simulation scenarios. Of particular interest was the question of how the price advantage of the sister companies (price-optimized scenarios) would affect the shorter delivery times and lower minimum order quantities of the parent company (turnover-optimized scenarios). In the simulation runs, this was taken into account by the different logistical parameters such as delivery time, goods receipt processing time and minimum order quantities as well as the different purchase prices.

Which scenario delivers the best results and what was the impact of the price differences between parent and sister companies? To assess the simulation results, the order volume and the number of order items over a comparative period were used in addition to the inventory level and the degree of readiness to deliver. This is because the reduction in minimum order quantities and stocking periods inevitably results in more order items and therefore, of course, more goods receipt processes.

When comparing the price-optimized and turnover-optimized scenarios, it quickly became clear that the 13 to 28 percent higher order volume compared to the actual situation exceeded the cost savings from the inventory reduction several times over and was therefore unacceptable. Similarly, the number of order items would more than triple in the scenarios with optimum turnover, thus significantly increasing the cost of purchasing and goods receipt. For this reason, only the price-optimal scenarios were considered below, all of which met the requirements for the degree of readiness to deliver.

In summary, it can be observed that shorter cover periods lead to lower inventories, but drove up the number of order items. The outlier factor, which makes it possible to smooth out peaks in demand in the historical data, also has the effect of reducing inventories due to lower forecast values. Overall, the price-optimized scenario V was selected, in which the target inventory value is 40 percent below the actual inventory value and thus an inventory turnover of 9.35 per year is achieved. The target of nine transshipments per year set by the Group’s headquarters would thus be achieved. The almost 250 percent increase in the number of order items can be absorbed in purchasing thanks to Diskover’s automation options. Assuming that all easily predictable X and Y articles can be ordered automatically in future, i.e. without the intervention of the buyer, the overall effort required to create orders can be reduced to below the current level. However, there will still be increased costs for incoming goods, which can still be managed by the logistics department to the extent calculated. The system offers the following additional functions to further automate purchasing processes:

  • Supplier-specific order and delivery days.
  • Consideration of price/quantity scales.
  • Dynamic minimum ranges.
  • Consideration of minimum order values.
  • Consideration of packaging units in the safety stock definition.
  • Exception notifications by e-mail to flexibly definable distribution lists.

Thanks to the flexible design of Diskover’s interfaces to the higher-level ERP system, further requirements could be implemented in a short time, so that the solution would meet future requirements.

A B C
X 99 99 95
Y 99 99 95
Z 98 98 80
Z2 80 80 80
N 0 0 0
Dr. Bernd Reineke

Dr. Bernd Reineke

Talk to us!

We are there for you personally and will be happy to advise you individually on our services and solutions.