LINEAR_WITH_MIN_MAX Formula

The LINEAR WITH MIN MAX formula is the simplest fee formula. This formula does not account for value ranges, and you cannot use valuations with this formula. This formula calculates a fee based on the product of the quantity that a user enters when assessing a fee and the unit price.  For example, if the unit price for a single pool heater is $15.00, the fee for two heaters is $30.00.

Formula Equation

a * X + b

Input Parameter Format

a,b,m,M

Example 1

Pool Heater Fee of $15 per pool heater.

X = number of pool heaters

Formula Parameter: 15,0,0,999999

So, if X = 5 heaters à Fee = 5 * 15 = $75

Example 2

Electrical Base Fee of $25.00

X = 1

Formula Parameter: 0,25,25,25

So, if X = 1 à Fee = $25

Example 3

Inspection Fee of $80 per hour with a minimum of ½ hour.

X = number of hours

Formula Parameter: 80,0,40,999999

So, if X = 5 hours à Fee = 5 * 80 = $400

So, if X = 0.25 hours (or 15 min.)à Fee = $40 (because 0.25 * 80 = $20, which is less than $40, the minimum fee.)

Input Parameter Definitions

a The unit price. For example, if you want to assess a fee of $15.00 for a single pool heater, enter 15.
b The base fee that you want to add to the product of “a” and the quantity that a user enters when assessing the fee. For example, if you want to charge a base fee of 25.00 for any electrical work, enter 25.
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.