FIXED_FEE_BY_RANGE_MULTIPLIER Formula
The FIXED FEE BY RANGE MULTIPLIER formula lets you assess a fixed, or set fee depending on the quantity that a user enters when assessing the fee. This formula calculates fees based on data in application specific information and multiplies the quantity that a user enters by the fee that you specify in the formula.
Formula Equation
| $FI10xxx$ | Fee |
|---|---|
| 1 - R1 | F1*X |
| R1 – R2 | F2*X |
| R2 – R3 | F3*X |
| R3 or more | F4*X |
Input Parameter Format
$FI10xxx$,F1,R1,F2,R2,F3,R3,F4
Example
Apply residential capital expansion fees based on square feet, where Civic Platform stores measurement for square feet in application specific information. Civic Platform applies fees according to this table.
| Library | Parks | Police | Fire | |
|---|---|---|---|---|
| Up to 700 Sq. Ft. | $260.00 | $866.00 | $64.00 | $93.00 |
| 701-1200 Sq. Ft. | $368.00 | $1227.00 | $91.00 | $132.00 |
| 1201-1700 Sq. Ft. | $433.00 | $1443.00 | $107.00 | $155.00 |
| 1701-2200 Sq. Ft. | $498.00 | $1659.00 | $123.00 | $128.00 |
| Over 2200 Sq. Ft. | $606.00 | $2020.00 | $150.00 | $217.00 |
Sample Use Case: Library Application 1
Square Feet: 700 Quantity Entered when assessing the fee: 1 The total library fee Civic Platform returns with the new fee formula is: 1 * ($260) = $260
Sample Use Case: Library Application 2
Square Feet: 700 Quantity Entered when assessing the fee: 3 The total library fee Civic Platform returns with the new fee formula is: 3 * ($260) = $780
Sample Use Case: Library Application 3
Square Feet: 800 Quantity Entered when assessing the fee: 3 The total library fee Civic Platform returns with the new fee formula is: 3 * ($368) = $1104
Sample Use Case: Library Application 4
Square Feet: 2600 Quantity Entered when assessing the fee: 3 The total library fee Civic Platform returns with the new fee formula is: 3 * ($606) = $1818
Input Parameter Definitions
| F | The fixed fee that you want to assess for any quantity that falls within the specified range of values. |
| R | The maximum value within a range of input quantities. |
| 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.
If you set up only one range, the fee is always equal to the fee for that range multiplied by the user input.