Find the right tools based on your needs.
Pick one of our Excel templates from the following categories:
Optimize your inventory management
All Inventory Management core skills at your fingertip
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
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
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
- Free 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
- Free EOQ Excel including formulas to download
Analyze like a pro
Construct insightful Supply Chain KPIs from scratch
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 syndrome)
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
Logistics Lead Time – Free Excel to Track itT
- Why is measuring lead time important?
- Calculate the average logistics lead time
- How to interpret the data
- Implementing the Lead Time KPI
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
Forecast more accurately
Learn the formulas and automation to master basic forecasting in no time.
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
Forecast Accuracy formula: 4 Calculations in Excel
- Reduce your stock-outs,
- Increase your service rate
- Reduce the cost of your Supply Chain.
- 5 steps how to master forecast accuracy formulas
- Implement the right KPI in your business.
Chat GPT Forecast in Excel
- Amazon sales data example
- Reduce the cost of your Supply Chain.
- Excel Sales Forecast
- Free Example in Excel to Download
Boost you career
Prepare your next big move
