LINEAR_MIN_MAX_VALUATION Formula
The LINEAR MIN MAX VALUATION formula does not accommodate value ranges. Using this formula you can configure fees that increase based on a job valuation or a unit price. You can also determine the minimum fee and maximum fee for any fee item that uses this formula. For example, you can set up a plan review fee that is 65% of the total valuation, at least $10.00, but not more than $1000.00.
This formula takes into account user input: the quantity that the user enters when assessing the fee. For example, if a user assesses a fee for 1000 square feet, and the unit price for each square foot is $0.44, then the quantity of 1000 is multiplied with the unit price to calculate the fee. The quantity for a fee item based on a valuation is typically 1. For example, if a user is assessing a fee for a plan review and Civic Platform calculates the fee item based on the total job value, the user enters “1” to indicate that one plan review is complete.
Formula Equation
c,a,b,min,max or $FI00003$,a,b,min,max or a*$FI00003$ * X + b
Input Parameter Format
c,a,b,m,M
Example 1
Pool Heater Fee of $15 per pool heater.
X = number of pool heaters
Formula Parameter: $FI00003$,15,0,0,999999
Example 2
Electrical Base Fee of $25.00
X = 1
Formula Parameter: 0,25,25,25
Example 3
Inspection Fee of $80 per hour with a minimum of ½ hour.
X = number of hours
Formula Parameter: 80,0,40,999999
Example 4
A Plan Review Fee of 65% of the total Valuation.
X=1
Formula Parameter: $FI00003$,0.65,0,999999
Formula Calculation: The Valuation = $40,000.00
When you enter X = 1, the fee is then 40000*0.65*1+0 = 26,000.00
Example 5
A Police Impact Fee of $0.44/sq.ft. plus a base fee of $10.00.
X=2000 (enter in Sq. Ft.)
Formula Parameter: 0.44,1,10,0,999999
Formula Calculation:
If X = 2000 (or 2000 square feet), Fee = (0.44)(1)(2000)+10 = $890.00
Input Parameter Definitions
| c | The unit price or the fee indicator of a valuation. A fee indicator is a five-digit number between 10100 and 10599 that identifies a standard valuation or the value of a specific information field on an application. |
| a | The fee factor used to multiply the unit price or job value. For example, if you want to assess a fee of 65% of the total valuation, enter .65. |
| b | The base fee that you want to add to the product of C and A. For example, if you want to add a base fee of $10.00 to any fee, enter 10. |
| m | The minimum fee that you want to assess regardless of user input. |
| M | The maximum fee that you want to assess regardless of user input. |
| X | User input. |
Conditions
A fee indicator must be a five-digit number between 10100 and 10599.