[SOLVED] please solve it in excel – Business Finance

PLE collects a variety of data from special studies, many of which are related to the quality of its products. The company collects data about functional test performance of its mowers after assembly; results from the past 30 days are given in the worksheet Mower Test in the Performance Lawn Equipment Database. In addition, many in-process measurements are taken to ensure that manufacturing processes remain in control and can produce according to design specifications. The worksheet Blade Weight shows 350 measurements of blade weights taken from the manufacturing process that produces mower blades during the most recent shift. Elizabeth Burke has asked you to study these data from an analytics perspective. Drawing upon your experience, you have developed a number of questions.For the mower test data, what distribution might be appropriate to model the failure of an individual mower?What fraction of mowers fails the functional performance test using all the mower test data?What is the probability of having x failures in the next 100 mowers tested, for x from 0 to 20?What is the average blade weight and how much variability is occurring in the measurements of blade weights?Assuming that the data are normal, what is the probability that blade weights from this process will exceed 5.20?What is the probability that blade weights will be less than 4.80?What is the actual percent of blade weights that exceed 5.20 or are less than 4.80 from the data in the worksheet?Is the process that makes the blades stable over time? That is, are there any apparent changes in the pattern of the blade weights?Could any of the blade weights be considered outliers, which might indicate a problem with the manufacturing process or materials?Is the assumption that blade weights are normally distributed justified?Summarize all your findings to these questions in a well-written report.What proportion of customers rate the company with “top box” survey responses (which is defined as scale levels 4 and 5) on quality, ease of use, price, and service in the Customer Survey worksheet? How do these proportions differ by geographic region?What estimates, with reasonable assurance, can PLE give customers for response times to customer service calls?Engineering has collected data on alternative process costs for building transmissions in the worksheet Transmission Costs. Can you determine whether one of the proposed processes is better than the current process?What would be a confidence interval for the proportion of failures of mower test performance as in the worksheet Mower Test?For the data in the worksheet Blade Weight, what is the sampling distribution of the mean, the overall mean, and the standard error of the mean? Is a normal distribution an appropriate assumption for the sampling distribution of the mean?How many blade weights must be measured to find a 95% confidence interval for the mean blade weight with a sampling error of at most 0.05? What if the sampling error is specified as 0.02?Elizabeth Burke has identified some additional questions she would like you to answer using the Performance Lawn Equipment Database.Are there significant differences in ratings of specific product/service attributes in the Customer Survey worksheet?In the worksheet On-Time Delivery, has the proportion of on-time deliveries in 2018 significantly improved since 2014?Have the data in the worksheet Defects After Delivery changed significantly over the past five years?Although engineering has collected data on alternative process costs for building transmissions in the worksheet Transmission Costs, why didn’t they reach a conclusion as to whether one of the proposed processes is better than the current process?Are there differences in employee retention due to gender, college graduation status, or whether the employee is from the local area in the data in the worksheet Employee Retention?Conduct appropriate statistical analyses and hypothesis tests to answer these questions and summarize your results in a formal report to Ms. Burke.Dealer Satisfaction
Survey Scale:
North America
2014
2015
2016
2017
2018
0
1
2
3
4
1
0
1
1
2
0
0
1
2
3
2
2
1
6
5
14
14
8
12
15
22
20
34
34
44
5 Sample
Size
11
50
14
50
15
60
45
100
56
125
0
0
0
0
1
0
0
0
1
1
0
0
1
1
2
2
2
4
3
4
6
6
11
12
22
2
2
14
33
60
10
10
30
50
90
2014
2015
2016
2017
2018
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
3
2
2
2
4
7
8
15
21
17
4
4
7
6
8
15
15
25
30
30
Pacific Rim
2014
2015
2016
2017
2018
0
0
0
0
0
0
0
0
0
0
1
1
1
0
1
2
1
1
2
2
2
3
3
5
7
0
0
1
3
2
5
5
6
10
12
0
0
0
0
0
0
0
1
1
1
4
5
0
2
8
0
0
2
1
7
16
South America
2014
2015
2016
2017
2018
Europe
China
2016
2017
2018
End-User Satisfaction
Survey Scale:
North America
2014
2015
2016
2017
2018
Sample
5 Size
0
1
2
3
4
1
1
1
0
0
3
2
2
2
2
6
4
5
4
3
15
18
17
15
15
37
35
34
33
31
38
40
41
46
49
100
100
100
100
100
1
1
0
0
0
2
3
2
2
2
5
6
6
5
5
18
17
19
20
19
36
36
37
37
37
38
37
36
36
37
100
100
100
100
100
2014
2015
2016
2017
2018
1
1
1
1
0
2
2
1
1
1
4
5
4
3
2
21
21
26
17
19
36
34
37
41
45
36
37
31
37
33
100
100
100
100
100
Pacific Rim
2014
2015
2016
2017
2018
2
1
1
0
0
3
2
2
2
1
5
7
5
4
3
15
15
16
17
19
41
41
40
40
42
34
34
36
37
35
100
100
100
100
100
0
1
0
3
2
1
3
2
1
6
4
3
28 10
30 11
31 14
50
50
50
South America
2014
2015
2016
2017
2018
Europe
China
2016
2017
2018
Customer Survey
Region Quality Ease of UsePrice Service
NA
4
1
3
4
NA
4
4
4
5
NA
4
5
4
3
NA
5
4
4
4
NA
5
4
5
4
NA
5
5
3
5
NA
5
4
4
2
NA
5
5
4
5
NA
4
4
4
5
NA
4
5
4
5
NA
4
5
1
4
NA
5
5
4
4
NA
5
4
3
3
NA
4
5
4
4
NA
5
4
3
5
NA
5
5
2
5
NA
5
4
2
5
NA
5
4
2
5
NA
4
5
4
4
NA
4
4
5
4
NA
4
4
2
4
NA
4
3
3
4
NA
5
5
2
5
NA
5
3
4
3
NA
5
4
4
5
NA
5
5
2
5
NA
5
5
5
3
NA
4
4
5
4
NA
5
4
4
4
NA
5
1
5
5
NA
5
4
3
5
NA
4
5
1
4
NA
4
4
3
5
NA
5
3
4
4
NA
5
5
2
4
NA
5
4
4
4
NA
5
5
4
4
NA
5
5
4
5
NA
4
3
3
5
NA
5
4
4
3
NA
5
4
3
4
NA
5
5
1
5
NA
5
4
5
4
NA
3
4
3
4
NA
5
4
2
4
NA
5
5
4
5
NA
5
5
3
4
NA
5
4
4
4
NA
5
4
4
4
NA
5
4
4
5
NA
5
4
1
4
NA
5
4
5
5
NA
5
5
3
4
NA
5
4
4
5
NA
4
3
5
5
NA
5
4
4
4
NA
5
5
5
5
NA
5
5
4
5
NA
4
4
4
4
NA
5
4
5
5
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
4
5
5
5
5
4
4
5
5
5
5
5
5
5
5
5
4
3
5
4
3
1
4
5
4
5
5
4
5
5
5
5
4
5
4
5
4
5
4
4
5
5
5
4
5
4
5
4
4
4
5
3
5
5
4
4
1
5
4
4
5
4
4
5
5
5
4
4
4
4
4
4
4
5
4
4
3
4
4
5
5
5
4
2
4
5
5
5
5
5
2
4
4
5
5
5
5
4
5
5
5
5
5
4
4
4
2
4
5
4
5
4
4
4
3
4
4
4
4
5
4
4
4
4
4
4
5
5
3
4
5
5
4
4
3
5
4
4
5
4
5
1
3
2
4
3
4
3
3
4
5
4
4
4
5
5
4
5
5
4
5
3
2
5
4
5
3
2
5
4
4
2
4
3
4
2
3
5
3
2
3
3
3
2
4
5
2
5
4
4
4
5
4
2
5
5
4
5
4
5
4
2
5
5
5
5
5
4
5
5
4
5
4
5
5
4
5
4
4
3
5
3
5
5
4
4
4
3
4
5
4
5
5
5
5
4
5
3
4
4
5
4
5
4
5
4
4
4
5
4
5
3
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Pac
Pac
Pac
Pac
Pac
Pac
3
5
4
4
4
4
4
5
4
5
5
4
4
5
5
5
3
4
4
5
4
5
5
5
3
4
4
4
4
3
3
4
5
5
4
3
3
4
5
5
5
3
4
4
5
4
3
4
5
5
4
4
5
2
5
4
5
5
5
4
4
5
4
3
4
4
5
1
5
4
4
4
5
5
4
4
4
4
4
4
3
4
4
3
3
4
4
4
4
3
5
4
4
4
4
5
5
5
4
5
4
4
3
5
4
5
5
4
5
5
4
5
3
5
3
4
4
4
5
4
4
5
4
3
4
4
4
4
4
5
4
4
4
3
4
4
4
2
4
4
4
1
4
5
2
3
4
5
4
4
3
1
4
5
4
5
1
5
5
5
5
4
3
5
5
4
4
4
4
4
4
4
3
4
3
4
2
4
3
4
5
4
1
4
5
4
4
5
4
5
4
1
5
5
4
5
4
5
3
4
4
5
5
4
4
5
4
3
3
5
5
4
4
4
4
3
3
2
4
3
5
5
1
4
4
3
4
5
4
5
4
5
4
5
4
4
2
4
5
4
4
3
4
4
3
5
5
5
4
4
4
4
Pac
Pac
Pac
Pac
China
China
China
China
China
China
China
China
China
China
5
4
3
5
5
5
4
4
4
4
4
3
3
2
5
2
4
4
5
5
4
4
4
4
4
4
4
3
4
3
4
4
4
4
3
3
3
3
3
3
2
2
5
3
4
5
4
3
3
3
2
3
2
3
2
1
Complaints
Month World NA SA Eur Pac China
Jan-14
169 102 12
52
3
Feb-14
187 115 13
55
4
Mar-14
210 128 15
61
6
Apr-14
226 136 16
67
7
May-14
232 137 17
73
5
Jun-14
261 151 19
82
9
Jul-14
245 140 18
80
7
Aug-14
223 128 16
76
3
Sep-14
195 103 15
73
4
Oct-14
174 96 14
62
2
Nov-14
154 84 11
59
0
Dec-14
163 99
9
54
1
Jan-15
195 123 10
59
3
Feb-15
221 141 13
62
5
Mar-15
240 152 16
66
6
Apr-15
264 163 20
70
11
May-15
283 178 22
75
8
Jun-15
296 170 28
86
12
Jul-15
269 153 25
81
10
Aug-15
256 146 23
79
8
Sep-15
231 131 20
73
7
Oct-15
214 125 16
68
5
Nov-15
201 118 13
66
4
Dec-15
171 96 11
61
3
Jan-16
200 112 15
66
4
3
Feb-16
216 117 18
71
6
4
Mar-16
234 126 20
76
9
3
Apr-16
253 138 23
79
11
2
May-16
282 152 26
85
14
5
Jun-16
305 163 30
91
15
6
Jul-16
296 156 28
89
18
5
Aug-16
279 148 26
86
15
4
Sep-16
266 143 24
82
13
4
Oct-16
243 131 21
76
12
3
Nov-16
232 128 18
73
10
3
Dec-16
203 107 15
70
7
4
Jan-17
216 110 19
74
8
5
Feb-17
239 123 23
79
10
4
Mar-17
266 138 26
83
13
6
Apr-17
284 150 30
88
11
5
May-17
315 169 33
91
15
7
Jun-17
340 181 37
95
19
8
Jul-17
319 169 34
92
17
7
Aug-17
304 160 32
90
15
7
Sep-17
277 141 29
87
14
6
Oct-17
250 123 26
83
12
6
Nov-17
228 112 24
77
10
5
Dec-17
213 105 23
74
7
4
Jan-18
240 121 26
80
8
5
Feb-18
251 126 28
82
10
5
Mar-18
281 148 31
85
12
5
Apr-18
298 155 35
89
13
6
May-18
322 168 39
95
12
8
Jun-18
350 183 43
98
15
11
Jul-18
330 170 41
95
14
10
Aug-18
311 158 38
93
13
9
Sep-18
289 149 33
89
11
7
Oct-18
265 136 30
85
8
6
Nov-18
239 121 26
80
7
5
Dec-18
219 108 23
76
7
5
A
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
B
C
D
E
F
G
Mower Unit Sales
Month
Jan-14
Feb-14
Mar-14
Apr-14
May-14
Jun-14
Jul-14
Aug-14
Sep-14
Oct-14
Nov-14
Dec-14
Jan-15
Feb-15
Mar-15
Apr-15
May-15
Jun-15
Jul-15
Aug-15
Sep-15
Oct-15
Nov-15
Dec-15
Jan-16
Feb-16
Mar-16
Apr-16
May-16
Jun-16
Jul-16
Aug-16
Sep-16
Oct-16
Nov-16
Dec-16
Jan-17
Feb-17
Mar-17
Apr-17
May-17
Jun-17
Jul-17
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
NA
6000
7950
8100
9050
9900
10200
8730
8140
6480
5990
5320
4640
5980
7620
8370
8830
9310
10230
8720
7710
6320
5840
4960
4350
6020
7920
8430
9040
9820
10370
9050
7620
6420
5890
5340
4430
6100
8010
8430
9110
9730
10120
9080
7820
6540
6010
5270
5380
6210
8030
8540
9120
9570
10230
9580
7680
6870
5930
5260
4830
SA Europe Pacific China World
200
720
100
0 7020
220
990
120
0 9280
250 1320
110
0 9780
280 1650
120
0 11100
310 1590
130
0 11930
300 1620
120
0 12240
280 1590
140
0 10740
250 1560
130
0 10080
230 1590
130
0 8430
220 1320
120
0 7650
210
990
130
0 6650
180
660
140
0 5620
210
690
140
0 7020
240 1020
150
0 9030
250 1290
140
0 10050
290 1620
150
0 10890
330 1650
130
0 11420
310 1590
140
0 12270
290 1560
150
0 10720
270 1530
140
0 9650
250 1590
150
0 8310
250 1260
160
0 7510
240
900
150
0 6250
210
660
150
0 5370
220
570
160
0 6970
250
840
150
0 9160
270 1110
160
0 9970
310 1500
170
0 11020
360 1440
160
0 11780
330 1410
170
0 12280
310 1440
160
0 10960
300 1410
170
0 9500
280 1350
180
0 8230
270 1080
180
0 7420
260
840
190
0 6630
230
510
180
0 5350
250
480
200
0 7030
270
750
190
0 9220
280 1140
200
0 10050
320 1410
210
0 11050
380 1340
190
0 11640
360 1360
200
0 12040
320 1410
200
0 11010
310 1490
210
0 9830
300 1310
220
0 8370
290
980
210
0 7490
270
770
220
0 6530
260
430
230
0 6300
270
400
200
0 7080
280
750
190
0 9250
300
970
210
5 10025
340 1310
220
16 11006
390 1260
200
22 11442
380 1240
210
26 12086
350 1300
230
14 11474
340 1250
220
15 9505
320 1210
220
11 8631
310
970
230
3 7443
300
650
240
1 6451
290
300
230
0 5650
Tractor Unit Sales
Month NA
SA
Eur
Pacific China World
Jan-14
570
250
560
212
0
1592
Feb-14
611
270
600
230
0
1711
Mar-14
630
260
680
240
0
1810
Apr-14
684
270
650
263
0
1867
May-14
650
280
580
269
0
1779
Jun-14
600
270
590
280
0
1740
Jul-14
512
264
760
290
0
1826
Aug-14
500
280
645
270
0
1695
Sep-14
478
290
650
263
0
1681
Oct-14
455
280
670
258
0
1663
Nov-14
407
290
888
240
0
1825
Dec-14
360
280
850
230
0
1720
Jan-15
571
320
620
250
0
1761
Feb-15
650
350
760
275
0
2035
Mar-15
740
390
742
270
0
2142
Apr-15
840
440
780
280
0
2340
May-15
830
470
690
290
0
2280
Jun-15
760
490
721
300
0
2271
Jul-15
681
481
680
312
0
2154
Aug-15
670
460
711
305
0
2146
Sep-15
640
460
695
290
0
2085
Oct-15
620
440
650
260
0
1970
Nov-15
570
436
680
250
0
1936
Dec-15
533
420
657
240
0
1850
Jan-16
620
510
610
250
10
2000
Feb-16
792
590
680
250
12
2324
Mar-16
890
610
730
260
20
2510
Apr-16
960
600
820
270
22
2672
May-16
1040
620
810
290
20
2780
Jun-16
1032
640
807
310
24
2813
Jul-16
1006
590
760
340
20
2716
Aug-16
910
600
720
320
31
2581
Sep-16
803
670
660
313
30
2476
Oct-16
730
630
630
290
37
2317
Nov-16
699
710
603
280
32
2324
Dec-16
647
570
570
260
33
2080
Jan-17
730
650
500
287
35
2202
Feb-17
930
680
590
290
50
2540
Mar-17
1160
724
620
300
63
2867
Apr-17
1510
730
730
310
68
3348
May-17
1650
760
740
330
70
3550
Jun-17
1490
800
720
340
82
3432
Jul-17
1460
840
670
350
80
3400
Aug-17
1390
830
610
341
90
3261
Sep-17
1360
820
599
330
100
3209
Oct-17
1340
810
560
320
102
3132
Nov-17
1240
827
550
300
110
3027
Dec-17
1103
750
520
290
114
2777
Jan-18
1250
780
480
200
111
2821
Feb-18
1550
805
523
210
121
3209
Mar-18
1820
830
560
220
123
3553
Apr-18
2010
890
570
230
120
3820
May-18
2230
930
590
253
130
4133
Jun-18
2490
980
600
270
136
4476
Jul-18
2440
1002
580
280
134
4436
Aug-18
2334
970
570
250
132
4256
Sep-18
2190
960
550
230
137
4067
Oct-18
2080
930
530
220
130
3890
Nov-18
2050
920
517
190
139
3816
Dec-18
2004
902
490
190
131
3717
Industry Mower Total Sales
Month NA
SA
Jan-14 60000 571
Feb-14 77184 611
Mar-14 77885 658
Apr-14 86190 778
May-14 96117 886
Jun-14 97143 882
Jul-14 84757 848
Aug-14 79804 735
Sep-14 64800 657
Oct-14 59307 595
Nov-14 52157 553
Dec-14 45049 462
Jan-15 58627 553
Feb-15 76200 615
Mar-15 82871 658
Apr-15 84904 784
May-15 93100 846
Jun-15 93000 838
Jul-15 83048 763
Aug-15 74854 694
Sep-15 60769 625
Oct-15 55619 610
Nov-15 48155 571
Dec-15 42647 512
Jan-16 57885 537
Feb-16 77647 595
Mar-16 81845 659
Apr-16 86095 756
May-16 91776 878
Jun-16 100680 825
Jul-16 86190 756
Aug-16 71887 714
Sep-16 60000 651
Oct-16 55566 643
Nov-16 50857 619
Dec-16 42596 548
Jan-17 58095 581
Feb-17 75566 614
Mar-17 80286 622
Apr-17 85140 727
May-17 90093 826
Jun-17 95472 783
Jul-17 87308 681
Aug-17 74476 646
Sep-17 61698 625
Oct-17 57238 617
Nov-17 50673 587
Dec-17 51238 591
Jan-18 59712 563
Feb-18 77961 571
Mar-18 83725 625
Apr-18 90297 723
May-18 91143 848
Jun-18 99320 792
Jul-18 93922 745
Aug-18 73143 739
Sep-18 66699 667
Oct-18 56476 660
Nov-18 51068 625
Dec-18 46893 608
Eur
Pac
China World
13091
1045
0
74662
17679
1111
0
96585
22759
1068
0 102369
27966
1237
0 116171
27895
1313
0 126210
30566
1176
0 129768
29444
1359
0 116409
28364
1238
0 110141
28393
1215
0
95065
24444
1154
0
85500
18000
1262
0
71972
12453
1386
0
59349
12778
1443
0
73401
18214
1515
0
96545
23889
1373
0 108791
29455
1442
0 116584
29464
1215
0 124625
27414
1333
0 122585
27368
1415
0 112594
27321
1296
0 104164
29444
1402
0
92241
23774
1468
0
81470
17308
1351
0
67386
12941
1389
0
57489
10962
1509
0
70892
15273
1402
0
94917
20556
1524
0 104583
26786
1574
0 115211
24828
1468
0 118949
24737
1560
0 127801
24828
1441
0 113216
25179
1545
0
99325
24545
1667
0
86863
19286
1698
0
77193
15273
1810
0
68558
9107
1731
0
53982
8571
1887
0
69135
13158
1845
0
91182
19655
1923
0 102486
25179
1981
125 113027
23103
1810
142 115832
24286
1942
226 122482
24737
1961
230 114686
26607
2000
122 103729
22982
2075
56
87381
16897
2019
10
76771
13750
2095
0
67105
7818
2150
0
61797
7547
1852
0
69673
13889
1743
0
94165
18302
1892
0 104544
25192
2037
236 118250
24706
1887
542 118583
25306
1944
875 127363
27083
2170
1386 123919
26042
2037
1193 101961
26304
2018
421
95688
22558
2072
56
81766
14773
2182
0
68648
6977
2035
0
56510
Industry Tractor Total Sales
Month NA
SA
Eur
Pac
China World
Jan-14
8143
984
5091
987
278 15483
Feb-14
8592
1051
5310
1090
283 16325
Mar-14
8630
1016
6071
1127
285 17129
Apr-14
8947
1027
5856
1209
288 17327
#####
8442
1057
5273
1221
286 16278
Jun-14
7500
1019
5315
1327
287 15448
Jul-14
6145
977
7170
1324
289 15905
#####
5882
1057
5926
1268
290 14422
#####
5595
1086
6075
1209
293 14258
Oct-14
5233
1045
6321
1168
295 14061
#####
4494
1078
8381
1127
298 15378
#####
3913
1029
7944
1085
301 14272
Jan-15
5938
1172
5688
1185
306 14289
Feb-15
6633
1273
7037
1286
302 16530
Mar-15
7327
1423
6981
1286
303 17320
Apr-15
8077
1612
7500
1346
307 18842
#####
7830
1728
6571
1388
309 17826
Jun-15
7103
1815
6990
1449
312 17669
Jul-15
6239
1776
6667
1490
315 16487
#####
6036
1685
6762
1449
318 16250
#####
5664
1679
6635
1394
321 15692
Oct-15
5345
1618
6311
1256
315 14844
#####
4831
1564
6476
1214
318 14402
#####
4454
1522
6250
1171
320 13716
Jan-16
5299
1835
5922
1208
333 14597
Feb-16
6529
2115
6667
1214
313 16836
Mar-16
7120
2202
7228
1256
606 18412
Apr-16
7619
2151
8200
1311
571 19852
#####
8387
2214
7941
1415
556 20513
Jun-16
8110
2278
7921
1520
526 20355
Jul-16
7752
2100
7677
1675
513 19716
#####
6894
2128
7200
1584
769 18575
#####
6015
2367
6735
1527
750 17394
Oct-16
5368
2211
6495
1422
732 16226
#####
4964
2483
6061
1366
714 15587
#####
4444
1986
5816
1262
698 14207
Jan-17
5000
2257
5051
1373
714 14394
Feb-17
6284
2353
6082
1436
1063 17218
Mar-17
7785
2457
6327
1478
1264 19310
Apr-17
9934
2517
7604
1512
1333 22901
##### 10645
2612
7789
1642
1556 24244
Jun-17
9491
2749
7347
1667
1739 22993
Jul-17
9182
2887
6979
1733
1702 22483
#####
8528
2833
6489
1700
1915 21465
#####
8293
2789
6316
1642
2083 21123
Oct-17
8221
2765
5833
1576
2128 20523
#####
7470
2746
5789
1493
2292 19789
#####
6509
2534
5591
1450
2245 18329
Jan-18
7267
2635
5106
1010
2292 18311
Feb-18
8807
2703
5474
1045
2449 20477
Mar-18 10168
2795
6022
1106
2400 22489
Apr-18 11044
2997
6064
1150
2353 23607
##### 12120
3131
6344
1244
2600 25439
Jun-18 13459
3311
6593
1357
2653 27374
Jul-18 13048
3390
6304
1421
2600 26764
##### 12275
3277
6064
1263
2549 25428
##### 11347
3232
5789
1173
2453 23995
Oct-18 10667
3131
5699
1128
2517 23142
##### 10459
3087
5604
974
2541 22666
##### 10082
3030
5444
979
2453 21989
Unit Production Costs
Month
Tractor Mower
Jan-14
$1,750
$50
Feb-14
$1,755
$50
Mar-14
$1,763
$51
Apr-14
$1,770
$51
May-14
$1,778
$51
Jun-14
$1,785
$51
Jul-14
$1,792
$51
Aug-14
$1,795
$51
Sep-14
$1,801
$52
Oct-14
$1,804
$52
Nov-14
$1,810
$52
Dec-14
$1,813
$52
Jan-15
$1,835
$55
Feb-15
$1,841
$55
Mar-15
$1,848
$55
Apr-15
$1,854
$55
May-15
$1,860
$56
Jun-15
$1,866
$56
Jul-15
$1,872
$56
Aug-15
$1,878
$56
Sep-15
$1,885
$56
Oct-15
$1,892
$57
Nov-15
$1,897
$57
Dec-15
$1,903
$57
Jan-16
$1,925
$59
Feb-16
$1,931
$59
Mar-16
$1,938
$59
Apr-16
$1,944
$59
May-16
$1,950
$59
Jun-16
$1,956
$60
Jul-16
$1,963
$60
Aug-16
$1,969
$60
Sep-16
$1,976
$60
Oct-16
$1,983
$60
Nov-16
$1,990
$61
Dec-16
$1,996
$61
Jan-17
$2,011
$59
Feb-17
$2,001
$59
Mar-17
$2,024
$59
Apr-17
May-17
Jun-17
Jul-17
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
$2,030
$2,039
$2,026
$2,034
$2,033
$2,056
$2,065
$2,068
$2,069
$2,073
$2,077
$2,081
$2,086
$2,092
$2,098
$2,104
$2,110
$2,116
$2,122
$2,129
$2,135
$59
$60
$60
$60
$60
$60
$60
$61
$61
$63
$63
$63
$63
$63
$63
$64
$64
$64
$64
$64
$64
Operating and Interest Expenses
Month AdministrativeDepreciationInterest
Jan-14
$633,073
$140,467 $7,244
Feb-14
$607,904
$165,636 $7,679
Mar-14
$630,687
$142,853 $6,887
Apr-14
$613,401
$160,139 $6,917
#####
$607,664
$165,876 $8,316
Jun-14
$632,967
$140,573 $7,428
Jul-14
$609,604
$163,936 $8,737
#####
$607,749
$165,791 $7,054
#####
$603,367
$170,173 $8,862
Oct-14
$629,083
$144,457 $8,488
#####
$611,995
$161,545 $7,049
#####
$625,712
$147,828 $8,807
Jan-15
$656,123
$175,447 $7,430
Feb-15
$652,679
$178,891 $6,791
Mar-15
$655,521
$176,049 $8,013
Apr-15
$676,581
$154,989 $8,979
#####
$676,581
$154,989 $7,484
Jun-15
$656,440
$175,130 $7,858
Jul-15
$661,969
$169,601 $7,424
#####
$677,212
$154,358 $6,848
#####
$653,545
$178,025 $6,751
Oct-15
$657,388
$174,182 $8,160
#####
$672,475
$159,095 $7,898
#####
$656,325
$175,245 $8,953
Jan-16
$723,594
$226,526 $9,443
Feb-16
$759,042
$191,078 $8,464
Mar-16
$749,187
$200,933 $10,264
Apr-16
$751,499
$198,621 $8,547
#####
$741,452
$208,668 $8,578
Jun-16
$729,122
$220,998 $9,519
Jul-16
$734,783
$215,337 $9,343
#####
$748,208
$201,912 $8,448
#####
$738,186
$211,934 $9,957
Oct-16
$759,403
$190,717 $9,738
#####
$726,183
$223,937 $9,785
#####
$757,037
$193,083 $8,191
Jan-17
$672,232
$179,138 $9,914
Feb-17
$665,023
$186,347 $9,954
Mar-17
$667,657
$183,713 $10,859
Apr-17
#####
Jun-17
Jul-17
#####
#####
Oct-17
#####
#####
Jan-18
Feb-18
Mar-18
Apr-18
#####
Jun-18
Jul-18
#####
#####
Oct-18
#####
#####
$654,198
$659,435
$661,190
$647,321
$666,743
$678,705
$658,990
$656,221
$676,934
$641,571
$634,973
$662,054
$654,962
$645,579
$658,112
$637,711
$638,317
$651,996
$630,766
$645,095
$637,807
$197,172
$191,935
$190,180
$204,049
$184,627
$172,665
$192,380
$195,149
$174,436
$210,589
$217,187
$190,106
$197,198
$206,581
$194,048
$214,449
$213,843
$200,164
$221,394
$207,065
$214,353
$9,730
$10,430
$10,222
$10,102
$10,610
$9,374
$10,830
$9,017
$10,423
$9,985
$9,766
$11,148
$9,339
$9,468
$10,324
$9,737
$9,290
$9,213
$10,143
$10,383
$9,059
On-Time Delivery
Month Number of deliveriesNumber On TimePercent
Jan-14
1086
1069 98.4%
Feb-14
1101
1080 98.1%
Mar-14
1116
1089 97.6%
Apr-14
1216
1199 98.6%
May-14
1183
1168 98.7%
Jun-14
1176
1160 98.6%
Jul-14
1198
1181 98.6%
Aug-14
1205
1189 98.7%
Sep-14
1223
1210 98.9%
Oct-14
1209
1194 98.8%
Nov-14
1198
1180 98.5%
Dec-14
1243
1223 98.4%
Jan-15
1220
1201 98.4%
Feb-15
1241
1224 98.6%
Mar-15
1237
1217 98.4%
Apr-15
1258
1242 98.7%
May-15
1262
1246 98.7%
Jun-15
1227
1212 98.8%
Jul-15
1243
1227 98.7%
Aug-15
1281
1264 98.7%
Sep-15
1272
1254 98.6%
Oct-15
1295
1278 98.7%
Nov-15
1298
1281 98.7%
Dec-15
1318
1296 98.3%
Jan-16
1281
1264 98.7%
Feb-16
1320
1304 98.8%
Mar-16
1352
1334 98.7%
Apr-16
1336
1320 98.8%
May-16
1291
1276 98.8%
Jun-16
1342
1326 98.8%
Jul-16
1352
1337 98.9%
Aug-16
1377
1360 98.8%
Sep-16
1385
1368 98.8%
Oct-16
1356
1338 98.7%
Nov-16
1362
1346 98.8%
Dec-16
1349
1333 98.8%
Jan-17
1386
1371 98.9%
Feb-17
1358
1342 98.8%
Mar-17
1371
1356 98.9%
Apr-17
1362
1348 99.0%
May-17
1350
1338 99.1%
Jun-17
1381
1366 98.9%
Jul-17
1392
1378 99.0%
Aug-17
1371
1359 99.1%
Sep-17
1402
1387 98.9%
Oct-17
1384
1370 99.0%
Nov-17
1399
1377 98.4%
Dec-17
1369
1357 99.1%
Jan-18
1401
1390 99.2%
Feb-18
1388
1376 99.1%
Mar-18
1395
1385 99.3%
Apr-18
1412
1401 99.2%
May-18
1403
1392 99.2%
Jun-18
1415
1402 99.1%
Jul-18
1426
1415 99.2%
Aug-18
1431
1420 99.2%
Sep-18
1445
1426 98.7%
Oct-18
1425
1414 99.2%
Nov-18
1413
1403 99.3%
Dec-18
1456
1427 98.0%
A
1
B
C
D
E
F
Defects After Delivery
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Defects per million items received from suppliers
Month
2014
2015
2016
2017
2018
January
812
828
824
682
571
February
810
832
836
695
575
March
813
847
818
692
547
April
823
839
825
686
542
May
832
832
804
673
532
June
848
840
812
681
496
July
837
849
806
696
472
August
831
857
798
688
460
September 827
839
804
671
441
October
838
842
713
645
445
November
826
828
705
617
438
December
819
816
686
603
436
Time to Pay Suppliers
Month
Working Days
Jan-14
8.32
Feb-14
8.28
Mar-14
8.29
Apr-14
8.32
May-14
8.36
Jun-14
8.35
Jul-14
8.34
Aug-14
8.32
Sep-14
8.36
Oct-14
8.33
Nov-14
8.32
Dec-14
8.29
Jan-15
7.89
Feb-15
7.65
Mar-15
7.58
Apr-15
7.53
May-15
7.48
Jun-15
7.45
Jul-15
7.36
Aug-15
7.35
Sep-15
7.32
Oct-15
7.3
Nov-15
7.27
Dec-15
7.25
Jan-16
7.22
Feb-16
7.21
Mar-16
7.22
Apr-16
7.29
May-16
7.25
Jun-16
7.23
Jul-16
7.28
Aug-16
7.25
Sep-16
7.24
Oct-16
7.26
Nov-16
7.21
Dec-16
7.23
Jan-17
7.24
Feb-17
7.19
Mar-17
7.21
Apr-17
7.23
May-17
7.22
Jun-17
7.19
Jul-17
7.17
Aug-17
7.15
Sep-17
7.16
Oct-17
7.16
Nov-17
7.15
Dec-17
7.14
Jan-18
7.12
Feb-18
7.11
Mar-18
7.11
Apr-18
7.11
May-18
7.11
Jun-18
7.12
Jul-18
7.08
Aug-18
7.09
Sep-18
7.09
Oct-18
7.04
Nov-18
7.06
Dec-18
7.08
Response times to customer service calls (days)
Q1 2017 Q2 2017 Q3 2017 Q4 2017 Q1 2018 Q2 2018 Q3 2018 Q4 2018
4.36
4.33
3.71
4.44
2.75
3.45
1.67
2.55
5.42
4.73
2.52
4.07
3.24
1.95
2.58
2.30
5.50
1.63
2.69
5.11
4.35
2.77
3.47
1.04
2.79
4.21
3.47
3.49
5.58
1.83
3.12
1.59
5.55
6.89
5.12
4.69
2.89
3.72
1.00
3.11
3.65
0.92
1.00
6.36
5.09
4.59
5.40
4.05
8.02
5.27
3.44
8.26
2.33
1.17
3.90
3.38
4.00
0.90
6.04
1.91
1.69
1.46
4.49
1.26
3.34
3.85
2.53
8.93
3.88
1.90
2.06
0.90
4.92
5.00
2.39
6.85
3.39
2.95
4.49
2.31
3.55
3.52
3.26
5.69
5.14
4.69
3.57
2.71
3.52
5.20
4.68
3.05
0.98
3.34
3.41
1.65
1.25
5.13
3.59
5.91
2.34
3.59
3.31
3.58
2.18
5.29
1.07
1.00
2.80
4.03
2.79
2.96
4.35
1.00
2.86
1.82
3.06
2.39
2.09
3.78
2.46
2.18
4.44
3.74
2.40
1.63
4.28
2.87
2.07
4.55
4.87
6.11
1.59
2.40
4.47
0.90
2.90
2.13
6.76
4.78
3.05
4.44
1.94
4.87
2.58
5.24
2.84
4.13
1.50
4.96
3.90
3.11
5.50
4.08
1.25
7.17
5.58
4.41
3.32
0.90
2.47
4.04
3.43
5.70
3.11
3.40
2.20
3.52
4.24
5.09
2.98
1.00
1.08
3.15
3.52
3.18
1.88
7.66
4.65
3.40
3.63
4.87
2.31
0.90
4.25
4.65
2.66
2.04
1.86
3.97
1.00
1.35
5.08
0.90
4.99
4.37
1.90
3.85
5.90
1.62
4.40
2.01
3.76
2.47
6.07
2.81
1.09
1.87
1.64
1.34
3.12
3.20
1.00
1.76
4.60
1.03
6.40
8.05
2.12
5.83
1.00
5.58
3.52
2.31
3.68
4.91
4.32
3.94
1.19
4.92
4.14
1.99
3.92
5.06
3.61
2.47
3.79
2.63
4.13
3.97
4.13
3.26
4.02
3.89
5.86
3.27
2.43
1.00
3.34
4.26
2.63
6.88
0.90
2.86
2.34
3.51
3.28
1.70
4.47
1.71
2.24
3.83
2.53
2.41
3.24
2.30
4.18
6.39
0.90
1.79
4.14
2.47
3.25
5.35
4.73
6.57
3.87
2.70
2.65
4.02
5.20
2.33
2.65
4.18
2.46
3.61
3.21
2.03
5.28
3.67
2.36
8.82
3.84
0.90
3.85
3.62
4.33
4.73
3.64
3.35
2.43
3.38
2.20
4.12
4.64
1.05
5.62
5.50
1.54
4.38
4.57
1.40
2.65
2.67
0.90
6.51
0.90
2.87
2.99
2.49
3.42
4.16
6.40
0.90
3.69
2.11
4.19
2.67
3.97
0.90
3.21
2.87
1.73
2.86
3.03
4.33
1.26
3.51
3.55
7.45
3.52
3.12
1.90
1.95
6.16
5.95
5.93
3.49
2.23
1.86
2.09
2.70
6.40
2.05
5.52
3.03
5.35
2.41
1.03
1.76
1.00
8.21
4.96
7.46
5.11
2.98
2.95
2.64
3.63
2.52
4.85
4.84
6.46
0.90
7.42
4.49
5.34
3.99
5.57
2.88
5.61
1.01
3.79
1.62
3.74
2.59
4.82
0.95
3.63
4.56
2.48
1.10
5.63
1.34
3.18
3.05
3.87
5.67
2.71
4.50
Employee Satisfaction Results
Averages using a 5 point scale
Design &
Sales &
Quarter Production Sample sizeManager Sample sizeAdministrationSample sizeTotal Sample size
1st Q-15
2.86
100
3.81
10
3.51
30
3.07
140
2nd Q-15
2.91
100
3.76
10
3.38
30
3.07
140
3rd Q-15
2.84
100
3.86
10
3.45
30
3.04
140
4th Q-15
2.83
100
3.48
10
3.61
30
3.04
140
1st Q-16
2.91
100
3.75
20
3.37
30
3.11
150
2nd Q-16
2.94
100
3.92
20
3.53
30
3.19
150
3rd Q-16
2.86
100
3.89
20
3.47
30
3.12
150
4th Q-16
2.83
100
3.58
20
3.66
30
3.10
150
1st Q-17
2.95
100
3.82
20
3.71
40
3.25
160
2nd Q-17
3.01
100
4.01
20
3.53
40
3.27
160
3rd Q-17
3.03
100
3.92
20
3.62
40
3.29
160
4th Q-17
2.96
100
3.84
20
3.48
40
3.20
160
1st Q-18
3.05
100
3.92
20
3.52
40
3.28
160
2nd Q-18
3.12
100
4.00
20
3.37
40
3.29
160
3rd Q-18
3.06
100
3.93
20
3.46
40
3.27
160
4th Q-18
3.02
100
3.70
20
3.59
40
3.25
160
Engine Production Time
Sample
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Production Time (min)
65.1
62.3
60.4
58.7
58.1
56.9
57.0
56.5
55.1
54.3
53.7
53.2
52.8
52.5
52.1
51.8
51.5
51.3
50.9
50.5
50.2
50.0
49.7
49.5
49.3
49.4
49.1
49.0
48.8
48.5
48.3
48.2
48.1
47.9
47.7
47.6
47.4
47.1
46.9
46.8
46.7
46.6
46.5
46.5
46.2
46.3
46.0
45.8
45.7
45.6
Unit Tractor Transmission Costs
Current Process AProcess B
$242.00 $242.00 $292.00
$176.00 $275.00 $321.00
$286.00 $199.00 $314.00
$269.00 $219.00 $242.00
$327.00 $273.00 $278.00
$264.00 $265.00 $300.00
$296.00 $435.00 $301.00
$333.00 $285.00 $286.00
$242.00 $384.00 $315.00
$288.00 $387.00 $300.00
$314.00 $299.00 $304.00
$302.00 $145.00 $300.00
$335.00 $266.00 $351.00
$242.00 $216.00 $277.00
$281.00 $331.00 $284.00
$289.00 $247.00 $276.00
$259.00 $280.00 $312.00
$322.00 $267.00 $273.00
$209.00 $210.00 $281.00
$282.00 $391.00 $303.00
$304.00 $297.00 $306.00
$391.00 $346.00 $312.00
$236.00 $230.00 $287.00
$383.00 $332.00 $306.00
$299.00 $301.00 $312.00
$300.00 $277.00 $295.00
$278.00 $336.00 $288.00
$303.00 $217.00 $313.00
$315.00 $274.00 $286.00
$321.00 $339.00 $338.00
Blade Weight
Sample Weight
1
4.88
2
4.92
3
5.02
4
4.97
5
5.00
6
4.99
7
4.86
8
5.07
9
5.04
10
4.87
11
4.77
12
5.14
13
5.04
14
5.00
15
4.88
16
4.91
17
5.09
18
4.97
19
4.98
20
5.07
21
5.03
22
5.12
23
5.08
24
4.86
25
5.11
26
4.92
27
5.18
28
4.93
29
5.12
30
5.08
31
4.75
32
4.99
33
5.00
34
4.91
35
5.18
36
4.95
37
4.63
38
4.89
39
5.11
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
5.05
5.03
5.02
4.96
5.04
4.93
5.06
5.07
5.00
5.03
5.00
4.95
4.99
5.02
4.90
5.10
5.01
4.84
5.01
4.88
4.97
4.97
5.06
5.06
5.04
4.87
5.00
5.03
5.02
5.02
5.06
5.21
5.09
4.97
5.01
4.90
4.89
4.93
5.16
5.02
5.01
5.10
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
5.03
5.07
4.92
5.08
4.96
4.74
4.91
5.12
5.00
4.93
4.88
4.88
4.81
5.16
5.03
4.87
5.09
4.94
5.08
4.97
5.23
5.12
5.09
5.12
4.93
4.79
5.10
5.12
4.86
5.00
4.94
4.95
4.95
4.87
5.09
4.94
5.01
5.04
5.05
5.05
4.97
4.96
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
4.96
4.99
5.04
4.91
5.19
5.03
4.99
5.12
4.97
4.88
5.07
5.01
4.89
4.95
5.09
5.09
4.89
4.93
4.85
5.03
4.92
5.09
4.99
4.92
4.87
4.90
5.02
5.21
5.02
4.9
5
5.16
5.03
4.96
5.04
4.98
5.07
5.02
5.08
4.85
4.9
4.97
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
5.09
4.89
4.87
5.01
4.97
5.87
5.33
5.11
5.07
4.93
4.99
5.04
5.14
5.09
5.06
4.85
4.93
5.04
5.09
5.07
4.99
5.01
4.88
4.93
5.1
4.94
4.88
4.89
4.89
4.85
4.82
5.02
4.9
4.73
5.04
5.07
4.81
5.04
5.03
5.01
5.14
5.12
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
4.89
4.91
4.97
4.98
5.01
5.01
5.09
4.93
5.04
5.11
5.07
4.95
4.86
5.13
4.95
5.22
4.81
4.91
4.95
4.94
4.81
5.11
4.81
4.97
5.07
5.03
4.81
4.95
4.89
5.08
4.93
4.99
4.94
5.13
5.02
5.07
4.82
5.03
4.85
4.89
4.82
5.18
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
5.02
5.05
4.88
5.08
4.98
5.02
4.99
5.02
5.03
5.02
5.07
4.95
4.95
4.94
5.12
5.08
4.91
4.96
4.96
4.94
5.19
4.91
5.01
4.93
5.05
4.96
4.92
4.95
5.08
4.97
5.04
4.94
4.98
5.03
5.05
4.91
5.09
5.21
4.87
5.02
4.81
4.96
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
5.06
4.86
4.96
4.99
4.94
5.06
4.95
5.02
5.01
5.04
5.01
5.02
5.03
5.18
5.08
5.14
4.92
4.97
4.92
5.14
4.92
5.03
4.98
4.76
4.94
4.92
4.91
4.96
5.02
5.13
5.13
4.92
4.98
4.89
4.88
5.11
5.11
5.08
5.03
4.94
4.88
4.91
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
4.86
4.89
4.91
4.87
4.93
5.14
4.87
4.98
4.88
4.88
5.01
4.93
4.93
4.99
4.91
4.96
4.78
Mower Test Functional Performance
Sample
Observation
1
1
Pass
2
Pass
3
Pass
4
Pass
5
Pass
6
Pass
7
Pass
8
Pass
9
Pass
10
Pass
11
Pass
12
Pass
13
Pass
14
Pass
15
Pass
16
Pass
17
Pass
18
Pass
19
Pass
20
Pass
21
Pass
22
Pass
23
Pass
24
Pass
25
Pass
26
Pass
27
Pass
28
Pass
29
Pass
30
Pass
31
Pass
32
Pass
33
Pass
34
Pass
35
Pass
36
Pass
37
Pass
38
Pass
2
Fail
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
3
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
4
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
5
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
6
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
7
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
8
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
9
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
10
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
11
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
12
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
13
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
14
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
15
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
16
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
17
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
18
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
19
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
20
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
21
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
22
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
23
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
24
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
25
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
26
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
27
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
28
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
29
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
30
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Employee Retention
YearsPLE YrsEducationCollege GPA Age GenderCollege Grad Local
10
18
3.01
33
F
Y
Y
10
16
2.78
25
M
Y
Y
10
18
3.15
26
M
Y
N
10
18
3.86
24
F
Y
Y
9.6
16
2.58
25
F
Y
Y
8.5
16
2.96
23
M
Y
Y
8.4
17
3.56
35
M
Y
Y
8.4
16
2.64
23
M
Y
Y
8.2
18
3.43
32
F
Y
Y
7.9
15
2.75
34
M
N
Y
7.6
13
2.95
28
M
N
Y
7.5
13
2.50
23
M
N
Y
7.5
16
2.86
24
M
Y
Y
7.2
15
2.38
23
F
N
Y
6.8
16
3.47
27
F
Y
Y
6.5
16
3.10
26
M
Y
Y
6.3
13
2.98
21
M
N
Y
6.2
16
2.71
23
M
Y
N
5.9
13
2.95
20
F
N
Y
5.8
18
3.36
25
M
Y
Y
5.4
16
2.75
24
M
Y
N
5.1
17
2.48
32
M
Y
N
4.8
14
2.76
28
M
N
Y
4.7
16
3.12
25
F
Y
N
4.5
13
2.96
23
M
N
Y
4.3
16
2.80
25
M
Y
N
4
17
3.57
24
M
Y
Y
3.9
16
3.00
26
F
Y
N
3.7
16
2.86
23
M
Y
N
3.7
15
3.19
24
M
N
N
3.7
16
3.50
23
F
Y
N
3.5
14
2.84
21
M
N
Y
3.4
16
3.13
24
M
Y
N
2.5
13
1.75
22
M
N
N
1.8
16
2.98
25
M
Y
N
1.5
15
2.13
22
M
N
N
0.9
16
2.79
23
F
Y
Y
0.8
18
3.15
26
M
Y
N
0.7
13
1.84
22
F
N
N
0.3
18
3.79
24
F
Y
N
Unit Shipping Cost
Plant
Singapore
Birmingham
Frankfurt
Mumbai
Kansas City
Auckland
Santiago
Singapore
Birmingham
Frankfurt
Mumbai
Kansas City
Auckland
Santiago
Singapore
Birmingham
Frankfurt
Mumbai
Kansas City
Auckland
Santiago
Customer Mowers Tractors
Toronto
$1.71
$2.03
Toronto
$1.34
$1.78
Toronto
$1.52
$1.87
Toronto
$1.67
$2.14
Toronto
$1.36
$1.79
Toronto
$1.86
$2.19
Toronto
$1.49
$2.13
Shanghai
$1.44
$1.78
Shanghai
$1.60
$2.15
Shanghai
$1.65
$2.32
Shanghai
$1.21
$1.47
Shanghai
$1.58
$2.13
Shanghai
$1.18
$1.63
Shanghai
$1.47
$2.03
Mexico City $1.72
$2.09
Mexico City $1.29
$1.79
Mexico City $1.54
$2.04
Mexico City $1.56
$2.22
Mexico City $1.32
$1.76
Mexico City $1.50
$2.07
Mexico City $1.22
$1.58
Singapore
Melbourne
$1.43
$1.70
Birmingham
Melbourne
$1.52
$2.06
Frankfurt
Melbourne
$1.73
$2.28
Mumbai
Melbourne
$1.38
$1.63
Kansas City
Melbourne
$1.72
$2.34
Auckland
Melbourne
$0.91
$1.17
Santiago
Singapore
Birmingham
Frankfurt
Mumbai
Kansas City
Auckland
Melbourne
London
London
London
London
London
London
$1.49
$1.88
$1.47
$1.37
$1.44
$1.49
$1.98
$1.80
$2.68
$1.77
$1.64
$1.82
$1.86
$2.60
Santiago
Singapore
Birmingham
Frankfurt
Mumbai
Kansas City
Auckland
Santiago
Singapore
Birmingham
Frankfurt
Mumbai
Kansas City
Auckland
Santiago
London
Caracas
Caracas
Caracas
Caracas
Caracas
Caracas
Caracas
Atlanta
Atlanta
Atlanta
Atlanta
Atlanta
Atlanta
Atlanta
$1.58
$1.50
$1.37
$1.59
$1.61
$1.54
$1.54
$1.00
$1.73
$1.02
$1.42
$1.57
$1.31
$1.74
$1.31
$2.14
$2.01
$1.86
$1.88
$2.08
$1.90
$1.98
$1.26
$2.35
$1.25
$1.70
$2.23
$1.82
$2.26
$1.76
Fixed Costs of Capacity Increase or New Construction
Current Plants
Kansas City
Kansas City
Santiago
Santiago
Proposed Locations
Auckland
Auckland
Birmingham
Birmingham
Frankfurt
Frankfurt
Mumbai
Mumbai
Singapore
Singapore
Additional CapacityCost
10000
$605,000.00
20000
$985,000.00
5000
$381,000.00
10000
$680,000.00
Maximum capacity
15,000
20,000
15,000
20,000
15,000
20,000
15,000
25,000
15,000
20,000
Cost
$917,000.00
$1,136,000.00
$962,000.00
$1,180,000.00
$874,000.00
$1,093,000.00
$750,000.00
$959,000.00
$839,000.00
$1,058,000.00
Purchasing Survey
Delivery speed Price levelPrice flexibilityManufacturing imageOverall service
4.1
0.6
6.9
4.7
2.4
1.8
3
6.3
6.6
2.5
3.4
5.2
5.7
6
4.3
2.7
1
7.1
5.9
1.8
6
0.9
9.6
7.8
3.4
1.9
3.3
7.9
4.8
2.6
4.6
2.4
9.5
6.6
3.5
1.3
4.2
6.2
5.1
2.8
5.5
1.6
9.4
4.7
3.5
4
3.5
6.5
6
3.7
2.4
1.6
8.8
4.8
2
3.9
2.2
9.1
4.6
3
2.8
1.4
8.1
3.8
2.1
3.7
1.5
8.6
5.7
2.7
4.7
1.3
9.9
6.7
3
3.4
2
9.7
4.7
2.7
3.2
4.1
5.7
5.1
3.6
4.9
1.8
7.7
4.3
3.4
5.3
1.4
9.7
6.1
3.3
4.7
1.3
9.9
6.7
3
3.3
0.9
8.6
4
2.1
3.4
0.4
8.3
2.5
1.2
3
4
9.1
7.1
3.5
2.4
1.5
6.7
4.8
1.9
5.1
1.4
8.7
4.8
3.3
4.6
2.1
7.9
5.8
3.4
2.4
1.5
6.6
4.8
1.9
5.2
1.3
9.7
6.1
3.2
3.5
2.8
9.9
3.5
3.1
4.1
3.7
5.9
5.5
3.9
3
3.2
6
5.3
3.1
2.8
3.8
8.9
6.9
3.3
5.2
2
9.3
5.9
3.7
3.4
3.7
6.4
5.7
3.5
2.4
1
7.7
3.4
1.7
1.8
3.3
7.5
4.5
2.5
3.6
4
5.8
5.8
3.7
4
0.9
9.1
5.4
2.4
0
2.1
6.9
5.4
1.1
2.4
2
6.4
4.5
2.1
1.9
3.4
7.6
4.6
2.6
5.9
4.9
5
2
5
3.1
3.4
5.8
5.4
3.7
2.6
4.5
2.8
3.8
2.9
4.9
5.4
4.3
2.3
3.1
5.1
4.1
3
1.1
3.7
4.2
1.6
5.3
2.3
3.6
5.6
3.6
5.2
3
4.2
3.8
3.3
1
4.5
5.5
3.4
1.6
2.3
2.6
0.9
2.3
1.3
2.6
2.5
1.9
3.9
0.2
2.1
0.7
4.8
4.1
2.4
0.8
2.6
4.4
2.5
1.8
4.5
1.9
1.9
1.1
3.8
2
1.4
2.5
4.5
1.7
3.7
5.4
2.2
2.2
1.3
2
2.4
0.8
2.6
1.9
1.6
1.8
4.6
2.8
3.7
3
9.6
9.3
8.6
6.5
9.4
10
5.6
8.8
8
8.2
8.2
6.3
6.7
8.7
7.7
7.4
9.6
7.6
8
9.9
9.2
9.3
5.5
7.2
9
9.2
6.4
8.5
8.3
5.9
8.2
9.9
9.1
6.6
9.4
8.3
9.7
7.1
8.7
8.7
5.5
6.1
7.6
8.5
7.8
4.5
4.7
3.7
4.6
4.5
5.6
4.5
3
6
5
5.9
4.9
2.9
7
6.9
5.5
5.4
4.7
4.5
5.8
5.5
4.9
4.7
4.5
6.2
5.3
3.7
5.2
6.2
3.1
4.8
4.5
6.6
4.9
6.1
3.3
4.5
4.6
3.8
8.2
6.4
5
6
3.4
3.6
3.1
2.4
3.7
2.6
3.6
3
3.8
2.1
3.6
4.3
2.5
1.6
2.8
4.6
4
3.1
3.3
2.6
3.6
2.5
3.4
1.6
2.6
3.3
3
3.5
3
4.5
4
2.9
3.3
2.4
3.2
2.2
2.9
1.5
3.1
3.6
4
2.3
3
2.8
2.5
2.4
2.1
2.9
4.3
3
4.8
3.1
1.9
4
0.6
6.1
2
3.1
2.5
3.1
2.9
3.5
1.2
2.5
2.8
1.7
4.2
2.7
0.5
1.6
0.5
2.8
2.2
1.8
7
8.4
7.4
7.3
9.3
7.8
7.6
5.1
5
6.7
6.4
9.2
5.2
6.7
9
4.2
5.9
4.8
6.1
6.3
7.1
4.2
7.8
4.9
4.5
5
4.8
5
6.8
5
2.8
2.7
2.8
2
3.4
3
3.3
3.6
2.2
2.2
0.7
3.3
2.4
2.6
2.2
Salesforce imageProduct qualityUsage LevelSatisfaction LevelSize of firm
2.3
5.2
32
4.2
0
4
8.4
43
4.3
1
2.7
8.2
48
5.2
1
2.3
7.8
32
3.9
1
4.6
4.5
58
6.8
0
1.9
9.7
45
4.4
1
4.5
7.6
46
5.8
0
2.2
6.9
44
4.3
1
3
7.6
63
5.4
0
3.2
8.7
54
5.4
1
2.8
5.8
32
4.3
0
2.5
8.3
47
5
0
1.4
6.6
39
4.4
1
3.7
6.7
38
5
0
2.6
6.8
54
5.9
0
1.7
4.8
49
4.7
0
2.9
6.2
38
4.4
0
1.5
5.9
40
5.6
0
3.9
6.8
54
5.9
0
2.6
6.8
55
6
0
1.8
6.3
41
4.5
0
1.7
5.2
35
3.3
0
3.4
8.4
55
5.2
0
2.5
7.2
36
3.7
1
2.6
3.8
49
4.9
0
2.8
4.7
49
5.9
0
2.5
7.2
36
3.7
1
3.9
6.7
54
5.8
0
1.7
5.4
49
5.4
0
3
8.4
46
5.1
1
3
8
43
3.3
1
3.2
8.2
53
5
0
2.4
4.6
60
6.1
0
3.4
8.4
47
3.8
1
1.1
6.2
35
4.1
1
2.4
7.6
39
3.6
1
2.5
9.3
44
4.8
1
2.6
7.3
46
5.1
0
2.6
8.9
29
3.9
1
2.2
8.8
28
3.3
1
2.5
7.7
40
3.7
1
4.6
1.3
2.5
1.7
1.4
3.2
2.3
2.4
1.4
2.5
2.5
3.4
2.6
2.1
3.6
4
3
2.5
2.2
3.1
2.3
2.7
2.6
3.2
2.3
3.9
2.5
1.9
2.3
2.9
1.6
1.9
2.7
2.7
2.7
2.6
1.5
3.1
2.1
2.1
4.4
3.8
2.5
2.8
4.5
6.2
3.7
8.5
6.3
3.8
9.1
6.7
5.2
5.2
9
8.8
9.2
5.6
7.7
9.6
7.7
4.4
8.7
3.8
4.5
7.4
6
10
6.8
7.3
7.1
4.8
9.1
8.4
5.3
4.9
7.3
8.2
8.5
5.3
5.2
9.9
6.8
4.9
6.3
8.2
7.4
6.8
58
53
48
38
54
55
43
57
53
41
53
50
32
39
47
62
65
46
50
54
60
47
36
40
45
59
46
58
49
50
55
51
60
41
49
42
47
39
56
59
47
41
37
53
6.7
5.9
4.8
3.2
6
4.9
4.7
4.9
3.8
5
5.2
5.5
3.7
3.7
4.2
6.2
6
5.6
5
4.8
6.1
5.3
4.2
3.4
4.9
6
4.5
4.3
4.8
5.4
3.9
4.9
5.1
4.1
5.2
5.1
5.1
3.3
5.1
4.5
5.6
4.1
4.4
5.6
0
0
0
1
0
0
1
0
0
0
1
1
1
0
0
1
0
0
1
0
0
0
0
1
0
0
1
0
1
1
0
0
0
1
0
0
0
1
0
0
0
1
0
1
2.2
2.7
2.3
2.5
4
3.8
1.4
4
2.5
2.1
2.1
2.8
2.7
2.9
3
9
6.7
7.2
8
7.4
7.9
5.8
5.9
8.2
5
8.4
7.1
8.4
8.4
6
43
51
36
34
60
49
39
43
36
31
25
60
38
42
33
3.7
5.5
4.3
4
6.1
4.4
5.5
5.2
3.6
4
3.4
5.2
3.7
4.3
4.4
1
1
0
1
0
0
0
0
1
0
1
0
1
1
0
Purchasing StructureIndustry Buying Type
0
1
1
1
0
1
1
1
2
1
1
1
0
1
3
1
1
2
0
1
1
1
0
2
0
1
3
1
0
2
0
0
1
0
1
2
1
0
1
0
1
1
0
0
3
0
0
3
1
1
2
0
0
2
0
1
3
0
0
3
0
0
2
0
0
1
1
0
3
1
0
1
0
0
2
0
1
3
1
0
1
0
1
3
0
1
3
1
0
2
1
0
1
1
0
3
0
0
3
1
0
1
1
0
1
1
1
1
1
1
2
0
1
3
1
1
1
1
1
1
1
1
1
0
0
0
1
0
0
1
0
0
0
1
1
1
0
1
1
0
0
1
0
0
0
1
1
0
0
1
0
1
1
0
0
0
1
0
0
0
1
0
0
1
1
1
1
1
0
0
1
0
1
1
1
1
0
1
0
1
0
1
0
0
1
1
1
0
1
1
1
0
0
0
0
1
1
1
0
1
0
1
0
1
1
0
0
1
0
0
0
3
3
2
1
3
3
2
3
3
2
2
2
1
1
2
2
3
3
2
3
3
3
2
1
2
3
2
3
2
2
3
3
3
1
2
2
3
1
3
3
2
1
1
2
1
1
1
1
0
1
0
1
1
0
1
0
1
1
0
1
0
0
1
0
1
0
1
0
1
1
1
0
0
0
1
2
1
1
3
2
2
2
1
1
1
3
1
1
1