HOSP 1015 – Managing the Hotel Guest Experience Term Project The following project will be completed in three sections and will be handed in during the second part of the term. Each Project section is outlined below with the instructions and due dates.

20180412204928schedule_template_spring_2018_2_.xlsx

Overview

HOSP 1015 Managing the Guest Experience
Scheduling Practice
Steps in the Scheduling Process:
1	Use the given Forecast of Occupied Rooms each night.
2	Apply the staffing guide to calculate the number of hours to be scheduled each day.
3	Enter the NUMBER OF HOURS (not the start and stop time) for the employees you schedule.
	No Overtime (over 40 hours a week)
	Two consequetive Days off for each employee
4	Save the Excel File.
5	Copy the Schedule into your approval memo (Word Document). As a PICTURE.
6	Complete your approval memo and submit.

HOSP 1015: Scheduling Form
Date	10/26	10/27	10/28	10/29	10/30	10/31	11/1
Day	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
Forecasted Occupancy	120	130	100	90	60	140	150
Guest Room Attendant - Required Hours
Amy
Brad
Carly
David
Frank
Gretchen
Holly
Isabella
Jake
Kelly
Laura
Mike
Total Scheduled Man Hours	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Variance to Staffing Guide (+/-)	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Runners - Required Hours
Nathan
Ophelia
Paula
Raymond
Sarah
Total Scheduled Man Hours	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Variance to Staffing Guide (+/-)	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Laundry Attendants = Required Hours
Tim
Victoria
Walter
Yuni
Zach
Total Scheduled Man Hours	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Variance to Staffing Guide (+/-)	0.0	0.0	0.0	0.0	0.0	0.0	0.0

HOSP 1015: Staffing Guide
Guest Room Attendant	0.5	Man Hours Per Occupied Room
Runners	0.1	Man Hours Per Occupied Room
Laundry Attendants	0.05	Man Hours Per Occupied Room
For each of the positions above, you are allowed to schedule to the forecasted rooms occupied.