4
.xlsx
keyboard_arrow_up
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
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