Ethan_Hunt
Active Member
- Joined
- Feb 26, 2008
- Messages
- 80
- Reaction score
- 48
Hey there folks!
Hope someone can please help me get my head around calculating the wages for my restaurant staff to be.
I understand that Sunday work time would be regarded as ordinary hours as we will be open on Sundays as well and should be calculated at 1.5 X regular wage. I further understand that all hours above 45 will be regarded as overtime hours and should also be calculated at 1.5 X regular wage.
All seems simple until I try to simulate a regular working week and then try to build my spread sheet to do the calculations… let me explain by means of an example assuming that for example the employee earns R14 per hour (regular wage). Further assume when we come to the end of the week, the times clocked are for example:
Monday = 9 hours worked
Tuesday = 9 hours worked
Wednesday = No work ( off day)
Thursday = 9 hours worked
Friday = 10 hours worked
Saturday = 10 hours worked
Sunday = 8 hours worked
The above hours already account for the 30 minute meal intervals and thus represent the actual hours worked which needs to be paid for and in this case totals 55 hours all and all.
To calculate overtime I suppose it’s simply subtracting 45 hours from 55 to get to 10 hours overtime.
I lose the plot more or less around here. Seeing that Sunday hours are regarded as ordinary hours also (but just paid differently) should I thus subtract the total Sunday hours (8hrs in this case) from 45 ordinary hours to get the ordinary hours excluding Sunday hours of 37. My payslip calculations will thus look like this.
Ordinary hours excluding Sunday hours = 37 hrs (37 hrs X R14 p/h = R518-00)
Sunday hours = 8 hrs (8 hrs X R14 p/h X 1.5 = R168-00)
Overtime hours = 10 hrs ( 10 hrs X R14 p/h X 1.5 = R210-00)
Could someone please check my logic or please explain to me by means of an example how a payslip would be calculated when a work week ordinarily includes work on a Sunday as well as overtime each week.
Kind regards and best wishes
DN
Hope someone can please help me get my head around calculating the wages for my restaurant staff to be.
I understand that Sunday work time would be regarded as ordinary hours as we will be open on Sundays as well and should be calculated at 1.5 X regular wage. I further understand that all hours above 45 will be regarded as overtime hours and should also be calculated at 1.5 X regular wage.
All seems simple until I try to simulate a regular working week and then try to build my spread sheet to do the calculations… let me explain by means of an example assuming that for example the employee earns R14 per hour (regular wage). Further assume when we come to the end of the week, the times clocked are for example:
Monday = 9 hours worked
Tuesday = 9 hours worked
Wednesday = No work ( off day)
Thursday = 9 hours worked
Friday = 10 hours worked
Saturday = 10 hours worked
Sunday = 8 hours worked
The above hours already account for the 30 minute meal intervals and thus represent the actual hours worked which needs to be paid for and in this case totals 55 hours all and all.
To calculate overtime I suppose it’s simply subtracting 45 hours from 55 to get to 10 hours overtime.
I lose the plot more or less around here. Seeing that Sunday hours are regarded as ordinary hours also (but just paid differently) should I thus subtract the total Sunday hours (8hrs in this case) from 45 ordinary hours to get the ordinary hours excluding Sunday hours of 37. My payslip calculations will thus look like this.
Ordinary hours excluding Sunday hours = 37 hrs (37 hrs X R14 p/h = R518-00)
Sunday hours = 8 hrs (8 hrs X R14 p/h X 1.5 = R168-00)
Overtime hours = 10 hrs ( 10 hrs X R14 p/h X 1.5 = R210-00)
Could someone please check my logic or please explain to me by means of an example how a payslip would be calculated when a work week ordinarily includes work on a Sunday as well as overtime each week.
Kind regards and best wishes
DN