All the Supply Chain Excel tools I created and fine tune over my career to quickly get start and see results when you are trying to optimise your stock level, increase your service rate, estimate your slow moving stock or forecasting the demand.
These tools come with a video tutorial and will save you a lot of time so you can focus on what matters the most.
Safety stock is essential in inventory management to avoid stockouts caused by demand or supply variability. This guide covers various safety stock formulas, including the Average-Max and statistical methods, to […]
Safety Stock Formula & Calculation: The 6 best methods Read More »
This guide covers essential Supply Chain Kpis and metrics like , Service Rate, Availability Rate, Stock Rotation (inventory turnover), and Forecast Accuracy to help you measure and optimize your supply
10 Essentials Supply Chain KPIs and Metrics in Excel Read More »
ABC analysis is a method used in inventory management to categorize items into three groups—A, B, and C—based on their importance and consumption value. By mastering ABC analysis, you can
ABC Analysis in Inventory Management: Step-by-Step Excel Tutorial Read More »
ABC XYZ analysis is a powerful inventory management tool that combines two methods: ABC classification by value and XYZ analysis by demand variability. This approach helps businesses optimize stock control,
ABC XYZ Analysis in Inventory Management: A Complete Guide with Excel Example Read More »
SLOB inventory (Slow-moving and obsolete inventory) possibly already occupying a significant amount of space in your warehouse. The longer this unwanted inventory remains part of your stock, the more it
Calculate SLOB Inventory: Slow Moving And Obsolete Inventory Read More »
Effective inventory management is crucial for business profitability. Beyond the obvious expenses, several hidden costs can significantly impact the bottom line. This article will explain the 9 key parameters that
Comprehensive Guide to Inventory Cost Calculation: 9 Key Parameters Read More »
If you’ve ever wondered how much and how often you should order, the EOQ formula (Economic Order Quantity or Wilson Formula) is your answer. In this guide, I’ll break down
Economic Order Quantity: EOQ Formula + Excel Guide Read More »
Are you efficient enough with Excel? Most people think they can master Excel but they do not exploit the potential of this tool at all. How many times have I
Essential Excel Skills for Supply Chain Management Read More »
The forecast reliability or forecast accuracy is a key indicator in demand planning. If chosen correctly and measured properly, it will allow you to reduce your stock-outs, increase your service
Forecast Accuracy formula: 4 Calculations in Excel Read More »
Forecasting in Excel offers a quick and efficient way to predict future trends by leveraging historical data. This Forecasting in Excel tutorial explains how to create forecasts in Excel, adjust
Forecasting in Excel : A Step-by-Step Tutorial with exemples Read More »
Too often neglected, OTIF, DIFOT, service level, and fill rate are essential indicators in supply chain management. They can drive satisfaction or cause stress, especially when products are out of
How to Calculate OTIF, DIFOT, and Fill Rate in Supply Chain Read More »
The inventory turnover ratio is a critical metric for assessing the efficiency of inventory management. This guide covers essential formulas and steps for calculating inventory turnover in Excel, including the
Inventory Turnover ratio: Formulas & Calculation in Excel Read More »
