Average Rate Rules

This is a code that represents an Average Rate Rule.

Specify the number of weeks over which the average is to be calculated.

Specify if weeks where no pay was paid will be included in the average calculation.

Option	Description
I	Include no-pay weeks in average calculated
E	Exclude no-pay weeks in the average calculated

 

This is the average rate formula to be used for calculating the average rate.

The values entered correspond to the Average Pay Rates on the Employee Other Payment Details and Salary window.

Option	Description
1	Average Pay Rate 1
2	Average Pay Rate 2
3	Average Pay Rate 3
4	Average Pay Rate 4
5	Average Pay Rate 5
6	Average Pay Rate 6
7	Average Pay Rate 7
8	Average Pay Rate 8
9	Average Pay Rate 9

 

Select the start date from the following options:

Option	Description
1	Adjusted Service Date
2	User Date 2
3	User Date 3
4	User Date 4
5	User Date 5
6	User Date 6
7	User Date 7
H	Hire Date

This is the earliest date/ starting point weeks can be counted from for Average Rates calculation.

Option	Description
D	Daily
W	Weekly

This field is only enabled and becomes mandatory when the Prevar *PP_LEAVE_UNITS is set to 'Y', and Program Control PEP39 Position 15 is set to 'A', and Average Pay Rate 7, 8, or 9 is selected in the Type field.

• If W is selected for Unit Type and the No of Weeks to be Averaged is 52 or 4 and Incl/Excl Zero Weeks is set to I, the calculation will look at the Earnings History for the 52 or 4 week period and divide by 52 or 4 to get a weekly rate. Example: 65750.00 / 52 = 1264.4231 or 5345.00 / 4 = 1336.25.
• If D is selected for Unit Type and the No of Weeks to be Averaged is 52 or 4 and Inc/Excl Zero Weeks is set to I, the calculation will look at the Earnings History for the 52 or 4 week period and divide by No of days worked for the average period. Example: 65750.00 / 260 = 252.8846.

  Note: Number of days is taken from the Hours code nominated in the Program Control PEP39 Positions 16 - 17.

• If the required No of Weeks to be Averaged on Earnings History (e.g. 35 ) are less than the number nominated on the Average Rate Rules (e.g. 52 ), the calculation will look at the earnings for the 35 week period and divide by the number of days worked in the 35 weeks which is stored in the Hours code. This calculation will keep rolling until 52 weeks and then will always use the last 52 weeks.

• If Incl/Excl Zero Weeks is E, the calculation will look at the Earnings History for 52 or 4 week period and divide by the actual number of pays found in the period.

 

This is the Hours Type code or the Allowance/Deduction code to be used.

This is the Hours Type code or the Allowance/Deduction code to be used in the calculation of Average Hours.

This calculation reviews Earnings History to calculate Average Pay, as to calculate averages over 52 weeks, e.g. you must have 52 weeks of earnings history in Preceda.

 

Option	Description
Y	Hours paid against the Code will be excluded from the Average Rates calculation, but the dollar value paid against the Code will be included
N	Hours paid against the Code will not be excluded from the Average Rates calculation.

 

Example 30 hours worked, normal hours = $1000 2 hours overtime = $20 During the annual leave rate calculation the 2 hours overtime would be excluded but not the $20 value, giving the annual leave rate of $1020 / 38 = 26.8421