Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
ASSESSMENT 2 ROSTER STAFF Part A
ASSESSMENT 2
ROSTER STAFF
Part A.
QUESTION 1)You are required to develop the roster for the week commencing 16 January 2017 to 22 January 2017, using the spreadsheets provided.
Note: The information provided below includes a 30-minute meal break for each staff member. You will need to use the Roster spreadsheet to develop this staff roster on the first Tab.
Mark (Front Office grade 1) – will be working from 13.30 – 22.00 on Wed, Thurs, Fri and Sun and from 13.30 – 20.00 on Sat.
Tom (Front Office grade 1) – will be working from 6.00 – 14.30 on Mon, Tues, Wed and Sun and from 6.00 – 12.30 on Saturday.
Jordan (Front Office grade 1) – will be working from 22.00 – 6.30 Tues, Wed, Thurs and Fri and from 24.00 – 6.30 on Sat.
Sam (Front Office grade 2) – will be working from 15.30 – 22.00 on Mon, from 6.00 – 14.30 on Thurs, Fri and Sat and from 13.30 – 22.00 on Sun.
Shelly (Front Office grade 2) – will be working from 13.30 – 22.00 on Mon, Tues, Wed and Thurs and from 13.30 – 20.00 on Fri.
Darren (Front Office grade 3) – will be working from 22.00 – 6.30 on Mon, Fri, Sat and Sun and from 24.00 – 6.30 on Tues.
Scott (Front Office Supervisor) will be working from 6.00 – 14.30 on Mon, Tues, Wed and Sun and from 6.00 – 12.30 on Thurs.
Margaret (Front Office Supervisor) – will be working from 15.30 – 22.00 on Tues, 13.30 – 22.00 on Wed and Sat, 12.30 – 21.00 on Thurs and from 6.00 – 14.30 on Fri.
|
Duke College |
||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
|
Front office Grade 1 |
Mark |
|
|
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
13.30-22.00 |
38 |
|
|
Front office Grade 1 |
Tom |
6.00-14-30 |
6.00-14-30 |
6.00-14-30 |
|
|
6.00-12.30 |
6.00-14.30 |
38 |
|
|
Front office Grade 1 |
Jordan |
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
24.00-6.30 |
|
38 |
|
|
Front office Grade 2 |
Sam |
15.30-22.00 |
|
|
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
13.30-22.00 |
38 |
|
|
Front office Grade 2 |
Shelly |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
|
|
38 |
|
|
Front office Grade 3 |
Darren |
22.00-6.30 |
24.00-6.30 |
|
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
38 |
|
|
Front office Supervisor |
Scott |
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
6.00-12.30 |
|
|
6.00-14.30 |
38 |
|
|
Front office Supervisor |
Margaret |
|
15.30-22.00 |
13.30-22.00 |
12.30-21.00 |
6.00-14.30 |
13.30-22.00 |
|
38 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Breaks: Each shift includes a 30 min unpaid meal break |
||||||||||
|
Weekly Hours: Each staff member work 4x8-hour shifts 1x6-hour shift |
||||||||||
|
Duke College |
||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
Penalty rates |
|
||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Weekdays |
Saturday |
Sunday |
Wages |
||||
|
Front office Grade 1 |
Mark |
|
|
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
13.30-22.00 |
38 |
|
|
|
|
|
||||
|
Front office Grade 1 |
Tom |
6.00-14-30 |
6.00-14-30 |
6.00-14-30 |
|
|
6.00-12.30 |
6.00-14.30 |
38 |
|
|
|
|
|
||||
|
Front office Grade 1 |
Jordan |
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
24.00-6.30 |
|
38 |
|
|
|
|
|
||||
|
Front office Grade 2 |
Sam |
15.30-22.00 |
|
|
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
13.30-22.00 |
38 |
|
|
|
|
|
||||
|
Front office Grade 2 |
Shelly |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
|
|
38 |
|
|
|
|
|
||||
|
Front office Grade 3 |
Darren |
22.00-6.30 |
24.00-6.30 |
|
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
38 |
|
|
|
|
|
||||
|
Front office Supervisor |
Scott |
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
6.00-12.30 |
|
|
6.00-14.30 |
38 |
|
|
|
|
|
||||
|
Front office Supervisor |
Margaret |
|
15.30-22.00 |
13.30-22.00 |
12.30-21.00 |
6.00-14.30 |
13.30-22.00 |
|
38 |
|
|
|
|
|
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
Breaks: Each shift includes a 30 min unpaid meal break |
|
|
|
|
||||||||||||||
|
Weekly Hours: Each staff member work 4x8-hour shifts 1x6-hour shift |
|
|
|
|
||||||||||||||
|
Total Wages for the Week |
|
|
|
|
||||||||||||||
Part B.
QUESTION 2. A) Check if each employee has at least two rostered days off in the week. Highlight these days in grey colour.
B) Calculate the weekly wages for each of the staff.
For Mark:
|
|
Duke College |
|||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
|
Penalty rates |
|
|||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Break |
Night penalty |
Saturday |
Sunday |
Wages |
|
||||
|
Front office Grade 1 |
Mark |
|
|
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
13.30-22.00 |
Half hour unpaid break |
$20.82 |
2.5hrs |
$2.27 till midnight-$3.41 till 7am |
$26.03 |
$31.23 |
|
|
||||
|
Working hour excluding break |
|
|
|
8 |
8 |
8 |
6 |
8 |
38 |
|
|
|
|
|
|
|
||||
|
Mon-Fri after 7pm to midnight |
|
|
|
3 |
3 |
3 |
|
|
|
|
|
|
|
|
|
|
||||
|
Mon-Fri after midnight to 7Am |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||
Total weekdays: 24 X 20.82= 499.68
Saturday: 6 X 26.03= 156.18
Sunday: 8 X 31.23= 249.84
Night penalty: 9 X 2.27=20.43
Weekly total wages: 499.68+156.18+249.84+20.43=$926.13
For Tom:
|
|
Duke College |
|||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
|
Penalty rates |
|
|||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Break |
Night penalty |
Saturday |
Sunday |
Wages |
|
||||
|
Front office Grade 1 |
Tom |
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
|
|
6.00-12.30 |
6.00-14.30 |
Half hour unpaid break |
$20.82 |
2.5hrs |
$2.27 till midnight-$3.41 till 7am |
$26.03 |
$31.23 |
|
|
||||
|
Working hour excluding break |
|
8 |
8 |
8 |
|
|
6 |
8 |
38 |
|
|
|
|
|
|
|
||||
|
Mon-Fri after 7pm to midnight |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||
|
Mon-Fri after midnight to 7Am |
|
1 |
1 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
||||
Total weekdays: 24 X 20.82= 499.68
Saturday: 6 X 26.03= 156.18
Sunday: 8 X 31.23= 249.84
Night penalty: 3 X 3.41=10.23
Weekly total wages: 499.68+156.18+249.84+10.23= $915.93
For Jordan
|
|
Duke College |
|||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
|
Penalty rates |
|
|||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Break |
Night penalty |
Saturday |
Sunday |
Wages |
|
||||
|
Front office Grade 1 |
Jordan |
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
24.00-6.30 |
|
Half hour unpaid break |
$20.82 |
2.5hrs |
$2.27 till midnight-$3.41 till 7am |
$26.03 |
$31.23 |
|
|
||||
|
Working hour excluding break |
|
|
8 |
8 |
8 |
8 |
6 |
|
38 |
|
|
|
|
|
|
|
||||
|
Mon-Fri after 7pm to midnight |
|
|
2 |
2 |
2 |
2 |
|
|
|
|
|
|
|
|
|
|
||||
|
Mon-Fri after midnight to 7Am |
|
|
6 |
6 |
6 |
6 |
|
|
|
|
|
|
|
|
|
|
||||
Total weekdays: 32 X 20.82= 666.24
Saturday: 6 X 26.03= 156.18
Night penalty after 7pm to midnight: 8 X 2.27= 18.16
Night penalty after midnight to 7am: 24 X 3.41=81.84
Weekly total wages: 666.24+156.18+18.16+81.84=$922.42
For Sam
|
|
Duke College |
|||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
|
Penalty rates |
|
|||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Break |
Night penalty |
Saturday |
Sunday |
Wages |
|
||||
|
Front office Grade 2 |
Sam |
15.30-22.00 |
|
|
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
13.30-22.00 |
Half hour unpaid break |
$21.54 |
2.5hrs |
$2.27 till midnight-$3.41 till 7am |
$26.93 |
$32.31 |
|
|
||||
|
Working hour excluding break |
|
6 |
|
|
8 |
8 |
8 |
8 |
38 |
|
|
|
|
|
|
|
||||
|
Mon-Fri after 7pm to midnight |
|
3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||
|
Mon-Fri after midnight to 7Am |
|
|
|
|
1 |
1 |
|
|
|
|
|
|
|
|
|
|
||||
Total weekdays: 22 X 21.54=473.88
Saturday: 8 X 26.93= 215.44
Sunday: 8 X 32.31= 258.48
Night penalty after 7pm to midnight: 3 X 2.27=6.81
Night penalty after midnight to 7am: 2 X 3.41=6.82
Weekly total wages: 473.88+215.44+258.48+6.81+6.82=$961.43
For Shelly
|
|
Duke College |
|||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
|
Penalty rates |
|
|||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Break |
Night penalty |
Saturday |
Sunday |
Wages |
|
||||
|
Front office Grade 2 |
Shelly |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
|
|
Half hour unpaid break |
$21.54 |
2.5hrs |
$2.27 till midnight-$3.41 till 7am |
$26.93 |
$32.31 |
|
|
||||
|
Working hour excluding break |
|
8 |
8 |
8 |
8 |
6 |
|
|
38 |
|
|
|
|
|
|
|
||||
|
Mon-Fri after 7pm to midnight |
|
3 |
3 |
3 |
3 |
1 |
|
|
|
|
|
|
|
|
|
|
||||
|
Mon-Fri after midnight to 7Am |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||
Total weekdays: 38 X 21.54=818.52
Night penalty after 7pm to midnight:13 X 2.27= 29.51
Weekly total wages: 818.52 + 29.51= $848.03
For Darren
|
|
Duke College |
|||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
|
Penalty rates |
|
|||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Break |
Night penalty |
Saturday |
Sunday |
Wages |
|
||||
|
Front office Grade 3 |
Darren |
22.00-6.30 |
24.00-6.30 |
|
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
Half hour unpaid break |
$22.70 |
2.5hrs |
$2.27 till midnight-$3.41 till 7am |
$28.38 |
$34.05 |
|
|
||||
|
Working hour excluding break |
|
8 |
6 |
|
|
8 |
8 |
8 |
38 |
|
|
|
|
|
|
|
||||
|
Mon-Fri after 7pm to midnight |
|
2 |
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
||||
|
Mon-Fri after midnight to 7Am |
|
6 |
6 |
|
|
6 |
|
|
|
|
|
|
|
|
|
|
||||
Total weekdays: 22 X 22.70=499.40
Saturday: 8 X 28.38=227.04
Sunday: 8 X 34.05=272.40
Night penalty after 7pm to midnight: 4 X 2.27=9.08
Night penalty after midnight to 7am: 18 X 3.41=61.38
Weekly total wages:499.40+227.04+272.40+9.08+61.38=$1069.30
For Scott
|
|
Duke College |
||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
|
Penalty rates |
|
||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Break |
Night penalty |
Saturday |
Sunday |
Wages |
|
|||
|
Front office Supervisor |
Scott |
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
6.00-12.30 |
|
|
6.00-14.30 |
Half hour unpaid break |
$24.12 |
2.5hrs |
$2.27 till midnight-$3.41 till 7am |
$30.15 |
$36.18 |
|
|
|||
|
Working hour excluding break |
|
8 |
8 |
8 |
6 |
|
|
8 |
38 |
|
|
|
|
|
|
|
|||
|
Mon-Fri after 7pm to midnight |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
Mon-Fri after midnight to 7Am |
|
1 |
1 |
1 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|||
Total weekdays: 30 X 24.12=723.6
Sunday: 8 X 36.18=289.44
Night penalty after midnight to 7am: 4 X 3.41=13.64
Weekly total wages:723.6+289.44+13.64= $1026.68
For Margaret
|
|
Duke College |
||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
|
Penalty rates |
|
||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Break |
Night penalty |
Saturday |
Sunday |
Wages |
|
|||
|
Front office Supervisor |
Margaret |
|
15.30-22.00 |
13.30-22.00 |
12.30-21.00 |
6.00-14.30 |
13.30-22.00 |
|
Half hour unpaid break |
$24.12 |
2.5hrs |
$2.27 till midnight-$3.41 till 7am |
$30.15 |
$36.18 |
|
|
|||
|
Working hour excluding break |
|
|
6 |
8 |
8 |
8 |
8 |
|
38 |
|
|
|
|
|
|
|
|||
|
Mon-Fri after 7pm to midnight |
|
|
3 |
3 |
2 |
|
|
|
|
|
|
|
|
|
|
|
|||
|
Mon-Fri after midnight to 7Am |
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
|
|||
Total weekdays:30 x 24.12=723.6
Saturday: 8 X 30.15=241.2
Night penalty after 7pm to midnight: 8 X 2.27=18.16
Night penalty after midnight to 7am: 1 X 3.41=3.41
Weekly total wages: $986.37
C) Calculate work hours for the week for each staff member.
|
Duke College |
||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
Penalty rates |
|
||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Weekdays |
Saturday |
Sunday |
Wages |
||||
|
Front office Grade 1 |
Mark |
|
|
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
13.30-22.00 |
38 |
|
|
|
|
$926.13 |
||||
|
Front office Grade 1 |
Tom |
6.00-14-30 |
6.00-14-30 |
6.00-14-30 |
|
|
6.00-12.30 |
6.00-14.30 |
38 |
|
|
|
|
$915.93 |
||||
|
Front office Grade 1 |
Jordan |
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
24.00-6.30 |
|
38 |
|
|
|
|
$922.42 |
||||
|
Front office Grade 2 |
Sam |
15.30-22.00 |
|
|
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
13.30-22.00 |
38 |
|
|
|
|
$961.43 |
||||
|
Front office Grade 2 |
Shelly |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
|
|
38 |
|
|
|
|
$848.03 |
||||
|
Front office Grade 3 |
Darren |
22.00-6.30 |
24.00-6.30 |
|
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
38 |
|
|
|
|
$1069.30 |
||||
|
Front office Supervisor |
Scott |
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
6.00-12.30 |
|
|
6.00-14.30 |
38 |
|
|
|
|
$1026.68 |
||||
|
Front office Supervisor |
Margaret |
|
15.30-22.00 |
13.30-22.00 |
12.30-21.00 |
6.00-14.30 |
13.30-22.00 |
|
38 |
|
|
|
|
$986.37 |
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
Breaks: Each shift includes a 30 min unpaid meal break |
|
|
|
|
||||||||||||||
|
Weekly Hours: Each staff member work 4x8-hour shifts 1x6-hour shift |
|
|
|
|
||||||||||||||
|
Total Wages for the Week |
|
|
|
$7656.29 |
||||||||||||||
D) Calculate the wages for each member for the week for this roster.
|
Duke College |
||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
Penalty rates |
|
||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Weekdays |
Saturday |
Sunday |
Wages |
||||
|
Front office Grade 1 |
Mark |
|
|
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
13.30-22.00 |
38 |
|
|
|
|
$926.13 |
||||
|
Front office Grade 1 |
Tom |
6.00-14-30 |
6.00-14-30 |
6.00-14-30 |
|
|
6.00-12.30 |
6.00-14.30 |
38 |
|
|
|
|
$915.93 |
||||
|
Front office Grade 1 |
Jordan |
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
24.00-6.30 |
|
38 |
|
|
|
|
$922.42 |
||||
|
Front office Grade 2 |
Sam |
15.30-22.00 |
|
|
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
13.30-22.00 |
38 |
|
|
|
|
$961.43 |
||||
|
Front office Grade 2 |
Shelly |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
|
|
38 |
|
|
|
|
$848.03 |
||||
|
Front office Grade 3 |
Darren |
22.00-6.30 |
24.00-6.30 |
|
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
38 |
|
|
|
|
$1069.30 |
||||
|
Front office Supervisor |
Scott |
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
6.00-12.30 |
|
|
6.00-14.30 |
38 |
|
|
|
|
$1026.68 |
||||
|
Front office Supervisor |
Margaret |
|
15.30-22.00 |
13.30-22.00 |
12.30-21.00 |
6.00-14.30 |
13.30-22.00 |
|
38 |
|
|
|
|
$986.37 |
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
Breaks: Each shift includes a 30 min unpaid meal break |
|
|
|
|
||||||||||||||
|
Weekly Hours: Each staff member work 4x8-hour shifts 1x6-hour shift |
|
|
|
|
||||||||||||||
|
Total Wages for the Week |
|
|
|
$7656.29 |
||||||||||||||
Mark weekly wage is $926.13
Tom weekly wage is $915.93
Jordan weekly wage is $922.42
Sam weekly wage is $961.43
Shelly weekly wage is $848.03
Darren weekly wage is $1069.30
Scott weekly wage is $1026.68
Margaret weekly wage is $986.37
E) Calculate the total wages for the week.
That is 926.13+915.93+922.42+961.43+848.03+1069.30+1026.68+986.37=$7656.29
So, $7656.29 is the total wages for the week.
|
Duke College |
||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
Penalty rates |
|
||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Weekdays |
Saturday |
Sunday |
Wages |
||||
|
Front office Grade 1 |
Mark |
|
|
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
13.30-22.00 |
38 |
|
|
|
|
$926.13 |
||||
|
Front office Grade 1 |
Tom |
6.00-14-30 |
6.00-14-30 |
6.00-14-30 |
|
|
6.00-12.30 |
6.00-14.30 |
38 |
|
|
|
|
$915.93 |
||||
|
Front office Grade 1 |
Jordan |
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
24.00-6.30 |
|
38 |
|
|
|
|
$922.42 |
||||
|
Front office Grade 2 |
Sam |
15.30-22.00 |
|
|
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
13.30-22.00 |
38 |
|
|
|
|
$961.43 |
||||
|
Front office Grade 2 |
Shelly |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
|
|
38 |
|
|
|
|
$848.03 |
||||
|
Front office Grade 3 |
Darren |
22.00-6.30 |
24.00-6.30 |
|
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
38 |
|
|
|
|
$1069.30 |
||||
|
Front office Supervisor |
Scott |
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
6.00-12.30 |
|
|
6.00-14.30 |
38 |
|
|
|
|
$1026.68 |
||||
|
Front office Supervisor |
Margaret |
|
15.30-22.00 |
13.30-22.00 |
12.30-21.00 |
6.00-14.30 |
13.30-22.00 |
|
38 |
|
|
|
|
$986.37 |
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
Breaks: Each shift includes a 30 min unpaid meal break |
|
|
|
|
||||||||||||||
|
Weekly Hours: Each staff member work 4x8-hour shifts 1x6-hour shift |
|
|
|
|
||||||||||||||
|
Total Wages for the Week |
|
|
|
$7656.29 |
||||||||||||||
F) Locate the correct hourly rate for each staff member based on their award including penalty rates which apply for specific times during weekdays and for Saturdays and Sundays.
|
Duke College |
|||||||||||||||||||||
|
FRONT OFFICE Week Commencing: 16 January 2017 to 22 January 2017 |
Penalty rates |
|
|||||||||||||||||||
|
Grade |
Employee |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
Sunday |
Work Hours |
Hourly Rate |
Weekdays |
Saturday |
Sunday |
Wages |
|||||||
|
Front office Grade 1 |
Mark |
|
|
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
13.30-22.00 |
38 |
$20.82 |
|
$26.03 |
$31.23 |
$926.13 |
|||||||
|
Front office Grade 1 |
Tom |
6.00-14-30 |
6.00-14-30 |
6.00-14-30 |
|
|
6.00-12.30 |
6.00-14.30 |
38 |
$20.82 |
|
$26.03 |
$31.23 |
$915.93 |
|||||||
|
Front office Grade 1 |
Jordan |
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
24.00-6.30 |
|
38 |
$20.82 |
|
$26.03 |
$31.23 |
$922.42 |
|||||||
|
Front office Grade 2 |
Sam |
15.30-22.00 |
|
|
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
13.30-22.00 |
38 |
$21.52 |
|
$26.93 |
$32.31 |
$961.43 |
|||||||
|
Front office Grade 2 |
Shelly |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-22.00 |
13.30-20.00 |
|
|
38 |
$21.52 |
|
$26.93 |
$32.31 |
$848.03 |
|||||||
|
Front office Grade 3 |
Darren |
22.00-6.30 |
24.00-6.30 |
|
|
22.00-6.30 |
22.00-6.30 |
22.00-6.30 |
38 |
$22.70 |
|
$28.38 |
$34.05 |
$1069.30 |
|||||||
|
Front office Supervisor |
Scott |
6.00-14.30 |
6.00-14.30 |
6.00-14.30 |
6.00-12.30 |
|
|
6.00-14.30 |
38 |
$24.12 |
|
$30.15 |
$36.18 |
$1026.68 |
|||||||
|
Front office Supervisor |
Margaret |
|
15.30-22.00 |
13.30-22.00 |
12.30-21.00 |
6.00-14.30 |
13.30-22.00 |
|
38 |
$24.12 |
|
$30.15 |
$36.18 |
$986.37 |
|||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||||
|
Breaks: Each shift includes a 30 min unpaid meal break |
|
|
|
|
|||||||||||||||||
|
Weekly Hours: Each staff member work 4x8-hour shifts 1x6-hour shift |
|
|
|
|
|||||||||||||||||
|
Total Wages for the Week |
|
|
|
$7656.29 |
|||||||||||||||||
Expert Solution
PFA
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.
