Tag Archives: Pareto Analysis

Perform ABC Analysis (Pareto Analysis) using the DSUM () function : [Part 2 of 2]

In the previous post, you have learnt how to perform ABC analysis/Pareto analysis using the DSUM function. By now, after reading that post you must have realised that there were no product categories in the previous data – as a result of which all the SKUs (regardless of their product categories) that contributed to top 80% of the sales were classified as A class items. Now, it is quite possible that a particular SKU could have sales not in the top 80% of the overall sales but in the top 80% of the category sales that it belongs to. In order words, you would want each categories to have its own A , B & C Class SKUs. This requirement is a simple extension of the following two posts:

Perform ABC Analysis (Pareto Analysis) using the DSUM () function : [Part 2 of 2]

 

Let us see how…

Continue reading

Perform ABC Analysis (Pareto Analysis) using the DSUM () function : [Part 1 of 2]

In this post, you will be learning to perform ABC analysis using the DSUM() function. There are instances when a small percentage of causes in your business lead to a large percentage of impacts – meaning that drawing your focus on these small percentages of causes could help you have better control over the large percentage of impacts.

Perform ABC Analysis (Pareto Analysis) using the DSUM () function : [Part 1 of 2]

 

 

 

 

 

 

Now, Let us understand how we can use the DSUM() function that we have already learnt to perform ABC/Pareto Analysis….

Continue reading