Operations ManagementHotel ComplaintsA 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 OccurrencesWeek 1Error on bill 10Room not ready at check-in 8Room service delivery late 3Longline at check-out 10Week 2Error on bill 12Noise in hallway 2Longline at check-out 5Room dirty 10Week 3Not enough towels in room 5Error on bill 7Room service delivery late 6Not enough close-up parking 2Week 4Room dirty 7Error on bill 9Room not ready at check-in 10Longline at check-in 9You 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 ExamplePLEASE 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 A Pareto Chart is a bar graph that represents data in descending order. It is used to identify the most significant factors in a dataset. The chart above displays common issues reported in a hotel setting. Each bar reflects the frequency of complaints, while the cumulative percentage line helps ascertain which problems collectively account for the majority of issues.**Details of the Chart:**- **Bars and Values:** - **Error on bill:** 38 complaints (33.0%) - **Room not ready at check-in:** 18 complaints (48.7% cumulative) - **Room dirty:** 17 complaints (63.5% cumulative) - **Long time at check-out:** 15 complaints (76.5% cumulative) - **Room service delivery late:** 9 complaints (84.3% cumulative) - **Long time at check-in:** 9 complaints (92.2% cumulative) - **Not enough towels in room:** 5 complaints (96.5% cumulative) - **Noise in hallway:** 2 complaints (98.3% cumulative) - **Not enough close-up parking:** 2 complaints (100% cumulative)- **Red Line (Cumulative Percentage):** - This line shows the cumulative percentage of complaints as more issues are included from left to right. The line assists in identifying the vital few problems responsible for the majority of complaints.Overall, the chart demonstrates that by focusing on resolving a few key issues (the leftmost bars), significant improvements can be made in customer satisfaction. **Title: Pareto Chart Example****Description:**This Pareto chart showcases a set of issues evaluated by their frequency (Count) and cumulative impact (Cumulative %). The chart is a combination of a bar graph and a line graph.**Components:**- **X-Axis (Categories):** - Not stability - Destroy data - Language… - Trashy features - Interface messy - Can't launch - Exit program - System halted- **Y-Axis (Left - Count):** - Represents the frequency of each issue, ranging from 0 to 45.- **Y-Axis (Right - Cumulative %):** - Represents the cumulative percentage, ranging from 0% to 100%.**Graph Details:**- **Bars (Blue):** Indicate the individual count of each issue. - "Not stability" has the highest count, followed by "Destroy data" and "Trashy features." - Lesser issues include "Interface messy," "Can't launch," "Exit program," and "System halted."- **Line (Red):** Represents the cumulative percentage of issues. - It starts at the level of "Not stability" and smooths out as it approaches 100%, indicating that few issues account for a majority of the problems addressed.This example illustrates how identifying and addressing the most frequent issues can significantly improve overall system performance or user satisfaction.

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