Rate Schedules

Top  Previous  Next

Module:  Project Administration    

Applet:  Rate Schedules

 


Description: Rate schedules are used to control job cost and bill rate schedules in the application. Once rate schedules are set up, they can then be applied to projects. Rate schedules are date-sensitive to all period changes to schedules.

 

Note: When time sheets are entered or edited in the system, they automatically pick up rates and store them in the time sheet module, where they are available for reporting. The Recalculate Rates utility is used to retroactively apply rates to time entries.

 

Grid descriptions are listed below

ProjAdm_RateSchedule

 

 

Schedule Name - Name of the Rate Schedule.  Must be unique.

 

Schedule Periods - Date range where the selected Rate Schedule is active.

 

 Add Period - When you click on this, you can create a new Rate Schedule date range.

 Delete Period - When you click this button, the selected Rate Period will be deleted.

 

Bill Rate Schedule - When selected, the current Rate Schedule is a Bill Rate Schedule.

 

Job Cost Schedule - When selected, the current Rate Schedule is a Job Cost Schedule.

 

Pay Rate Schedule - When selected, the current Rate Schedule is a Pay Rate Schedule, however, Pay Rates cannot be multiplier based.

 

Add Row - When you click on this, the bottom section of this Applet (Rate Details, see below) becomes active so that you can add a new row to the current Rate Schedule.

 

 

RATE DETAILS

 

Job Title - Job Title to be matched; left blank, any job title is a match.

 

Employee - Employee to match; left blank, any employee is a match.

 

Base Rates

 

Premium Method Multiplier - When checked, the Employee OT Multiplier is used; if Override Multiplier is checked, the multiplier here is used.

 

Premium Method Rate - When marked, either the Employee OT rate is used or if override rate is checked then the rate entered here is used.

 

Override Regular Rate - When checked, the entered amount will be the regular base rate. Otherwise the employee regular pay rate is used

 

Override Multiplier - Overtime multiplier if premium method is selected and override multiplier is checked.

 

Override OT Rate - Overtime multiplier if premium method is selected and override multiplier is checked.

 

Flat Rates

 

Use Flats Rates - When checked, flat rates will be used for the job cost or bill rate. Otherwise multipliers will be used.

 

Regular - Rate for non-premium time.

 

Premium - Rate for premium time.

 

Multipliers

 

DPE Mult.- Direct personal expense multiplier

 

OH Mult.- Overhead multiplier

 

Profit Mult.- Profit Multiplier

 

Apply Mults. On Premium - When checked, only the non-premium portion of overtime is marked up. The premium portion is then added to that. For Example:

An employee makes $10/hr. and receives time and a half for overtime.The combined multipliers are 3.0

If the box is unchecked, the hourly premium rate would be 10 x 1.5 x 3 = $45/hr.

If this box was checked, the calculation would be (10 x 3.0) + ( (10 x 1.5) – 10) = $35/hr.