Reference no: EM133184031
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.
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.
g. Determine if the wage budget of $7200.00 for the week is being met. By how much is it over or under?