Module: Project Administration Applet: Rate Schedules |
|
Description - Rates come from three sources in InFocus—Projects, Schedules, or the Employee Setup Record. Rates are determined by comparing the time sheet line item with the three areas and locking in on a match. When a match is achieved, the corresponding rate(s) are applied to the time sheet line item.
EXAMPLE: In the following scenario we will walk through a match for a Bill Rate (would be the same for Job Cost Rate).
The following scenario illustrates the process of matching for a bill rate. The time sheet line item will have a WBS path of 9801-10-A, a job title of Senior Architect (SAR), an employee Joe Jones (JJ), and a work date of 6/1/2007.
Steps to finding a Bill Rate to "Lock In"
Step 1 - Compare the WBS path on the time sheet item. If that path has the Use Multipliers for bill rate set on, then a match has occurred and the bill rate is calculated based on the WBS path multipliers. If no match occurs and there is a rate schedule attached to 9801-10-A, then the system will attempt to find a match using the rate schedule.
(Fig.1)
Step 2 - If no match occurs, and there is a Rate Schedule attached to Project 9801-10-A, then the system will next attempt to find a match using the Rate Schedule (Fig.2).
(Fig.2)
FOR YOUR INFORMATION:
Finding matches on the rate schedule works by going through the most specific match to the least specific match truth table. The table has two columns: job title and employee (with job title being the more important of the two). The table can be filled out with any combination of job titles and/or employees. The priority - starting with highest priority - is as follows:
Job Title Employee
Matching Job Title Matching Employee
Matching Job Title Any employee (blank)
Any job title (blank) Matching Employee
Any job title (blank) Any employee (blank)
In our scenario, if a line item in Rate Schedule has an "SAR" in Job Title, a "JJ" in Employee, or a line has both entries blank, a match has occurred.
Remember: Rate Schedules are date sensitive so the schedule will only be looked at if has an effective date range that covers 6/1/2007 in this example.
Step 3 - If no match occurs in the Rate Schedule, the process (Steps 1 & 2) starts all over at the next WBS code up the chain. In this case that is 9801-10. This process starts at the lowest level (Task in this example) and works its way up the WBS to the Phase level, then the Project level.
Step 4 - If all levels of the WBS have been exhausted without a match, then the Employee record rate is used (Fig. 3).
(Fig.3)