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,

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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,

  • Mack1int's avatar
    Mack1int
    Frequent Visitor
    8 years ago

    Thank You so much for all of your help! 

  • 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.

      • divyakolavil's avatar
        divyakolavil
        Regular Visitor
        3 years ago

        The file is not accessible , it says the item might not exist/no longer available. Could you please reshare it?

         

        Thanks