The Unanet system can be configured to dilute both cost rate and hours information. When enabled, both effective rates and effective hours are calculated and stored.
The Unanet concept of Dilution may also be referred to in your organization by one of the following terms: Total Time Accounting, Adjusted Rates, Auto Adjust, or Uncompensated Overtime.
Topics covered on this help page include:
Styles of Dilution
Style 0 Dilution (This is the default. No Dilution is calculated)
Style 1 Dilution (This is the basic cost dilution methodology -- dilute rates up and down)
Style 2 Dilution (Variant of Style 1 -- only dilute rates if hours worked is > hours in period)
Dilution - Knowledge Center Topics (search for this topic in the Knowledge Center)
Quick Topic - Dilution for Salaried Employees with Non-Standard Business Weeks (e.g., 32 hours per week) (search for this topic in the Knowledge Center)
When dilution is enabled, rates are adjusted based on the number of hours a person worked versus the number of hours available in a given period. The simplest example of this is when you have an exempt (salaried) employee and they work 80 hours in a week. Since their cost rate is probably based on a 40 hour week, their effective cost rate, or diluted rate ends up being half of their normal rate (such that the actuals hours worked times their effective cost rate will equal their period salary). If it wasn't, their salary for that week would double!
At the end of each period (after a user has entered all of their time and had it approved), the dilution calculations are triggered and a Dilution Factor is calculated and applied to their cost rate to arrive at their effective (or diluted) cost rate.
When dilution is enabled, Unanet reports will reflect the effective/diluted cost rates (for those timesheets having reached the COMPLETED status). Further, both undiluted and diluted rate information will be available for export to downstream systems.
Hours dilution is similar in concept to the rate dilution. Once a timesheet has reached the COMPLETED status, the calculated dilution factor is also applied against the number of hours. Currently, diluted hours values are only available in the Unanet ad-hoc reports rather than the Unanet built-in reports. Both undiluted and diluted hours values, however, are available for export to downstream systems.
Note Unanet Dilution periods must align with Unanet Time Periods.
To enable dilution in Unanet, the unanet.properties file must be updated to include the Cost Dilution Method (unatime.cost.dilution.class) property (which enables both the cost rate and hours dilution functionality).
Note that when enabled, cost information in the system will reflect the diluted cost values (once a timesheet has reached the COMPLETED status), but diluted hours will not be reflected in any reports (the diluted hours are available for exporting to a downstream system --- again, once the timesheet has reached the COMPLETED status).
Note that when you initially activate the dilution properties, it will take effect with current timesheets as they are completed (ie. it will not automatically dilute all previously entered time).
** IMPORTANT ** Dilution is only applied to users having the Salaried Classification.
You can enable dilution with or without having cost rates stored in the system (i.e., if you were only interested in the hours dilution).
The following concepts are used in support of the timesheet dilution processing.
Dilution Hours / Business Hours
Dilution Hours - (Business Hours Factor * (Hours Charged to (Undiluted) & LWOP pay codes) )
Hours Charge to (Diluted) pay codes
Style 0 dilution is the default, and is basically NO DILUTION. It simply means that no cost dilution is performed. The effective cost rate and effective hours are always the same as the regular cost rate and hours, and the dilution calculations are never performed.
Style 1 dilution is standard dilution, where effective cost and effective hours worked values are adjusted either up or down if the quantity of reported hours either falls short of or exceeds the expected hours for a time period.
(Dilution Hours - (Business Hours Factor * (Hours Charged to (Undiluted) & LWOP pay codes) ) )
Hours Charged to Standard Pay (Diluted) pay codes
If Hours Charged to Standard Pay (Diluted) pay codes is zero, Dilution Factor will be set to one.
Style 2 dilution is a modified version of Style 1 dilution, where effective cost and effective hours worked for regular time is only adjusted down if the quantity of reported hours exceeds the expected hours for a time period.
Note: This is legacy behavior and is only maintained if the property Set Dilution Business Hours in Period from Dilution Hours (unatime.cost.dilution.business_hours_from_dilution_hours) is set to true. If this property is not set to true, it is possible for this dilution style to dilute up, or increase the cost rate, if the number of dilution hours in the time period is less than the number of business hours in the time period. A common situation in which this might occur would be for semi-monthly time periods in the last half of February.
This Style of Dilution is likely obsolete with the introduction of the Business Hour Factor and LWOP pay codes.
(Dilution Hours - (Business Hours Factor * (Hours Charged to (Undiluted) & LWOP pay codes) ) )
Hours Charged to Standard Pay (Diluted) pay codes
If Hours Charged to Standard Pay (Diluted) pay codes is zero, or
If Hours Charged to Standard Pay (Diluted) pay codes is <= (Dilution Hours - (Business Hours Factor * (Hours Charged to (Undiluted) & LWOP pay codes) ) )
Dilution Factor will be set to Business Hours Factor.
Dilution will be applied to time slips for a timesheet as follows:
For time slips charged to an Standard Pay (Undiluted) or LWOP pay code, the Business Hours Factor will be used to calculate effective cost rate and effective hours worked.
For time slips charged to a Standard Pay (Diluted) pay code, the Dilution Factor will be used to calculate effective cost rate and effective hours worked.
When dilution factors are being applied to effective cost and effective hours worked during the rating process, the applied factor for time slips shall be:
Business Hours Factor for time slips charged to a Standard Pay (Undiluted) or LWOP pay code
Dilution Factor for time slips charged to a Standard Pay (Diluted) pay code
A factor of one for time slips charged to an Additional Pay (Undiluted) pay code
When rating:
For timesheets where the timesheet owner is not salaried, pay code factors should be applied to cost rate for all time slips.
For timesheets where the timesheet owner is salaried, pay code factors should be applied to cost rate for time slips charged to Additional Pay (Undiluted) or LWOP pay codes only.
Note that the dilution calculations do not occur immediately (i.e. it wouldn't make sense to attempt to calculate a user's diluted cost rate after entering 8 hours on Monday).
Dilution, when using a style other than Style 0, is triggered by the following:
Note that previously entered time is not diluted when the dilution properties are activated. That is, only those timesheets moving through the approval process will be diluted going forward.
The People Profile >> Dilution screen is available to the Admin on the People Profile screen to allow for the viewing of person dilution information (recalculate status, factors, etc.). This screen also offers the administrator the ability to manually trigger the recalculation of a person’s dilution information at any time. This may be useful, for example, if you want to adjust an individual person's available hours in a particular period -- then immediately see the diluted results.
When cost dilution is enabled, project level cost rate overrides are ignored for salaried users. Cost rates must remain constant for each person throughout a given time period or the dilution calculations will not be accurate. If you have a salaried employee whose salary changes in the middle of a time period, see handling pay changes off dilution boundaries for an example of one method used to handle this situation.
When cost dilution is enabled, those reports that provide results based on planned work entries will also ignore any project or task level cost rate overrides (unless you have the Use Plan Cost Rates for Dilution (unatime.cost.dilution.use_plan_rates) property enabled).
When cost dilution is enabled, the cost rate field cannot be used on the Administrative Timesheet Adjustment screen (for Salaried users). Again, cost rates must remain constant for each person throughout a given time period or the calculation will not be accurate. You can, however, retroactively adjust a person's cost rate for an entire time period via the Person Profile Rates tab screen.
The Rate change process generates all necessary adjustment records in the event Dilution is enabled. This means that even if you only added 1 hour to a person's timesheet, every single entry will have to be adjusted. The reason for this is because any change that effects the dilution calculation will have an effect on each and every time entry's effective cost rate.
To minimize the potential for creating adjustments to passed periods, it is always a good idea to lock or extract your timesheets for closed time periods. See Admin >> Time >> Export for more information.
Dilution calculations will not impact those timesheets marked as "Historical Time Entries ".
Before you use Dilution, there are several items which must first be addressed. It is important that you handle all of these items before allowing users to enter time for a certain time period with Dilution enabled. If you have just started setting up your Unanet system and are going to use Dilution, you should follow the guidelines below. If you are already using Unanet, then you should pick a time when no user activity will occur and follow the steps below.
Ref # |
Item |
Description |
1 |
Properties |
In order for the system to use Dilution, you need to enable it in the unanet.properties file (or via Admin >> Properties). |
2 |
Cost Rates |
Since Dilution is designed to work with true salary cost values, you need to calculate the correct cost rate for each salaried employee. This cost rate should represent only the person's salary per hour, based on their annual salary (or perhaps monthly salary). Typically, this does not include any additional overhead such as benefits, expense allotments, bonuses, etc. Cost rates are defined on the Person Profile Rate tab. If necessary, add a new rate for each person who does not already have the correct cost rate. Note that cost rates will need to align with time period date boundaries when using dilution. |
3 |
Work Hours |
You need to make sure that each Time Period defined in the Unanet system has the correct hours in period value. This is what the system uses when performing the Dilution calculation (worked hours/available hours). If your Unanet system was upgraded from a prior version, these values were defaulted based on the period type (monthly - 173.3, twice a month - 86.6, every two weeks - 80 or weekly - 40). If these values are not correct for your location, you should update them now. |
4 |
Pay Code - Salaried Usage |
Each pay code defined in your system has a Salaried Usage indicator associated with it. This indicator includes three options:
See the Admin >> Setup >> Pay Code screen for additional information. |
5 |
Timing |
One of the most important things to consider when activating Style 1 cost dilution is "when?" Since dilution changes cost rates for all salaried employees, the best time to activate it is after all timesheets for a time period have been COMPLETED, SUBMITTED, APPROVED, and, if you extract data from Unanet, EXTRACTED. Next, make sure that steps 1-4 on this checklist are complete. |
When new employees are hired, they may not begin on a date that corresponds to the begin date of your company's time period. Similarly, when employees are terminated, they may not work until the end date of the time period. The Unanet system can handle these individual situations that may be unique to an employee. The following steps outline the manual procedure to use if you are hiring a new employee and that employee does not start on the boundary of the time period:
Add the employee to your Unanet system, making their effective date equal to the begin date of the nearest time period begin date.
Either create the first timesheet for that employee if your Unanet system is set up to allow it -- or have the employee create their first timesheet themselves.
Edit that person in your Unanet system and navigate to the Dilution screen on the Person Profile. Edit the dilution entry for the timesheet just created, modifying the "hours in period" to be the true available hours for that employee for that week. For example, if the periods are weekly (Mon - Sun) and the employee started on Thursday, you would probably enter 16 hours as the "hours in period" for that time period because you would expect them to work only on Thursday and Friday.
Now the system will calculate the dilution for this timesheet based on an available hours amount of 16. This means that if the employee were to report 32 hours for those two days, their effective cost rate would be reduced by a factor of .5 resulting in the correct dilution for this salaried employee's timesheet.
Using this method, you can also handle employees that are terminated in the middle of a time period. Simply edit their last timesheet's dilution information and set their "hours in period" to the correct value that you expect them to work.
See the Unanet Knowledge Center for additional information on this topic.
As stated above, cost rates must remain constant for each salaried person throughout a given time period or the calculation will not be accurate. So what happens if someone's salary changes in the middle of a time period?
Let's take this situation as an example: Jane, a salaried employee who works for you, is supposed to have a pay raise on November 8. Her time period is monthly beginning on the first of each month. You can handle this in the Unanet system by using the following manual procedure:
Add a new rate for Jane beginning on November 1 -- change her classification to 'HOURLY' and make sure her cost rate for this new rate is correct. You may have to manually calculate this rate if any dilution is necessary for the first 8 days of November.
Add another new rate beginning on November 8 -- still keeping her classification as 'HOURLY', but now increase her cost rate to match her new salary. Again, you may have to manually calculate the appropriate diluted rate depending on the hours Jane works from November 8 to November 30.
Finally, add another rate beginning on December 1 -- you will be able to change her classification back to 'SALARIED' since this date is on a dilution boundary. Make the cost rate her real cost rate for her new salary. From this point on, dilution will be calculated automatically by the system.
Tip! While an approach such as this could be used to handle a pay changes off time period boundaries, many customers recognize the effort involved and attempt to enforce a policy of aligning pay changes with time period boundaries to avoid this type of effort all together.
See the Unanet Knowledge Center for additional information on this topic.