|
How
do I write complex commission formulas?
This may seem a bit confusing at first but in no time you'll
be writing complex formulas very easily.
Basic Sliding Scales
Route Expert uses simple algebra to write complex formulas.
Using the event codes in formula 1 allows the user to apply that value
in formula 2. Formula 2 uses 'X' to represent the value of
the result of formula 1.
Example 1:
Formula 1: CO + OS
- LE - LD
Formula 2: IF (X<100,X
* 0.25, IF(X<250, X*0.30, IF(X<400, X*0.35,
X*0.40)))
This is an example of a simple sliding scale using algebra. Simply
put the formula takes the Coin (CO) adds it to the Operator
Service (OS) and then subtracts the LEC Bill (LE) and the
Long Distance Bill (LD) to generate 'X'. The value
of the total is then plugged into formula 2 represented by the 'X'.
Formula 2 simply states that if X is less than $100 multiply X
by 25%, else if X is less than $250, multiply X by 30%,
else if X is less than $400, multiply X by 35%, else
multiply X by 40%. The value of Formula 1 is multiplied by
the highest percentage in the sliding scale.
Example 2:
Formula 1: $250(CO) +
$50(OS) - $60(LE) - $10(LD) =$230
of revenue
Formula 2: IF (230<100,
230*25%, IF(230<250,230*30%,
IF(230<400, 230*35%,
230*40%)))
Since 230 is less than 250, the 230 of
revenue will be multiplied by 30% (230* 0.30) producing a commission of
$66.00.
Example 1 shows how the formula is written in Route Expert.
Example 2 shows how it is uses.
Tiered Sliding Scales
Using the example above suppose you wanted to pay 25% of the first
$100 of revenue and 30% of $101-250 and so on. Using the SLIDE
function allows the user the ability to apply tiered sliding scales in
Route Expert.
Example 3:
Formula 1: CO + OS - LD - LE
Formula 2: slide(X) *0.25 +
slide(X - 100) * 0.05 + slide(x-250) * 0.05 + slide(X-400) * 0.05
Simply put, the formula pays 25% of the first $100 and adds 5% of
revenues over $100 and under $250 and then adds another 5% of the
revenue over 250 and under $400 and adds another 5% to all revenues over
$400.
Using the $230 from Example 2 the account would receive a commission of
$64.00 (25% of $230 + 5% of $130)
|
|
