A flat fee is a single, fixed amount. It follows this formula:

The Factor will always be 1, so the Rate is equal to the amount of the fee.

To create a flat fee, continue as follows:

1. Select FLATFEE from the Fee Type drop-down list.

2. Enter a date in the Effective date field, or click the calendar icon to select a date.

3. Enter the rate in the Amount field.

4. Click Save.

An incremental fee is based on a set number of increments or units. Partial increments or units are rounded up to the next full increment. The Fee Type is used to calculate X dollars per increment, such as $10 per linear foot, $150 per yard, etc. The formula for this fee is:

The Quantity is the number entered by the end user in a linked data group or data field. The Increment is the per-unit used in determining the cost, and the Rate is the per-unit cost.

EXAMPLE The impact fee for fire and emergency services for a townhouse or duplex is $260 per housing unit. The Fee Code is linked to the R-TOWNDUP data field. End users enter the number of units in this box on the Case Data panel, and the fee code uses that value to calculate the amount. The increment is 1, and the rate per increment is 260. Therefore, a building permit for 10 townhouses would pay a fee of $2,600.

The equation is:

To add an incremental fee, continue as follows:

11. Select INCFEE from the Fee Type drop-down list.

12. Enter a date in the Effective date field, or click the calendar icon to select a date.

13. Enter a value in the Increment field.

14. Enter the amount of increase per increment in the Rate field.

15. Enter an amount in the Min Value field. If the calculated value of the fee is less than the value in this field, this value will become the default fee amount.

16. Enter an amount in the Max Value field. If the calculated value of the fee is greater than the value in this field, this value will become the default fee amount.

17. Click Save.

A variable fee is based upon a set of variables: Start Quantity, End Quantity, Increment (units), Rate, and Base. The variable fee type is typically used for complex fee schedules involving multiple milestones where different base rates and per increment rates apply. For example, a fee schedule could include a per-unit fee plus a base rate. The formula for this fee is:

NOTE: End Quantity is the milestone at which the new fee schedule begins.

The variable fee type can combine the Incremental fee type with a base rate.

EXAMPLE Consider an electrical inspection fee for commercial buildings. The fee schedule is $0.03 per square foot of total new construction square feet plus a $60 base fee. The fee code is linked to the C-PRJSQFT data field. The fee for a new commercial building of 10,000 square feet is calculated as follows: the end user enters 10,000 in the C-PRJSQFT field in the case data panel of the permit. This value is the Quantity variable in the equation. Therefore, the completed equation looks like this: The End Quantity is set to 1,000,000,000 (one billion). This is essentially infinity and means the fee will be $0.03 per square foot with no cap on square footage. Always use a large enough number to account for all potential scenarios. In this case, it is safe to assume no one will apply for a permit to construct a one billion square foot building.

The variable fee type can also accommodate a tiered fee schedule involving ranges of values where different fees and base rates apply.

The following fee schedule is for a police impact fee for commercial buildings based on the square footage of the building. The fee is linked to the C-OFFINST data field. The Start Quantity and End Quantity are the range in which the fee applies, the Increment is the unit used in the fee calculation, the Rate is the per-unit rate that applies to the range, and the base is the base rate added to the per-unit calculation. Thus, the fee for a 20,000-square foot building would be:

The fee schedule configured in the preceding formula above is:

• $536 per 1,000 square feet for buildings 0–25,000 square feet
• $339 per 1,000 square feet for buildings 25,001–50,000 square feet
• $191 per 1,000 square feet for buildings 50,001–100,000 square feet
• $162 per 1,000 square feet for buildings greater than 100,001 square feet

NOTE: The end quantity on this line is 1 billion, which accounts for everything over 100,000 square feet.

The base variable in this example is zero and makes the per-unit calculation of $10,720 the primary fee. Conversely, setting the rate variable to zero would make the per-unit calculation zero which in turn makes the base fee the appropriate dollar amount.

Another example is a tiered fee schedule with a per-unit rate plus base rate and base rate with no per-unit rate.

EXAMPLE This example of a commercial zoning compliance fee for new commercial buildings combines the different calculation methods and highlights the flexibility of the Variable Fee type. The fee schedule is $100 plus $2 per 100 square feet for buildings over 5,000 square feet. For buildings under 5,000 square feet, the fee is just $100. The fee code is linked to the C-PRJSQFT data field. The first line of the fee shows that values up to 5,000 do not have a rate. When the rate variable is zero, this zeroes out the per-unit fee and the base rate becomes the fee. Thus, the fee formula for a 2,000-square feet building is: The second line of this fee is applied when values greater than 5,000 square feet are entered in the related data field. The increment is 100, which accounts for the per-100 square feet in the fee schedule. The rate per-unit is $2. The base is $100. Thus, the fee for a building that is 12,000 square feet would be:   IMPORTANT: It is important to note that this fee is set up to exclude the $2 per 100 square foot for the first 5,000-square feet, even after the 5,000-square foot milestone is met. The preceding equation shows the $2 per 100 square feet will only be applied to 7,000 of the total 12,000 square feet of the building.

In the preceding example, the fee schedule will need to account for the total square footage once the 5,000 square feet milestone is reached.

If the $2 per 100 square feet is to be applied to the total square footage of the building (once the 5,000 square feet milestone is met), then the second line item in the fee code needs to account for that total. This is accomplished by rolling up those costs and adding them to the base fee in the line item.

• Calculate the per-unit cost for the first 5,000 square feet.
  • (5000/100) x $2 = $100.
  • The $100 is the total per-unit fee of the first milestone.
• Add this $100 to the base fee on the second milestone.
  • The second milestone’s base fee is now $200, rather than $100.
  • The $200 base fee accounts for the $2 per 100 square feet for the first 5,000 square feet of the building and the $100 regular Base fee.
• Check the math.
  • Accounting for all 12,000 square feet, the equation is:
  • ((12,000-5,001)/100 x $2) + $200 = $340

The completed configuration will look like the following:

IMPORTANT: If there were more milestones, the per-unit rate for each previous milestone would need to be "rolled up" and added to the base fee of the milestone range. It is a best practice to keep detailed notes and consider breaking the fee schedule into a combination of flat fees and variable fees to keep it simple.

The variable fee type is the most dynamic of the fee types. Nearly any fee schedule can be accommodated using the method it provides. However, it is very important to keep it as simple as possible. Tricking the system to calculate the correct fees is okay as long as it is thoroughly documented. Otherwise, when it is time to update the fees, you will have no idea what was done previously.

To add a Variable fee, continue by following these steps:

1. Select VARFEE from the Fee Type drop-down list.

2. Enter a date in the Effective date field, or click the calendar icon to select a date.

3. Enter the start and end quantities in the respective fields.

4. Enter the desired value in the Increment field.

5. If applicable, enter the value that the calculated fee will be added to in the Base field.

6. Enter the amount of increase per increment in the Rate field.

7. Click Accept.

8. Click Save.

A percentage fee is a percentage of the sum of selected fees on the permit. The Grand Sum, Data Group Code, and Detail Code fields on the Add: Fee Setup panel should be left blank.

PREREQUISITES: The fee code must be applied to the permit. The fee code must be added to the percentage fee code on the Fee Setup panel.

The Percentage field is the total percentage of the fee totals from the fee codes applied to this fee.

Click Click here to Add/Edit/Delete Fees to add fee codes to the percentage fee.

NOTE: Only the fees that are added here will be included in the calculation of the percentage fee. Therefore, when adding new fees, be sure to update the percentage-based fees as well.

IMPORTANT: Adding a minimum fee to a percentage fee is known to cause miscalculations. In PLL 2014 SP5, 2015, and newer, users will no longer be able to add minimum fees to a percentage fee calculation. If existing percentage fees include minimum fees, please be aware that selecting ALL Fees will cause a miscalculation.

To add a percentage fee, continue by following these steps:

1. Select PERFEE from the Fee Type drop-down list.

2. Enter a date in the Effective date field, or click the calendar icon to select a date.

3. Enter an amount in the Min Value field. If the calculated value of the fee is less than the value in this field, this value will become the default fee amount.

4. Enter an amount in the Max Value field. If the calculated value of the fee is greater than the value in this field, this value will become the default fee amount.

5. Enter a numerical value in the Percentage field.

6. Select ALL Fees or Unpaid Fees to indicate which fees to use when calculating the percentage fee.

7. Click the Click here to Add/Edit/Delete Fees link.

IMPORTANT: Adding the same percentage fee to its own setup is known to cause miscalculations. For example, if there is a 3% tax fee, including the 3% tax fee in the calculation will cause problems.

The selection window contains two fields: Available Fees and Selected Controls. The window also contains four arrow buttons.

The field on the left displays all the available tasks. The field on the right lists which fees will be included in the percentage fee calculation.

8. Select items in the Available Fees field by clicking on them.

TIP: Use <Ctrl + click> or <Shift + click> to select multiple items.

9. When you have selected the tasks you want, click Move highlighted item(s) to Selected list to add them to the Selected Controls field.

Fees may be removed from a template by selecting the task you wish to remove in the Selected Controls field and clicking Remove highlighted item(s) from Selected list.

You can move a fee up or down in the Selected Controls field by selecting the fee you wish to move and then clicking Move selection up or Move selection down until the item is in the desired place.

10. When you have added the fees you want, click Submit.
11. The fee(s) you selected now appears in the percentage fee sub panel.

12. Click Save.

A minimum fee is used in conjunction with one or more other fees. The sum of all the calculated fees on the permit must total at least the set minimum fee amount.

EXAMPLE For a $200 minimum fee, if the total of all other fees on the permit equals $190, then the minimum fee applied is $10 ($190 + $10 = $200). If the total of all fees equal $200 or more, no additional minimum fee is necessary.

NOTE: When configuring a minimum fee, the Grand Sum, Data Group Code, and Detail Code fields on the Add: Fee Setup panel should be left blank.

To add a linear fee, continue by following these steps:

1. Select MINFEE from the Fee Type drop-down list.

2. Enter a date in the Effective date field, or click the calendar icon to select a date.

3. Enter a value in the Amount field.

4. Click Save.

Custom fees give users the option to design new fee formulae to meet unique needs. However, predefined fees suffice in most situations, and it is recommended that they be used when possible.

IMPORTANT: Custom fees should always be kept as simple as possible, using as few case data details as possible, and should only be used by advanced users. Furthermore, custom fees should be thoroughly tested before being deployed in a production environment. As formulae become more complex, the likelihood of incorrectly defining a fee increases significantly. Custom fees should not be used as a substitute for properly configuring individual case templates or multiple fees. Creating complex custom fees can severely inhibit the performance of Cityworks software.

Custom fees are intended to be used with case data (data sum, data groups, data details). The values (or variables) within the case data can be used as input variables in formulae.

The supported operators for custom fees are:

• Basic math and arithmetic (addition, subtraction, multiplication, and division)

• Conditional "IF" functions

• Logical "AND" and "OR" operations

The supported variable types are:

• Case data details: Number, Value, Text, Comment, Yes/No, List, and Q1xQ2xQ3

• Case data group: Sum

EXAMPLE Writing custom fees with proper syntax: Basic Math and Arithmetic: $DETAILCODE$ + 50 Conditional IF functions: IF(“$DETAILCODE$ “ = “1”,50,0) Nesting: IF(“$DETAILCODE$” =”1”,50,(IF(“$DETAILCODE$”=”2”,100,(IF(“$DETAILCODE$”=”3”,250,400))))) Logical AND: IF(AND(“$DETAILCODE$”=”1”,” $DETAILCODE2$”=”concrete”),50,0) Logical OR: IF(OR(“$DETAILCODE$” =”2”,” $DETAILCODE2$”=”concrete”),50,0)

To add a custom fee, continue by following these steps:

1. Select CUSFEE from the Fee Type drop-down list.

2. Enter a date in the Effective date field, or click the calendar icon to select a date.

3. Enter the formula in the Fee Formula field, using the Insert Value drop-down list to enter the values drawn from case data fields.

IMPORTANT: The Insert Value drop-down list is populated based on the Data Group Codes and Detail Codes selected on the Add: Fee Setup panel. If those fields are left blank, the Insert Value drop-down list will be empty.

NOTE: Cityworks only allows two parameters when using the AND operator, which means that if more than two are needed then AND will need to be nested. For example:

IF(AND($[BD-HVAC]DWELUNNO$=0,AND($[BD-HVAC]NUMHVAC$=0,AND($[BD-HVAC]NUMVAV$=0,AND($[BD-HVAC]NUMCOOLER$=0,AND("$[BD-HVAC]NORDUCTS$"="Y",$[BD-HVAC]NUMCEH$=0))))),100,0)

TIP: Users can now create custom fees that use dates from case data to calculate fees. See Custom Fees Support Date Values for more information.

4. Click Validate to automatically test your formula.

5. Click Save.

A linear fee is calculated by multiplying the rate with the value. The linear fee is simple. The formula for this fee is:

The equation is:

EXAMPLE It is important that the data group or box provides descriptions on what the end user should enter. If the sidewalk frontage for a permit was 100 feet, then the fee would be $50.

To add a linear fee, continue by following these steps:

1. Select LINFEE from the Fee Type drop-down list.

2. Enter a date in the Effective date field, or click the calendar icon to select a date.

3. Enter a amount owed per unit from the data group in the Rate field.

4. Click Save.