TQM Tools Application-Nicolle Ramirez

Sun Mon Tues Wed Thur Fri Sat Jet bridge delayed 1 1 1 2 1 1 2 Baggage belt broken 0 0 0 1 0 1 1 Refueling delayed 0 0 0 2 0 0 1 Gallery servicing delayed 3 6 5 11 5 4 10 Cabin cleaning delayed 0 0 0 2 0 0 0 Cabin not properly cleaned 3 5 3 10 3 2 7 Baggage loading delayed 1 0 1 2 0 1 1 Total 8 12 10 30 9 9 22 Sun Mon Tues Wed Thur Fri Sat 0 5 10 15 20 25 30 35 Chart Title This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different f format will permanently break the chart.

Total 9 3 3 44 2 33 6 100 file

12 The chart indicates a positive correlation between the number of staf shortfalls and the delay in galley servicing. The galley servicing delay rises in tandem with the number of staf shortages. This implies that one of the reasons behind the galley servicing delay errors is a staffing shortage. Based on the data, we can suggest the following actions to lower the galley servicing delay errors: Recruit more workers to make up for staf shortages on days when galley servicing delay errors are high. Put in place a system to more efectively manage staf scheduling so that, on days when galley servicing delay errors are high, there is sufficient coverage. Perform a root cause analysis to find any underlying problems that are causing the staffing shortage and take appropriate action. By implementing these changes, we can lessen the staffing shortfall and enhance the efectiveness of the galley servicing procedure, which will ultimately lower the errors that cause galley servicing delays.

2 3 4 5 6 7 c-chart Sample

7 Column B Column C Column D Column E

y Service Delays actions midity