Recent Question/Assignment

All relevant information relating to awards and award conditions must be sourced from the following website:
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 from13: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:30on Mon, Tues, Wed and Sun and from 6:00 – 12:30 on Saturday.
Jordan(Front Office grade1) – will be working from 22:00 – 6:30 Tues, Wed, Thursday and Friday and from 24:00 – 6:30 on Sat.
Sam(Front office grade 2) - will be working from 15:30 – 22:00on 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:00on Mon, Tues, wed and Thursday 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 Sunday 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 Thursday and from 6:00 – 14:30 on Fri.
2. Once you have developed the roster based on the above information, transfer the roster on TAB Part A and:
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.
c. Calculate work hours for the week for each staff member.
d. 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.
e. Calculate the wages for each staff member for the week for this roster.
f. Calculate the total wages for the week.
Duke restaurant
FRONT OFFICE Week commencing: 16 January 2017 to 22 January 2017
Grade employee Monday Tuesday Wed Thurs Fri Sat Sun Work hours Hourly rate Wages
Front office grade 1
Front office grade 1
Front office grade 1
Front office grade 2
Front office grade 2
Front office grade 3
Front office supervisor
Front office supervisor
Total Wages for this Week
Breaks: Each shifts include a 30 minute unpaid meal break
Weekly hours: Each staff member work 4 x 8 hours shifts and 1 x 6 hour shift

Looking for answers ?

Recent Questions