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/employe

and attached here for you are the rates as per Hospitality Industry (General) Award 2020 : a. Front Office Grade 1: $21.19 per hour
b. Front Office Grade 2: $21.92 per hour, c. Front Office Grade 3 : $23.09 per hour
d. Front Office Supervisor: $24.54 per hour
e. Front Office Supervisor grade 2:  $30.68 per hour

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)

 

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

 

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.

 

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

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