Pareto's Law and ABCD ranking of items
 

I would like to apply this 80/20 law to groups of items within a given
vendor's line. I have attached a file with the following done.

1. Arrange the values in decending order
2. Calculate values as a percentage of the total
3. Calculate thd cumulative percentage in decending order.

What I'd like is a "A" - "D" Column to match the ranking below

4. A column identifying the sales history A B C D E
"A" ranked products responsible for 80% of sales
"B" ranked products responsible for 15% of sales
"C" ranked products responsible for 4% of sales
"D" ranked products responsible for 1% of sales

5. I'd also like to see how the listing below is expressed.

First 40%, cumulative 40% are "A" items
Second 40% cumulative 80% are "B" items
Next 15% cumulative 95% arer "C" items
Next 4% cumulaitive 99% are "D" items
Last 1% cumulative 100% are "E" items


+-------------------------------------------------------------------+
|Filename: ABCDE RANKING.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4374 |
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=514137

Pareto's Law and ABCD ranking of items
 

What I'm looking for here is a formula for the ABCDE column


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=514137

Pareto's Law and ABCD ranking of items
 

I'd like a formula in the ABCD column that reads the percentage and
displays A or B or C or D


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=514137