PENALTY Formula

The PENALTY formula is similar to the MIN_FEE_ADD_ON formula, which lets you assess a penalty fee based on the total outstanding balance of new and invoiced fees added prior to the fee item with the PENALTY formula. For example, if the sum of all unpaid fees exceeds $3000, you can assess a penalty fee of $10.00 for every $1000 over a certain limit.

A unique feature of the PENALTY formula is that it figures user input in the equation. The user input referenced is the quantity that a user enters when assessing the penalty fee. You can set up the PENALTY formula with minimum fees and maximum fees. Civic Platform forces any penalty fee that falls below this range to the minimum fee. Civic Platform forces any fee that falls above this range to the maximum fee that you determine.

Civic Platform calculates the PENALTY formula as follows: Total fee assessed * X * (a/100) + b

Input Parameter Format

a,b,min,max

Example 1

10,5,50,9999

Total fees assessed is $100. The penalty fee calculation is:

X = 1

Penalty fee = $100 * 1 * (10 /100) + 5 = $15.00

Because the penalty fee of $15.00 is less than minimum fee amount, which is $50, the penalty fee is $50.00

Example 2

20,100,50,99999

Total fee assessed is $100. The penalty fee calculation is:

X = 1

Penalty fee = $100 * 1 * (20/100) + 100 = $120.00

Because the penalty fee of $120.00 is more than the minimum fee amount of $50 and less than the maximum fee amount of $99999, the penalty fee calculates to $120.00.

Input Parameter Definitions