Hornbach hb amsterdam01a 1200x800 1200x800

Client Introduction

Head of Store Process Development, Strategy & Innovation at Hornbach

  • Industry: DIY Retail
  • Role: Head of Store Process Development, Strategy & Innovation
  • Company Size: €6.3 billion in revenue; 169 stores in Europe, of which 17 are in the Netherlands (approximately 226,617 square meters).

Hornbach is a prominent DIY retailer operating 169 stores across Europe. Known for a wide range of quality DIY products at competitive prices, Hornbach has remained family-managed since 1877, emphasizing a strong customer-first approach.
 
Typically, DIY retailers want to provide customers with a one-stop-shopping experience, implying a high service and availability level regardless of the project they wish to complete. Offering such a value proposition is by nature capital-intensive and is, given the growth of online and offline channels, requiring ever more capital expenditure.

Visit Hornbach

The Challenge of Reducing Capital Expenditure

Hornbach’s commitment to customer satisfaction hinges on its ability to offer a complete range of items needed for DIY projects in a single store visit. However, their existing forecasting method, an 8-week sales data analysis, was not sufficiently accurate, leading to overstocking and underutilization of floor space. This not only tied up valuable working capital but also compromised the store layout and customer experience.

Introducing Advance Demand Forecasting

Recognizing the need for a more sophisticated approach to managing inventory more effectively, our team convinced Hornbach to develop a cutting-edge forecasting solution:

  • Enhanced Data Architecture
    Parallel to developing the forecasting model, Crunch worked closely with Hornbach’s data teams to upgrade their data infrastructure. This strategic enhancement supported the advanced analytics capabilities required for modern inventory management. 

    Hornbach now has a more data-science-ready environment that connects to its legacy data warehousing environment. Such a data-science-ready environment runs a number of data-science-enabling technologies like Jupyter Notebooks to visualize data, Git to track code, Docker to handle dependencies, Kubernetes for managing virtual machines, and Airflow for scheduling.

     

  • Key Performance Indicators
    The primary metric for assessing the impact of the new system was the weighted Mean Absolute Percentage Error (wMAPE), which showed considerable improvement in forecasting accuracy.

     

  • AI-Powered Forecasting Model
    Crunch’s solution involved the deployment of a LightGBM-based machine learning model that improved prediction accuracy significantly. 
    By categorizing inventory articles into demand types (smooth, erratic, intermittent, lumpy) and focusing initially on smooth and erratic articles, the model provided actionable insights that directly supported better stock control.

Results

Optimized Inventory Levels
The implementation of the AI forecasting model enabled Hornbach to more accurately predict future sales and adjust their stock levels accordingly. This not only reduced the necessity for excess working capital but also minimized the risk of stockouts, thereby ensuring that customers always find what they need.

Improved Store Processes 
In the store, several stock pickers now use their trusted stock-picking app, connected to said data infrastructure, to input current inventories. These inventory numbers are then compared with the forecast and a set of business rules. Based on this comparison, the stock-picking app provides the correct number to ensure proper in-store replenishment.

Conclusion

Hornbach’s journey illustrates the power of AI in transforming retail operations. By adopting advanced forecasting models and improving data infrastructure, Hornbach now enjoys reduced operational costs, improved customer experience, and a competitive edge in the DIY retail market.

Interested in learning more about how data-driven solutions can transform your business? Have a look at our cases for more inspiring examples, or follow us on LinkedIn for the latest updates and insights. For a personalized consultation or to discuss how we can assist your company, please contact us.

Follow us on Linkedin

Like to learn more about our services for business leaders?

Are you a business leader like our stakeholder at Hornbach? Learn how we can help you move forward with confidence.

Case Image Contact Laurent

Set up a 30-minute introductory call to see how we can help!

We'd love to help! In recent years, we've assisted many leaders like yourself, even through a 30-minute call where we listen to your challenges and provide guidance on how to move forward.

Book your call

More use cases

Let us help you move forward, with confidence

Book your introduction call