help converting contracted days into hours

[qetjack]

i need your help everybody. this may be long winded, so hopefully i will explain this well enough to understand.

our full time colleague work 37 hours per week are entitled to 22 days per year. they work 7.4 hours a day.

if a colleague is part time, say 20 hours for example (4 days @ 5 hours per day), we divide 22 by 37 and then multiply by the amount of hours they work. so in this example, (22/37)*20. this gives us the pro-rata'd holiday entitlement for somebody who works 20 hours per week.

along the way, we will deduct bank holidays, or other holidays already taken to give a NET entitlement.

So say for example, we figure out this colleague is left with 3 days entitlement. frustratingly, they system we use to pay the colleagues those 3 days needs that entitlement converting into hours.

what would i multiply the 3 days by? the 5 hours that they work? or the 7.4 hours that a full time equivalent would work?

Something is telling me that because we have already pro-ratad the entitlement based on 7.4, we would need to multiply by 7.4 to get the correct hours. if we multiply by 5 are we not pro-rata-ing them twice?

if anyone could explain, that would be great

 

[Deleted member 4993]

i need your help everybody. this may be long winded, so hopefully i will explain this well enough to understand.

our full time colleague work 37 hours per week are entitled to 22 days per year. they work 7.4 hours a day.

if a colleague is part time, say 20 hours for example (4 days @ 5 hours per day), we divide 22 by 37 and then multiply by the amount of hours they work. so in this example, (22/37)*20. this gives us the pro-rata'd holiday entitlement for somebody who works 20 hours per week.

along the way, we will deduct bank holidays, or other holidays already taken to give a NET entitlement.

So say for example, we figure out this colleague is left with 3 days entitlement. frustratingly, they system we use to pay the colleagues those 3 days needs that entitlement converting into hours.

what would i multiply the 3 days by? the 5 hours that they work? or the 7.4 hours that a full time equivalent would work?

Something is telling me that because we have already pro-ratad the entitlement based on 7.4, we would need to multiply by 7.4 to get the correct hours. if we multiply by 5 are we not pro-rata-ing them twice?

if anyone could explain, that would be great

Entitled to what?

 

[qetjack]

Entitled to what?

Sorry, this is working out holiday entitlement for team members

 

[Ishuda]

i need your help everybody. this may be long winded, so hopefully i will explain this well enough to understand.

our full time colleague work 37 hours per week are entitled to 22 days per year. they work 7.4 hours a day.

if a colleague is part time, say 20 hours for example (4 days @ 5 hours per day), we divide 22 by 37 and then multiply by the amount of hours they work. so in this example, (22/37)*20. this gives us the pro-rata'd holiday entitlement for somebody who works 20 hours per week.

along the way, we will deduct bank holidays, or other holidays already taken to give a NET entitlement.

So say for example, we figure out this colleague is left with 3 days entitlement. frustratingly, they system we use to pay the colleagues those 3 days needs that entitlement converting into hours.

what would i multiply the 3 days by? the 5 hours that they work? or the 7.4 hours that a full time equivalent would work?

Something is telling me that because we have already pro-ratad the entitlement based on 7.4, we would need to multiply by 7.4 to get the correct hours. if we multiply by 5 are we not pro-rata-ing them twice?

if anyone could explain, that would be great

What it looks to me like is that you need to have something that connects weeks to years, i.e. 52 weeks in a year, or connects hours to years or may days to years since your 'bonus' is in days per year and other time units are in hours, days or weeks.

EDIT: Another way to look at it is if they worked the bonus day they would work x hours, but you pay them for the work even though they don't work that x hours.

 

[qetjack]

Please supply explanations:

Backstory: every full time colleague at our company works 37 hours per week. This is made up of 5 days at 7.4 hours each day. If you are full time, you are entitled to 22 days per year holiday.

So for example, if a colleague takes 12 days holiday by the end of the year, we will still owe him 10 days holiday. We need to convert this into hours to pay him, so we calculate 10*7.4 = 74 hours.

This is where i need help....
We have a part time colleague that works 20 hours per week. 4 days at 5 hours per day.
The way our company calculates holiday is pro-rata the full time equivalent (see the first paragraph)
A full time colleague is entiled to 22 days based on 37 hours per week, so we take 22 /37 and then * 20, to calculate how many a 20 hour colleague would be entitled to.

Say the colleague has taken some holidays (it doesnt matter how many) and for the purpose of the story, the colleague has 10 days remaining. How do i turn them into hours?

One manager says multiply the 10 days by 5 (because thats how many hours per day they work), another manager says we should still multiply the 10 days by 7.4, as we have already pro-ratad value.

The 2nd manager goes on to say the reduced value for part time is a representation based on 7.4 hours, so should be multiplied by that, otherwise we will effectively be pro-rata'ing twice.

Can you help explain the correct figure?

 

[qetjack]

Hi denis.

Sorry i think your first sum should be 22* 7.4 = 162.8 hours. You have done 22 x weeks when u have multiplied 37.

The problem is if you are part time, you are not entitled to 162.8 hours holiday, because that figure is based on you working full time.

This is why we do this sum:
22 (full time entitlement)/37(the hours per week full time colleagues work) * x ( number of hours the part time colleague works).

It would be so much easier if everything was in hours, but we have to calculate days and convert into hours.
Appreciate your help with this

 

[Ishuda]

...So say for example, we figure out this colleague is left with 3 days entitlement. frustratingly, they system we use to pay the colleagues those 3 days needs that entitlement converting into hours.

what would i multiply the 3 days by? the 5 hours that they work? or the 7.4 hours that a full time equivalent would work? ...

You have a constant a which when multiplied by 37 (the number of "full time hours") would give 22, i.e.
a = 22/37
to use for holiday days H;
HD = a * hw
where hw is the number of hours worked per week. For a 20 hour per week employee that would be 22*20/37 ~ 11.89 holiday days

If instead, you compute a constant b which when multiplied by 37 will given you the number of holiday hours, your problem would be over. Thus a full time employee works 7.4 hours per day and gets 7.4*22=162.8 holiday hours per year, so our constant is
b = 162.8/7.4 = 22
and the number of holiday hours an employee has is
HH = 22 hd
where hd is the (average) number of hours worked per day FOR A 5 DAY WORK WEEK.

So, if an employee works full time and takes a holiday day they are taking 7.4 hours and have (162.8-7.4)/7.4 = 21 holiday days left.

If an employee works 20 hours a week or 4 hours a day FOR A 5 DAY WORK WEEK they get
HH = 22 * 4 = 88 holiday hours
If we convert that to holiday days based on the 7.4 hour work day the number of holiday days they would have is 88/7.4 ~ 11.89 holiday days which is what we have above with your numbers for the 20 hour work. If they take a holiday then they have (88 - 7.4)/7.4 ~ 10.89 days remaining.

So the employee has an
HD = a * hw
where HD is based on the 7.4 hour work day and hw is the actual hours worked per week