Need help with my Excel question – I’m studying for my class.

TQM Tools for Improving Aircraft Turnaround Essay

In this activity, you will apply some of the tools to examine errors during the turnaround of aircraft for a large, fictional airline.

This chart provides the number of errors reported for a seven day period for the events completed during the turnaround process.

Complete the steps in each section and then submit your assignment for grading. Submit one spreadsheet containing a tab for each TQM tool used. Include all recommendations, interpretations, and suggested actions in the spreadsheet. Current APA formatting and references are not needed for this activity.(TQM Tools for Improving Aircraft Turnaround Essay)

Step 1: Develop a Histogram and Pareto Chart

Use Excel and the error data to develop a histogram and Pareto chart. Review the charts and draw conclusions from the data. What actions would you suggest to reduce the number of errors?

A histogram shows the frequency of occurrences of a variable. For this exercise, we want to look at the total errors by day so your Histogram should have 7 bars, one for each day of the week. For the Pareto chart, you should also have seven bars, one for each of the events.

Step 2: Build a Cause-and-Effect Diagram

Pick one of the seven events in the Errors Reported in a Seven Day Period chart and build a fish-bone cause-and-effect diagram.

Hint: check out this video for some more information on how to create a cause-and-effect diagram: How to create cause-and-effect diagrams (YouTube 3:16).

Step 3: Produce a Scatter Diagram

Continue with your examination of ways to reduce the error rate. Use the Servicing Delay vs. Support Staff data to produce a scatter diagram comparing the galley servicing delay versus the number of staff you are short of on each respective day.(TQM Tools for Improving Aircraft Turnaround Essay)

Can you draw any conclusions based on the chart? Based on this data, what actions would you recommend to reduce the galley servicing delay errors?(TQM Tools for Improving Aircraft Turnaround Essay)

Hint: you should end up with a linear regression type line. Check out this video for some more information on building a scatter diagram: Excel 2016: Creating a Scatter (XY) Chart (YouTube 4:34).(TQM Tools for Improving Aircraft Turnaround Essay)

Step 4: Create a Statistical Process Control Chart

Use the Servicing Delay vs. Support Staff data from Step 3 and the Excel OM plugin to create a statistical process control chart (SPC) (using the c Chart and make sure to click on the graph box). While this method is best used in manufacturing, you can apply the principles to our problem.

Explain the chart and indicate whether it provided you with any additional information on ways to reduce errors and improve quality.

Hint: using Gallery Service delay data only, from step 3.

Step 5: Submit the Assignment

Submit one spreadsheet containing a tab for each TQM tool used. Include all recommendations, interpretations, and suggested actions in the spreadsheet. Current APA formatting and references are not needed for this activity.

Total Quality Management Tools for Improving Aircraft Turnaround: A Case Study of a Fictional Airline

Introduction:

In the highly competitive airline industry, efficient aircraft turnaround is crucial for ensuring on-time departures, maximizing fleet utilization, and enhancing overall customer satisfaction. Errors during the turnaround process can lead to delays, increased operational costs, and negative customer experiences. To address these challenges, the fictional airline can employ Total Quality Management (TQM) tools to identify and rectify errors, streamline processes, and achieve higher levels of operational excellence. In this essay, we will explore how some of the key TQM tools can be applied to examine errors during the turnaround of aircraft for our large, fictional airline.(TQM Tools for Improving Aircraft Turnaround Essay)

1. Checklists:

Implementing comprehensive checklists for each stage of aircraft turnaround is a fundamental step in ensuring error-free operations. These checklists should cover pre-boarding, boarding, refueling, cleaning, catering, and other critical tasks. By following a standardized checklist, the airline’s ground crew and personnel can ensure that no important steps are missed, reducing the occurrence of errors.(TQM Tools for Improving Aircraft Turnaround Essay)

2. Fishbone Diagram (Ishikawa Diagram):

A Fishbone diagram is a powerful tool to identify root causes of errors during aircraft turnaround. The major categories for analysis could include personnel, equipment, procedures, external factors, and communication. By visually mapping out the possible causes, the airline’s management team can better understand the underlying issues and develop targeted solutions.(TQM Tools for Improving Aircraft Turnaround Essay)

3. Statistical Process Control (SPC):

Utilizing SPC techniques, the airline can monitor key performance indicators (KPIs) during aircraft turnaround. By collecting and analyzing data on variables such as turnaround time, fueling duration, and cleaning efficiency, the airline can identify trends and variations. This data-driven approach enables the airline to take corrective actions promptly and continuously improve its turnaround processes.(TQM Tools for Improving Aircraft Turnaround Essay)

4. Process Mapping:

Creating detailed flowcharts that illustrate the entire aircraft turnaround process allows the airline to visualize the sequence of events and interactions between different departments. Process mapping helps identify inefficiencies and potential bottlenecks, enabling the airline to streamline operations and reduce the likelihood of errors.(TQM Tools for Improving Aircraft Turnaround Essay)

5. Failure Mode and Effects Analysis (FMEA):

FMEA is a proactive approach to risk management that assesses potential failure modes in the aircraft turnaround process. By conducting FMEA, the airline can identify high-risk areas and prioritize improvement efforts accordingly. This minimizes the chances of errors occurring and improves the overall reliability of the turnaround process.

6. Cause-and-Effect Diagram:

The cause-and-effect diagram, also known as the “5 Whys,” is a powerful problem-solving tool. By asking “why” repeatedly for each error encountered during turnaround, the airline can delve deep into the root causes. This method helps to avoid superficial fixes and instead address the underlying issues more effectively.(TQM Tools for Improving Aircraft Turnaround Essay)

7. Quality Circles and Kaizen:

Implementing quality circles and promoting the Kaizen philosophy within the airline’s workforce fosters a culture of continuous improvement. Employees involved in the turnaround process can collaborate, share ideas, and collectively work towards identifying and addressing errors. These small, incremental improvements can lead to significant enhancements in overall efficiency.(TQM Tools for Improving Aircraft Turnaround Essay)

Conclusion:

In conclusion, the application of Total Quality Management (TQM) tools is essential for a large, fictional airline to examine errors during aircraft turnaround effectively. By utilizing tools such as checklists, Fishbone diagrams, SPC, process mapping, FMEA, cause-and-effect diagrams, quality circles, and Kaizen, the airline can identify root causes, make data-driven decisions, and implement targeted solutions. Continuous improvement through TQM will result in reduced errors, improved efficiency, and heightened customer satisfaction, positioning the fictional airline as a leader in the competitive aviation industry(TQM Tools for Improving Aircraft Turnaround Essay)