ICBO_STYLE Formula

The ICBO STYLE formula is similar to the ICBO_BLDG_PERMIT formula in that it lets you configure fee formulas for a range of values.  Instead of calculating fees based on job values, the ICBO_STYLE formula bases fees on the quantity that users enter when assessing fees.

For each range that you include in the ICBO_STYLE formula you must determine the maximum quantity in that range, the fee factor for that range, and the modular base for that range. You should also determine the minimum fee for any within any range. The fee for each quantity that falls within a pre-defined range is dependent on the sum of fees for all previous ranges.

Input Parameter Format

M,R1,N1,B1,R2,N2,B2,R3,N3,B3,...Rn,Nn,Bn

Where,

M is the minimum fixed fee.

Ri is the range below.

Ri+1 is the range above.

Ni is the fee factor for range i.

Bi is the modular base for range i.

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
$5001 - $10,000 = $250.00 + 2% of excess over $5000.00
$10,001 - $25,000 = $350.00 + 1% of excess over $10,000.00
$25,001 and Over = $520.00 + 3/4% of excess over $25,000.00

You must break down this fee schedule into four individual formulas, one for each range.

Parameters:

Formula1 = (80,1000,.03,1,5000,0,0) for the $1001 - $5000 range

Formula2 = (250,5000,.02,1,10000,0,0) for the $5001 - $10,000 range

Formula3 = (350,10000,.01,1,25000,0,0) for the $10,001 - $25,000 range

Formula4 = (520,25000,.0075,1,999999,0,0) for the over $25,000 range

If X=2000, the user must enter X into Formula1, because R1 < X = R2, then

Fee = M + N1 * (mod(X) base B1 – R1) / B1

Fee = 80 + .03 * (mod(2000) base 1 – 1000) / 1

Fee = 80 + .03 * (2000 – 1000) / 1

Fee = 80 + .03 * 1000

Fee = 80 + 30

Therefore, Fee = 110

If X= $30,000, the user must enter X into Formula4, because R1 < X = R2, then

Fee = M + N1 * (mod(X) base B1 – R1) / B1

Fee = 520 + .0075 * (mod(30000) ) base 1 – 25000) / 1

Fee = 520 + .0075 * (30000 – 25000) / 1

Fee = 520 + .0075 * 5000

Fee = 520 + 37.5

Therefore, Fee = 557.5

Input Parameter Definitions

M The minimum fee for any job value; a fixed fee for job values within your first range of job values.
R The maximum value within a range of quantities. For example, if you want to configure fees for a range of quantities between 0 and 500, enter 500.
N The fee factor used to multiply the user input. For example, if in addition to the minimum fee you want to charge 3% of the total quantity, enter .03.
B The modular base of the job value. The modular base determines how Civic Platform rounds off a user input value, such as to the nearest tenth.
X User input.

Conditions

  • If you want to set up a fee formula with a changing minimum fee for each range of quantities, you must set up individual fee items for each range. Each fee item can use only one formula. When you create the fee item, make sure you enter the input parameters and choose the formula that is appropriate for the range you want to set up.

  • 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.

  • If you set up only one range of job values, the fee is equal to the minimum fixes fee (M).

  • If you configure multiple ranges up to Rn, the fee includes the sum of the minimum fee and the maximum fee for all other ranges up to and including Rn-1.