Quantitative and Qualitative Forecasting – Excel and Questions and Paragraphs

1. Complete “Example 13.2: Process Control Chart Design,” Attached. Write a 150-300-word paragraph comparing the simple moving average weighted moving average, exponential smoothing, and linear regression analysis time series models. 2. Refer to the Excel spreadsheet, ?Quality Control Analytics at Toyota,” to complete the “Case: Quality Management Toyota,” 2a. Answer Questions 1-8.3. Refer to the Excel spreadsheet, “Computing Trend and Seasonal Factor From a Linear Regression Line Obtained “to complete the “Example 18.4: Computing Trend and Seasonal Factor From a Linear Regression Line Obtained With Excel,” located in Chapter 18 of the textbook. 3a. After working through the example, reflect write a 150-300-word paragraph explaining the market research, panel consensus, historical analogy, and Delphi method qualitative forecasting techniques.While APA format is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines.
quantitative_and_qualitative_forecasting.docx

Unformatted Attachment Preview

1. Complete “Example 13.2: Process Control Chart Design,” Attached. Write a 150-300word paragraph comparing the simple moving average weighted moving average,
exponential smoothing, and linear regression analysis time series models.
2. Refer to the Excel spreadsheet, ?Quality Control Analytics at Toyota,” to complete the
“Case: Quality Management Toyota,”
2a. Answer Questions 1-8.
Questions
1.
2.
3.
4.
5.
6.
If the specifi cation is such that no washer should be greater than 2.4 millimeters, assuming that the
thicknesses are distributed normally, what fraction of the output is expected to be greater than this
thickness?
If there are an upper and lower specifi cation, where the upper thickness limit is 2.4 and the lower thickness
limit is 1.4, what fraction of the output is expected to be out of tolerance?
What is the Cpk for the process?
What would be the Cpk for the process if it were centered between the specification limits (assume the
process standard deviation is the same)?
What percentage of output would be expected to be out of tolerance if the process were centered?
Set up __
X – and range control charts for the current process. Assume the operators will take samples of 10
washers at a time.
7. Plot the data on your control charts. Does the current process appear to be in control?
8. If the process could be improved so that the standard deviation were only about .10 millimeter, what would
be the best that could be expected with the processes relative to fraction defective?
3. Refer to the Excel spreadsheet, “Computing Trend and Seasonal Factor From a Linear
Regression Line Obtained “to complete the “Example 18.4: Computing Trend and
Seasonal Factor From a Linear Regression Line Obtained With Excel,” located in
Chapter 18 of the textbook.
3a. After working through the example, reflect write a 150-300-word paragraph
explaining the market research, panel consensus, historical analogy, and Delphi
method qualitative forecasting techniques.
…
Purchase answer to see full
attachment