I am an HR consultant and I made the worst mistake,i excuted an offer letter with 15 vacation days and 5 sick days for an employee who start date is May 1, how do I calculate their vacation. What is the formula? what do I multipy and or divide? Math is not my favorie so i need to see in full writing.
Hi Madelyn! No problem, we are here to help!
We assume that you will be prorating the vacation and sick time for 2009– the first year of employment. It’s actually fairly easy to do.
For the 3 weeks of annual vacation, take 15 days x 8 hours = 120 hours of vacation, divided by 52 weeks per year= 2.307 hours of vacation earned per week. We checked the calendar, and an employee hired on May 1 will work exactly 35 weeks in 2009. So 2.307 hours of vacation x 35 weeks = 80.75 hours of vacation. That is two weeks of vacation, plus 3/4 of an hour.
For the 5 days of sick leave, take 5 days x 8 hours = 40 hours, divided by 52 weeks per year =0.769 hours of sick leave earned per week, x 35 weeks = 26.915 hours of sick leave. Most employers would round this to 27 hours of sick leave. That is 3 days plus 3 hours of sick leave.
Note that not every employer would prorate annual leave in this way. Some employers would award the entire 15 days of vacation and 5 days of sick leave on the employees first anniversary (May 1, 2010.) Other employers would accrue the employees sick time and vacation time based on hours worked. But it appears from your question that your client is prorating it based on the number of weeks worked this year.
This entry was posted
on Wednesday, May 6th, 2009 at 10:51 pm and is filed under
Benefits, Human Resources Management.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
7 Responses to “How do you calculate prorated vacation of 15 days and 5 sick days?”
Leave a Reply
- Attendance Management (1446)
- Benefits (2020)
- Compensation (2336)
- Employment Training (329)
- Hiring and Staffing (1017)
- Human Resources Management (4832)
- Labor Laws (1585)
- Management / Leadership Development (357)
- Performance Management (246)
- Structural Development (41)
- Termination (744)
- Workplace Health & Safety (346)
- Workplace Management (500)