On May 8, 3:41=A0am, HongKongMan <donotemailmeh...@[EMAIL PROTECTED]
> wrote:
> Hello Everybody,
>
> I forgot all my pre-biz math skills from first year and stupidly left
all =
my textbooks back home on the other side of the planet. =A0I need to
determi=
ne a function for determining a commision rate for order values of the
follo=
wing:
> =A0-Order value from $0 to $5000: 15%
> =A0-Order values greater than $5000 to $50000: decrease to 5%
> =A0-Order values greater than $50000: 5%
>
> Between $5000 and $50000 I would like the commission rate to decrease at
a=
decreasing rate so that the graph looks like a perfect curve. =A0This is
to=
ensure that the dollar value of the commission is always larger as the
orde=
r value increases. =A0Can anyone help me with this?
>
> Thanks!!!
Let C stand for commission, S stand for sales (in dollars)
C =3D .519897 - (log S)/10
plug in 5000 and you get .15, plug in 50000 and you get .05.
You could also express it as C =3D 51.9897 - 10 log S
and get the answer "in percent"
You get about the same drop in commission between 5k and 6k,
as you do between 40k and 50k. Keeps things in pro****tion.
You need a calculator with a log button, obviously.
By the way, 51.9897 =3D 45 + 10 log 5
|
