4.3
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
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
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
12/11/23
Galley Servicing Delay
Quality control/c-chart
Number of samples
7
Data
Results
# Defects
Total units sampled
7
Sample 1
3
Total Defects
44
Sample 2
6
6.2857143
Sample 3
11
Standard deviation
2.5071327
Sample 4
5
z value
2
Sample 5
5
Sample 6
4
Upper Control Limit
11.29998
Sample 7
10
Center Line
6.2857143
Lower Control Limit
1.2714489
Graph information
Sample 1
3 1.27144892 6.2857143
11.29998
Sample 2
6 1.27144892 6.2857143
11.29998
Sample 3
11 1.27144892 6.2857143
11.29998
Sample 4
5 1.27144892 6.2857143
11.29998
Sample 5
5 1.27144892 6.2857143
11.29998
Sample 6
4 1.27144892 6.2857143
11.29998
Sample 7
10 1.27144892 6.2857143
11.29998
Defect rate, l
1
2
0
2
4
6
8
10
12
Mean
Enter the number of defects for each of the samples/items.
Enter the number of defects for each of the samples/items.
Based on the chart, each day stayed within the limits for delay the chart offers an alternative visual representation, it doesn't done correctly, despite other charts highlighting process issues
delay events daily. The graph sets the lower control limit at aro
2
3
4
5
6
7
c-chart
Column B
Column C
Column D
Column E
Sample
events, even though two days had exceptionally high numbers in other related charts. While provide substantial value. According to the control chart, it suggests that everything is being s. In this case, a lower control limit isn't necessary because the ultimate aim is to have zero ound one event per day, implying that achieving zero delays would be seen as inefficienct.
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
Personel
Vacation
Day Off
Sick Kids
Poorly Trained
Lack of
Galley Servicing Delays
Training
Not properly trained Lack of Personn
Galley Servicing Delays
Personel
Training
Supplies
Delayed Cabin Cleaning
Insufficient Supply
Limited Personnel
Wrong Supplies
No cleaning supplies
Poorly Training Person
Improper Cabin Cleaning
nel
Lack of Supplies
Supplies
Delayed Cabin Cleaning
Improper cabin cleaning
nnel
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