Columbia College Case Study 1: I am working on Case Study

This week you will complete your first Case Study Assignment from Chapter 1 about PLE Lawn Equipment.

Download the

Case Study 1 Instructions.docx

Download the

Case Study 1 Excel Student File

Dealer Satisfaction
Survey Scale:
North America
2018
2019
2020
2021
2022
0
1
2
3
4
1
0
1
1
2
22
20
1
2
3
2
2
1
8
7
16
14
8
12
15
9
20
36
34
44
5 Sample
Size
11
61
2
58
15
62
45
102
56
127
0
0
0
0
1
12
22
1
1
1
3
0
1
1
2
2
2
4
3
4
6
6
11
12
22
2
2
14
33
60
25
32
31
50
90
2018
2019
2020
2021
2022
0
0
0
0
0
20
16
12
0
1
1
1
1
1
1
3
2
2
3
4
7
8
15
20
17
4
4
5
6
8
35
31
35
30
31
Pacific Rim
2018
2019
2020
2021
2022
0
0
0
0
0
0
0
0
0
0
1
4
1
4
1
2
1
2
3
2
2
3
3
5
7
0
5
1
3
2
5
13
7
15
12
0
0
0
0
0
0
25
1
1
3
4
5
0
3
8
5
12
22
33
20
36
South America
2018
2019
2020
2021
2022
Europe
China
2020
2021
2022
Region
Year
North America
South America
Europe
Pacific Rim
Totals
North America
South America
Europe
Pacific Rim
Totals
North America
South America
Europe
Pacific Rim
China
Totals
North America
South America
Europe
Pacific Rim
China
Totals
North America
South America
Europe
Pacific Rim
China
Totals
0
1
2
3
4
5
End-User Satisfaction
Survey Scale:
North America
2018
2019
2020
2021
2022
0 1
0 1
1 28
1 23
1 2
0 2
0 2
2
2
5
4
22
4
3
3
3
15
18
15
15
15
4
4
30
35
34
33
31
5 Sample
5 Size
20
99
20
101
35
109
46
100
49
100
South America
2018
2019
2020
2021
2022
1
1
0
0
0
7
8
6
5
15
18
17
18
20
19
36
36
37
29
37
38
37
36
36
37
102
102
99
92
110
2
3
2
2
2
`
Europe
2018
2019
2020
2021
2022
Pacific Rim
2018
2019
2020
2021
2022
23 2
2 2
1 1
1 1
0 11
5
5
4
3
12
21
21
26
17
19
36
34
37
40
32
20
37
31
37
23
107
101
100
99
97
2
1
1
0
0
4
2
2
2
1
5
7
5
4
3
15
15
16
17
19
41
41
40
40
41
34
34
36
37
35
101
100
100
100
99
0
1
0
3
5
1
4
2
2
6
3
3
20 10
30 11
31 14
43
52
51
China
2020
2021
2022
Region
Year
North America
South America
Europe
Pacific Rim
Totals
North America
South America
Europe
Pacific Rim
Totals
North America
South America
Europe
Pacific Rim
China
Totals
North America
South America
Europe
Pacific Rim
China
Totals
North America
South America
Europe
Pacific Rim
China
Totals
0
1
2
3
4
5
Mower Test Functional Performance
Number of failures
Sample
Observation
1
2
3
4
5
6
7
8
9
1
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
2
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
3
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
4
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
5
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
6
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
7
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
8
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
9
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
10
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
11
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
12
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
13
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
14
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
15
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
16
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
17
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
18
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
19
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
20
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
21
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
22
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
23
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
24
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
25
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
26
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
27
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
28
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
29
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
30
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
31
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
32
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
33
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
34
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
35
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
36
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
37
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
38
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
39
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
40
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
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
82
83
84
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
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
Fail
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
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
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
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
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
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
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
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Fail
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Fail
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
Pass
Fail
11
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
12
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Fail
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
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
14
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
15
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Fail
Fail
Fail
Fail
Fail
Fail
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
Pass
Pass
17
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
Fail
Pass
Pass
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
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
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
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
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
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
Fail
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
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
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
Fail
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
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
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Fail
Pass
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Pass
Fail
Pass
Pass
Pass
Fail
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
Fail
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
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
Fail
Pass
Pass
Fail
Pass
Fail
Pass
Pass
Pass
Pass
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
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
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
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
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
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
Pass
Pass
26
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
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
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
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
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
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
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
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
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
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
Fail
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
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
Gross Revenues
Prices for PLE products for the past 5 years:
Year Mower PriceTractor Price
2018
$152
$3,250
2019
$166
$3,305
2020
$200
$3,800
2021
$225
$3,900
2022
$250
$4,030
Mower Unit Sales
Month NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
SA
7318
8379
9744
10243
7312
5295
10507
5489
6654
5264
9123
6981
7015
10347
8479
8067
6623
5989
5293
7545
6647
9889
8128
6379
8295
9253
6489
8373
9604
9966
Europe
278
209
455
286
263
302
341
329
345
286
239
368
268
333
348
376
444
326
224
493
249
378
238
356
394
425
263
433
487
361
Pacific
1634
1279
1122
593
484
933
1596
629
1287
900
1357
997
1108
671
382
1956
1296
1330
862
1832
1450
1549
1002
1384
677
1161
1797
852
756
1728
China
249
285
162
343
266
288
260
279
155
224
179
154
215
316
293
154
170
171
335
238
197
173
183
181
151
203
232
279
262
322
4
46
38
34
54
54
28
1
41
52
14
50
8
24
29
36
49
46
22
36
33
5
24
27
45
0
47
52
29
32
World
9483
10198
11521
11499
8379
6872
12732
6727
8482
6726
10912
8550
8614
11691
9531
10589
8582
7862
6736
10144
8576
11994
9575
8327
9562
11042
8828
9989
11138
12409
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
6168
5489
8150
7318
7441
5168
9824
6162
10789
6033
6963
9449
7452
10564
5401
5226
5400
6898
5899
7685
8556
10284
5396
10298
5446
7637
6959
10526
8174
7724
455
349
416
383
346
381
279
284
443
437
434
317
493
486
482
247
239
407
475
364
230
277
389
267
339
262
371
354
360
239
1763
598
435
1637
1807
1518
773
918
1699
1507
1496
825
1135
996
607
1712
607
1730
1702
1558
1158
1165
762
943
893
1954
1827
460
778
1808
231
284
235
222
346
347
333
166
296
325
272
265
350
155
285
207
291
345
183
284
194
181
299
325
290
258
162
208
261
320
19
9
20
3
0
48
5
15
17
36
12
13
3
2
52
53
22
49
40
21
25
19
5
4
22
54
25
7
0
32
8636
6729
9256
9563
9940
7462
11214
7545
13244
8338
9177
10869
9433
12203
6827
7445
6559
9429
8299
9912
10163
11926
6851
11837
6990
10165
9344
11555
9573
10123
Gross Revenues Mowers
Month NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
SA
Europe
Pacific
China
World
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Tractor Unit Sales
Month NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
SA
2688
1631
1108
340
2447
773
1329
1754
2822
2142
2205
2513
2992
863
2901
493
2589
2463
900
2609
1682
2719
644
2558
1023
1900
690
1400
1500
2130
Eur
274
254
1057
877
598
970
1175
998
610
499
594
864
1027
559
835
584
821
533
417
911
320
604
672
587
397
1113
997
715
957
255
Pac
526
531
458
647
608
470
559
529
618
682
452
545
492
682
565
422
544
616
521
585
458
442
560
603
437
499
623
642
562
638
China
365
277
389
314
376
295
337
313
156
235
176
206
384
328
181
304
166
287
395
175
160
364
168
159
319
235
177
169
328
329
World
215
24
226
222
35
61
20
120
78
191
49
183
149
210
211
236
123
27
76
148
71
146
66
161
126
41
245
57
68
222
4068
2717
3238
2400
4064
2569
3420
3714
4284
3749
3476
4311
5044
2642
4693
2039
4243
3926
2309
4428
2691
4275
2110
4068
2302
3788
2732
2983
3415
3574
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
1908
1132
1768
1730
2762
1529
825
2121
810
1464
2072
392
1366
2441
2720
843
1853
2009
1820
1837
1737
1049
1138
1568
948
528
1117
2282
1386
586
769
1033
725
318
412
252
262
795
991
549
415
811
758
827
1126
861
378
1044
1032
484
324
1158
615
438
997
449
1041
744
874
797
403
460
464
561
442
614
604
496
637
526
526
439
593
582
497
674
700
452
502
662
603
514
553
487
423
639
491
512
510
670
312
286
317
313
332
161
198
314
379
315
251
184
222
175
206
389
151
382
260
374
313
247
309
242
325
249
153
341
336
347
80
207
218
226
3
189
134
134
72
125
58
152
136
153
27
136
237
107
246
91
109
230
96
41
193
150
178
24
34
71
3472
3118
3492
3148
3951
2745
2023
3860
2889
2979
3322
1978
3075
4178
4576
2903
3319
3994
3860
3448
3086
3198
2711
2776
2886
2015
2980
3903
3140
2471
Gross Revenues Tractors
Month NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
SA
Eur
Pac
China
World
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Market Share
Industry Mower Total Sales
Month
NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
SA
93326
52664
89925
67127
94998
72968
66870
80202
99818
53869
94748
52559
75934
94020
61041
91530
71666
59627
85698
50230
60223
70443
98918
56025
66524
91234
82470
83965
83201
54891
78998
69592
71314
49462
84800
100828
66956
44326
95360
Eur
442
461
315
322
329
386
336
460
409
240
194
386
199
367
309
285
95
311
405
165
210
306
300
139
405
67
74
289
157
344
413
309
94
182
239
268
172
301
370
Pac
20219
15352
18243
16613
11468
7066
10316
7172
17432
19790
16534
24725
10615
16224
22756
9013
13456
21704
26832
27413
25962
16304
13619
8287
24313
10886
10802
20401
25721
8549
26069
10389
18404
12642
25091
27486
27752
9730
9566
2011
2656
1867
1183
2773
355
2443
616
1243
2949
890
1338
1997
1079
641
1325
1122
103
1231
2144
1121
1478
711
2280
1987
2214
1128
2364
2046
1532
1151
691
2463
1017
2245
1797
1833
1136
830
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Totals
91160
75952
47450
74223
55563
91937
73219
43041
87946
99636
63685
55859
82455
66834
77324
90146
72919
73341
48050
58949
99115
4447154
126
399
192
118
465
127
290
485
320
278
166
284
267
154
391
365
397
276
244
95
137
16631
25110
26462
20723
21166
22424
8958
7454
13494
26888
9925
7968
13792
14181
12863
17779
12620
16439
16770
8297
8623
7776
984628
1783
941
808
1182
1061
1188
2417
606
1452
2055
1827
2365
2374
794
2915
2099
1662
896
2672
338
2305
93730
PLE Mower Unit Sales
China
World
212
797
923
228
959
99
314
366
248
288
363
471
336
659
106
866
101
806
724
573
628
457
663
817
385
38
690
924
323
811
43
584
648
623
88
767
49
749
442
116210
71930
111273
85473
110527
80874
80279
88816
119150
77136
112729
79479
89081
112349
84853
103019
86440
82551
114890
80525
88144
88988
114211
67548
93614
104439
95164
107943
111448
66127
106674
81565
92923
63926
112463
131146
96762
56242
106568
Month
NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
SA
7318
8379
9744
10243
7312
5295
10507
5489
6654
5264
9123
6981
7015
10347
8479
8067
6623
5989
5293
7545
6647
9889
8128
6379
8295
9253
6489
8373
9604
9966
6168
5489
8150
7318
7441
5168
9824
6162
10789
278
209
455
286
263
302
341
329
345
286
239
368
268
333
348
376
444
326
224
493
249
378
238
356
394
425
263
433
487
361
455
349
416
383
346
381
279
284
443
673
676
866
25
308
170
604
308
508
309
701
486
196
526
12
713
730
919
285
67
41
28291
118852
104430
70039
96714
79821
102380
83984
57934
117114
112203
74347
72786
99473
81171
98421
105943
92147
92202
59548
68072
109374
5570434
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Totals
6033
6963
9449
7452
10564
5401
5226
5400
6898
5899
7685
8556
10284
5396
10298
5446
7637
6959
10526
8174
7724
459169
437
434
317
493
486
482
247
239
407
475
364
230
277
389
267
339
262
371
354
360
239
20902
Market Share
Europe
Pacific
1634
1279
1122
593
484
933
1596
629
1287
900
1357
997
1108
671
382
1956
1296
1330
862
1832
1450
1549
1002
1384
677
1161
1797
852
756
1728
1763
598
435
1637
1807
1518
773
918
1699
China
249
285
162
343
266
288
260
279
155
224
179
154
215
316
293
154
170
171
335
238
197
173
183
181
151
203
232
279
262
322
231
284
235
222
346
347
333
166
296
World
4
46
38
34
54
54
28
1
41
52
14
50
8
24
29
36
49
46
22
36
33
5
24
27
45
0
47
52
29
32
19
9
20
3
0
48
5
15
17
9483
10198
11521
11499
8379
6872
12732
6727
8482
6726
10912
8550
8614
11691
9531
10589
8582
7862
6736
10144
8576
11994
9575
8327
9562
11042
8828
9989
11138
12409
8636
6729
9256
9563
9940
7462
11214
7545
13244
Month
NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
1507
1496
825
1135
996
607
1712
607
1730
1702
1558
1158
1165
762
943
893
1954
1827
460
778
1808
71375
325
272
265
350
155
285
207
291
345
183
284
194
181
299
325
290
258
162
208
261
320
14839
36
12
13
3
2
52
53
22
49
40
21
25
19
5
4
22
54
25
7
0
32
1592
8338
9177
10869
9433
12203
6827
7445
6559
9429
8299
9912
10163
11926
6851
11837
6990
10165
9344
11555
9573
10123
567877
Five Year Market Share
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Industry Tractor Total Sales
SA
Europe
Pacific
China World
Month
NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
7800
6215
8512
6415
8442
7500
6145
5882
5595
5233
4494
3913
5938
6633
7327
8077
7830
7103
6239
6036
5664
5345
4831
4454
5299
6529
7120
7619
8387
8110
7752
6894
6015
5368
4964
4444
5000
6284
7785
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Totals
9934
10645
9491
9182
8528
8293
8221
7470
6509
7267
8807
10168
11044
12120
13459
13048
12275
11347
10667
10459
10082
458206
actor Total Sales
SA
PLE Tractor Unit Sales
Eur
1025
785
1500
1458
987
1019
977
1057
1086
1045
1078
1029
1172
1273
1423
1612
1728
1815
1776
1685
1679
1618
1564
1522
1835
2115
2202
2151
2214
2278
2100
2128
2367
2211
2483
1986
2257
2353
2457
Pac
6500
4587
6910
4500
5273
5315
7170
5926
6075
6321
8381
7944
5688
7037
6981
7500
6571
6990
6667
6762
6635
6311
6476
6250
5922
6667
7228
8200
7941
7921
7677
7200
6735
6495
6061
5816
5051
6082
6327
China
987
1090
1127
1209
1221
1327
1324
1268
1209
1168
1127
1085
1185
1286
1286
1346
1388
1449
1490
1449
1394
1256
1214
1171
1208
1214
1256
1311
1415
1520
1675
1584
1527
1422
1366
1262
1373
1436
1478
World
365
16677
321
12998
215
18264
200
13782
286
16208
287
15448
289
15905
290
14422
293
14258
295
14061
298
15378
301
14272
306
14289
302
16530
303
17320
307
18842
309
17826
312
17669
315
16487
318
16250
321
15692
315
14844
318
14402
320
13716
333
14597
313
16836
606
18412
571
19852
556
20513
526
20355
513
19716
769
18575
750
17394
732
16226
714
15587
698
14207
714
14394
1063
17218
1264
19310
Month
NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
SA
2688
1631
1108
340
2447
773
1329
1754
2822
2142
2205
2513
2992
863
2901
493
2589
2463
900
2609
1682
2719
644
2558
1023
1900
690
1400
1500
2130
1908
1132
1768
1730
2762
1529
825
2121
810
274
254
1057
877
598
970
1175
998
610
499
594
864
1027
559
835
584
821
533
417
911
320
604
672
587
397
1113
997
715
957
255
769
1033
725
318
412
252
262
795
991
2517
2612
2749
2887
2833
2789
2765
2746
2534
2635
2703
2795
2997
3131
3311
3390
3277
3232
3131
3087
3030
126196
7604
7789
7347
6979
6489
6316
5833
5789
5591
5106
5474
6022
6064
6344
6593
6304
6064
5789
5699
5604
5444
386338
1512
1642
1667
1733
1700
1642
1576
1493
1450
1010
1045
1106
1150
1244
1357
1421
1263
1173
1128
974
979
79364
1333
1556
1739
1702
1915
2083
2128
2292
2245
2292
2449
2400
2353
2600
2653
2600
2549
2453
2517
2541
2453
64160
22901
24244
22993
22483
21465
21123
20523
19789
18329
18311
20477
22489
23607
25439
27374
26764
25428
23995
23142
22666
21989
1114264
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Totals
1464
2072
392
1366
2441
2720
843
1853
2009
1820
1837
1737
1049
1138
1568
948
528
1117
2282
1386
586
99549
549
415
811
758
827
1126
861
378
1044
1032
484
324
1158
615
438
997
449
1041
744
874
797
42353
Market Share
Eur
Pac
526
531
458
647
608
470
559
529
618
682
452
545
492
682
565
422
544
616
521
585
458
442
560
603
437
499
623
642
562
638
403
460
464
561
442
614
604
496
637
China
365
277
389
314
376
295
337
313
156
235
176
206
384
328
181
304
166
287
395
175
160
364
168
159
319
235
177
169
328
329
312
286
317
313
332
161
198
314
379
World
215
4068
24
2717
226
3238
222
2400
35
4064
61
2569
20
3420
120
3714
78
4284
191
3749
49
3476
183
4311
149
5044
210
2642
211
4693
236
2039
123
4243
27
3926
76
2309
148
4428
71
2691
146
4275
66
2110
161
4068
126
2302
41
3788
245
2732
57
2983
68
3415
222
3574
80
3472
207
3118
218
3492
226
3148
3
3951
189
2745
134
2023
134
3860
72
2889
Month
NA
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
SA
Europe
526
526
439
593
582
497
674
700
452
502
662
603
514
553
487
423
639
491
512
510
670
32752
315
251
184
222
175
206
389
151
382
260
374
313
247
309
242
325
249
153
341
336
347
16450
125
58
152
136
153
27
136
237
107
246
91
109
230
96
41
193
150
178
24
34
71
7664
2979
3322
1978
3075
4178
4576
2903
3319
3994
3860
3448
3086
3198
2711
2776
2886
2015
2980
3903
3140
2471
198768
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Five Year Market Share
Pacific
China
World
Case Study Assignment 1 Instructions
Read and complete the first case study from our Business Analytics eText. Your case study will require
you to demonstrate your understanding and application of business analytics concepts. You will be
asked to complete Excel functions and tasks and answer questions from the text. Your case study will be
found in Chapter 1. Some of the numbers listed in your text will be different from the file provided to
you. Use the file provided in the Content area of our course, week 3, Case Study Assignment 1 Excel
File.
Worth 50 points, your case study will explore concepts covered in Weeks 1, 2 and 3 and encourage
critical analysis. Your case study will ask for opinions and recommendations. Your claims should be
supported by evidence including references from the text, valid outside resources, or rational
arguments. Your case study should exhibit strong structure and organization. A concise introduction
with a clear preview, a well-written body using complete sentences, in-text citations when necessary
and a clear summary in the conclusion are expected.
Excel functions you will use include SUM, division, multiplication, COUNTIF, copy and pasting, Gross Sales
are overall sales unadjusted for costs, and Market Share (corporation total sales/ industry total sales).
You will also need to use filtering and sorting.
Aside from just describing the analysis, discuss your interpretation of the data. You may include images
from your analysis in the report, but images should not constitute the majority of the report. If you use a
table or image, you must spend some time discussing it within the body of the text. A good rule of
thumb is at least a paragraph of text to describe each image.
College-level writing is expected, points will be deducted for grammar and spelling errors. Include and
upload your accompanying Excel file. Your submission must be in APA format. Include a title page with
your name, case study title, and date. Your report should be at least 2 full pages, 1-inch margins 12point Times New Roman font, double-spaced. References and citations must be provided. Your
Reference List should be provided at the end of your paper. Your report should be submitted in Word
(.docx) format. Information for downloading MS Office 2016 for free is provided in the “Start Here”
module. Please refer to the Case Study Assignment tab in the Assignment Overview module for a copy of
the rubric for evaluation of your Case Study. Your submitted Excel file will be evaluated under the
Content section of the rubric.
Make sure you complete each of the tasks listed in your eText for PLE Case Study 1.
Here are some details you need to complete the file.
1. Note that any worksheets you will be working with are shaded in dark green.
2. Check your text to understand what you are being asked to do. For Dealer Satisfaction and EndUser Satistaction, start with year 2014 for first set of data you copy. The next set will be for
2015, then 2016, 2017 and 2018. This exercise will give you practice copying, pasting, and
manipulating data in spreadsheets. The areas shaded in green in the worksheet are the areas
where you will input the appropriate data, formulas, functions, etc. For example, on the “Dealer
Satisfaction” worksheet, the answer area is shaded:
3. The new worksheets referenced in numbers 3 and 4 have already been created. They are
labeled “Gross Revenues” and “Market Share”, respectively. You will need to use an absolute
cell reference when creating formulas for Gross Revenues. (Note the additional worksheets are
provided for reference.)
4. Place your name in each worksheet in cell A201 and your student number in A202 to receive
credit for your Excel worksheets for this assignment.
5. Summarize your findings and observations in your Word document report. Provide
recommendations for future decisions, supported by data from your Excel worksheets. Think
about any potential areas for growth and ways to increase profits. Reread the case study in your
text for context and ideas for areas you could address in your report.
You must submit both your Excel file and Word document to the Dropbox.
Your Case Study Assignment is to be submitted to the appropriate Dropbox by 11:59 pm CT Sunday of
Week 3.
Case Study Assignment 1 Instructions
Read and complete the first case study from our Business Analytics eText. Your case study will require
you to demonstrate your understanding and application of business analytics concepts. You will be
asked to complete Excel functions and tasks and answer questions from the text. Your case study will be
found in Chapter 1. Some of the numbers listed in your text will be different from the file provided to
you. Use the file provided in the Content area of our course, week 3, Case Study Assignment 1 Excel
File.
Worth 50 points, your case study will explore concepts covered in Weeks 1, 2 and 3 and encourage
critical analysis. Your case study will ask for opinions and recommendations. Your claims should be
supported by evidence including references from the text, valid outside resources, or rational
arguments. Your case study should exhibit strong structure and organization. A concise introduction
with a clear preview, a well-written body using complete sentences, in-text citations when necessary
and a clear summary in the conclusion are expected.
Excel functions you will use include SUM, division, multiplication, COUNTIF, copy and pasting, Gross Sales
are overall sales unadjusted for costs, and Market Share (corporation total sales/ industry total sales).
You will also need to use filtering and sorting.
Aside from just describing the analysis, discuss your interpretation of the data. You may include images
from your analysis in the report, but images should not constitute the majority of the report. If you use a
table or image, you must spend some time discussing it within the body of the text. A good rule of
thumb is at least a paragraph of text to describe each image.
College-level writing is expected, points will be deducted for grammar and spelling errors. Include and
upload your accompanying Excel file. Your submission must be in APA format. Include a title page with
your name, case study title, and date. Your report should be at least 2 full pages, 1-inch margins 12point Times New Roman font, double-spaced. References and citations must be provided. Your
Reference List should be provided at the end of your paper. Your report should be submitted in Word
(.docx) format. Information for downloading MS Office 2016 for free is provided in the “Start Here”
module. Please refer to the Case Study Assignment tab in the Assignment Overview module for a copy of
the rubric for evaluation of your Case Study. Your submitted Excel file will be evaluated under the
Content section of the rubric.
Make sure you complete each of the tasks listed in your eText for PLE Case Study 1.
Here are some details you need to complete the file.
1. Only use the given values in the workbook provided to you in the Content area of our course for
the assignment. Note that there are different values in the text for Gross Revenues. These
values are adjusted in the file to reflect new class sections.
2. Check your text to understand what you are being asked to do. For Dealer Satisfaction and EndUser Satisfaction, start with year 2014 for first set of data you copy. The next set will be for
2015, then 2016, 2017 and 2018. This exercise will give you practice copying, pasting, and
manipulating data in spreadsheets. The areas shaded in green in the worksheet are the areas
where you will input the appropriate data, formulas, functions, etc. For example, on the “Dealer
Satisfaction” worksheet, the answer area is shaded:
3. The new worksheets referenced in numbers 3 and 4 have already been created. They are
labeled “Gross Revenues” and “Market Share”, respectively. You will need to use an absolute
cell reference when creating formulas for Gross Revenues.
4. Place your name in each worksheet in cell A200 and your student number in A201 to receive
credit for your Excel worksheets for this assignment.
5. Summarize your findings and observations in your Word document report. Provide
recommendations for future decisions, supported by data from your Excel worksheets. Think
about any potential areas for growth and ways to increase profits. Reread the case study in your
text for context and ideas for areas you could address in your report.
You must submit both your Excel file and Word document to the Dropbox.
Your Case Study Assignment is to be submitted to the appropriate Dropbox by 11:59 pm CT Sunday of
Week 3.