I guess I was sleeping when they taught this... I want to
know if there is an established business statistics theory
for what I want to do. A client has a simple salesperson's
profitability report, and he wants it sorted from highest
profit margin to lowest. We have an RBase report to do this,
and the report looks like this:
#Sales Sales$ Avg$ Profit%
Salesman1 1 150 150 30%
Salesman2 50 10000 200 25
Salesman3 40 15000 375 20
Obviously sorting by Profit% is misleading. Salesman1 isn't
exactly their 'best' salesman! Salesman2 had the highest
number of sales and the highest profit% (after the loafer #1).
But Salesman3 had highest total sales$ and average$!
Is there a way to WEIGHT the profit%? And what's the best
indicator of the 'best' salesman? Is it the Total Sales$,
the Average$, the number of items sold? I guess if there's
a formula to weight the profit% then I could ask my client
what other parameter is the most important to them.
Karen
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
