Tools, Excel, Best Practices
Supply Chain & Inventory Management

Discover and apply the best Tools, SCM best practices and Excel to improve your Inventory Management, Logistics & Supply Chain Performance

ABC Analysis in Excel

  • Presentation of the Pareto principle & ABC classification
  • Business example with 500 products in Excel
  • Advice to Automate your ABC analysis on Excel
  • Perfect first tool to start optimizing your inventory management
  • Download free Excel with examples

ABC XYZ Analyse to optimize your Inventory Management

  • The ABC Analysis is not sufficient to optimize your inventory
  • Classify your product based on uncertainty & volatility
  • Optimize your safety stock with the ABC XYZ classification
  • Business example in Excel with 2000 products
  • Download ABC XYZ Excel with 3 methodologies

Optimize your EOQ with the Wilson Formula

  • Optimize your inventory management with Wilson Formula
  • Economic Order Quantity Formula (EOQ)
  • Minimum Order Quantity Formula (MOQ)
  • Nike Business Example in Excel
  • Download free EOQ Excel with all formulas

Safety Stock : the 6 best formulas on Excel

  • Optimize your inventory with Safety Stock
  • Order Point calculation formula
  • Discover the 6 best safety stock formulas
  • Calculation and Mistakes to avoid
  • Business Safety Stock Example on Excel
  • Business Example in Excel

10 best KPIs for your Supply Chain & Logistics

  • 10 best KPIs / Metrics for manage Supply Chain performance
  • Included : Service Rate, Availability Rate, Stock Coverage ..
  • Build Dashboard & Metrics to track your performance
  • 10 mistakes to avoid (syndrom expert)
  • Download Excel with business case

Excel is today and will remain for a long time the main tool to analyze, optimize your inventory and your supply chain. Believe me, even the world's largest companies that spend hundreds of millions of euros on ERP and analysis/reporting software continue to extract and analyze their data in Excel. We are developing several Tools Excels to help you effectively manage your supply chain and inventory management.

Edouard Thieuleux

Fondateur - AbcSupplyChain

expert supply chain gestion de stock

Follow us

Scroll to Top