On May 8, 9:04=A0am, gearhead <nos...@[EMAIL PROTECTED]
> wrote:
> 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
al=
l my textbooks back home on the other side of the planet. =A0I need to
deter=
mine a function for determining a commision rate for order values of the
fol=
lowing:
> > =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
or=
der 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. =A0Keeps things in pro****tion.
>
> You need a calculator with a log button, obviously.
>
> By the way, 51.9897 =3D 45 + 10 log 5
I just thought of a more pleasing way to express it:
C =3D 45 + log (5/S)
|
