Free Excel templates & tutorials for Supply Chain Management

Free Excel Tutorials

Download for free the “must have” Supply Chain Management Excel templates and tutorials for immediate results

Inventory Management
Demand Forecasting
Supply Chain Analytics
Check our free tutorials
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

Free Excel template with real examples

Check the tutorial!

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 Excel template with real examples

Check the tutorial!

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

Check the tutorial!

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

Free Excel template with real examples

Check the tutorial!

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
Inventory assessment test for supply chain professionals

Start the Assessment

Inventory Management assessment

Are you capable of adapting your inventory management policy to the specificity of each product / category ? With this quick test you’ll have your answer

Analyze like a pro
Construct insightful Supply Chain KPIs from scratch

Free Excel template with real examples

Check the tutorial!

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 ratio formula calculation days in inventory

Free Excel template with real examples

Check the tutorial!

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

Free Excel template with real examples

Check the tutorial!

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

Free Excel template with real examples

Check the tutorial!

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

Check the tutorial!

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

Check the tutorial!

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 assessment on KPI for supply chain professionals

Start the Assessment

SCM Analytics Assessment 

Ready to present your latest KPIs to the board? Are you dashboards up to the game? Be sure in 5 minutes by taking a test.

Forecast more accurately
Learn the formulas and automation to master basic forecasting in no time.

Free Excel template with real examples

Check the tutorial!

 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

Free Excel template with real examples

Check the tutorial!

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.

Free Excel template with real examples

Check the tutorial!

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

Free Excel template with real examples

Check the tutorial!

Seasonality Forecast in Excel

  • Amazon and bike company sales data example
  • Quarterly Seasonality Calculation
  • Monthly Seasonality Calculation
  • Free Example in Excel to Download
Free assessment on forecasting for supply chain professionals

Start the Assessment

Forecasting assessment

Are your Forecasting methods sufficient to optimize your service level ? How do you level up compared to the best? After this test you will will know. 

Boost you career

Prepare your next big move

Free Salary Estimator

Check the guide!

Estimate your Salary

  • Ultimate Supply Chain Salary Guideline
  • 6 simple questions
  • 70+ countries included
  • 48 different positions analyzed
  • 180,000 salaries estimated
Supply Chain Assessment

Start the Assessment

Full Skills assessment

In 10 minutes, test your knowledge in

  • Inventory Management,
  • Forecasting Methods,
  • Supply Chain KPIs,
  • Data Manipulation

and receive your complete skills assessment for free.

Ready to boost your skills ?
Discover our courses
See all courses
SMC Foundation Course
SCM Foundation™️
View the course
Excel training label
Excel Expert™️
View the course
SCM Analytics training label
SCM Analytics™️
View the course
Inventory management training label
Inventory Management™️
View the course
Forecasting training label
Forecasting Expert™️
View the course
Scroll to Top

FIND OUT HOW MUCH YOU ARE WORTH.

You will receive an email with an estimate of your salary along with some advice on how to boost it.

Your information is confidential and will never be given to third parties. You can unsubscribe in 1 click from any of my emails.