On May 8, 9:13=A0am, gearhead <nos...@[EMAIL PROTECTED]
> wrote:
> 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 =
all my textbooks back home on the other side of the planet. =A0I need to
det=
ermine a function for determining a commision rate for order values of the
f=
ollowing:
> > > =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
i=
s to ensure that the dollar value of the commission is always larger as
the =
order 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)- Hide quoted text -
>
> - Show quoted text -
Oops, I left out a factor of ten.
Anyway, here's the most intuitive way to write it:
C =3D 45 - 10 log (S/5)
|
