Case Study

The Duke Hotel is a popular hotel that runs a 24/7 front office, business centre, reception and on-site cafe. It is situated on a busy highway and is often used by overnight travellers, businesspeople and long-haul truck and freight drivers. 

It is a large hotel with 135 various rooms and runs multiple services 24 hours a day and this requires adequate and appropriate staffing in the front office to manage the operational needs of the customers, cleaning and kitchen. 

Maintaining appropriate staffing levels in the Front Office with relevant experience and abilities is at times a difficult task for The Duke. The majority of the staff are cross trained and have been with the Duke for a long time and so know the operating procedures very well.  

 

Rostering Project

Our Task  -

All relevant information relating to awards and award conditions must be sourced from the following website: https://www.fairwork.gov.au/employment-conditions/national-employment-standards

and attached here for you to refer the rates as per Hospitality Industry (General) Award 2020:
a. Front Office grade 1 = $21.19 ,  b. Front Office grade 2 = $21.92, c. Front Office Supervisor = $24.54
Assessment Task 3A:

You are required to develop the roster for the week commencing 27th March 2023 to 2nd April 2023, using the template provided for the Front Office of the Duke Hotel

Note: The information provided below includes a 30 minute meal break for each staff member.   (You MAY use a spreadsheet to develop this staff roster FIRST then transfer it into the template provided. Please upload this spreadsheet with your assessment if you find it easier)
Staff details and hours:

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. 

Akim (Casual on call) Can cover up to Front Office Supervisor grade 2 - is at University full time but will accommodate shifts when possible. Evenings and weekends are best.

Annie (Casual) Can cover up to Front Officer Supervisor grade 2 - only available when husband can sit their 8month old baby. Evenings are best but can be flexible.

 

USE this template:  Roster Template_ SITXHRM002 Ass 3A & 3B 2023

 DUKE RESTAURANT
FRONT OFFICE: 	   Week Commencing:	27th March 2023 TO 2nd April 2023	
Grade	Employee	Monday	Tuesday	Wed	Thru	Fri	Sat	Sun	Total Hours	Hourly Rate	Notes:
F/O Grade 1	Mark	  
  
  	  	  	  	  	  	  	  	  	
F/O Grade 1  	Tom	  
  
  	  	  	  	  	  	  	  	  	
F/O Grade 1  	Jordan	  
  
  	  	  	  	  	  	  	  	  	  
F/O Grade 2  	Sam	  
  
  	  	  	  	  	  	  	  	  	  
F/O Grade 2  	Shelly	  
  
  	  		  	  	  	  	  	  	  
F/O Grade 3  	Darren	  
  
  	  	  	  	  	  	  	  	  	  
F/O
Supervisor  	Scott	  
  
  	  	  	  	  	  	  	  	  	  
F/O
Supervisor  	Margaret	  
  
  	  	  	  	  	  	  	  	  	  
 
    F/O = Front Office	Breaks: Each shift includes a 30-minute unpaid meal break  
Weekly Hours: Each staff member work 4 x 8-hour shifts and 1 x 6-hour shift   
Casual Staff: Rate of shift cover + 25% loading
Overtime shifts: Short notice coverage may be authorised as Overtime (or Extension of shift) from other staff member on their days off of a continuity of shifts not exceeding 12 hours.
Overtime/Extension rates: First 3 hours 1.5 x hourly rate; thereafter double hourly rate.
Saturday overtime rate: Hourly rate +50% loading/hr
Sunday overtime rate: Hourly rate + 75% loading/hr 	

Assessment Task 3B:

Check if each employee has at least two rostered days off in the week. Highlight these days in colour.
Calculate work hours for the week for each staff member - add to the table in labelled column
Find the hourly rate according to the correct award for the following positions and add to the table next to relevant staff in labelled column:
Front Office Grade 1
Front Office Grade 2
Front Officer Supervisor
 Ensure prior to submitting your assessment that you:

Entered dates into the roster table
Upload excel spreadsheet (IF USED) to assist you preparing roster
Finished all elements of PART B on roster table
 Roster Template_ SITXHRM002 Ass 3A & 3B 2023