The system displays the following in the “Price List Details” group box.
Service Price List # |
The number identifying the service price list. |
Revision # |
The number identifying the revision of the service price list. |
Description |
The textual description of the service price list. Zoom facility available. |
Status |
The status of the service price list, such as “Active” or “Inactive”. |
Currency |
The currency of the service price list. |
Price List Category |
The price list category of the service price list. |
Enter the following in the “Roster Code Options” group box.
Roster Code Basis |
Use the drop-down list box to specify the basis of the . The system displays the following values: "Attendance Type" and "Work Time". |
Enter the following in the “Roster Code Details” multiline.
Roster Code |
Use the drop-down list box to specify the identification number of the roster code for the service price list. The system lists all the active quick codes defined for Quick Code Type "Roster Code" in the Work Center component in addition to any previously saved values. |
Element |
Use the drop-down list box to specify the element of the roster code. If you select “Attendance Type” in the Roster Code Basis field, the system lists all the Active quick codes defined for the Quick Code Type "Attendance Type" in the Work Center component and “Normal”.If you select “Work Time” in the Roster Code Basis field, the system displays the following values: "Working Day", "Weekly Offs", "Holidays" , "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday", and any other value saved previously. |
Note: 1) If the Roster Code Basis is “Attendance Type”, you must not repeat the Element and Roster Code combination for any record. 2) With Roster Code Basis as “Work Time”, you cannot a create a Roster Code record with Element as "Monday", "Tuesday", "Wednesday", "Thursday" or "Friday", if Roster Code record with Element as “Working Day” already exists. 3) Similarly, you cannot a create another Roster Code record with Element as "Saturday" or "Sunday", if Roster Code record with Element as “Weekly Offs” already exists. 4) With Roster Code Basis as “Work Time”, you cannot a create Roster Code record with Element as "1 OT" or "11/2 OT","2 OT", etc . 5) With Roster Code Basis as “Attendance Type”, you cannot a create a Roster Code record with Element as "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", “Saturday”, “Sunday”, “Working Day” or “Weekly Offs”.
From Time |
The start-time of the duty, (Date Format). |
To Time |
The end-time of the duty, (Date Format). |
Note: 1) You can specify any one or both the fields, From Time or To Time, if you have selected “Work Time” in the Roster Code Basis field. 2) The specified To Time must be later than the From Time. 3) If you do not specify the Time fields, the Labor Rate/Hr specified in the “Edit Service Price List becomes valid for the entire day. 4)You must not specify the From Time and To Time fields, if the Roster Code Basis is “Attendance Type”. 5)You must not repeat the Element, From Time and To Time values for a Roster Code, if the Roster Code Basis is “Work Time”. 6) The Element, From Time and To Time values must not coincide with those of any other Roster code, if the Roster Code Basis is “Work Time”.
Factor |
The pricing factor for the Normal Rate / Hr or Overtime Rate / Hr. This is applicable for the duration between the specified From Time and To Time fields. |
Remarks |
Any comments or additional information on the roster code record. |
Select the “Edit Roster Code Details” pushbutton.
See Pricing of skills based on Roster Code for examples.
Recording roster code details - An Overview
You can use the “Edit Roster Code Details” page to set differential rates for Normal and Overtime work hours, based on various time slabs. For example, you can set specific Normal and Overtime hourly rate for various time slabs.
You must set the Pricing Method for Resource Type “Skill” to “Roster Code” in the “Create Service Price List”, to enable the system to compute the resource price based on roster code. Differential rates are obtained by applying specific pricing factors on Normal and Overtime hourly rates for predefined durations.
You can estimate the skill price based on “Attendance Type” or “Work Time”.
With “Attendance Type” as the roster code basis, you can set different overtime rates using the Pricing Factor attribute.
With “Work Time” as the roster code basis, you can fix normal rates for specific durations on working days (Monday thru Friday) and weekly offs (Saturday and Sunday), using the Pricing Factor attribute.
Examples under the Pricing of skills based on Roster Code illustrate the techniques used by the system to arrive at the resource price.
Pricing of skills based on Roster Code
The examples given below illustrate the logic adopted by the system to compute the price of resources (employees) for a service price list. The values used for computation are displayed in tables under the concerned attributes.
Resource Type |
Resource # |
Normal Rate / Hr |
Pricing Method |
Skills |
Airframe Mechanic |
100 |
Roster Code |
Scenario1: Work Time Based Roster Code Pricing
Roster Code |
Element |
Factor |
From Time |
To Time |
100 |
Monday |
1.25
|
8:00 |
17:00 |
125
|
Monday |
1.5 |
18:00 |
24:00 |
150 |
Tuesday |
1.5 |
18:00 |
24:00
|
175 |
Wednesday |
1.25 |
8:00 |
24:00
|
For example, time sheet entries exist for an Airframe Mechanic employee, Monday between 800 to 1700 Hrs; with 1.25 as the Pricing Factor, the price will be as follows:
Resource Price = No Of Hrs Worked * Normal Rate/ Hr * Factor
Rs.1125 = 9 * 100 * 1.25
Scenario2: Attendance Type Based Roster Code Pricing
Roster Code |
Element |
Factor |
From Time |
To Time |
100 |
1 OT |
1.25
|
NA |
NA |
125
|
11/2 OT |
1.5 |
NA |
NA |
150 |
2 OT |
1.5 |
NA |
NA |
175 |
21/2 OT |
1.25 |
NA |
NA |
For example, if time sheet entries for two OT exist for the same employee as in the previous example, the resource price is calculated as follows:
Resource Price = No Of Hrs Worked * Normal Rate/ Hr * Factor
Rs.2700 = 18 * 100 * 1.5
Note: In the above example, nine hours of work equals one OT.