Forum Discussion

Mack1int's avatar
Mack1int
Frequent Visitor
8 years ago
Solved

ABC Analysis

Good Evening Everyone!    I have been working over the last few weeks on creating an ABC analysis however, I am still struggling with the calculations and formulas necessary to meet the requirement...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    See if my solution in this file helps.  I think some of your answers in the ABC column are wrong.  Please check my ABC column,

divyakolavil's avatar
divyakolavil
Regular Visitor
3 years ago

Hi,

I have a similar requirement, based on Div/Cat and Gender and YTD Sales Data i need to classify the Article Codes as ABC. The articles which contributes to the 70% of sales will be calssified as A, 70% to 90% as B, and 90% above as C. Below is the sample data. 

Thanks in advance

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Please study the file which i shared the link of in my post dated 23-11-2017.  Apply those formulas on your dataset as well.