Clarity Time Tracking and Per Diem (contractors)

[mike2.2]

Any suggestions around Toime tracking for handling contractors on a per diem? We want to track all staff, so they would put in theor timesheets and use the rate matrix to calculate the actuals. Byt in teh case of contractors on a per diem, we still want them to put in their hours, but we want only the daily per diem rate to be aplied.

 

Any suggestions?

[System]

Hi All - Any suggestions here for Mike? Thanks! Chris

Michael Thibault wrote:

 

Any suggestions around Toime tracking for handling contractors on a per diem? We want to track all staff, so they would put in theor timesheets and use the rate matrix to calculate the actuals. Byt in teh case of contractors on a per diem, we still want them to put in their hours, but we want only the daily per diem rate to be aplied.

 

Any suggestions?

[Anon Anon]

One option would be to set up multiple input type codes with different rates.  You could have a REG input type with the contractor's hourly rate that would equal their per diem (per diem divided by regular daily hours, e.g. 8) and an OT input type with a 0 rate, or a cleaner method might be one input type with a zero rate to enter all their hours worked, and a per diem input type with the per diem rate on which they would enter 1 unit per day.  Either method should bill the per diem amount but record all hours worked.

[Anon Anon]

My reading of the requirement is that you want to; 1) caputer the hours worked by the per diem contractors, and 2) capture the cost/day for all work with a "not to exceed' value (per diem cap).

 

Consider creating a process that runs after the time sheets are posted and processed to the WIP tables  that looks for the per diem contractors (add attriute to the resource properties), calculates the total daily cost based on the WIP values (calculated from the standard rate matrix), compares that daily cost to the per diem cap for that resource;

1) Total cost =, per diem cap - no further action required

2) Total cost > per diem cap - distribute the per diem cap as a percentage across all of the resource tasks for that date.

 

Additional thought is required to detail out the technical specifications to support this approach.

[Deactivated User]

That has some similarities to the salaried people challenge I was involved some years ago.

Clarity is designed to work with hourly work effort and hourly rates. That works fine with hourly paid or billed persons.

However, it does not work so well for salaried people as the number of hours varies by the month. The Clarity functionality to support that would be different rates by the month which ain't that much fun if you have many resources.

The solution selected was to have the rates set up in the same manner as for hourly paid and billed. That at the beginning of each month the real payment data came from the payroll system. That was xogged in to the system and the hour costs were reversed so that the hours and moneys in Clarity matched the real world.