Clean It Up
UK General Cleaning Forum => General Cleaning Forum => Topic started by: mxg on April 11, 2007, 12:12:40 pm
-
Guys
I understand all the stuff about 20 days entitlement and pro rata for days/hours worked.
My problem is that most of my people work different hours from week to week which further complicates matters.
So does anybody have a spreadsheet model that caters for this situation. I hate to reinvent the wheel and I already have far too much to do!
Fingers crossed in anticipation.
Mick
-
If your written statement with your employee states that their basic hours are X per week and from time to time additional hours may be needed then their holiday will be 4 weeks at X.
If your staff are on a written statement saying various hours then an average of the previous 12 weeks determines their entitlement.
Shouldn't be too difficult to set up on excel names in columns and hours in rows.
Hope this helps
Regards Kevin
-
Hi , we pay ours based on the average of the previous 12 weeks, hope it helps.
-
Hello, I don't employ anyone but my friend does - he works out the yearly total of hours and holiday pay, adds them together then works them back to an hourly rate so his blokes have save for their own holidays. It seems to work well because it makes the rate seem more attractive but they have never saved their holiday money so they are less inclined to take the time off. I don't know if its 100% legal but he has never had any grief
-
I think what you are referring to is known as "rolled up" holiday pay ie your hourly rate includes an element of holiday pay which as you say makes the rate seem more attractive.
Unfortunately in a case fairly recentlu or was it Brussels, it was deemed to be unfair so its not really kosher.
But undoubtedly it is much easy to administer
Don't you just love bureaucrats etc
Mick