I am working on a spread sheet for my Company. I have looked at many examples but I am still not finding what I need with the specific perimeters involved. the facts:
- PDO accrual rate increases every employee anniversary.
- PDO accrues every weekly pay period worked.
- PDO accrues after 90 days of employment.
- PDO max accrual is 120 hours.
PDO incremental rate accrual as follows:
- 1st year----2.0 hrs per pay period
- after first year-----2.15
- after second yr----2.3
- after third year----2.46
- after fourth year--2.61
- after fifth year-----2.76
- after sixth year----2.92
- after seventh yr---3.07
- after eigth yr------3.23
Bookmarks