Managing Supply Chain and Operations 1st Edition by Thomas Foster ,Scott Sampson,Cynthia Wallin,Scott Webb

Exercise 40

The service manager for a bicycle sales and service shop wants to study the length of time required to replace the gears on road bikes. The manager has implemented a quality improvement program to standardize the process for replacing bike gears. As a part of the improvement program, four bikes needing gear replacements are randomly selected each day for 20 days. The time required, in minutes, to replace the gears for each bike is measured. The results are as follows: Use Excel to develop an chart to determine if the process is stable or not.