Spreadsheet: 841527d1693713908-calculating-employee-work-hours-and-overtime-based-on-maximum-ordinary-week-hours-emp44823_spot-check-labourer
Sheet: Labourer

Client name
Employee Name | N/A - Labourer
Age
EE Status (FT, PT, CAS) | FT
Award | Building and Construction General On-site Award 2020
[NAME] | General building and construction – residential building industry building industry
 |  |  | ROSTERED HOURS |  | ORDINARY HOURS |  |  |  |  | Note: [NAME] hrs to [NAME] of 38 per week then divert to OT | OVERTIME HOURS |  |  |  | RATES AS PER PAY RATE SCHEDULES O R PACT
CW1 Level (d) |  |  |  |  | Note: See award/ PRS for maximum ord hrs that can be  worked per day/shift |  |  |  |  |  | Note: See award for OT provisions |  |  |  | Ord hours Monday to Friday | Ord Hours Sat | Ord hours Sun | Additional Rate 1 | Additional Rate 2 | Overtime 150% first two hours | Overtime 200% (or overtime weekends) | Additional OT 1 | Total Daily Pay | Allowances as per PRS or PACT | Total Weekly Pay | Loaded rate including ALL
 | Start time | Finish time | Total hours rostered | Rostered Unpaid Breaks eg lunch breaks | Ord hours Monday to Friday | Ord Hours Sat | Ord hours Sun | Additional Rate 1 | Additional Rate 2 | Cumulative ord hours total | Overtime 150% first two hours | Overtime 200% (or overtime weekends) | Additional OT 1 | Total Hours worked per week | 26.2 |  |  |  |  | 39.3 | 52.4 |  |  |  |  | 0.175
Monday | 6 | 14.5 |  |  | 8
Tuesday | 6 | 14.5 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Allowances TABLE
Wednesday | 6 | 14.5 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Allowance | Frequency | Allowance rate | Units (ie how many hrs or shifts) | Allowance cost per week
Thursday | 6 | 15.5 |  |  | 8 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meal | Per Occasion | 17.57 | 4 | 70.28
Friday | 6 | 15.5 |  |  | 6 |  |  |  |  |  | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Industry allowance included in rate |  | $                            - |  | $                       -
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $                            - |  | $                       -
Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $                            - |  | $                       -
Monday | 6 | 14.5 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $                            - |  | $                       -
Tuesday | 6 | 14.5 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $                            - |  | $                       -
Wednesday | 6 | 14.5 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $                            - |  | $                       -
Thursday | 6 | 15.5 |  |  | 8 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $                            - |  | $                       -
Friday | 6 | 15.5 |  |  | 6 |  |  |  |  |  | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | 70.28
Saturday
Sunday
Monday | 6 | 14.5 |  |  | 8
Tuesday | 6 | 14.5 |  |  | 8
Wednesday | 6 | 14.5 |  |  | 8
Thursday | 6 | 15.5 |  |  | 8 |  |  |  |  |  | 1
Friday | 6 | 15.5 |  |  | 6 |  |  |  |  |  | 2 | 1
Saturday
Sunday
Monday | 6 | 14.5 |  |  | 8
Tuesday | 6 | 14.5 |  |  | 8
Wednesday | 6 | 14.5 |  |  | 8
Thursday | 6 | 15.5 |  |  | 8 |  |  |  |  |  | 1
Friday | 6 | 15.5 |  |  | 6 |  |  |  |  |  | 2 | 1
Saturday | 6 | 14.5 |  |  | 8 |  |  |  |  |  | 2 | 6
Sunday
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5336.48 | 30.67 | 70180.78