What is the logic behind the XYZ classification?

[Former Member]

We performed the ABC-XYZ segmentation using data from version IBP2208 of SAP Best Practice.

In the Dashboard app, we have done the ABC-XYZ Segmentation

I looked at the "Actuals Revenue by ABC code, XYZ code and Product ID (last 12 months)" in the Dashboard app and it looks like the attached.

However, when I manually calculate the data provided in Best Practice, I get the result as shown in Excel. Since the coefficient of variation is larger for IBP-320 than for IBP-210, I think that IBP-320 should be classified as "Y" as well as IBP210.

However, the dashboard shows that IBP-320 is classified as "X". If you know the reason, could you please explain?

※

n：Number of pieces of data

ΣXi：Total quantity

ΣXi/n：Mean

Σ（Xi-μ）^2：Sum of the squares of the difference from the mean

Σ（Xi-μ）^2/n：Variance

√V：Standard deviation

√V/ΣXi/n：Coefficient of variationexcel.jpgdashboard.jpg

Thank you in advance.

Kana.Osawa