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

Editable Microsoft Excel Workbook
Worksheet Count: 1 worksheet

Buy Now at $19.99 USD
This above price is for already used answers. Please do not submit them directly as it may lead to plagiarism. Once paid, the deal will be non-refundable and there is no after-sale support for the quality or modification of the contents. Either use them for learning purpose or re-write them in your own language. If you are looking for new unused assignment, please use live chat to discuss and get best possible quote.

Looking for answers ?