ICBO_STYLE_ENHANCED Formula
The ICBO STYLE ENHANCED formula is similar to the ICBO_STYLE which lets you set up unique fees for a range of values that a user enters. The user input used in this formula is the quantity that a user enters when assessing the fee. Each range of quantities can have a unique minimum fee, a unique modular base, and a unique fee factor.
Unlike the ICBO_STYLE formula, you do not need to set up an individual formula with unique input parameters for each range. You can include the minimum value, the modular base, and the fee factor for each range within a single set of input parameters. The fee calculated is not dependent on any other range values.
Formula Equation
If X =< R1 (below Range 1), then Fee = M0 + N0 * Ceiling(X – R0) base B0
If R1 < X = R2 (Range 1), then Fee = M 1+ N1 * Ceiling (X – R1) base B1
Generalized:
If Ri < X = Ri+1, then Fee = Mi + Ni * Ceiling (X – Ri) base Bi
Out of Range:
If X > Rmax, then Fee = Mmax + Nmax * Ceiling (X – Rmax) base Bmax
Input Parameter Format
M0,N0,B0,R1,M1,N1,B1, (R2,M2,N2,B2, (R3,M3,N3,B3,...Rn,Mn,Nn,Bn))
Where,
Mi is the base fee.
Ni is the fee factor for range i.
Bi is the modular base for range i.
Ri+1 is the range above (R0 = Civic Platform assumes 0 for the low end).
Fi is the fee for range i.
Example
A Client requires a fee formula with a changing base fee plus a sliding percentage over a defined range of inputs. Such as:
| $1001 - $5000 | = $80.00 + 3% of excess over $1000.00 per 100 unit increment |
| $5001 - $10,000 | = $250.00 + 2% of excess over $5000.00 per 500 unit increment |
| $10,001 - $25,000 | = $350.00 + 1% of excess over $10,000.00 per 1000 unit increment |
| $25,001 and Over | = $520.00 + 3/4% of excess over $25,000.00 per 1000 unit increment |
Parameters:
(0,0,1,1000,80,.03,100,5000,250,.02,500,10000,350,.01,1000,25000,520,.0075,1000)
If X=500, not in the range
Fee = 0 + 0*(x-0)/1 = 0
If X=2050, first range
Fee = M1 + N1 * Ceiling(X – R1) base B1
Fee = 80 + .03 * Ceiling(2000 – 1000) / 100
Fee = 80 + .03 * 11
Fee = 80 + 3.3
Therefore, Fee = 83.3
If X= $30,000
Fee = M + N1 * Ceiling (X – R1) base Bmax
Fee = 520 + .0075 * Ceiling (30000 – 25000) / 1000
Fee = 520 + .0075 * 5
Fee = 520 + 0.038
Therefore, Fee = 520.04
Input Parameter Definitions
| M | The minimum fee for any job value within a range. |
| R | The minimum value within a range of job values. For example, if you want to configure fees for a range of job values between $1000 and $5000, enter 5000. |
| N | The fee factor used to multiply the range a job values. For example, if in addition to the minimum fee you want to charge 3% of the job value, enter, enter .03. |
| B | The modular base of the job value. The modular base determines how Civic Platform rounds off a job value, such as to the nearest tenth. |
| X | User input. |
Conditions
There is no limit to the number of ranges you can set up for this fee formula, but the total number of characters that you can use to enter input parameters is 500.
Any modular base (B in this formula) cannot equal zero and must be greater than one.