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

  1. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!