Good morning. Our company has long lost the formula behind determining how paid time off is calculated. I need to determine it now b/c we have added a level to the accrual schedule (over 25 years).
Immediately (5 paid days off)
1 calendar month completed = 0 days
2 calendar months completed = 1
3 calendar months completed = 1
4 calendar months completed = 1 1/2
5 calendar months completed = 2
6 calendar months completed = 2 1/2
7 calendar months completed = 3
8 calendar months completed = 3
9 calendar months completed = 4
10 calendar months completed = 4
11 calendar months completed = 4 1/2
12 calendar months completed = 5
1 year of service through 7 years (15 days)
1 calendar month completed = 1
2 calendar months completed = 2 1/2
3 calendar months completed = 3 1/2
4 calendar months completed = 4 1/2
5 calendar months completed = 6
6 calendar months completed = 7 1/2
7 calendar months completed = 9
8 calendar months completed = 9 1/2
9 calendar months completed = 11 1/2
10 calendar months completed = 12
11 calendar months completed = 13 1/2
12 calendar months completed = 15
8 -15 calendar years (20 days)
1 calendar month completed = 1
2 calendar months completed = 3 1/2
3 calendar months completed = 5
4 calendar months completed = 6 1/2
5 calendar months completed = 8
6 calendar months completed = 9
7 calendar months completed = 12
8 calendar months completed = 13
9 calendar months completed = 15
10 calendar months completed = 16 1/2
11 calendar months completed = 18 1/2
12 calnedar months completed = 20
16-25 calendar years (25 days)
1 calendar month completed = 1 1/2
2 calendar months completed = 4
3 calendar months completed = 6
4 calendar months completed = 8
5 calendar months completed = 10
6 calendar months completed = 12 1/2
7 calendar months completed = 14 1/2
8 calendar months completed = 16
9 calendar months completed = 19
10 calendar months completed = 20 1/2
11 calendar months completed = 22 1/2
12 calendar months completed = 25
Hopefully this makes sense. I apologize for the length of the question and if I have put it in the wrong section.
Any help determining the formula and the next schedule (30 paid days off) is greatly appreciated!
Immediately (5 paid days off)
1 calendar month completed = 0 days
2 calendar months completed = 1
3 calendar months completed = 1
4 calendar months completed = 1 1/2
5 calendar months completed = 2
6 calendar months completed = 2 1/2
7 calendar months completed = 3
8 calendar months completed = 3
9 calendar months completed = 4
10 calendar months completed = 4
11 calendar months completed = 4 1/2
12 calendar months completed = 5
1 year of service through 7 years (15 days)
1 calendar month completed = 1
2 calendar months completed = 2 1/2
3 calendar months completed = 3 1/2
4 calendar months completed = 4 1/2
5 calendar months completed = 6
6 calendar months completed = 7 1/2
7 calendar months completed = 9
8 calendar months completed = 9 1/2
9 calendar months completed = 11 1/2
10 calendar months completed = 12
11 calendar months completed = 13 1/2
12 calendar months completed = 15
8 -15 calendar years (20 days)
1 calendar month completed = 1
2 calendar months completed = 3 1/2
3 calendar months completed = 5
4 calendar months completed = 6 1/2
5 calendar months completed = 8
6 calendar months completed = 9
7 calendar months completed = 12
8 calendar months completed = 13
9 calendar months completed = 15
10 calendar months completed = 16 1/2
11 calendar months completed = 18 1/2
12 calnedar months completed = 20
16-25 calendar years (25 days)
1 calendar month completed = 1 1/2
2 calendar months completed = 4
3 calendar months completed = 6
4 calendar months completed = 8
5 calendar months completed = 10
6 calendar months completed = 12 1/2
7 calendar months completed = 14 1/2
8 calendar months completed = 16
9 calendar months completed = 19
10 calendar months completed = 20 1/2
11 calendar months completed = 22 1/2
12 calendar months completed = 25
Hopefully this makes sense. I apologize for the length of the question and if I have put it in the wrong section.
Any help determining the formula and the next schedule (30 paid days off) is greatly appreciated!