AdventureLand theme park recently received a large number of complaints from customers who had endured delays while waiting to ride on AdventureLands largest rollercoaster, Monster Train. As newly appointed operations manager, you are considering the problem of delayed rides on Monster Train. By observing 100 delayed Monster Train rides over a 10 week period, you find that a variety of factors are contributing to the Monster Train delay problem. You summarize the results of your study in a diagram:

You also create this table to tally the frequency with which you observed various causes of delay:

Problem Areas	Number of Occurences
Delayed availability of safety inspector	6
Mechanical failure of turnstile	30
Broken gearing mechanism requiring frequent repair	50
Staff arrive late for work	5
Bad weather	2
Insufficient staff to load passengers	4

a. Create a Pareto chart using Excel spreadsheet.

b. What conclusion can you draw from the chart? Hint: you need to answer the following questions:

What are the largest issues facing AdventureLand theme park?

What 20% of sources are causing 80% of the problems (80/20 Rule)?

Where should AdventureLand theme park focus its efforts to achieve the greatest improvements?

c. Consider the following potential improvements that AdventureLand theme park is considering to address the Monster Train Delays:

Improvement 1: Hire additional staff, both to load passengers and to serve as safety inspectors.

Improvement 2: Replace the faulty gearing mechanism requiring frequent repair. The company selected to perform the Monster Train gearing replacement work has also agreed to fix the failing turnstile in the waiting area for free.

Improvement 3: Fire the staff arriving late for work and hire replacements.

Improvement 4: Invest in research and development to invent a weather-control device to prevent bad weather.

Since each of these potential improvements involves money, AdventureLand theme park can only undertake one improvement at a time and can only afford to complete two of the improvements listed above. Which improvement do you recommend first, and which should follow second, to reduce the frequency of customer complaints as quickly as possible?