davidwylie
New Member
- Joined
- Jul 1, 2004
- Messages
- 27
does anyone have a formula to help calculate UK redundancy pay
rules are as follows:
-0.5 weeks pay for each full year under 22
-1 week pay for each full year they were 22 or older but under 41
-1.5 week pay for each full year they were 41 or older
-length of service capped at 20 years
-weekly pay capped at £500
-total max stat pay capped at £15,000
assume cell a1 for employee age, cell b1 for years of service, cell c1 for average weekly pay
thanks for your help in advance
rules are as follows:
-0.5 weeks pay for each full year under 22
-1 week pay for each full year they were 22 or older but under 41
-1.5 week pay for each full year they were 41 or older
-length of service capped at 20 years
-weekly pay capped at £500
-total max stat pay capped at £15,000
assume cell a1 for employee age, cell b1 for years of service, cell c1 for average weekly pay
thanks for your help in advance