Question

Using the following weekly demand data for a new soft drink, determine the upper and lower...

Using the following weekly demand data for a new soft drink, determine the upper and lower control limites that can be used in recognizing a change in demand patterns. Use _+3 control limits.

Week 1 - 3500

Week 2 - 4100

Week 3 - 3750

Week 4 - 4300

Week 5 - 4000

Week 6 - 3650

Business   Operations-Management   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

process Mean= Sum all the demands of week /number of week =23300/6 =3883.3

Demand
Week 1 3500.0
Week 2 4100.0
Week 3 3750.0
Week 4 4300.0
Week 5 4000.0
Week 6 3650.0
Average 3883.3

Find variance of demand = sum of ( Average-Demand of week)2 / 6

Std. deviation of demand = sqrt( Variance )

Demand Variance
Week 1 3500.0 146944.4
Week 2 4100.0 46944.4
Week 3 3750.0 17777.8
Week 4 4300.0 173611.1
Week 5 4000.0 13611.1
Week 6 3650.0 54444.4
Average 3883.3 75555.6
Std. Dev 274.9

UCL = Process Mean + 3* Std. dev

LCL =  Process Mean - 3* Std. dev

UCL = 3883.3 +3*274.9 = 4708

LCL = 3883.3 - 3*274.9 = 3058.6

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A convenience store recently started to carry a new brand of soft drink. Management is interested...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing​ (let alpha α equals=0.4 with an initial forecast for week 1 of 586​) methods to forecast demand for week 13....
calculate the upper and lower control limits and then construct a control chart. Display your chart....
calculate the upper and lower control limits and then construct a control chart. Display your chart. Question: Using the control chart rules for detecting special causes, can you detect a special cause? Explain why or why not. Week Average Delay Time (in days) 1 34 2 30 3 35 4 32 5 28 6 26 7 29 8 28 9 35 10 26 11 34 12 31 13 28 14 40 15 26 16 32 17 31 18 30 19...
Given the following sample data, what would be the Upper and Lower +/- 3 Sigma Control...
Given the following sample data, what would be the Upper and Lower +/- 3 Sigma Control Limits for the corresponding X-bar chart? Sample Obs X1 Obs X2 Obs X3 Obs X4 Obs X5 Obs X6 1 36 20 32 28 21 40 2 31 38 35 38 33 32 3 33 28 36 31 25 25 4 38 25 32 40 29 39 5 38 30 28 30 31 31
Using samples of 200 credit card statements, an Auditor found the following: ---Sample Number: 1    2    ...
Using samples of 200 credit card statements, an Auditor found the following: ---Sample Number: 1    2     3     4     5     6     7   8 9    10    11   12   13   14   15 Number of Errors:    17  12   11   12   10    10   17   15   12   13    15    10     7     8      10 Determine lower and upper control limits for the fraction of errors using three-sigma limits. Question 8 options: 0 , .126 .017 , .101 .026 , .093 .009 , .109 None of the Above The Quality Control...
The following are quality control data for a manufacturing process at Kensport Chemical Company. The data...
The following are quality control data for a manufacturing process at Kensport Chemical Company. The data show the temperature in degrees centigrade at five points in time during a manufacturing cycle. Sample x R 1 95.72 1.0 2 95.24 0.9 3 95.18 0.7 4 95.42 0.4 5 95.46 0.5 6 95.32 1.1 7 95.40 0.9 8 95.44 0.3 9 95.08 0.2 10 95.50 0.6 11 95.80 0.6 12 95.22 0.2 13 95.60 1.3 14 95.22 0.6 15 95.04 0.8 16...
The following are quality control data for a manufacturing process at Kensport Chemical Company. The data...
The following are quality control data for a manufacturing process at Kensport Chemical Company. The data show the temperature in degrees centigrade at five points in time during a manufacturing cycle. Sample x R 1 95.72 1.0 2 95.24 0.9 3 95.18 0.7 4 95.44 0.4 5 95.46 0.5 6 95.32 1.1 7 95.40 0.9 8 95.44 0.3 9 95.08 0.2 10 95.50 0.6 11 95.80 0.6 12 95.22 0.2 13 95.54 1.3 14 95.22 0.6 15 95.04 0.8 16...
The following are quality control data for a manufacturing process at Kensport Chemical Company. The data...
The following are quality control data for a manufacturing process at Kensport Chemical Company. The data show the temperature in degrees centigrade at five points in time during a manufacturing cycle. Sample x R 1 95.72 1.0 2 95.24 0.9 3 95.18 0.7 4 95.42 0.4 5 95.46 0.5 6 95.32 1.1 7 95.40 0.9 8 95.44 0.3 9 95.08 0.2 10 95.50 0.6 11 95.80 0.6 12 95.22 0.2 13 95.58 1.3 14 95.22 0.6 15 95.04 0.8 16...
Suppose your company wanted to determine the amount of sales of a new SUV model, called...
Suppose your company wanted to determine the amount of sales of a new SUV model, called Lightning. The sales estimate would be based on the overall demand of various SUV model types. Overall demand is assumed to be normally distributed with a mean of 3 million units and standard deviation of 500,000 units. The share of demand that Lightning will take is assumed to be 4%. After running 1,000 simulated scenarios, a 95% confidence interval was constructed for the expected...
The following are quality control data for a manufacturing process at Kensport Chemical Company. The data...
The following are quality control data for a manufacturing process at Kensport Chemical Company. The data show the temperature in degrees centigrade at five points in time during a manufacturing cycle. Sample x R 1 95.72 1.0 2 95.24 0.9 3 95.18 0.7 4 95.46 0.4 5 95.46 0.5 6 95.32 1.1 7 95.40 1.0 8 95.44 0.3 9 95.08 0.2 10 95.50 0.6 11 95.80 0.6 12 95.22 0.2 13 95.60 1.3 14 95.22 0.5 15 95.04 0.8 16...
In a small-scale regression study, we collected data on the number of children in a family...
In a small-scale regression study, we collected data on the number of children in a family Xi and the number of hours per week spent shopping Yi. The following data were obtained: i 1 2 3 4 5 6 Xi 2 6 3 1 1 9 Yi 13 17 12 12 9 22 Assume we performed a simple linear regression of Yi on Xi, i.e. E(Yi) = ?0 + ?1Xi (a) By hand compute X?X, X?Y, (X?X)-1, b, Y^(means Y-hat),...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT