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
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
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
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
Inventory Accuracy KPI - Stocktake, Excel Calculation Tutorial
- Why is Inventory Accuracy so important?
- The Excel formulas of Stock Tracking
- How to check your stock (inventory process)
- Implementing the Inventory Accuracy KPI
- Free Excel template with real examples to download
Logistics Lead Time - Free Excel to Track it
- Why is measuring lead time important?
- Calculate the average logistics lead time
- How to interpret the data
- Implementing the Lead Time KPI
- Free Excel template with real examples to download
Slow Moving And Obsolete Inventory
- Understanding Slow Moving and Obsolete Inventory
- How to deal with Obsolete Inventory
- How to manage Slow-moving Inventory
- Implementing the SLOB Inventory KPI
- Free Excel template with real examples to download
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
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
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