50% stock reduction realized for pilot articles

Logistics specialist Würth uses DISKOVER for inventory optimization

By Armin Breitner1, Michel Mondelaers2 and Dr. Bernd Reineke

Würth logoHigh delivery readiness often comes at the price of high inventories. That doesn’t have to be the case. At Würth Belux, stocks of pilot articles were reduced by 50 percent. Total inventory turnover was increased from 5.6 to 7.5 within a short period of time, which frees up liquidity. All this without sacrificing 98.5% of delivery readiness and without additional costs for scheduling staff. This was made possible by the use of the DISKOVER optimization and scheduling tool.

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
The project results had a positive impact after just a short time. The results for the pilot articles planned 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% reduction in stock after 5 months

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 readiness rate of 98.5% 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 9 stock turnovers per year for each country branch. However, stock turnover in Belgium was only 5.6 per year, a far cry 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. Of a total of 17,000 items, around 13,500 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.

Problem case IT

It quickly became clear 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 IT 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 expanded 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 as a general rule. 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 inventories as part of the ABC/XYZ analysis clearly shows that the purchasers understood very well how to hold inventories in the AB-XY range in order to achieve a high readiness to deliver for these items and at the same time not to take a high risk due to regular consumption, while at the same time avoiding inventories in the difficult-to-plan Z and Z2 ranges
The evaluation of inventories as part of the ABC/XYZ analysis clearly shows that the purchasers understood very well how to hold inventories in the AB-XY range in order to achieve a high readiness to deliver for these items and at the same time not to take a high risk due to regular consumption, while at the same time avoiding inventories in the difficult-to-plan Z and Z2 ranges

Evaluation

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% (see table).

ABC
X999995
Y999995
Z989880
Z2808080
N000

The possibility of purchasing from different suppliers (sister companies, parent company, see above) 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. The simulation scenarios are shown in the following table:

Further analyses showed that only an insignificant proportion of the articles (<encoded_tag_open />1%) had a trend character, but that 5% of the articles showed seasonal behavior (see example in Figure 3), which was known to the buyers but was not previously considered for automated replenishment

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 stock 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 the turnover-optimized scenarios, it quickly became clear that the 13% to 28% 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% below the actual inventory value and thus an inventory turnover of 9.35 per year is achieved. The target of 9 transshipments per year set by the Group’s headquarters would thus be achieved.

The almost 250% increase in the number of order items can be handled by the purchasing department 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 involved in creating 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.

DISKOVER 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 reports by email to flexibly definable distribution lists

Thanks to the flexible design of the DISKOVER interfaces to the higher-level ERP system, further requirements could be implemented in a short time, so that the solution is also well equipped for future requirements.


1 Head of Group Logistics Würth Group, Künzelsau

2 Head of Logistics at Würth Belux N. V., Turnhout

Picture of Dr. Bernd Reineke

Dr. Bernd Reineke