View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TimBeau TimBeau is offline
external usenet poster
 
Posts: 4
Default Vacation accrual Spreadsheet

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