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
, 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 |
+-------------------------------------------------------------------+
--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=514172