Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Title: Dilution calculation for a salaried/exempt new hires, for employees terminated mid-period or for uncompensated leave within a period

Brief description:

When you hire or terminate an exempt employee mid-time period or when an exempt employee has uncompensated leave within a period, by default, Unanet will adjust the employee’s cost rate based on the hours worked against the hours in the time period resulting in an inflated cost rate for that individual.  This document describes the process for calculating the correct hours in the period to replace the default hours for the employee.

This method works when an exempt employee is paid a percentage of their salary based on the hours worked over the business hours in the period.  Note that some organizations pay the exempt employee’s hourly rate when partial periods are worked.  Please refer to the Quick Topic “Quick Topic dilution (Straight Pay)” for the configuration of this method of compensation.

 

What’s covered in this document:

 

 

The following steps outline the process for calculating the expected dilution period for a salaried new hire, termination mid-period or employee with uncompensated leave.  This process should be followed after the timesheet has been approved and is in a COMPLETED or LOCKED state but before the timesheet is extracted.

Calculate the adjusted hours for the period

Let:

  1. HOURS WORKED =  hours on the timesheet for the employee
  2. BUSINESS HOURS = standard work day hours * the number of business days in the time period
  3. PERCENTAGE OF PERIOD = HOURS WORKED / BUSINESS HOURS
  4. ADJUSTED PERIOD HOURS = Dilution Period Default hours * PERCENTAGE OF PERIOD

Setting the adjusted hours in the Person Dilution Hours in Period

The ADJUSTED PERIOD HOURS are entered into “Hours in Period” field of the employee’s dilution table (http://www.unanet.com/unadocs/current/unanet_menu/people/people_dilution.htm).   Following this process will ensure the employee’s adjusted cost rate is accurate.

Example 1

In a semi-monthly time period, the standard dilution hours are set to 86.667.  Within a given period, a new-hire works 7 of 11 working days.  Let’s assume the standard work day is 8 hours.  

 

 

 

July

 

 

 

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

Project

Title

Pay Code

1st

2nd

3rd

4th

5th

6th

7th

8th

9th

10th

11th

12th

13th

14th

15th

1110100

USDA

RT

 

 

 

 

8

8

 

 

8

8

8

8

8

 

 

Step

Formula

Example

Results

A

HOURS WORKED

8 hours * 7 days

56 hours

B

BUSINESS HOURS

8 hours * 10 days

80 hours

C

PERCENTAGE OF PERIOD

56 hours worked / 80 hours in period

.7

D

ADJUSTED PERIOD HOURS

86.667 dilution period default *.7 percent of time period worked

60.6667

Example 2

In a bi-weekly time period, the standard dilution hours are set to 80.  Within a given period, a new-hire is employee for 4 of 10 working days in the period.  The employee is expected to work 8 hours a day.  

 

 

 

July

 

 

 

M

T

W

T

F

S

S

M

T

W

T

F

S

S

Project

Title

Pay Code

2nd

3rd

4th

5th

6th

7th

8th

9th

10th

11th

12th

13th

14th

15th

1110100

USDA

RT

 

 

 

 

 

 

 

 

8

8

8

8

 

 

Step

Formula

Example

Results

A

HOURS WORKED

8 hours * 4 days

32 hours

B

BUSINESS HOURS

8 hours * 10 days

80 hours

C

PERCENTAGE OF PERIOD

32 hours worked / 80 hours in period

.4

D

ADJUSTED PERIOD HOURS

80 dilution period default *.4 percent of time period worked

32

 

Considerations for a Stored Procedure

One concern with this process is that the Unanet Administrator or client Payroll Manager is unaware of the situation and that the user timesheet is completed and time is diluted prior to this setting being in effect.  Recalculation is always a possibility, but a stored procedure may help to reduce the possibility of missing the scenario.

A stored procedure is a customized script that runs on the Unanet database and validates entries to the timesheet or expense report.  In this case, the validation would be a Save validation warning and submit validation warning on the timesheet. 

For a new hire, the stored procedure would be setup to trigger if the user Hire Date field was populated with a date within the time period and the hours worked are less than the business hours in the period.  Special exceptions would need to be accounted for if the Hire Date was on the first weekday of the time period and therefore all normal business hours were included in the dilution period.  The Save and Submit message would be a warning to indicate to the user that he should contact the System Administrator to review the dilution settings. 

Unanet does not track Termination Dates as a standard field, but if validation on termination is necessary, it would be possible to setup a Person user defined field (UDF) to enter a Termination Date.  The validation routine would be very similar for the termination, with special exception if the termination date is on the last weekday of the time period.  The client will need to determine if the Termination date can be identified and entered into Unanet in a timely fashion in order to make the stored procedure routine viable in their environment.

If a Stored Procedure is desired, the client should contact their Customer Account Manager or implementation consultant.

Additional Resources

Person Profile

Dilution

 

 

 

 

 

  • No labels