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
- Pareto principle & ABC classification
- Business example with 500 products in Excel
- Step-by-Step tutorial in Excel to automate your ABC analysis
- Fondation to start optimizing your inventory management
- Free Excel template with real examples to download
Inventory Turnover KPI : Calculation in Excel
- Presentation of the Inventory Turnover Ratio formula
- Stock Turn in days
- Stock Turn in cycle
- Perfect first metric to start optimizing your inventory management
- Download free Excel with examples
Forecasting with Excel in 3 clicks
- Forecast automatically with Excel in less than 5 minutes
- Forecasting models and trendlines
- Seasonality & exponential smoothing (easy 😉 )
- Forecast examples of Covid Cases in the World, India and USA
- Forecast examples of Sales Cars in the USA
KPIs Service rate - OTIF - DIFOT - Availability
- Step-by-Step tutorial to track your Service in Excel
- Global service level (OTIF, DIFOT)
- Service level / Fill rate (DIF)
- Delivery on Quality (DOQ)
- Delivery on Time (DOT)
- Availability Rate Indicator
- Free Excel template with real examples to download
ABC XYZ Analyse to optimize your Inventory Management
- The ABC Analysis is insufficient to optimize your inventory
- Classify your products based on the uncertainty & volatility of the demand
- 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 including formulas to download
Safety Stock: the 6 best formulas in Excel
- Optimize your inventory with Safety Stock
- Order Point calculation formula
- Discover the 6 best safety stock formulas
- How to choose the best formula
- Calculations and common mistakes to avoid
- Free Business Example in Excel to download
The 10 best KPIs for your Logistics & Supply Chain
- 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 (expert syndrom)
- Free Excel 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
Founder - AbcSupplyChain