SLOB: Slow Moving & Obsolete Inventory Calculation in Excel (step-by-step tutorial)

Download the SLOB Inventory Calculation in Excel here: https://abcsupplychain.com/download-s...

Join my Supply Chain WORKSHOPS (free): https://abcsupplychain.com/free-suppl...

How is your SLOB situation? 📦🙋

This stock is the most "toxic" in our companies ☢️

SLOB Inventory means Slow Moving & Obsolete Inventory.

Too much SLOB means:

-Not enough cash flow to invest in fresh products 💰
-More Promotions, donations, or destructions
-Low profit 📉
-High occupancy rate in your warehouse/factory/store ❌
-And a lot of "firefighting" 👨‍🚒

The best way to reduce your SLOB is to track it properly AND regularly.

I just published a new step-by-step YOUTUBE tutorial to track your obsolete and slow-moving stock.

It only takes 10 minutes with an Excel example you can download.

I hope you will like it 👨‍🏫

▬▬▬▬▬▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬▬▬▬▬▬▬

0:00 Intro
0:43 SLOB Meaning
1:13 Obsolete Inventory
2:45 Slow Moving Inventory (excess inventory)
3:29 Inventory Turnover
4:15 SLOB Excel Tutorial
4:35 Obsolete Inventory in Excel
6:18 Total value of Obsolete Inventory
7:42 Slow Moving Inventory in Excel
10:31 Compare Stock Turn with Safety Stock & Reorder Point levels
11:25 Integrate the SLOB KPI into your dashboard
11:50 How to reduce SLOB & Improve Service?
12:17 My Supply Chain Workshops

►MY BLOG : https://abcsupplychain.com

#supplychain #logistics #inventory