Understanding the increase in warehouse stock for better supply chain management

*This project was produced in French, so the visual elements may contain French content.

The context

In a fast-food chain specializing in local fresh produce, the main warehouse experienced a sharp increase in stock (+89% in value) in 9 months, with no apparent cause.

Management wanted to understand this phenomenon in order to avoid bottlenecks, better plan supplies, and ensure the safety of their teams.

What I’ve done

  • Detailed analysis of 6 key indicators, based on 4 datalake sources (orders, receipts, inventory, shipments) :
    • Quantity in stock: +67% between May 2022 and January 2023
    • Average purchase price : -9.44% → not the cause of the increase in value
    • Number of references stocked : +7,95 %
    • Quantities received vs. shipped: +20% vs. +27% → relative imbalance
    • Number of orders placed : -9.24% (but overall upward trend)
    • Supplier service rate: +5.71 points → significant improvement
  • Build a dynamic Excel file with :
    • Clear charts for each indicator
    • Calculation of variation between 1st and last month
    • Filtering by product family
  • Identification of the 3 families with the most pronounced stock increases :
    • Bakery
    • Vegetables mix
    • Dairy
  •  Preparation of a clear, educational visual aid (PowerPoint) for distribution to non-technical teams

The results

  • Precise visualization of stock evolution factors
  • Putting the purchase price out of the equation (observed drop)
  • Identification of 3 families with high stock drift
  • Targeted recommendations by family, including :
    • Supplier management (dairy)
    • Flow coordination (Vegetables Mix)
    • Order quantity reduction (Bakery)

    What about the technical side ?

    • Advanced Excel: PT, filterable curves, % variation
    • Automated calculations for the period May 2022 → January 2023
    • Uncluttered visual design for quick reading by non-analysts
    • Compliance with corporate format imposed by the company

    Let’s talk about it !

    Would you like to analyze your inventory performance or identify logistical drifts?
    I can help you with :

    • Implement intelligent logistics indicators
    • Create ready-to-use files for your business teams
    • Reveal the real levers of action from your data

    📩 Contact me to discuss your requirements !