For DXB staffs and the staffs who are earning BasicSalary more than 2000, they need to work 9 hours for 26 days and for other Emirates they need to work 9 hours for 30 days. That is the entire concept.
Yes it’s determined by what Emirates the person works but the challenge is some of the staffs are having BasicSalary more than 2000 and NormalOT more than others. In this case what is the better way we can do it?
This is confusing, can we separate the DXB from others?
The DXB basic salary is 570 according to your spreadsheet. So to get this they must work how many hours a day for how many days? It looks like 9 hours a day for 26 days. Is that correct?
If a DXB staff is making more than basic salary (more than 570) they must work how many hours a day for how many days?
For staff members who do not work at DXB and who have a basic salary of 2000, they must work 9 hours a day for 30 days, correct?
For staff member who do not work at DXB and their basic salary is higher than 2000, how many hours a day and how many days must they work?
What do you call the salary if someone makes more than Basic salary?
If a person makes more than the basic salary, we will need to document that and I assume that the salary can change over time, so we will need to keep a history of the salary changes.
What happens if the basic salary or rates change? How are you going to handle that?
Regards to normalOT, is normalOT based on the salary * factor? So if someone is earning basic salary the normalOT is determined by basic salary * factor
If someone is making more than basic salary, the normalOT is determined by thier current salary * factor. I understand the factor changes. So for DXB staff the factor is 1.25. I assume that those earning basic salary and not at DXB, the factor is 2. I further assume that those earning more than basic salary and do not work at DXB, their rate is 1.25, correct?