Automate store orders with a scalable, intuitive DRP tool

The context

A fast-growing chain of DIY stores, was experiencing frequent stock-outs, especially during periods of high demand.

Procurement teams needed a simple, customizable and automated tool to place the right orders at the right time, and gain operational reliability.

What I’ve done

• Development of an Excel-based DRP (Distribution Resource Planning) tool:
  • Calculating projected inventory over several weeks
  • Visualization of stock coverage
  • Follow-up of confirmed and planned orders

• DRP V2 integrating:
  • Dynamic safety stock (adjustable in days)
  • MOQ (Minimum Order Quantity) per item
  • Parameters that can be adjusted directly by suppliers

• Add a clear, visual histogram to monitor stock variations
• Design a training manual for the tool

The results

• An automated, educational tool, 100% Excel, tailored to the business
• Fewer disruptions, better anticipation, greater comfort for the team
• Structured, easily modifiable order logic
• Better appropriation of management rules: MOQ, safety, transfer

What about the technical side ?

• Advanced Excel: conditional formulas, dynamic calculations, automated formatting
• V1 : Projected stock + single cover
• V2 : Integration of safety stock, MOQ, interactive frame, control logic
• Clear business calculations (projected stock, net requirements, estimated shortages, etc.)
• Histograms & visual indicators for quick risk analysis

Let’s talk about it !

Would you like to automate your orders or make your Excel tools more intelligent?
I can help you with :

• Create or improve your DRP
• Add business parameters (MOQ, safety stock, etc.)
• Helping your teams get to grips with tailor-made tools

📩 Contact me to discuss your requirements !