Alabama Air Case
1. State any business problem that the enterprise needs to resolve:
Darden Restaurants needs to manage a supply-chain of highly perishable items such as seafood, over 35 countries, while managing costs and product quality. Furthermore, the company needs to ensure a strict protocol of inspection and quality assurance throughout the supply chain.
2. Briefly summarize relevant background information from the case. Darden restaurant owns popular brands such Olive Garden and Red Lobster, comprising of 1400 restaurants in the US. These are 300 million meals served annually with purchases from 35 ountries. The average shelf life of the food item is 4 days and temperature of 34 degrees must be ensured at each step of the way.
3. Describe how the enterprise dealt with its issues and their relevance
The airline executives have decided to use Statistical Process Control tools to measure the airlines on-time performance and to guage how it is doing in relation to the rest of the airline industry.
The Data:
Week Late Flights Fraction Late
1 2 0.02
2 4 0.04
3 10 0.1
4 4 0.04
5 1 0.01
6 1 0.01
7 13 0.13
8 9 0.09
9 11 0.11
10 0 0
11 3 0.03
12 4 0.04
13 2 0.02
14 2 0.02
15 8 0.08
16 2 0.02
17 3 0.03
18 7 0.07
19 3 0.03
20 2 0.02
21 3 0.03
22 7 0.07
23 4 0.04
24 3 0.03
25 2 0.02
26 2 0.02
27 0 0
28 1 0.01
29 3 0.03
30 4 0.04 120
4. Using a 95% confidence level plot the overall percentage of late flights p, and the upper and lower control limits.
p = Total Number of errors Total Number of Sample p= 120 = 0.04 (100)*(30)
sigma= SQRT(((.04)*(1-.04))/100) sigma= 0.02 UCL= p + 2*.02 = 0.08 LCL= p - 2*.02 = 0
Using 95% Confidence level (z=2), we plot a control chart for the fraction of late flights for ezch week. We also superimpose the industry upper and lower control limits of .1 and .04 repectively:
The Fraction of flights late on Week 3, 7, 8 and 9 fall above the UCL of .08 for
Darden Restaurants needs to manage a supply-chain of highly perishable items such as seafood, over 35 countries, while managing costs and product quality. Furthermore, the company needs to ensure a strict protocol of inspection and quality assurance throughout the supply chain.
2. Briefly summarize relevant background information from the case. Darden restaurant owns popular brands such Olive Garden and Red Lobster, comprising of 1400 restaurants in the US. These are 300 million meals served annually with purchases from 35 ountries. The average shelf life of the food item is 4 days and temperature of 34 degrees must be ensured at each step of the way.
3. Describe how the enterprise dealt with its issues and their relevance
The airline executives have decided to use Statistical Process Control tools to measure the airlines on-time performance and to guage how it is doing in relation to the rest of the airline industry.
The Data:
Week Late Flights Fraction Late
1 2 0.02
2 4 0.04
3 10 0.1
4 4 0.04
5 1 0.01
6 1 0.01
7 13 0.13
8 9 0.09
9 11 0.11
10 0 0
11 3 0.03
12 4 0.04
13 2 0.02
14 2 0.02
15 8 0.08
16 2 0.02
17 3 0.03
18 7 0.07
19 3 0.03
20 2 0.02
21 3 0.03
22 7 0.07
23 4 0.04
24 3 0.03
25 2 0.02
26 2 0.02
27 0 0
28 1 0.01
29 3 0.03
30 4 0.04 120
4. Using a 95% confidence level plot the overall percentage of late flights p, and the upper and lower control limits.
p = Total Number of errors Total Number of Sample p= 120 = 0.04 (100)*(30)
sigma= SQRT(((.04)*(1-.04))/100) sigma= 0.02 UCL= p + 2*.02 = 0.08 LCL= p - 2*.02 = 0
Using 95% Confidence level (z=2), we plot a control chart for the fraction of late flights for ezch week. We also superimpose the industry upper and lower control limits of .1 and .04 repectively:
The Fraction of flights late on Week 3, 7, 8 and 9 fall above the UCL of .08 for