4

.xlsx

School

Embry-Riddle Aeronautical University *

*We aren’t endorsed by this school

Course

420

Subject

Industrial Engineering

Date

Jan 9, 2024

Type

xlsx

Pages

9

Uploaded by cmckee82

Report
Event Sun Mon Tues Wed Thur Total 8 12 30 10 9 Jet bridge delayed 1 1 2 1 1 Baggage belt broken 0 0 1 0 0 Refueling delayed 0 0 2 0 0 Galley servicing delayed 3 6 11 5 5 Cabin cleaning delayed 0 0 2 0 0 Cabin not properly cleaned 3 5 10 3 3 Baggage loading delayed 1 0 2 1 0 Total 8 12 30 10 9 1 2 3 4 5 6 7 0 5 10 15 20 25 30 35 8 12 30 10 9 9 22 Errors Reported in a Seven Day Period Day of the Week Number of Times Events Occured This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file form permanently break the chart. The data in these charts indicates that Tuesday and Saturday experienced the highest number of events causi throughout the week were galley servicing delays and inadequate cabin cleaning. Various factors could contri shortages. The cleanliness problem may result from insufficient supplies or inadequate training, while equipm might stem from improper maintenance or aging machinery. To prevent these occurrences, ensure the availab sufficient number of well-trained staff, and prioritize proper equipment maintenance.
Fri Sat Total 9 22 100 1 2 9 1 1 3 0 1 3 4 10 44 0 0 2 2 7 33 1 1 6 9 22 100 mat will ing delays. The most common issues ibute to these delays, including staffing ment issues like the broken baggage belt bility of necessary supplies, have a
Event Sun Mon Tues Wed Thur Galley servicing delayed 3 6 11 5 5 Missing galley support staff 2 3 6 4 3 From the data, the days with the most galley servicing delays coincided with the days when there was a the day with the fewest delays had the least employee shortages. While hiring more staff is a long-term optimizing staff distribution across the week based on employee availability. This may temporarily increa concentration of delays seen on Tuesday and Saturday. Building a schedule that suits each employee and significantly reduce delays. 2 3 4 5 6 7 8 9 10 11 12 0 1 2 3 4 5 6 7 8 Missing galley support staff GALLEY SERVICING DELAYED Axis MISSING GALLEY SUPPORT STAFF
Fri Sat 4 10 3 7 shortage of galley support staff. Conversely, solution, an immediate fix would involve ase delays on certain days but will prevent the d fostering open communication could
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help