Question: You are required to develop the roster for the week commencing 16 January 2017 to 22 January2017 , usingthespreadsheets provided. Note: The information provided below
- You are required to develop the roster for the week commencing 16 January 2017 to 22January2017, usingthespreadsheets provided.
Note:The information provided below includes a 30 minute meal break for each staff member.Youwill needto usetheRosterspreadsheet todevelop this staffrosteronthe firstTab.
Mark(Front Office grade 1) - will be working from 13.30 - 22.00 on Wed, Thurs, Fri and Sun andfrom13.30 -20.00onSat.
Tom(Front Office grade 1) - will be working from 6.00 - 14.30 on Mon, Tues, Wed and Sun andfrom6.00-12.30onSaturday.
Jordan(Front Office grade 1) - will be working from 22.00 - 6.30 Tues, Wed, Thurs and Fri andfrom24.00 -6.30onSat.
Sam(Front Office grade 2) - will be working from 15.30 - 22.00 on Mon, from 6.00 - 14.30 onThurs,Fri andSatandfrom13.30-22.00on Sun.
Shelly(Front Office grade 2) - will be working from 13.30 - 22.00 on Mon, Tues, Wed and Thursandfrom13.30-20.00onFri.
Darren(Front Office grade 3) - will be working from 22.00 - 6.30 on Mon, Fri, Sat and Sun andfrom24.00 -6.30onTues.
Scott(Front Office Supervisor) will be working from 6.00 - 14.30 on Mon, Tues, Wed and Sun andfrom6.00-12.30onThurs.
Margaret(Front Office Supervisor) - will be working from 15.30 - 22.00 on Tues, 13.30 - 22.00 onWedandSat,12.30-21.00 onThursandfrom6.00-14.30on Fri.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
