ABC XYZ Analysis for Inventory Management: Example in Excel (Full Tutorial)

Hi Eduard. Thanks for some truly great videos.
Do you have any rule-of-thumb regarding the percentage of items which should be classified as X, Y and Z?

Hi Edouard, the tutorials are quite helpful. In this video you have mentioned about the 2nd method but its not covered in the video and I have not been able to find it in other videos of your. It would be quite helpful if you can share the 2nd method as well.

Great video. Exist some difference between the use of standard deviation of a sample and standard deviation of a population in the formula? Which is better?

HI Eduourd, thanks for this video. Its helpful to do the analysis. I had a question. While doing the ABC analysis, we did it on the basis of value but while doing the XYZ analysis, do we need to do it on the basis of volumes or value and if yes on value, how can we calculate safety stock on XYZ based on value? Thanks.

Does your course come with the full access to your excel database/dashboard? I'm thinking of signing up for you course. This is great information. I appreciate your sharing and educating.

How often do you recommend updating ABC XYZ?

Thank you very much.But in 11.13 secs - can you explain why we need low safety stock for AZ (we do have high uncertainty and volumes are high).I guess it should be HIGH SAFETY STOCK

2 videos into this absolute masterclass of a channel and I am blown away! Thank you so much for explaining complicated concepts so clearly! I have a question, when you were talking about standard deviation in this video as a way to measure how fluctuative a particular product is, the column next to it is called "coefficient variation" and there is a percentage number, how is that calculated? I did a rough test and could it be Std. Dev/Average Sales? Anyway I will be watching the rest of the videos in this channel now, thank you so so much for the amazing material you've put up Mr Edouard!

Life saver✨

very good video, thank you very much!

Great video!
I have some doubts. If I work at supply management I should make the global ABC XYZ analysis by costs or quantity to use(units, kg, etc) of the insums and materials used for production? On the other hand I should do the analysis according the type of insume for example ABC XYZ analysis for colorants wich uses 0,01 kg per ton according the colour. Other ABC XYZ analysis per fragances wich uses 20 kg per ton and so on.
I am looking forward for you reponse. Thanks a lot.

Hi, thank you for this video. But ı need different and complicated XYZ formula.

Wow. I just discovered this very underrated channel. I can't wait to watch your free cources. Thank you so much. You got my subs.

hey I have a question: if we already calculate the ABC base on average sales performance, isn't that already take the % fluctuation into account. It seems XYZ is redundant if I put it that way ?

Thank you so much for your videos!! They are very inspiring! My question is, when performing ABC xyz analysis, should we be using monthly dollars booked (incoming sales), or monthly sales (outgoing sales)?

Excellent overview, thank you!

I enjoyed this video a lot. Great job! Can you share a video about product distribution? for example from Distribution Centers to Stores? best practices and analytics. Thanks!

Amazing analysis! Thankyou

Category AX you’ve listed as having high safety stock but given high volume low variation the opposite should be true

Thanks for yet another great tutorial. Will using data per day or week give a better result? Or is it just overkill? I have the consumption data per day and have to merge it to week or month to calculate with those periods.

Hi Edouard. Thanks for this very enlightening video!
I've seen examples where the square of the Coefficient of Variation (CV²) is used.
What benefit/disadvantages does this have in comparison to the method you demonstrated?

I am 3 weeks into my first ever job as supply chain analyst and this is GOLD.

Thanks a lot Edouard for sharing the knowledge in a very clear way. It is really a great starting point for me to step into supply chain domain :).

Good Job ! Edouard.

Hi Edouard, where we can download the excel example? Thanks for your sharing. It's helpful

when there be another free workshop in July! hope there is, your classes are great.

Thanks a lot, Edouard! Great video and it's very easy to understand and follow through it. I just keep watching one after another!!! Very addictive! I realized this tool is no longer available when I tried to download it. Can you please make it available again? Really appreciate it!

Hi Edouard, thanks for the video, very helpfull! I'm currently working on a business project with a large data set that I'm doing an ABC-XYZ analysis on.
I have one complex question that I hope you can help me with, concerning the calculation of average and ST.D. for the XYZ part. 
First the question: How do I input 0 values in the blank cells in between the sales data values, and not in the blanks before and after the actual sales values (only during the PLC)?

And then the explanation (may be needed to understand the question):
I have data on 2000 SKU's (columns) over a period of 36 months(rows). The SKU's have different PLC's as they are introduced during the full data period, and therefore I have a lot of 0 values in different columns and rows in the dataset, and some SKU's have 0 sales during the PLC as well. In order for Excel to work automatically for me, I have replaced all 0's with blanks so they don't affect the average and ST.D score, but I need excel to keep the 0 values that were during the product life cycle, otherwise the average will be too high and ST.d will be to low to reflect the real picture of the SKU's.
So how do I input 0 values in the blank cells in between others values, and not in the blanks before and after the actual sales values?

Worst case I will have to go through all 2000 lines manually ;)

Thanks!

Great video. I am graduated in management engineering, and i found your video very useful!

I perfomed the ABC XYZ analysis on my
company's item !

I have some issues related to the coefficiente of variations : our demand Is affected by High seasonality

How could we deal with It?

Great job, many thanks Edouard. I have a question: when you have to analyze 4000 items, with different units of measurement (pcs, Kg, etc), how do you do the ABC classification on the quantity consumed?

Great job. Where i can find the execl sheet?

Thank you for uploading. I've been waiting for a long time now. Your singular ABC helped me categorising the amount of sales (in quantity) for 400 sterile hospital disposables. Since february have I been working to optimize two decentral strorages at the OR. I've made a double ABC by bonding the amount of order quantities to amount of sales (in quantity). That way I selected a couple disposables to be replaced? What do you think of this method? Should I continue with this or should I try it your way? I'd like to hear tour opinion. Thanks in advance

Great explanation, well done. I myself opt for a lower SS on "AX" materials as those are expensive and due to predictability the business can give good enough service level without needing to tie up lot of cash. Sure companies can have different lead times and agreements which need alternative stock keeping strategy.

Thanks. Great Video