# Average Rate for OT payment

Requirement:

OT to be paid to employee based on rate from their quarterly average of basic salary and quarterly average of Working hours.

Condition 1: Once OT rate is formed for a quarter, it should not recalculate in retro in case of salary hike or working hrs changes.

Condition2: In case of arrear payable , those amount should be added in respective quarter and no recalculation in retro quarter months.

eg:

Jan-19 Basic salary - 50000 _ Working hours 82.80 hrs

Feb-19 Basic salary - 50000_ Working hours 82.80 hrs

Mar-19 Basic salary - 50000_ Working hours 82.80 hrs

Average calculation:

Jan+Feb+Mar salary / 3 = 50000+50000+50000 /3 = 150000/3 = 50000

Jan+Feb+Mar whr/ 3 = 82.80+82.80+82.80/3 = 248.4/3 = 82.80

OT rate of First quarter should be 50000/82.80 = 603.86 (no revision in this rate 603.86 should happen in retro)

In may19, Jun and Jul19, if employer wants to pay OT, the rate to calculate OT should be 603.86 of first quarter.

The above calculation applicable for subsequent quarter.

We tried AVERA function and its configuration, its recalculating the frozen average rate while paying arrears which should not be the case in this requirement.

Regards,

Velvendhan D.

10|10000 characters needed characters exceeded