mohammedansar
New Member
- Joined
- Jun 12, 2019
- Messages
- 2
Dear Mr. Excel,
Hope this mail finds you in good health.
I have a question, and would appreciate it if you could answer it ASAP.
Ex: I have a bonus pool of 150,000 to be distributed among 5 employees on criteria of grade, department, annual evaluation and their date of joining (pro rata).
<tbody>
</tbody>
Thanks for your kind support and understanding.
Best Regards.
MA.
Hope this mail finds you in good health.
I have a question, and would appreciate it if you could answer it ASAP.
Ex: I have a bonus pool of 150,000 to be distributed among 5 employees on criteria of grade, department, annual evaluation and their date of joining (pro rata).
Employee | Grade | Dept | Annual Evalutiaon | Date of Joining | Bonus (Jan – Dec 2018) |
A | 6 | 4 | 83% | 15-Jan-2018 | ? |
B | 5 | 4 | 86% | 01-May-2018 | ? |
C | 4 | 3 | 90% | 01-June-2018 | ? |
D | 3 | 2 | 92% | 01-Jan-2018 | ? |
E | 1 | 3 | 80% | 01-Jan-2018 | ? |
<tbody>
</tbody>
Thanks for your kind support and understanding.
Best Regards.
MA.