Pro Rata Help

charlie-louise88

i have never understood pro rata calculations and i need help with the following calculation that i need to understand

our standard annual leave is 22 days per year, i have an employee working 5 days a week 37.5 hours total.

she is now working 30 hours a week working a 4 day week from 4th march, how much pro rata annual leave is she entitled to until the end of the year from march including bank holidays

i been trying all week and i cant work this out, any help would be great

Torry_Quine

She is working 4/5 days so is entitled to 4/5 holiday leave. That works out as 17.6 days by my maths. She is also entitled to 4/5 of public holidays so if full timers get 8 then she gets 6.4 for them.

Sambucus_Nigra

charlie-louise88 wrote: »

i have never understood pro rata calculations and i need help with the following calculation that i need to understand

our standard annual leave is 22 days per year, i have an employee working 5 days a week 37.5 hours total.

she is now working 30 hours a week working a 4 day week from 4th march, how much pro rata annual leave is she entitled to until the end of the year from march including bank holidays

i been trying all week and i cant work this out, any help would be great

All week?

Firstly, she is entitled to 5.6 weeks leave. So in hours, 5.6 x 30 hours. So that's 168 hours. Or 22.4 days at 7.5 hours per day.

If she works bank hols, take those hours or days off.

The rest is annual leave.

anamenottaken

charlie-louise88 wrote: »

i have never understood pro rata calculations and i need help with the following calculation that i need to understand

our standard annual leave is 22 days per year, i have an employee working 5 days a week 37.5 hours total.

she is now working 30 hours a week working a 4 day week from 4th march, how much pro rata annual leave is she entitled to until the end of the year from march including bank holidays

i been trying all week and i cant work this out, any help would be great

Is your company holiday year January to December?
Has she worked for you since on or before 1 January 2013?

I could go through various scenarios depending on holiday year etc but easier if you answer those two questions first. If the answer to either of them is "no", give the actual holiday year and her start date with you.

Also confirm that your full-time people get 22 days plus bank holidays. If they get just 22 days including bank holidays, then that's not their entitlement.

anamenottaken

Sambucus_Nigra wrote: »

All week?

Firstly, she is entitled to 5.6 weeks leave. So in hours, 5.6 x 30 hours. So that's 168 hours. Or 22.4 days at 7.5 hours per day.

If she works bank hols, take those hours or days off.

The rest is annual leave.

That's for a whole year at the 30 hours a week basis for someone getting statutory minimum entitlement. I'm not sure if the OP is asking about a whole year or just a portion of it and full-time staff appear to get more than the minimum statutory entitlement.

anamenottaken

Torry_Quine wrote: »

She is working 4/5 days so is entitled to 4/5 holiday leave. That works out as 17.6 days by my maths. She is also entitled to 4/5 of public holidays so if full timers get 8 then she gets 6.4 for them.

Not a good idea to apportion "public holidays" like that. It depends on whether they would be normal working days. It may well be that she needs to be allocated more or fewer depending on which day of the week she doesn't normally work.

paddedjohn

For Jan/Feb she gets 1/6 of the full time entitlement so 5 days earned there, for the other5/6ths of the year she earns 4/5ths that of a full timer so 5/6ths of 24=20 days. By my reckoning its 25 days for the year less what she has had so far.

anamenottaken

paddedjohn wrote: »

For Jan/Feb she gets 1/6 of the full time entitlement so 5 days earned there, for the other5/6ths of the year she earns 4/5ths that of a full timer so 5/6ths of 24=20 days. By my reckoning its 25 days for the year less what she has had so far.

Not quite.
The balance of the year (March to December) for a full-timer is 25 days, not 24.
It's not 5/6th but 4/5th of those 25 days but that of course is indeed 20 days.

Torry_Quine

anamenottaken wrote: »

Not a good idea to apportion "public holidays" like that. It depends on whether they would be normal working days. It may well be that she needs to be allocated more or fewer depending on which day of the week she doesn't normally work.

She is entitled to pro-rata public public holidays and if one falls on a day she works then she has one less to take off.

paddedjohn

anamenottaken wrote: »

Not quite.
The balance of the year (March to December) for a full-timer is 25 days, not 24.
It's not 5/6th but 4/5th of those 25 days but that of course is indeed 20 days.

Yes your right I wrote my working out wrong (grandson wanting help with his homework) but the sum is still the same, she is entitled to 25 days this year less what she has already used.

Sambucus_Nigra

anamenottaken wrote: »

That's for a whole year at the 30 hours a week basis for someone getting statutory minimum entitlement. I'm not sure if the OP is asking about a whole year or just a portion of it and full-time staff appear to get more than the minimum statutory entitlement.

YEs but we don't know when the holiday year starts or ends and we aren't mind readers! Once we know we can apportion it out.