Скачать с ютуб 6 Best Safety Stock Formulas: Calculation & Examples in Excel (Full TUTORIAL) в хорошем качестве

6 Best Safety Stock Formulas: Calculation & Examples in Excel (Full TUTORIAL)

Download the EXCEL Safety Stock Calculator: https://abcsupplychain.com/download-s... Join my next Inventory Management WORKSHOP (free): https://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: https://abcsupplychain.com #supplychain #inventorymanagement #safetystock