Place all references and citations in and below the appropriate work. Do not place them on the same page. Times New Roman 12 and APA format
Assignment- Due Wednesday February 7, 2018
There are significant calculations to be made in doing this assignment. I have attached calculation worksheets to assist in which all of the necessary calculations and charts in those worksheets are done for you. Go through those calculations very carefully, making sure that you understand them completely. Once you understand those calculations, you should be able to answer the questions without any major difficulty. IN ANSWERING THE QUESTIONS, IT IS ESSENTIAL THAT YOU INCLUDE APPROPRIATE NUMBERS FROM THE WORKSHEETS TO SUPPORT YOUR ANSWERS.
**The data in the table below lists country code and the order to remittance (OTR) time for hardware / software installations for the last 76 installations (from first to last). OTR is the time it takes from an order being placed until the system is installed and payment is received (remittance). Because this company does business internationally, it also notes the country of installation using a country code. This code is listed in the first column.
Table: Country Code and OTR Cycle Time for Software Systems Installation
Country Code
Cycle Time Country Code Cycle Time
1 20 5 29
1 24 6 40
1 46 7 157
1 26 8 19
14 38 5 24
1 15 1 81
1 15 7 53
17 23 7 26
1 31 1 28
1 31 1 34
6 64 1 34
5 29 7 50
5 44 1 52
1 32 1 19
1 15 1 44
7 11 14 150
7 14 7 29
1 89 17 23
17 41 6 79
7 41 17 13
1 36 6 32
8 43 7 61
17 21 8 42
8 28 8 46
7 18 7 88
8 47 14 24
6 26 7 7
6 47 1 33
5 9 5 129
7 42 17 41
5 5 17 43
6 27 14 42
6 27 14 42
1 33 7 53
7 44 7 53
1 21 7 48
1 22 5 21
1 50 1 19
Use the date in table above and answer the following questions in the space provided below:
1. Does the OTR time appear to be stable? Why or why not?
2. If you were to use a control chart to evaluate stability, which chart would you use? Why?
3. What can you learn about the distribution of the installation process?
4. Does it appear that the country has an impact on installation time? Why or why not?
Discussion 1 ½ Paragraphs of substance (no copying and pasting)
Process Improvement and Problem-Solving Tools
• Use the Internet to research articles on process improvement and problem-solving tools. Select one (1) business project that used one of the tools discussed in the textbook. Evaluate the level of the efficiency and effectiveness of the utilization of the tool within the project that you selected. Justify your response.
Search the Internet for an article that supports your position and post the link in your thread for everyone to read.
Discussion 1 ½ Paragraphs of substance (no copying and pasting)
Building Data Models
• Per the textbook, in order to understand the causal relationship in business process, managers often ask “whys” to drill down the root cause of failures. Select one (1) project from your working or educational environment, and propose at least three (3) “why” questions that you would ask in order to identify the root cause of the problem. Justify your responses.
Search the Internet for an article that supports your position and post the link in your thread for everyone to read.
Discussion 1 ½ Paragraphs of substance (no copying and pasting)
Creating Statistical Experiments
• Select one (1) project from your working or educational environment for which you would apply the DOE technique for the work process. Next, analyze the overall manner in which you would utilize DOE to manage and improve the work process of the project in question. Provide a rationale for your response.
>Analysis
Country Code UCL LCL 1 .00
4. 1 .00
. 0.00 4 84.21 0.00 . . . 0.00 34.00 84.21 0.00 6 5
.01
0.00 34.00 84.21 0.00 7 .02
9.92
0.00 34.00 84.21 0.00 8 .34
0.00 34.00 84.21 0.00 .29
0.00 1 34.00 84.21 0.00 1 15 17 34.00 84.21 0.00 34.00 84.21 0.00 34.00 84.21 0.00 34.00 84.21 0.00 31 34.00 84.21 0.00 18 34.00 84.21 0.00 1 44 25 34.00 84.21 0.00 0.00 36.25 149.15 0.00 36.25 149.15 0.00 0.00 42.75 93.31 0.00 21 42.75 93.31 0.00 20 42.75 93.31 0.00 13 42.75 93.31 0.00 42.75 93.31 0.00 0.00 27 46.76 139.92 0.00 46.76 139.92 0.00 46.76 139.92 0.00 32 46.76 139.92 0.00 5 46.76 139.92 0.00 4.67 59.20 212.49 0.00 59.20 212.49 0.00 63.54 0.00 Country Code #1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 20 24 46 26 15 15 31 31 32 15 89 36 33 21 22 50 81 28 34 34 52 19 44 33 19 UCL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 LCL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Average 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 Observation number OTR (minutes) Country Code #5 1 2 3 4 5 6 7 8 29 44 9 5 29 24 129 21 1 2 3 4 5 6 7 8 36.25 36.25 36.25 36.25 36.25 36.25 36.25 36.25 1 2 3 4 5 6 7 8 149.153493 290891 149.15349330290891 149.15349330290891 149.15349330290891 149.15349330290891 149.15349330290891 149.15349330290891 149.15349330290891 1 2 3 4 5 6 7 8 0 0 0 0 0 0 0 0 Observation numbers OTR (minutes) Country Code #6 1 2 3 4 5 6 7 8 64 26 47 27 27 40 79 32 1 2 3 4 5 6 7 8 42.75 42.75 42.75 42.75 42.75 42.75 42.75 42.75 1 2 3 4 5 6 7 8 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 1 2 3 4 5 6 7 8 0 0 0 0 0 0 0 0 Observation numer OTR (minutes) Country Code #7 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 11 14 41 18 42 44 157 53 26 50 29 61 88 7 53 53 48 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.76470588235294 2 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Observation number Country Code #8 1 2 3 4 5 6 43 28 47 19 42 46 1 2 3 4 5 6 37.5 37.5 37.5 37.5 37.5 37.5 1 2 3 4 5 6 70.327029716378547 70.327029716378547 70.327029716378547 70.327029716378547 70.327029716378547 70.327029716378547 1 2 3 4 5 6 4.6729702836214599 4.6729702836214599 4.6729702836214599 4.6729702836214599 4.6729702836214599 4.6729702836214599 Observation number Country Code #14 1 2 3 4 5 38 150 24 42 42 1 2 3 4 5 59.2 59.2 59.2 59.2 59.2 1 2 3 4 5 212.49079424414242 212.49079424414242 212.49079424414242 212.49079424414242 212.49079424414242 1 2 3 4 5 0 0 0 0 0 Observation number Country Code #17 1 2 3 4 5 6 7 23 41 21 23 13 41 43 1 2 3 4 5 6 7 29.285714285714285 29.285714285714285 29.285714285714285 29.285714285714285 29.285714285714285 29.285714285714285 29.285714285714285 1 2 3 4 5 6 7 63.543650397900997 63.543650397900997 63.543650397900997 63.543650397900997 63.543650397900997 63.543650397900997 63.543650397900997 1 2 3 4 5 6 7 0 0 0 0 0 0 0 Observation number
2
Counts
Country Code
Cycle Time
Moving Range (MR)
Avg.
UCL
LCL
Average Cycle Time
Avg. Moving Range
1
2
0
3
4
8
21
0.00
34
18
88
84.21
2 1
24
34.00
5
3
6
25
42
44
14
9
15
3 1
46
22
42.
7
19
93.
31
4 1
26
20
46.76
35
13
5 1 15
11
37.
50
12
70.
33
4.67
6 1 15 0 34.00 84.21 0.00 14
59.20
57.63
212.49
7 1 31
16
17
29
12.88
63.54
8 1 31 0 34.00 84.21 0.00
See Page 214: Chart: Individual and MR
9 1
32
10
11 1
89
74
12 1
36
53
13 1 33 3 34.00 84.21 0.00
14 1 21 12 34.00 84.21 0.00
15 1 22 1 34.00 84.21 0.00
16 1 50
28
17 1
81
18 1 28 53 34.00 84.21 0.00
19 1 34 6 34.00 84.21 0.00
20 1 34 0 34.00 84.21 0.00
21 1
52
22 1 19 33 34.00 84.21 0.00
23
24 1 33 11 34.00 84.21 0.00
25 1 19 14 34.00 84.21 0.00
1 5 29
36.25
149.15
2 5 44 15 36.25 149.15 0.00
3 5 9 35 36.25 149.15 0.00
4 5 5 4 36.25 149.15 0.00
5 5 29 24 36.25 149.15 0.00
6 5 24 5 36.25 149.15 0.00
7 5
129
105
8 5 21
108
1 6
64
42.75
93.31
2 6 26
38
3 6
47
4 6
27
5 6 27 0 42.75 93.31 0.00
6 6
40
7 6
79
39
8 6 32 47 42.75 93.31 0.00
1 7 11 46.76
139.92
2 7 14 3 46.76 139.92 0.00
3 7
41
4 7 18 23 46.76 139.92 0.00
5 7 42 24 46.76 139.92 0.00
6 7 44 2 46.76 139.92 0.00
7 7
157
113
8 7 53
104
9 7 26 27 46.76 139.92 0.00
10 7 50 24 46.76 139.92 0.00
11 7 29 21 46.76 139.92 0.00
12 7
61
13 7 88 27 46.76 139.92 0.00
14 7 7 81 46.76 139.92 0.00
15 7 53 46 46.76 139.92 0.00
16 7 53 0 46.76 139.92 0.00
17 7
48
1 8
43
37.50
70.33
2 8 28 15 37.50 70.33 4.67
3 8 47 19 37.50 70.33 4.67
4 8 19 28 37.50 70.33 4.67
5 8 42 23 37.50 70.33 4.67
6 8 46 4 37.50 70.33 4.67
1 14 38 59.20 212.49 0.00
2 14
150
112
3 14 24
126
4 14 42 18 59.20 212.49 0.00
5 14 42 0 59.20 212.49 0.00
1 17 23
29.29
2 17 41 18 29.29 63.54 0.00
3 17 21 20 29.29 63.54 0.00
4 17 23 2 29.29 63.54 0.00
5 17 13 10 29.29 63.54 0.00
6 17 41 28 29.29 63.54 0.00
7 17 43 2 29.29 63.54 0.00
30
OTR (minutes)
OTR (minutes)
OTR (minutes)
OTR (minutes)Histogram
2 1 24 20
20 14
40 30
60 23
80 3
100 3
120 0
0
Histogram
Frequency 0 20 40 60 80 100 120 140 160 More 0 14 30 23 3 3 0 1 2 0 Bin
Frequency