Salary Users - OnTrax Timesheets uses the weekly salary amount from the user master record to calculate an Internal Rate (Cost) per hour for salaried user.
User Rate Visibility - The only two places in the system where a users salary is maintained and/or viewable is on the users individual User Master record and the advanced Task based project planning screen for authorized users. Anywhere else in the system where Internal rates can be set (Project/Item) a salaried users Internal rate (Cost) is displayed as the term "Salaried" and is not visible/modifiable.
Below are steps the system uses for calculating a salaried employees Internal Rate (Cost) per hour. Calculations are only preformed on "Approved" records at the time of approval.
Read the User master record and obtain the users weekly salary amount.
For the calendar week for which time is being "Approved", obtain the total amount of 'Approved" hours in the system for the user/week combination- including those hours currently being approved.
Divide the weekly salary amount for the user by total amount of "Approved" hours for the week and calculate an Internal rate (Cost) per hour for the user/week.
Update all "Approved" time posting for the week using the-calculated rate so that the total internal Cost for the week always equals the employees weekly salary amount.
Internal rate (cost) and internal amount $
Determination for SALARIED Employees Systems Total Weekly Internal Cost $=salary $
Salary Amount User Master Record- obtain weekly salary
$1000 amount
STEP 2 and 3
Weekly Salary Total approved Calculated rate Determine Calculated Internal Rate (cost) Hr
Amount Hours for week System determines total cost per hour for
individual employee by dividing weekly
$1000 / 25 Hrs = $ 40 Salary amount by the total amount of app-
roved hours the user posted for the week.
STEP 4
Calculated Hours on Calculated amount System updates All Approved records with New
Rate Posting On Posting Costs - based Upon the new internal rate
(cost) calculated, the application updates all
$40 * 6 = $240 all applicable records with both the new
Internal rate (Cost) and Internal amount $.
* All salaried employees time postings follow this Internal rate process at time of approval.
OnTrax Timesheets uses rates stored in the User master record as default values through out the system
When time postings are created or approved, the system follows the exact same steps to determine what applicable rates are for the assigned User/Project & Project Item/Task combination.
It is Highly recommended that default rates are entered on the user master records. Rates can also be set at the individual project level.
Below are steps the system uses for determining the applicable rates for a time posting
Obtains rates from User Master record.
Read the project item/project task record that is being posted to. If the rates for the Item are set at the project level, it will override the user Master rates and use those set at the project level.
Apply the rate multiplier for the Time Category as selected by the user at the time of the posting.
Example
Step 1
Internal rate External rate User Master - Default rates for all Postings
$50 $75
Step 2
$50 $80 Project Item/Task- at the individual project
If no rate is found at the project level then use the rate found in the user master. If a rate is found at the project level then utilize this rate in the final rate calculation.
Step 3
Internal Rate Calculation
rate Multiplier New rate
$50 * 1.5 = $75 Time Category Multipliers applied to the Rate.
External Rate Calculation
rate Multiplier new rate
$80 * 1.5 = $120 Time Category Multipliers applied to the Rate.
Results
Internal rate (Cost) External rate (Billed) Hourly rate used for Calculations and
Saved on posting record
$75 $120
* All time postings follow this rate determination process at time of creation and approval