MGMT 484 University at Buffalo Statistical Process Control Analysis Questions Hi, this is Operation Management 484 course. I uploaded the instruction file

MGMT 484 University at Buffalo Statistical Process Control Analysis Questions Hi, this is Operation Management 484 course. I uploaded the instruction file for you. Please take a look at it and let me know if you have any questions. MGMT 484 Operations Management
Assignment 3(Statistical Process Control)
You can submit your work either
•
as a Word file, or an Excel file, or
•
Don’t forget to explain your work!
You work as a quality inspector at a cereal factory. Your task is to weigh boxes of cereal and make
sure that they are up to the standard, which is 20 ounces. Some inspection results are given in
“Win Lei Phyu’s Assignment 3 Dataset.xlsx” excel file.
Based on the given dataset:
Q1. What are the Upper and Lower Control Limits in your X̅-Chart? (p. 251) Show your work
detail and calculations.
Q2. What are the Upper and Lower Control Limits in your R-Chart? (p.253) Show your work
detail and calculations.
Inspection #
1
2
3
4
5
6
7
8
9
10
Time Sample 1 Sample 2 Sample 3
9:00
21.01
18.21
19.29
10:00
19.40
18.01
20.27
11:00
20.02
19.89
20.69
12:00
17.49
20.09
18.02
13:00
21.68
20.55
19.01
14:00
18.32
21.11
20.98
15:00
20.41
19.91
21.57
16:00
21.87
21.50
17.94
17:00
19.19
20.72
21.70
18:00
17.14
18.97
21.48
Sample Weights (in ounces)
Sample 4 Sample 5 Sample 6 Sample 7
20.67
17.12
20.99
21.79
17.66
19.68
20.22
21.92
19.69
19.50
21.59
18.19
18.32
19.23
20.76
19.71
20.80
21.95
21.45
20.12
17.88
20.73
21.14
18.64
17.32
19.00
20.04
19.27
22.00
20.45
18.47
17.08
17.05
21.00
20.69
18.69
19.82
19.14
17.22
20.89
nces)
Sample 8 Sample 9 Sample 10
20.22
18.49
20.70
17.17
19.04
19.57
18.87
17.34
17.37
21.21
20.79
18.30
19.63
21.33
20.07
21.82
18.30
20.50
18.20
18.74
18.31
20.62
19.79
19.99
21.59
21.83
18.49
19.40
19.55
20.01

Purchase answer to see full
attachment