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,

pankajj's avatar
pankajj
Helper III
6 years ago

Ashish_Mathur 

 

Hi Ashish,

 

Is there a quick way to get following results using RANKX in ABC analysis?

 

    1. Top 10% of annual cost to A
    2. Between 10% and 50% of annual cost to B
    3. Between 50% and 90% of annual cost to C
    4. Bottom 10% of annual cost to D

Looking forward for your kind response.

 

Thanks & best regards,

 

PG

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    Your question is not clear.  Share some data, describe the question and show the expected result.

    • pankajj's avatar
      pankajj
      Helper III
      6 years ago

      Ashish_Mathur 

      Hi Ashish,

       

      Thank you very much for your quick reponse and sorry for the delays from my side.

       

      I have figured another way to define ABC which is working fine.

       

      Thanks again. Have a wonderful day.

       

      Best regards,

       

      PG