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

  Рет қаралды 26,509

AbcSupplyChain

AbcSupplyChain

Күн бұрын

Пікірлер: 20
@7shoresclothing505
@7shoresclothing505 2 жыл бұрын
Thank you so much for sharing this video, Please keep this channel alive and post more informative videos on Supply Chain and Inventory Management
@abcsc
@abcsc 2 жыл бұрын
Thank you, I will!
@sandeep00784
@sandeep00784 Жыл бұрын
Thank you sir...for deep knowledge about KPI of supply chain.
@topsyturvyy4558
@topsyturvyy4558 2 жыл бұрын
Amazing tutorial, amazing teacher!
@kwyvander
@kwyvander Жыл бұрын
Great vídeo! I'm work with Slob and report de E&O here in Brazil.
@rauljimenez5485
@rauljimenez5485 2 жыл бұрын
Your channel is the perfect compilation of very key concepts in Inventory Management, thank you very much for the great content!!
@abcsc
@abcsc 2 жыл бұрын
You're very welcome Raul!
@crazycruize3455
@crazycruize3455 Жыл бұрын
Your videos are very helpful for SCM professional.
@marlolitgonzales5188
@marlolitgonzales5188 5 ай бұрын
Good Day, may I ask the starting date is the manuf date and the end date is expiry date? And the 90 days is the safety stocks cover?
@abcsc
@abcsc 5 ай бұрын
Hi! Mmmh not really, slow moving KPI period should be taken according to your general inventory turnover. For example 3 months if your business has a quick turnover, or 12 if it is longer. And it is calculated on active products (not expired products or product not yet launched). So that period is not related to manufacturing date or expiry date
@ErikDalinStuntman
@ErikDalinStuntman Жыл бұрын
Do you count safety stock as part of your stock when calculating overstock? Some people don't include safety stock in their calculation since the safety stock serves an important purpose as a buffer agains supply risks (lead time variations), and is not inherently bad for the company.
@hicksonj5
@hicksonj5 2 жыл бұрын
How do you track serialize appliances. I work for a distribution center and I mange appliances. Only thing I track is my cycle counts. I need help or recommendation
@MrKocsis23
@MrKocsis23 Жыл бұрын
SLOB report is obligatory? What is the main goal of this report? And who are you reporting to? To stakeholders?
@omarkhaled1412
@omarkhaled1412 2 жыл бұрын
You're great
@abcsc
@abcsc 2 жыл бұрын
Thanks!
@CasaDeMold
@CasaDeMold Жыл бұрын
Some goods became better and better in inventory.
@pharma8975
@pharma8975 Жыл бұрын
🎉 not much clear dear...start date and end date couldn't get
@WiChiT-S
@WiChiT-S 2 жыл бұрын
❤❤❤❤❤
@abcsc
@abcsc 2 жыл бұрын
Thank you for the support
How to optimize Inventory: 11 proven inventory reduction strategies
15:10
요즘유행 찍는법
0:34
오마이비키 OMV
Рет қаралды 12 МЛН
Jaidarman TOP / Жоғары лига-2023 / Жекпе-жек 1-ТУР / 1-топ
1:30:54
Calculating Safety Stock: Protecting Against Stock Outs
6:17
Ian Johnson
Рет қаралды 306 М.
ABC Analysis : Step-by-Step Tutorial in Excel with 500 products
21:57
AbcSupplyChain
Рет қаралды 114 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 390 М.
How I Built a ONE CLICK Excel Dashboard with ChatGPT 😎
8:32
Website Learners
Рет қаралды 336 М.