LINEAR_WITH_MIN_MAX_ENHANCED Formula
The LINEAR WITH MIN MAX ENHANCED formula is similar to the LINEAR_WITH_MIX_MAX formula in that you cannot use valuations. This formula calculates fees based only on the quantity that a user enters when assessing a fee. You can however, set up input parameters for multiple ranges of quantities. For example, you can assess a design review fee of $350 per house unit, and $150 per house unit after 15 units.
Formula Equation
ai * (X – Ri) + bi
| X | Fee |
|---|---|
| 0 - R1 | a * ( X ) + b |
| R1 – R2 | a1 * ( X – R1 ) + b1 |
| R2 – R3 | a2 * ( X – R2 ) + b2 |
| R3 or more | a3 * ( X – R3 ) + b3 |
This formula assumes the initial range begins with zero. You can enter the minimum value only for subsequent ranges. For example, if you want an initial range of 0-5, enter “5” as the R1 input parameter.
Input Parameter Format
a,b,m,M,R1,a1,b1,m1,M1,R2,a2,b2,m2,M2,...Rn,an,bn,mn,Mn
Example 1
Design Review Fee ($350 per house unit, $150 per house unit after 15 units)
| X | Fee |
|---|---|
| 0 - 15 | 350 * X + 0 |
| 15 or more | 150 * (X – 15) + 5250 |
X = number of house units
Formula Parameter: 350,0,0,9999999,15,150,5250,0,9999999
Formula Calculation:
So, if X = 10 house units, then Fee = 350 * 10 + 0 = $3500.
So, if X = 20 house units, then Fee = 150 * (20 – 15) + 5250 = $6000.
Example 2
A Day Care Operation Fee:
| x | Fee |
|---|---|
| 0 - 6 | 35 * X + 0 |
| 7 -12 | 50 * (X – 12) + 50 |
| 12 or more | 50 * (X – 12) + 50 |
When the number of children is less than 6, fee = $35.00
When the number of children is between 7 and 12, fee = $50.00
When the number of children is greater than 12, fee = $50.00 + (X –12)*2
X =number of children
Formula Parameter: 0,35,0,999999,6,0,50,0,999999,12,2,50,50,999999
Formula Calculation:
So if X = 5 Children, then Fee = 35 * 5 + 0 = $175.00
So if X = 10 Children, then Fee = 50 * (10 –12) = $500.00
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. |
| R | The minimum quantity within a range of quantities. For example, if you want to assess a unique fee for quantities greater than or equal to 5, but less than 15, enter “5” for R1 and “15” for R2. |
| X | User input. |