4.3

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
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