If you know enough excel to do everything that he just did here, you can likely land an entry level job as an analyst in inventory/supply mangement. This is an underrated tutorial
This is the best tutorial that i've seen on this topic. Great tips, a deep view of the analysis and everything around it with a touch of humour. Perfect. Thank you so much!
Can't thank you enouph for that valuable information. I have a question about ABC Model. Can this model can be executed in the level of components and materials?
Hello Edouard, thank you for explaining these fundamentals. This video, in combination with your other lessons, really help to have a holistic image of supply chain. However, I'm not a big fan of all those Excel tabs and data entry. I would like to have this combined with Power Query and later Power Bi. for automatic data- and report generation. Is this something you could do a course on as well?
Really helpful, Thank you. I have a question regarding the cumulative percentage volume calculation. If I follow exactly like you did, the percentage values goes above 100%.
Hei, can you help with tips how to make ABC analyse without costs? I want to know only how often some produkt has been picked ? which one is most frequent ?
Hi first of all thank you for your video and explanation normally this is the same as the 20 80 rule if I'm not wrong but you do use 40% a A class, could you tell why ?
Hi Bilal. Yes indeed you can also do it with a 40/60 as shown in the video :) As you wish. Its all about grouping your products: in my example, the first 0.5%-1% of the products represent 10% of the revenue! So it was usefull to seperate A and B class at 40% and not 80%, to better identify the first class products that are critical
Thank you very much, Very Excellent Explanation. Actually, I'm dealing with retails with more than 15K items and more than 80 category, how can I differentiate the Percentages of ABC for each category or is it fine to have it all with the same percentage, is there any rule to specify the percentage??
Hi Sereen, the same applies here: just make your ABC Analysis with 15K products (here I did it with 500 products). You could also make an ABC Analysis with 50 Category to see which ones are the most important (so you must sum the items' sales for each category).
@@abcsc one question! Regarding unit price in order to work out ABC by value, in general it will be mixed sales + forecast . 1, if forecast $, we can use cheapest price as worse scenario; 2, if actual sales $ (invoiced price), which unit price should we use as one item usually has different price due to multi different discount for different customers? Thanks
Really excellent videos! Thank you very much, it's been very helpfull! Regarding to the forecast, is there a way to forecast for several items at once in excel? Or is it a manually task, where one has to pick up a forecast for each item time series and then aggregate it in a table like in the Data sheet?
Hello João, I am glad it was helpful for you ! Yes, you can forecast for several items at once. I would say that it doesn't matter if you have several forecasts that are family or items specific, or just one aggregated forecast, as long as you can get one table with all your items and forecasts that you will use for your classification. If you want to learn more about forecasting in Excel, you can check my video : th-cam.com/video/hy-u_ss7Wu8/w-d-xo.html Have a great day
I am a new subscriber.. I am working in a spareparts warehouse,am wondering how can I use this in this kind of warehouse. Just a newbie. Hoping for a kind reply.thank u
On 16:47 min on Column K3, I can see 80% being mentioned which has 113 counts, but that should be for >40% to 80% isn't it ? What I think is that, if you mention as 80% the total count for that should be 152 and not 113. Please correct me if I am wrong. And if I am right, can you write down how to put the figure for K3 ? Thank you
Hi. 113 is the count of B codes. 80% is just the upper limit range for B codes. So yes, B codes are in between 40% and 80%, I just put the upper limits in the K column.
Would you be able to explain why at the ABC table the revenue is classified as 40% for A, 80% for B and 80+% for C? Is that normal or does it depend on the company and products?
Hi, you can choose the percentages you want. It's all about grouping your products: in my example, the first 0.5%-1% of the products represent 10% of the revenue! So it was usefull to seperate A and B items at 40% and not 80%, to better identify the first class products that are critical
Starting at 13:30 - to get %item by dividing the rank / Nb of items doesn't make sense to me (=A4/E2). Divide total count of each item/Nb of (All) Items is what I know to get %item. Rank (an ordinal type, not numerical for division) was based on12 month Sales Volume. Am I missing something? Thanks for sharing.
Good Question ! As I pointed out in the video, we want the CUMULATIVE percentage item. Not the percentage of one item over the rest :) We get the cumulative percentage by starting with the first ranked items (A codes) and ending by the last ones. Thus, we can easily identify the 20/80 rule on the graph.
Hi Sten. Yes absolutely, usually for the warehouse ABC analysis, we use the volumes that leave (or pick) the warehouse in quantity to optimize flows and productivity. I could include this example, but the video was already too long for an introduction ;-) Do you want to see more details about ABC Analysis ?
thankyou but i cant undrestand why u give A code for less than 40% isnt it reverse?bc A code has the most part of revenue and should have more than 80% in formula? the second question is why u cumulate the percentages?itemes are diffrenet products not the same arent they? i appreciate if u answer clearly thanks for it❤
My pleasure Abd. I would definitely use ABC Analysis for inventory counting. I have been using it for many years with my warehouses and factories. You have 2 options : 1) ABC Classification based on the volumes of sales/movements/shipping 2) ABC Classification based on the volume of stock I would recommend the first option, and make sure you have more frequent inventory counting for A and B codes. WHY ? To guarantee the availability and inventory accuracy for your most strategic products. One of the main reason of poor service level is the incorrect information of available inventory. Your ERP/WMS thinks you have stock available, but in reality you don't and there is no automatic replenishment that can causes long term out of stock. Good luck with your inventory counting, hope you get more than 99% accuracy ;-) Edouard
what if I have one item that dominates more than 40% of the sales? By this definition that item will be in B category whilst in reality that's an A level product because of the contribution for the sales.
Iam struggling with this because I have more than one item of the same item ( e.g. I have 27 of item 1. And 24 of item 2!! This misleads the ABC grouping. Should I separate these by creating the same row 27 times?
Hi Bill, Thanks for you comment. This topic is covered in our free Inventory management course. You can join with this link : abcsupplychain.com/inventory-management-course/#minitraining
Hi Michael! The perfect order is the order delivered at the right time, quantity and quality. If you want to know more about KPIs, I'll have soon a MasterClass about the best KPIs and dashboards for your Supply Chain, you can register here: abcsupplychain.com/webinar-scm-metrics/
it's funny when i remember how much i did spend time to do gather the data for my ABC analysis for my end-of-study project while you have sum it up all in a 21 video xD .. why 40% and not 20% ?
Thanks Nosy, I tried to keep it as simple as possible with example ;-) Why 40% ? it's the common distribution we find for most of the company. 5% of your product/action/services represent 40% of your sales/results ... It can vary a bit. In my examples it's 7%, but it also depends if you include inactive or discontinued product in your ABC Classification. Take care, Edouard
My university just copied this exercise one-to-one, didn't even change the numbers, and claimed it's a new database for VW. This is feel like straight up plagiarism
If you know enough excel to do everything that he just did here, you can likely land an entry level job as an analyst in inventory/supply mangement. This is an underrated tutorial
Big applause from South Korea ! Such a perfect tutorial video for people who study for SCM.
Thanks for being my first South Korean comment 🙌 I will do my best to keep it up 🚀
This is the best tutorial that i've seen on this topic. Great tips, a deep view of the analysis and everything around it with a touch of humour. Perfect. Thank you so much!
Keep sharing videos.
I have spent hours to do abc analysis manually and after seeing you video, It took me 5 min
Glad it helped Ahmed! Yes, I plan to share more ;)
Fantastic tutorial on the ABC analysis and Pareto diagram.
Helped me save a day of studying the textbook.
Great to hear!
Ohh man, this video is excellent! It is the best tutorial about ABC analysis, thank you so much!!!!
Big thanks from Iraq for your efforts 🙏
You're welcome 😊
Thank you, very comprehensive explanation on the video also combine with the free excel template. Merci Edouard
Thank you sir! Very helpful in terms of big picture and technical work as well. Abdullah from Arabia.
This is a really great video, you have really simplified ABC analysis, thank you.
Thank you! Yes indeed, "keep it simple" is my mantra ;)
@@abcsc wow
It's also now my mantra, “keep it simple.”
Thank you Edouard Thieuleux for your kindness. much appreciated.
You are very welcome!
It is all time a pleasure to watch your video because it is very instructive.
Thank you for your good job.
My pleasure Nabil, more tutorial coming soon 🚀
Great Video. Thank you very much. Looking forward for more videos on inventory management
Thank you! About Inventory Management, I just released a new video: th-cam.com/video/p40SxvWFQ_A/w-d-xo.html
Briliant video & kudos for creating it. Simple demonstration, yet carries much values for day-to-day operations.
Glad you liked it!
Excellent..Simple and clear inventory management...thank you!! Looking forward for new videos.
Thanks J DO🙏 I am recording a new tutorial right now. Which topic do you want to see on this channel ?
Edouard
Thank you soo much😇
Stay blessed✨
May God Bless you.
Thank you for watching Hira !
Thanks for information and knowledge.
You're welcome!
Can't thank you enough ! sheer amount of hard work that has gone into making these videos and the wealth of knowledge you are sharing, Thank you!
Fantastic materials to revisit supply chain principles, thanks for your hard work!
Can't thank you enouph for that valuable information.
I have a question about ABC Model. Can this model can be executed in the level of components and materials?
Hello Edouard, thank you for explaining these fundamentals. This video, in combination with your other lessons, really help to have a holistic image of supply chain. However, I'm not a big fan of all those Excel tabs and data entry. I would like to have this combined with Power Query and later Power Bi. for automatic data- and report generation. Is this something you could do a course on as well?
Hi Jonas,
Power BI should be one of the next courses I release. I'm also waiting to dive deep in microsoft excel copilot to see the value there.
Excellent guide! Simple & easy to understand. I will comeback for more videos 👍
Looking forward for XYZ analysis 🙏
I am glad you liked it! Much more to come 😉
Thank you very much for your sharing! This is very helpful to me, I expect your coming supply chain videos !
Fantastic, I am happy that you enjoy my videos, stay tuned as there is more to come :)
Really helpful, Thank you. I have a question regarding the cumulative percentage volume calculation. If I follow exactly like you did, the percentage values goes above 100%.
Hi, thank you for your feedback. Well l am not sure I can help without seeing your sheet, double check your formulas ;)
You're welcome!
Hei, can you help with tips how to make ABC analyse without costs? I want to know only how often some produkt has been picked ? which one is most frequent ?
Can we use 10-20-70 rule for ABC analysis instead of 20-80.??
Really it was very helpful.
Glad to hear that!
Thank you very much , the video is absolutely great and informative . Looking forward for more such videos
Thank you very much for your feedback Sahil!
Merci édouard tu m’aides beaucoup 👌👌
Thanks, easy to follow. Please, continue :)
Hi first of all thank you for your video and explanation normally this is the same as the 20 80 rule if I'm not wrong but you do use 40% a A class, could you tell why ?
Hi Bilal. Yes indeed you can also do it with a 40/60 as shown in the video :) As you wish. Its all about grouping your products: in my example, the first 0.5%-1% of the products represent 10% of the revenue! So it was usefull to seperate A and B class at 40% and not 80%, to better identify the first class products that are critical
Thank you so much!!!
You're welcome!
Excellent, you are a Master
Thank you so much, glad you like the video :)
Thank you so much.
Very useful and specific video. Thank you so much!
Glad you enjoyed it! I am recording a new video about ABC XYZ analysis, you will love it ! coming very soon 🚀
Perfect and to the point. thank you for sharing the knowledge.
Awesome Very Informative Sir🙏
Kindly provide example for Hospital Pharmacy too
Thank you very much for your feedback! The analysis is the same for pharmaceutical products ;)
@@abcsc but sir in hospital industry we take A class item upto 70% value on the basis of consumption
Wow. I'm a Supply Chain Management student. I would want to know all the tool for inventory and the Supply Chain Management as a whole.
Then watch my videos and articles 😜
Thank you very much, Very Excellent Explanation. Actually, I'm dealing with retails with more than 15K items and more than 80 category, how can I differentiate the Percentages of ABC for each category or is it fine to have it all with the same percentage, is there any rule to specify the percentage??
Hi Sereen, the same applies here: just make your ABC Analysis with 15K products (here I did it with 500 products).
You could also make an ABC Analysis with 50 Category to see which ones are the most important (so you must sum the items' sales for each category).
Hi, how do you get the table Revenue Index 40, 80 and >80? Where can you find out in the corporation? Finance department or Sales Department?
Hi Michael! Well if you want to get the sales excel files, yes i guess ask to the finance department :)
so we will not also have to calculate susceptibility to theft in the abc analysis?
Brilliant! Thanks so much. If u could give some tutorials for how to do forecasting, it will be greatly appreciated
You're welcome! Yes it is coming, stay tuned ;)
@@abcsc one question! Regarding unit price in order to work out ABC by value, in general it will be mixed sales + forecast . 1, if forecast $, we can use cheapest price as worse scenario; 2, if actual sales $ (invoiced price), which unit price should we use as one item usually has different price due to multi different discount for different customers? Thanks
It was an excellent explanation of the systemt Thanks!!
Glad it was helpful!
great video thanks
Subscribed! I wish I could have a template of your Excel. I love that dashboard tab!
Really excellent videos! Thank you very much, it's been very helpfull! Regarding to the forecast, is there a way to forecast for several items at once in excel? Or is it a manually task, where one has to pick up a forecast for each item time series and then aggregate it in a table like in the Data sheet?
Hello João, I am glad it was helpful for you ! Yes, you can forecast for several items at once.
I would say that it doesn't matter if you have several forecasts that are family or items specific, or just one aggregated forecast, as long as you can get one table with all your items and forecasts that you will use for your classification.
If you want to learn more about forecasting in Excel, you can check my video : th-cam.com/video/hy-u_ss7Wu8/w-d-xo.html
Have a great day
I am a new subscriber.. I am working in a spareparts warehouse,am wondering how can I use this in this kind of warehouse. Just a newbie. Hoping for a kind reply.thank u
On 16:47 min on Column K3, I can see 80% being mentioned which has 113 counts, but that should be for >40% to 80% isn't it ? What I think is that, if you mention as 80% the total count for that should be 152 and not 113. Please correct me if I am wrong. And if I am right, can you write down how to put the figure for K3 ?
Thank you
Hi. 113 is the count of B codes. 80% is just the upper limit range for B codes. So yes, B codes are in between 40% and 80%, I just put the upper limits in the K column.
Would you be able to explain why at the ABC table the revenue is classified as 40% for A, 80% for B and 80+% for C? Is that normal or does it depend on the company and products?
Hi, you can choose the percentages you want. It's all about grouping your products: in my example, the first 0.5%-1% of the products represent 10% of the revenue! So it was usefull to seperate A and B items at 40% and not 80%, to better identify the first class products that are critical
Thanks so much for this video :)
You are so welcome!
Hey! You mention your inventory management course in the video. Where can I find it?
Hi Christian ! It is still under development in english. But you can join the waiting list here : abcsupplychain.com/inventory-management-course/
Starting at 13:30 - to get %item by dividing the rank / Nb of items doesn't make sense to me (=A4/E2).
Divide total count of each item/Nb of (All) Items is what I know to get %item.
Rank (an ordinal type, not numerical for division) was based on12 month Sales Volume.
Am I missing something? Thanks for sharing.
Good Question ! As I pointed out in the video, we want the CUMULATIVE percentage item. Not the percentage of one item over the rest :) We get the cumulative percentage by starting with the first ranked items (A codes) and ending by the last ones. Thus, we can easily identify the 20/80 rule on the graph.
Thank you!
You're welcome!
Hi, if in a Import itens company, working with Long LeadTimes (120days) how frequently would you make the ABC analysis?
Hi Edouard, is it possible to use your stock(how many products leave the warehouse) instead of revenue? Thanks for the video.
Hi Sten. Yes absolutely, usually for the warehouse ABC analysis, we use the volumes that leave (or pick) the warehouse in quantity to optimize flows and productivity. I could include this example, but the video was already too long for an introduction ;-) Do you want to see more details about ABC Analysis ?
@@abcsc Thanks for the response. Im currently using this method to rearrange a company's warehouse. Im interested in more details if you have them.
thanks for sharing this knowledge
i have a newbie question, im sorry but i dont understand, why did you take 40% revenue i thought A is around 70-80% contribution based on the value?
thankyou but i cant undrestand why u give A code for less than 40%
isnt it reverse?bc A code has the most part of revenue and should have more than 80% in formula?
the second question is why u cumulate the percentages?itemes are diffrenet products not the same arent they?
i appreciate if u answer clearly
thanks for it❤
superb
Is it possible to make a macro for the analysis or it won't work properly?
Hi! Of course it is possible, but this level of complexity is not worth it in my opinion. You can do it with simple formulas as shown in the video
@@abcsc okay, thanks!
Amazing....
how do you use ABC Analysis،
Can i use it for stock classification for inventory counting?🙏 thanx alot
My pleasure Abd. I would definitely use ABC Analysis for inventory counting. I have been using it for many years with my warehouses and factories. You have 2 options :
1) ABC Classification based on the volumes of sales/movements/shipping
2) ABC Classification based on the volume of stock
I would recommend the first option, and make sure you have more frequent inventory counting for A and B codes. WHY ? To guarantee the availability and inventory accuracy for your most strategic products.
One of the main reason of poor service level is the incorrect information of available inventory. Your ERP/WMS thinks you have stock available, but in reality you don't and there is no automatic replenishment that can causes long term out of stock.
Good luck with your inventory counting, hope you get more than 99% accuracy ;-)
Edouard
@@abcsc
Thank you sir, your advice 100% fullfilled my quastion. 😇
Can I use mark-up price*quantity for each product instead of revenue?
what if I have one item that dominates more than 40% of the sales? By this definition that item will be in B category whilst in reality that's an A level product because of the contribution for the sales.
Hi Irman! Well just raise the limit above 40% so your item is a A code ;) 40% is not a general rule
Iam struggling with this because I have more than one item of the same item ( e.g. I have 27 of item 1. And 24 of item 2!! This misleads the ABC grouping.
Should I separate these by creating the same row 27 times?
Hi! Well, just sum up the sales of that item and use one row :)
Hello, I am having a problem drilling down the formula. Each row contains an "A" with no B or C
Hi Bill, Thanks for you comment. This topic is covered in our free Inventory management course. You can join with this link : abcsupplychain.com/inventory-management-course/#minitraining
will you do a follow up video with XYZ?
I will ! ;)
Can we have the Excell dear?
All the links are in the description of the video.
abcsupplychain.com/download-excel-abc-analysis/
Great !!!!
where can I view the excel template shown in 20:03? Can't seem to find it anywhere.
This is from my Inventory Management course: abcsupplychain.com/inventory-management-course/
great
How do I calculate perfect order rate??
Hi Michael! The perfect order is the order delivered at the right time, quantity and quality.
If you want to know more about KPIs, I'll have soon a MasterClass about the best KPIs and dashboards for your Supply Chain, you can register here: abcsupplychain.com/webinar-scm-metrics/
I wonder y the % of revenue need to accumulate?
Why the revenue not the profit ?
You can also do it with the profit (products' margin) 😉
Why can't we download the practice file?
Yes you can, the link is in the description
it's funny when i remember how much i did spend time to do gather the data for my ABC analysis for my end-of-study project while you have sum it up all in a 21 video xD .. why 40% and not 20% ?
Thanks Nosy, I tried to keep it as simple as possible with example ;-) Why 40% ? it's the common distribution we find for most of the company. 5% of your product/action/services represent 40% of your sales/results ... It can vary a bit. In my examples it's 7%, but it also depends if you include inactive or discontinued product in your ABC Classification.
Take care,
Edouard
My university just copied this exercise one-to-one, didn't even change the numbers, and claimed it's a new database for VW. This is feel like straight up plagiarism
You explain way too fast...
I'll try to go slower for my next videos :) don't hesitate to read my article to go at your own rythm: abcsupplychain.com/abc-analysis/
Thanks i have some questions can i get your email??