![Excel Excel](http://excelk.com/wp-content/uploads/2016/10/00154E-1.jpg)
As the title suggests im working on an ABC-analysis, and since I'm here, naturally I need some help/advice/tips..
Link o sheet:
https://1drv.ms/x/s!Asdl-iuZDQdchJ0h1ICV0Vx9usUQ0A
If you don't know what an ABC-analysis does, it sorts 'thing' after useage/cost/worth etc. (whatever you would like really) after certain criterias, whereas 'A-articles' is articles that stand for 80% of a companys total income, but only stand for 20% of the companys total number of different articles. This is called the '80-20 rule'.
So..Problem being.
I would like some formula (or some other way) to sort out theese articles.
As you can see in the sheet I have a column for 'avg.mothly use' and one for 'STD cost'. Theese are the columns I would like to use.
End of note: Please help me sort out the articles that stand for 80% of the total 'STD cost' and 20% of the total 'montly average use'
My excel language is set to swedish. I don't know if it automaticly changes to your preferred language.
Thank you!
![Abc Abc](/uploads/1/2/5/6/125613063/458681534.jpg)
The output is Power Pivot if I recall which is an addon to Excel however, it uses DAX so the pattern could be applied to BI. You'll note that @GregDeckler actually has looked at the same document and found a potential limitation or an improvement, however you look at it, it's pretty nifty.To be honest I have yet to have a project with an ABC need so I've never looked into implementation I. This is a good tool to assist in the calculations of ABC Analysis. However, as a long time supply chain professional I have been using this three prong approach for a number of years. Value, Quantity and Frequency of Sales for all items in the inventory is the crux of properly using ABC analysis/Pareto’s Law.