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 PLEASE DO NOT SEND ME A COMPLAINT CHART THAT YOU HAVE DONE TWICE ALREADY...THAT IS A INCORRECT CHART....PLEASE HELP ME WITH A PARETO CHART PLEASE. AGAIN THE EXAMPLE OF A PARETO CHART IS ATTACHED TO THIS. THANKS

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 PLEASE DO NOT SEND ME A COMPLAINT CHART THAT YOU HAVE DONE TWICE ALREADY...THAT IS A INCORRECT CHART....PLEASE HELP ME WITH A PARETO CHART PLEASE. AGAIN THE EXAMPLE OF A PARETO CHART IS ATTACHED TO THIS. THANKS

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...

See similar textbooks

Related questions

Question

Course: 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

PLEASE DO NOT SEND ME A COMPLAINT CHART THAT YOU HAVE DONE TWICE ALREADY...THAT IS A INCORRECT CHART....PLEASE HELP ME WITH A PARETO CHART PLEASE. AGAIN THE EXAMPLE OF A PARETO CHART IS ATTACHED TO THIS. THANKS