tellef wrote:
So let's put that all aside and say that my client has
picked the one factor that is the most important to them
in terms of weighing the profit%. Let's say that they
pick the profit$ as most immportant. I could simly sort
the RBase report by profit% DESC, and then profit$ DESC:
Salesman1 $1,500 40%
Salesman2 150 40
Salesman3 2,000 38
Salesman4 1,500 38
But again this doesn't look fair because Salesman3 was
clearly more 'productive' than Salesman2!
So here's my final question on this. Is there a formula
where I can 'weigh' the profit% by the profit$ so that
it gives me a number that is comparable between all 4 of
these guys!
Karen,
As Steve pointed out, there are many other factors in a profit than the
markup. If you sell $20,000 at a 20% markup but end up carrying the cost
for 4-5 months each time, even though you get paid every time, you
aren't making at 20% profit.
If profit$ is realistic, weight the profit$ by the % of total sales.
Nicky
================================================
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/
