formula question - weighted sales/distribution

D

Dan

Hello - I am trying to calculate a weighted distribution problem, and I can't seem to come up with the correct calculation.

BRAND_X 1301512 97
BRAND_Y 691257 84
BRAND_Z 716962 41

BRAND_X had distribution in 97% of our accounts and sales of 1301512.
BRAND_Y had distribution in 84% of our accounts and sales of 691257.
BRAND_Z had distribution in 41% of our accounts and sales of 716962.

How can I calculate the ranking of these items based on their distribution and sales? As you can see from the example, BRAND_Z has good sales but small distribution.

Thanks for any assistance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RMD Question 2
weighted average profit margin 3
Too negative XIRR? 3
Force Distribution/ Force Ranking for Bell Curve 1
Detemine sales order based on plac changes and not sales figures -mathmatic problem to solve 1
Impact of negative sales on inventory weeks on hand 4
Analyzing data in collections of classes? 3
formula to project revenue 1

Top