20180404163735hosp_1015_term_project_spring_20181 x20180412204928schedule_template_spring_2018_2_.xlsx
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.
For this project you are the hypothetical owner of a 200-room hotel. You will make several decisions, and will present several parts of your operating plan. Read the entire project to have an understanding of the project requirements.
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.
For this project you are the hypothetical owner of a 200-room hotel. You will make several decisions, and will present several parts of your operating plan. Read the entire project to have an understanding of the project requirements.
Project I: Classification, Brand, Location, ADR and Average Wage Rate
You will make the following decisions about your hotel, and present these in a paper. Format instructions for your paper are at the end of this project document.
1. Classification: Will you be an economy hotel, a limited service hotel, a full service hotel, or a luxury hotel? Whatever you choose to be, you need to describe your hotel, the services you will offer, and WHY you chose this.
2. Brand: You will select an appropriate brand for your hotel, and describe specifically why you chose that brand.
3. Management: Will you select the Brand to manage your hotel, or an independent management company? Why will you make that decision?
4. Location: Where will your hotel be located? A specific city and state, and an address within this area (Google maps satellite view comes in really handy for this). Why did you choose to locate here?
5. Average Daily Rate: You will research the average room rates for similar hotels in the area you select (using Kayak, Expedia, and others). You need to review at least four seasonal dates and create an average rate for your hotel. This will be considered your “rack rate”. In addition create a minimum of 5 special or discounted rates for different markets of guests.
6. Average Wage Rate: You will need to determine what the minimum wage is for your market (mimimumwage.com). This information is helpful for building schedules and other financial data.
Project 2: Management Organization
1. Create a Management Organizational Chart for your hotel. You must use the SmartArt graphics in Word to create this chart in your document.
2. For each position, provide a detailed list (Job Description) of the responsibilities of the job and include the skills required for the job. You will need to do some internet research for this!
3. Assume that after your management staffing was completed that it was decided by your management company that you will need to eliminate one management position.
a. Which Management position would you eliminate?
b. Why that position?(Provide a detailed explanation)
c. How would you cover the responsibilities of that manager? (Provide a detailed explanation. Keep in mind that the duties may need to be assigned to several other positions)
Project 3: Developing a weekly schedule
1. You need to develop a one week schedule for your Housekeeping employees.
2. Using the Excel spreadsheet that is provided in this week’s assignment(located in ulearn), you will prepare a schedule for the week.
a. The day-by-day occupied rooms forecast has been given to you for the week.
b. Using the Staffing guideline, determine how many hours you will need to schedule each day.
c. You must staff the hours as closely as possible to the staffing guide each day.
Write a professionally formatted memo to your General Manager requesting approval of your schedule for the week.
Note: When using the Excel spreadsheet for parts of your assignment, you will need to insert the relevant parts of the spreadsheet into your Word document by copy/paste function.
FORMAT Requirements (for ALL Sections of the Term Project)
Your paper must meet the following requirements. These are designed to allow you to submit a professional quality paper.
1. Each paper must have a title page (sample below).
2. Margins must be 1.5 inches on the top and bottom and 1 inch on each side.
3. Use headings for each section and logically organize the content.
4. Each page must be numbered at the bottom of the page, centered, in the footer section of the page (Use Word Footer functionality). The Title Page is not numbered.
5. Paper must be double spaced, with each paragraph beginning indented.
6. There must be no spelling and no grammatical errors.
7. The tone of the paper must be professional.
8. Each paper must be submitted through Turnitin using the Turnitin link in the course as instructed by your professor.
9. When using the Excel spreadsheet for parts of your assignment, you will need to insert the relevant parts of the spreadsheet into your Word document by copy/paste function.
Essential Elements:
Each section of your paper must be logically organized, based on the assigned items. It should be easy to read, and move sequentially through the content you are presenting. The “why” of your decisions is as important as the “what”. You must be able to describe and defend the reason/thought process you used to arrive at your decision.
There is not necessarily a “right answer” to many of these points. Your performance on the paper will be based not so much on what you chose, but WHY you chose it. Was your choice logical and based on the facts available? Was your choice based on creating a competitive advantage?
For example, if you are presenting the location of your hotel. Why did you locate your hotel there? What are the advantages to this location and what will you do to maximize these? Are there any disadvantages and if so, what could you do to minimize them. It is important that you use any information that has been presented in the class to date, along with your knowledge.
Under no circumstances are you to use the term “as stated before” or “as stated above”, and then repeat what you said earlier. This is both annoying an unprofessional.
Use professional terms, not slang. Assume you are writing this note to your investors or to your boss.
Title Page Example:
Title of Paper
Subtitle of Paper (if any)
Name, etc.
Submitted in partial fulfillment of:
HOSP2015, Managing the Hotel Guest Experience
Professor
Date Submitted
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.
For this project you are the hypothetical owner of a 200-room hotel. You will make several decisions, and will present several parts of your operating plan. Read the entire project to have an understanding of the project requirements.
Project I: Classification, Brand, Location, ADR and Average Wage Rate
You will make the following decisions about your hotel, and present these in a paper. Format instructions for your paper are at the end of this project document.
1. Classification: Will you be an economy hotel, a limited service hotel, a full service hotel, or a luxury hotel? Whatever you choose to be, you need to describe your hotel, the services you will offer, and WHY you chose this.
2. Brand: You will select an appropriate brand for your hotel, and describe specifically why you chose that brand.
3. Management: Will you select the Brand to manage your hotel, or an independent management company? Why will you make that decision?
4. Location: Where will your hotel be located? A specific city and state, and an address within this area (Google maps satellite view comes in really handy for this). Why did you choose to locate here?
5. Average Daily Rate: You will research the average room rates for similar hotels in the area you select (using Kayak, Expedia, and others). You need to review at least four seasonal dates and create an average rate for your hotel. This will be considered your “rack rate”. In addition create a minimum of 5 special or discounted rates for different markets of guests.
6. Average Wage Rate: You will need to determine what the minimum wage is for your market (mimimumwage.com). This information is helpful for building schedules and other financial data.
Project 2: Management Organization
1. Create a Management Organizational Chart for your hotel. You must use the SmartArt graphics in Word to create this chart in your document.
2.
For each position, provide a detailed list (Job Description) of the responsibilities of the job and include the skills required for the job. You will need to do some internet research for this!
3. Assume that after your management staffing was completed that it was decided by your management company that you will need to eliminate one management position.
a. Which Management position would you eliminate?
b. Why that position?(Provide a detailed explanation)
c. How would you cover the responsibilities of that manager? (Provide a detailed explanation. Keep in mind that the duties may need to be assigned to several other positions)
Project 3: Developing a weekly schedule
1. You need to develop a one week schedule for your Housekeeping employees.
2. Using the Excel spreadsheet that is provided in this week’s assignment(located in ulearn), you will prepare a schedule for the week.
a. The day-by-day occupied rooms forecast has been given to you for the week.
b. Using the Staffing guideline, determine how many hours you will need to schedule each day.
c. You must staff the hours as closely as possible to the staffing guide each day.
Write a professionally formatted memo to your General Manager requesting approval of your schedule for the week.
Note: When using the Excel spreadsheet for parts of your assignment, you will need to insert the relevant parts of the spreadsheet into your Word document by copy/paste function.
FORMAT Requirements (for ALL Sections of the Term Project)
Your paper must meet the following requirements. These are designed to allow you to submit a professional quality paper.
1. Each paper must have a title page (sample below).
2. Margins must be 1.5 inches on the top and bottom and 1 inch on each side.
3. Use headings for each section and logically organize the content.
4. Each page must be numbered at the bottom of the page, centered, in the footer section of the page (Use Word Footer functionality). The Title Page is not numbered.
5. Paper must be double spaced, with each paragraph beginning indented.
6. There must be no spelling and no grammatical errors.
7. The tone of the paper must be professional.
8. Each paper must be submitted through Turnitin using the Turnitin link in the course as instructed by your professor.
9. When using the Excel spreadsheet for parts of your assignment, you will need to insert the relevant parts of the spreadsheet into your Word document by copy/paste function.
Essential Elements:
Each section of your paper must be logically organized, based on the assigned items. It should be easy to read, and move sequentially through the content you are presenting. The “why” of your decisions is as important as the “what”. You must be able to describe and defend the reason/thought process you used to arrive at your decision.
There is not necessarily a “right answer” to many of these points. Your performance on the paper will be based not so much on what you chose, but WHY you chose it. Was your choice logical and based on the facts available? Was your choice based on creating a competitive advantage?
For example, if you are presenting the location of your hotel. Why did you locate your hotel there? What are the advantages to this location and what will you do to maximize these? Are there any disadvantages and if so, what could you do to minimize them. It is important that you use any information that has been presented in the class to date, along with your knowledge.
Under no circumstances are you to use the term “as stated before” or “as stated above”, and then repeat what you said earlier. This is both annoying an unprofessional.
Use professional terms, not slang. Assume you are writing this note to your investors or to your boss.
Title Page Example:
Title of Paper
Subtitle of Paper (if any)
Name, etc.
Submitted in partial fulfillment of:
HOSP2015, Managing the Hotel Guest Experience
Professor
Date Submitted
>Overview
01 Managing the Guest Experience
0 hours a week)
s off for each employee
– Required Hours
0.0 0.0 0.0 0.0 0.0 0.0 Variance to (+/-) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 – Required Hours
Total Scheduled Man Hours 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 = Required Hours
Variance to Staffing Guide (+/-) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Staffing Guide Man Hours Per Occupied Room Man Hours Per Occupied Room
HOSP
1
5
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
4
Two consequetive
Day
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.
Scheduling Form
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
Amy
Brad
Carly
David
Frank
Gretchen
Holly
Isabella
Jake
Kelly
Laura
Mike
Total Scheduled Man Hours
0.0
Staffing Guide
Runners
Nathan
Ophelia
Paula
Raymond
Sarah
Variance to Staffing Guide (+/-)
Laundry Attendants
Tim
Victoria
Walter
Yuni
Zach
Total Scheduled Man Hours 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
Laundry Attendants
0.05
For each of the positions above, you are allowed to schedule to the forecasted rooms occupied.