Need help creating a function

[nander]

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

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

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

 

[Leith Ross]

Hello Nander,

To determine the sales ranking corrrectly would require including the
cost of each item. Without using a weighted average, you can't actually
determine which item(s) is/are responsible for 80% of the sales in
dollars. The only time quantity would be an accurate gauge is when you
are being paid piece rate.

Sincerely,
Leith Ross

 

[nander]

Hope you can take another look. Thanks

 

[Leith Ross]

Hello Nander,

Thanks for adding the costs. I added some columns to the worksheet to
give you a better breakdown analysis. All the additions are in the
attached workbook. You can easily see the 80/20 rule applies here.
There are 4 items in your list of 16 that produce 80% or more of the
sales dollars. You can also see the difference between the simple
average based on the total pieces as compared to weighted average based
on sales dollars per item. If you have any more questions or need help
with something, you can e-mail me at (e-mail address removed), or send ame a
private message here at the Excel Forum.

Sincerely,
Leith Ross


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