Operations Management Hotel Complaints A luxury hotel has been receiving a lot of complaints from guests recently. The manager worries that if these complaints continue, the hotel will start to lose clients. Therefore, you have been hired as a consultant to correct the problem(s). A list of the major complaints by week for the last month is as follows: Complaint                                                      Number of Occurrences Week 1 Error on bill                                                                        10 Room not ready at check-in                                                8 Room service delivery late                                                   3 Longline at check-out                                                        10 Week 2 Error on bill                                                                        12 Noise in hallway                                                                  2 Longline at check-out                                                        5 Room dirty                                                                         10 Week 3 Not enough towels in room                                               5 Error on bill                                                                         7 Room service delivery late                                                  6 Not enough close-up parking                                             2 Week 4 Room dirty                                                                          7 Error on bill                                                                         9 Room not ready at check-in                                              10 Longline at check-in                                                            9 You have decided to use a few of the “Tools of Quality” to present your finding to hotel management. Task: Create A Pareto Chart: See Attachment for Example

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
100%
 
Operations Management

Hotel Complaints
A luxury hotel has been receiving a lot of complaints from guests recently. The manager worries that if these complaints continue, the hotel will start to lose clients. Therefore, you have been hired as a consultant to correct the problem(s). A list of the major complaints by week for the last month is as follows:
Complaint                                                      Number of Occurrences

Week 1
Error on bill                                                                        10
Room not ready at check-in                                                8
Room service delivery late                                                   3
Longline at check-out                                                        10

Week 2
Error on bill                                                                        12
Noise in hallway                                                                  2
Longline at check-out                                                        5
Room dirty                                                                         10

Week 3
Not enough towels in room                                               5
Error on bill                                                                         7
Room service delivery late                                                  6
Not enough close-up parking                                             2

Week 4
Room dirty                                                                          7
Error on bill                                                                         9
Room not ready at check-in                                              10
Longline at check-in                                                            9

You have decided to use a few of the “Tools of Quality” to present your finding to hotel management.

Task: Create A Pareto Chart: See Attachment for Example

PLEASE DO NOT SEND ME THE 2ND OTHER CHART ATTACHED AS IT WAS COPIED FROM ANOTHER WEBSITE.  PLEASE HELP CREATE A NEW PARETO CHART PLEASE.   THANKS

Pareto Chart
40
38
120.0%
35
98.3%
100.0%
96.5%
92.2%
100.0%
30
84.3%
76.5%
80.0%
25
63.5%
20
18
60.0%
17
48.7%
15
15
33.0%
40.0%
10
20.0%
5
2
2
0.0%
Error on Room not Room dirty Long time
Room
Long time
Not
Noise in
Not
service at check-in enough
delivery
bill
ready at
at check-
hallway
enough
close-up
parking
check-in
out
towels in
late
room
Transcribed Image Text:Pareto Chart 40 38 120.0% 35 98.3% 100.0% 96.5% 92.2% 100.0% 30 84.3% 76.5% 80.0% 25 63.5% 20 18 60.0% 17 48.7% 15 15 33.0% 40.0% 10 20.0% 5 2 2 0.0% Error on Room not Room dirty Long time Room Long time Not Noise in Not service at check-in enough delivery bill ready at at check- hallway enough close-up parking check-in out towels in late room
PARAETO CHART EXAMPLE
45
40
35
30
100.00%
25
90.00%
20
80.00%
15
70.00%
10
60.00%
50.00%
I Count
40.00%
30.00%
Not stability
Destroy data
Cumulative
20.00%
10.00%
Language.
0.00%
Trashy features
Interface messy
Can't launch
Exit program
System halted
Transcribed Image Text:PARAETO CHART EXAMPLE 45 40 35 30 100.00% 25 90.00% 20 80.00% 15 70.00% 10 60.00% 50.00% I Count 40.00% 30.00% Not stability Destroy data Cumulative 20.00% 10.00% Language. 0.00% Trashy features Interface messy Can't launch Exit program System halted
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.