Bill Rate Dilution

You can set up your Unanet system to allow dilution of bill rates. Bill Rate Dilution simply means that bill rates are adjusted down for any time worked over the normal amount. Let's look at an example:

Joe is an employee whose hourly bill rate is $100/hr. He is working on a project contract and is supposed to bill no more than 40 hours per week to the customer. This week, Joe worked 50 hours. Using Bill Rate Dilution, the Unanet system can adjust his rate by taking the hours available (40) divided by the hours worked (50) to come up with a factor of .8 (4/5). This factor can then be applied to his bill rate of $100/hr to come up with a diluted bill rate of $80/hr. This satisfies the project contract requirement to not bill more than 40 hours per week.

Using Bill Rate Dilution

In order for your system to allow the use of Bill Rate Dilution, you must first enable it in the unanet.properties file by adding the following line if it is not already there, and restarting your servlet engine:

unatime.select.bill.dilution=true

Bill Rate Dilution adjusts the bill rate of people based on the hours that they worked versus the hours available (input by the user). There is currently only one method used by the Unanet system to dilute bill rates. This method involves the user of a report choosing to see diluted bill rates and then entering the available hours for the period. You should always enter the available hours based on the date range that you use for the report. The following screens have the option of using Bill Rate Dilution:

Reports - People - Time Detail

Reports - People - Summary

Reports - Project - Time Detail

Reports - Project - Summary

Reports - Project - Billing

Reports - Financial - Funding

Reports - Project - Variance

On the selection criteria page for each of these screens, you can select whether or not to see diluted bill rates and what the available hours should be. If you choose to see diluted bill rates, you must enter the available hours. Here are the two variations of what the selection criteria looks like:

It is important to note that Bill Rate Dilution only acts on data as it is displayed on the reports. No data in the database is stored as a result of the calculations, so each time you want to see diluted bill rates, you must enter in the available hours on the report selection criteria.

Return to Unanet Table of Contents page