Tools, Excel, Best Practices
Supply Chain & Inventory Management

Discover 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
  • Guide to automate your ABC analysis on Excel
  • Perfect first tool to start optimizing your inventory management
  • Free Excel with examples to download

ABC XYZ Analyse to optimize your Inventory Management

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

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
  • Free EOQ Excel with all formulas to download

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
  • Free Business Example in Excel to download

10 best KPIs for your Supply Chain & Logistics

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

Excel is and will remain for a while 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 keep extracting and analyzing their data through Excel. We are developing several Excel Tools to help you manage your Supply Chain and inventory management with efficiency.

Edouard Thieuleux

Fondateur - AbcSupplyChain

expert supply chain gestion de stock

Follow me

Scroll to Top