How To Enter a Percentage Fee as a per Dollar Amount

Issue:

The intent of this feature is to simplify the ability to report and show "per $1,000". For example, they might charge a rate of $.50 per $1,000. This would mean that the fee on a $5 million project would come out to $2,500. This can currently be achieved inside of Estimator with a % fee. In this case, we are setting up a 0.05% fee.

However, this method is not always straightforward. In both creating the fee AND presenting it to the owner. If this is not translated correctly between the per $1,000 language and the percentage-based language, that can cause confusion.

Resolution:

We update the Fee User Interface to simply the workflow creating a Fee Type and Fee Target columns.

Fee Type - There are now 4 Fee Types - Bond, Lump Sum, Percent, and Per Value.

Fee Target - remain the same targets where you want to reference your fees.

The newly added Fee Type "Per Value" works the same as a Percentage Fee but rather than entering a %, the amount will be entered as a $ amount/$ amount.

When you set the Per Value for that fee the $ will be enabled in the Amount column, click the $ sign to open the Per Value Target window, set your fees, and click OK.

Example: Entering $0.50 / $1,000, equates to a 0.05% fee (0.50 /1,000 x 100)

Existing fees - Upgrading to the latest version

All existing fees will continue to work exactly as they were working before the upgrade.
The $$Fees$$ sheet on the Dashboard will remain the same and report on the percentage and not show as a Per Value amount.
Reports will work the same as well.

When existing fees are changed to be 'Per Value' fees

If the original fee type was set as a percentage
- The amount will default to the corresponding value, using $1,000 as the denominator
  - For example, a 1% fee changed to Per Value, would have an amount of $10 / $1,000
If the amount is not a percentage fee
1. The amount will default to $0.00 / $1,000
When Per Value fees are changed to by another type
1. If the new fee type is a percent
  1. The amount should default to the corresponding percent value.
  2. For example, a $10 / $1,000 per value would be changed to a Percent, which would have an amount of 1%

Otherwise

1. The amount should default to 0

Here are all of the possible Fee types that can be created. As you can see, Bond and Lump Sum don't have a Fee target

Under the Hood	How it is entered by the User
	Fee Type Value	Fee Target Value		Fee Type Value	Fee Target Value
Bond	Bond	n/a
Lump Sum	Lump Sum	n/a
% of Direct	Percent	Direct	OR	Per Value	Direct
% of Distributed Direct	Percent	Distributed Direct	OR	Per Value	Distributed Direct
% of Total	Percent	Total	OR	Per Value	Total
% of Labor	Percent	Labor	OR	Per Value	Labor
% of Material	Percent	Material	OR	Per Value	Material
% of Other	Percent	Other	OR	Per Value	Other
% of Sub	Percent	Sub	OR	Per Value	Sub
% of Equipment	Percent	Equipment	OR	Per Value	Equipment
% of Custom	Percent	Custom	OR	Per Value	Custom
% of Fee	Percent	Fee Name	OR	Per Value	Fee Name