Рет қаралды 87,284
Download the EXCEL Safety Stock Calculator: abcsupplychain.com/download-s...
Join my next Inventory Management WORKSHOP (free): abcsupplychain.com/inventory-...
In this world of uncertainty, it feels good to have more safety stock:
-Unpredictable demand 📊 🧻
-Pandemic 😷
-Inflation 💰
-Suppliers delays 🏭
-Events like the Suez Canal block ⛴
-Transport crisis 🚚
-Global shortages 📱
-Geopolitical tension 🌍
However, we cannot have infinite stock to cover infinite issues.
Most companies tend to increase manually their safety stocks before realizing that they don't have any cash flow left...
Then they reduce their stocks too much and face dramatic shortages 🤯
In addition, maintaining high safety stock is a trick to hide the root causes of our problems:
-Poor forecast accuracy 📈
-Poor data accuracy 🧑💻
-Manual processes 🥵
-Outdated IT systems (ERP, WMS, TMS ...) 💾
-Lack of visibility 🧐
-Lack of communication with suppliers 🤺
-Lack of skills & training 🧑🏫
In this new video step-by-step tutorial, I explain :
-The 6 FORMULAS to calculate safety stock in EXCEL
-The “old school” method from my grandpa 👴
-The one I recommend for you today
-How to combine EOQ with Safety Stock
-How to calculate the Re-Order-Point
-The limitations of the Normal distribution method
-The Future of safety stock (new methods)
-Examples in EXCEL that you can download below the video
-The action plan to start optimizing your inventory TODAY 🚀
I try to keep it simple ;-)
Let me know in the comments, what your favorite method is and how you face uncertainty 😁
Enjoy my Excel !
Edouard
▬▬▬▬▬▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬▬▬▬▬▬▬
Safety Stock Calculation in Excel:
00:00 Safety Stock Introduction
00:44 Safety Stock Definition
01:20 Demand Uncertainty
02:12 Lead Time Uncertainty
04:11 Economic Order Quantity (EOQ)
04:49 Reorder Point
05:30 Safety Stock Goals
07:06 Basic Safety Stock formula
08:47 Average - Max formula
12:12 Normal Distribution
14:22 Safety Stock Calculation Method 3 (demand uncertainty)
16:06 Safety Stock Calculation Method 4 (lead time uncertainty)
17:16 Safety Stock Calculation Method 5 (lead time & demand uncertainty)
18:31 Safety Stock Calculation Method 6 (lead time & demand are dependent)
19:19 Normal Distribution limits
20:40 Tip: ABC XYZ Classification
21:15 Other Safety Stock methods
22:12 How to choose the right method?
23:20 Safety Stock: Action Plan
MY BLOG: abcsupplychain.com
#supplychain #inventorymanagement #safetystock