Question
Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database. First, she would like you to
Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database. First, she would like you to edit the worksheets Dealer Satisfaction and End-User Satisfaction to display the total number of responses to each level of the survey scale across all regions for each year. Second, she wants a count of the number of failures in the worksheet Mower Test. Next, Elizabeth has provided you with prices for PLE products for the past five years:
Year Mower Price ($) Tractor Price ($)
2010 150 3,250
2011 175 3,400
2012 180 3,600
2013 185 3,700
2014 190 3,800
Create a new worksheet in the database to compute gross revenues by month and region, as well as worldwide totals, for each product using the data in Mower Unit Sales and Tractor Unit Sales. Finally, she wants to know the market share for each product and region based on the PLE and industry sales data in the database. Summarize all your findings in a report to Ms. Burke
Dealer Satisfaction
Survey Scale: 0 1 2 3 4 5 Sample
North America Size Region Year 0 1 2 3 4 5
2014 1 0 2 14 22 11 50 North America 2014 1 0 2 14 22 11
2015 0 0 2 14 20 14 50 South America 2014 0 0 0 2 6 2
2016 1 1 1 8 34 15 60 Europe 2014 0 0 1 3 7 4
2017 1 2 6 12 34 45 100 Pacific Rim 2014 0 0 1 2 2 0
2018 2 3 5 15 44 56 125 Totals 1 0 4 21 37 17
North America 2015 0 0 2 14 20 14
South America South America 2015 0 0 0 2 6 2
2014 0 0 0 2 6 2 10 Europe 2015 0 0 1 2 8 4
2015 0 0 0 2 6 2 10 Pacific Rim 2015 0 0 1 1 3 0
2016 0 0 1 4 11 14 30 Totals 0 0 4 19 37 20
2017 0 1 1 3 12 33 50 North America 2016 1 1 1 8 34 15
2018 1 1 2 4 22 60 90 South America 2016 0 0 1 4 11 14
Europe 2016 0 0 1 2 15 7
Europe Pacific Rim 2016 0 0 1 1 3 1
2014 0 0 1 3 7 4 15 China 2016 0 0 0 1 0 0
2015 0 0 1 2 8 4 15 Totals 1 1 4 16 63 37
2016 0 0 1 2 15 7 25 North America 2017 1 2 6 12 34 45
2017 0 0 1 2 21 6 30 South America 2017 0 1 1 3 12 33
2018 0 0 1 4 17 8 30 Europe 2017 0 0 1 2 21 6
Pacific Rim 2017 0 0 0 2 5 3
Pacific Rim China 2017 0 0 1 4 2 0
2014 0 0 1 2 2 0 5 Totals 1 3 9 23 74 87
2015 0 0 1 1 3 0 5 North America 2018 2 3 5 15 44 56
2016 0 0 1 1 3 1 6 South America 2018 1 1 2 4 22 60
2017 0 0 0 2 5 3 10 Europe 2018 0 0 1 4 17 8
Dealer Satisfaction
Survey Scale: -0.163268489 -0.212506335 0.31753148 -0.507387626 4.288448793 2.345951425 Sample
North America -0.196717477 -0.260340727 0.232154692 -0.905032942 3.529492028 1.468402791 Size Region Year -0.1 -0.4 0.3 0.9 2.5 -0.7
2019 -0.230166465 -0.30817512 0.146777903 -1.302678258 2.770535262 0.590854158 1.66714748 North America 2014 -0.2 -0.6 -2.22045E-16 -0.4 0.6 -2.4
2020 -0.263615454 -0.356009512 0.061401115 -1.700323574 2.011578496 -0.286694476 -0.533663405 South America 2014 -0.3 -0.8 -0.3 -1.7 -1.3 -4.1
End-User Satisfaction
Survey Scale: 0 1 2 3 4 5 Sample
North America 0 1 2 3 4 5 Size Region Year 0 1 2 3 4 5
2014 1 3 6 15 37 38 100 North America 2014 1 3 6 15 37 38
2015 1 2 4 18 35 40 100 South America 2014 1 2 5 18 36 38
2016 1 2 5 17 34 41 100 Europe 2014 1 2 4 21 36 36
2017 0 2 4 15 33 46 100 Pacific Rim 2014 2 3 5 15 41 34
2018 0 2 3 15 31 49 100 Totals 5 10 20 69 150 146
North America 2015 1 2 4 18 35 40
South America South America 2015 1 3 6 17 36 37
2014 1 2 5 18 36 38 100 Europe 2015 1 2 5 21 34 37
2015 1 3 6 17 36 37 100 Pacific Rim 2015 1 2 7 15 41 34
2016 0 2 6 19 37 36 100 Totals 4 9 22 71 146 148
2017 0 2 5 20 37 36 100 North America 2016 1 2 5 17 34 41
2018 0 2 5 19 37 37 100 South America 2016 0 2 6 19 37 36
Europe 2016 1 1 4 26 37 31
Europe Pacific Rim 2016 1 2 5 16 40 36
2014 1 2 4 21 36 36 100 China 2016 0 3 3 6 28 10
2015 1 2 5 21 34 37 100 Totals 3 10 23 84 176 154
2016 1 1 4 26 37 31 100 North America 2017 0 2 4 15 33 46
2017 1 1 3 17 41 37 100 South America 2017 0 2 5 20 37 36
2018 0 1 2 19 45 33 100 Europe 2017 1 1 3 17 41 37
Pacific Rim 2017 0 2 4 17 40 37
Pacific Rim China 2017 1 2 2 4 30 11
2014 2 3 5 15 41 34 100 Totals 2 9 18 73 181 167
2015 1 2 7 15 41 34 100 North America 2018 0 2 3 15 31 49
2016 1 2 5 16 40 36 100 South America 2018 0 2 5 19 37 37
2017 0 2 4 17 40 37 100 Europe 2018 0 1 2 19 45 33
2018 0 1 3 19 42 35 100 Pacific Rim 2018 0 1 3 19 42 35
China 2018 0 1 1 3 31 14
China Totals 0 7 14 75 186 168
2016 0 3 3 6 28 10 50
2017 1 2 2 4 30 11 50
2018 0 1 1 3 31 14 50
Mower Test Functional Performance Number of failures 54
Sample
Observation 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
1 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
2 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
3 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
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
5 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
6 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass 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
8 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
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
10 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
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
12 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
13 Pass Pass Pass Pass Pass 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
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
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
16 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
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
18 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
19 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass 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
21 Pass Pass Pass Pass Pass Fail Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Fail Pass Pass Pass Pass Pass Pass Pass Pass Pass
22 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Fail Pass Pass Pass Pass Pass Pass Fail 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
24 Pass Pass Pass Pass Pass Pass 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
26 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
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
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
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
30 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
31 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
32 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
33 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
34 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
35 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
36 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
37 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
38 Pass Pass Pass Pass Pass Pass 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 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
40 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
41 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
42 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
43 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
44 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
45 Pass Pass 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 Pass Pass
46 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
47 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
48 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
49 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
50 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
51 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
52 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
53 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
54 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
55 Pass Pass 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
56 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
57 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
58 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
59 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
60 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
61 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
62 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
63 Pass Pass Pass Pass Pass 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
64 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
65 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
66 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
67 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
68 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
69 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
70 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
71 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
72 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
73 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
74 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
75 Pass Pass Fail 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
76 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
77 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
78 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
79 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
80 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
81 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
82 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
83 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
84 Pass Pass Pass Pass Pass Pass 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 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
86 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
87 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
88 Pass Pass 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
89 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
90 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
91 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
92 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
93 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
94 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
95 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
96 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
97 Pass Pass Pass Pass Pass Fail Pass Pass Pass Fail Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
98 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
99 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
100 Pass Pass Pass 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
Gross Revenues
Prices for PLE products for the past 5 years:
Year Mower Price Tractor Price
2014 $150 $3,250
2015 $175 $3,400
2016 $180 $3,600
2017 $185 $3,700
2018 $190 $3,800
Mower Unit Sales Tractor Unit Sales
Month NA SA Europe Pacific China World Month NA SA Eur Pac China World
Jan-14 6000 200 720 100 0 7020 Jan-14 570 250 560 212 0 1592
Feb-14 7950 220 990 120 0 9280 Feb-14 611 270 600 230 0 1711
Mar-14 8100 250 1320 110 0 9780 Mar-14 630 260 680 240 0 1810
Apr-14 9050 280 1650 120 0 11100 Apr-14 684 270 650 263 0 1867
May-14 9900 310 1590 130 0 11930 May-14 650 280 580 269 0 1779
Jun-14 10200 300 1620 120 0 12240 Jun-14 600 270 590 280 0 1740
Jul-14 8730 280 1590 140 0 10740 Jul-14 512 264 760 290 0 1826
Aug-14 8140 250 1560 130 0 10080 Aug-14 500 280 645 270 0 1695
Sep-14 6480 230 1590 130 0 8430 Sep-14 478 290 650 263 0 1681
Oct-14 5990 220 1320 120 0 7650 Oct-14 455 280 670 258 0 1663
Nov-14 5320 210 990 130 0 6650 Nov-14 407 290 888 240 0 1825
Dec-14 4640 180 660 140 0 5620 Dec-14 360 280 850 230 0 1720
Jan-15 5980 210 690 140 0 7020 Jan-15 571 320 620 250 0 1761
Feb-15 7620 240 1020 150 0 9030 Feb-15 650 350 760 275 0 2035
Mar-15 8370 250 1290 140 0 10050 Mar-15 740 390 742 270 0 2142
Apr-15 8830 290 1620 150 0 10890 Apr-15 840 440 780 280 0 2340
May-15 9310 330 1650 130 0 11420 May-15 830 470 690 290 0 2280
Jun-15 10230 310 1590 140 0 12270 Jun-15 760 490 721 300 0 2271
Jul-15 8720 290 1560 150 0 10720 Jul-15 681 481 680 312 0 2154
Aug-15 7710 270 1530 140 0 9650 Aug-15 670 460 711 305 0 2146
Sep-15 6320 250 1590 150 0 8310 Sep-15 640 460 695 290 0 2085
Oct-15 5840 250 1260 160 0 7510 Oct-15 620 440 650 260 0 1970
Nov-15 4960 240 900 150 0 6250 Nov-15 570 436 680 250 0 1936
Dec-15 4350 210 660 150 0 5370 Dec-15 533 420 657 240 0 1850
Jan-16 6020 220 570 160 0 6970 Jan-16 620 510 610 250 10 2000
Feb-16 7920 250 840 150 0 9160 Feb-16 792 590 680 250 12 2324
Mar-16 8430 270 1110 160 0 9970 Mar-16 890 610 730 260 20 2510
Apr-16 9040 310 1500 170 0 11020 Apr-16 960 600 820 270 22 2672
May-16 9820 360 1440 160 0 11780 May-16 1040 620 810 290 20 2780
Jun-16 10370 330 1410 170 0 12280 Jun-16 1032 640 807 310 24 2813
Jul-16 9050 310 1440 160 0 10960 Jul-16 1006 590 760 340 20 2716
Aug-16 7620 300 1410 170 0 9500 Aug-16 910 600 720 320 31 2581
Sep-16 6420 280 1350 180 0 8230 Sep-16 803 670 660 313 30 2476
Oct-16 5890 270 1080 180 0 7420 Oct-16 730 630 630 290 37 2317
Nov-16 5340 260 840 190 0 6630 Nov-16 699 710 603 280 32 2324
Dec-16 4430 230 510 180 0 5350 Dec-16 647 570 570 260 33 2080
Jan-17 6100 250 480 200 0 7030 Jan-17 730 650 500 287 35 2202
Feb-17 8010 270 750 190 0 9220 Feb-17 930 680 590 290 50 2540
Mar-17 8430 280 1140 200 0 10050 Mar-17 1160 724 620 300 63 2867
Apr-17 9110 320 1410 210 0 11050 Apr-17 1510 730 730 310 68 3348
May-17 9730 380 1340 190 0 11640 May-17 1650 760 740 330 70 3550
Jun-17 10120 360 1360 200 0 12040 Jun-17 1490 800 720 340 82 3432
Jul-17 9080 320 1410 200 0 11010 Jul-17 1460 840 670 350 80 3400
Aug-17 7820 310 1490 210 0 9830 Aug-17 1390 830 610 341 90 3261
Sep-17 6540 300 1310 220 0 8370 Sep-17 1360 820 599 330 100 3209
Oct-17 6010 290 980 210 0 7490 Oct-17 1340 810 560 320 102 3132
Nov-17 5270 270 770 220 0 6530 Nov-17 1240 827 550 300 110 3027
Dec-17 5380 260 430 230 0 6300 Dec-17 1103 750 520 290 114 2777
Jan-18 6210 270 400 200 0 7080 Jan-18 1250 780 480 200 111 2821
Feb-18 8030 280 750 190 0 9250 Feb-18 1550 805 523 210 121 3209
Mar-18 8540 300 970 210 5 10025 Mar-18 1820 830 560 220 123 3553
Apr-18 9120 340 1310 220 16 11006 Apr-18 2010 890 570 230 120 3820
May-18 9570 390 1260 200 22 11442 May-18 2230 930 590 253 130 4133
Jun-18 10230 380 1240 210 26 12086 Jun-18 2490 980 600 270 136 4476
Jul-18 9580 350 1300 230 14 11474 Jul-18 2440 1002 580 280 134 4436
Aug-18 7680 340 1250 220 15 9505 Aug-18 2334 970 570 250 132 4256
Sep-18 6870 320 1210 220 11 8631 Sep-18 2190 960 550 230 137 4067
Oct-18 5930 310 970 230 3 7443 Oct-18 2080 930 530 220 130 3890
Nov-18 5260 300 650 240 1 6451 Nov-18 2050 920 517 190 139 3816
Dec-18 4830 290 300 230 0 5650 Dec-18 2004 902 490 190 131 3717
Gross Revenues Mowers Gross Revenues Tractors
Month NA SA Europe Pacific China World Month NA SA Eur Pac China World
Jan-14 $900,000 $30,000 $108,000 $15,000 $0 $1,053,000 Jan-14 $1,852,500 $812,500 $1,820,000 $689,000 $0 $5,174,000
Feb-14 $1,192,500 $33,000 $148,500 $18,000 $0 $1,392,000 Feb-14 $1,985,750 $877,500 $1,950,000 $747,500 $0 $5,560,750
Mar-14 $1,215,000 $37,500 $198,000 $16,500 $0 $1,467,000 Mar-14 $2,047,500 $845,000 $2,210,000 $780,000 $0 $5,882,500
Apr-14 $1,357,500 $42,000 $247,500 $18,000 $0 $1,665,000 Apr-14 $2,223,000 $877,500 $2,112,500 $854,750 $0 $6,067,750
May-14 $1,485,000 $46,500 $238,500 $19,500 $0 $1,789,500 May-14 $2,112,500 $910,000 $1,885,000 $874,250 $0 $5,781,750
Jun-14 $1,530,000 $45,000 $243,000 $18,000 $0 $1,836,000 Jun-14 $1,950,000 $877,500 $1,917,500 $910,000 $0 $5,655,000
Jul-14 $1,309,500 $42,000 $238,500 $21,000 $0 $1,611,000 Jul-14 $1,664,000 $858,000 $2,470,000 $942,500 $0 $5,934,500
Aug-14 $1,221,000 $37,500 $234,000 $19,500 $0 $1,512,000 Aug-14 $1,625,000 $910,000 $2,096,250 $877,500 $0 $5,508,750
Sep-14 $972,000 $34,500 $238,500 $19,500 $0 $1,264,500 Sep-14 $1,553,500 $942,500 $2,112,500 $854,750 $0 $5,463,250
Oct-14 $898,500 $33,000 $198,000 $18,000 $0 $1,147,500 Oct-14 $1,478,750 $910,000 $2,177,500 $838,500 $0 $5,404,750
Nov-14 $798,000 $31,500 $148,500 $19,500 $0 $997,500 Nov-14 $1,322,750 $942,500 $2,886,000 $780,000 $0 $5,931,250
Dec-14 $696,000 $27,000 $99,000 $21,000 $0 $843,000 Dec-14 $1,170,000 $910,000 $2,762,500 $747,500 $0 $5,590,000
Jan-15 $1,046,500 $36,750 $120,750 $24,500 $0 $1,053,000 Jan-15 $1,941,400 $1,088,000 $2,108,000 $850,000 $0 $5,987,400
Feb-15 $1,333,500 $42,000 $178,500 $26,250 $0 $1,354,500 Feb-15 $2,210,000 $1,190,000 $2,584,000 $935,000 $0 $6,919,000
Mar-15 $1,464,750 $43,750 $225,750 $24,500 $0 $1,507,500 Mar-15 $2,516,000 $1,326,000 $2,522,800 $918,000 $0 $7,282,800
Apr-15 $1,545,250 $50,750 $283,500 $26,250 $0 $1,633,500 Apr-15 $2,856,000 $1,496,000 $2,652,000 $952,000 $0 $7,956,000
May-15 $1,629,250 $57,750 $288,750 $22,750 $0 $1,713,000 May-15 $2,822,000 $1,598,000 $2,346,000 $986,000 $0 $7,752,000
Jun-15 $1,790,250 $54,250 $278,250 $24,500 $0 $1,840,500 Jun-15 $2,584,000 $1,666,000 $2,451,400 $1,020,000 $0 $7,721,400
Jul-15 $1,526,000 $50,750 $273,000 $26,250 $0 $1,608,000 Jul-15 $2,315,400 $1,635,400 $2,312,000 $1,060,800 $0 $7,323,600
Aug-15 $1,349,250 $47,250 $267,750 $24,500 $0 $1,447,500 Aug-15 $2,278,000 $1,564,000 $2,417,400 $1,037,000 $0 $7,296,400
Sep-15 $1,106,000 $43,750 $278,250 $26,250 $0 $1,246,500 Sep-15 $2,176,000 $1,564,000 $2,363,000 $986,000 $0 $7,089,000
Oct-15 $1,022,000 $43,750 $220,500 $28,000 $0 $1,126,500 Oct-15 $2,108,000 $1,496,000 $2,210,000 $884,000 $0 $6,698,000
Nov-15 $868,000 $42,000 $157,500 $26,250 $0 $937,500 Nov-15 $1,938,000 $1,482,400 $2,312,000 $850,000 $0 $6,582,400
Dec-15 $761,250 $36,750 $115,500 $26,250 $0 $805,500 Dec-15 $1,812,200 $1,428,000 $2,233,800 $816,000 $0 $6,290,000
Jan-16 $1,083,600 $39,600 $102,600 $28,800 $0 $1,045,500 Jan-16 $2,232,000 $1,836,000 $2,196,000 $900,000 $36,000 $7,200,000
Feb-16 $1,425,600 $45,000 $151,200 $27,000 $0 $1,374,000 Feb-16 $2,851,200 $2,124,000 $2,448,000 $900,000 $43,200 $8,366,400
Mar-16 $1,517,400 $48,600 $199,800 $28,800 $0 $1,495,500 Mar-16 $3,204,000 $2,196,000 $2,628,000 $936,000 $72,000 $9,036,000
Apr-16 $1,627,200 $55,800 $270,000 $30,600 $0 $1,653,000 Apr-16 $3,456,000 $2,160,000 $2,952,000 $972,000 $79,200 $9,619,200
May-16 $1,767,600 $64,800 $259,200 $28,800 $0 $1,767,000 May-16 $3,744,000 $2,232,000 $2,916,000 $1,044,000 $72,000 $10,008,000
Jun-16 $1,866,600 $59,400 $253,800 $30,600 $0 $1,842,000 Jun-16 $3,715,200 $2,304,000 $2,905,200 $1,116,000 $86,400 $10,126,800
Jul-16 $1,629,000 $55,800 $259,200 $28,800 $0 $1,644,000 Jul-16 $3,621,600 $2,124,000 $2,736,000 $1,224,000 $72,000 $9,777,600
Aug-16 $1,371,600 $54,000 $253,800 $30,600 $0 $1,425,000 Aug-16 $3,276,000 $2,160,000 $2,592,000 $1,152,000 $111,600 $9,291,600
Sep-16 $1,155,600 $50,400 $243,000 $32,400 $0 $1,234,500 Sep-16 $2,890,800 $2,412,000 $2,376,000 $1,126,800 $108,000 $8,913,600
Oct-16 $1,060,200 $48,600 $194,400 $32,400 $0 $1,113,000 Oct-16 $2,628,000 $2,268,000 $2,268,000 $1,044,000 $133,200 $8,341,200
Nov-16 $961,200 $46,800 $151,200 $34,200 $0 $994,500 Nov-16 $2,516,400 $2,556,000 $2,170,800 $1,008,000 $115,200 $8,366,400
Dec-16 $797,400 $41,400 $91,800 $32,400 $0 $802,500 Dec-16 $2,329,200 $2,052,000 $2,052,000 $936,000 $118,800 $7,488,000
Jan-17 $1,128,500 $46,250 $88,800 $37,000 $0 $1,054,500 Jan-17 $2,701,000 $2,405,000 $1,850,000 $1,061,900 $129,500 $8,147,400
Feb-17 $1,481,850 $49,950 $138,750 $35,150 $0 $1,383,000 Feb-17 $3,441,000 $2,516,000 $2,183,000 $1,073,000 $185,000 $9,398,000
Mar-17 $1,559,550 $51,800 $210,900 $37,000 $0 $1,507,500 Mar-17 $4,292,000 $2,678,800 $2,294,000 $1,110,000 $233,100 $10,607,900
Apr-17 $1,685,350 $59,200 $260,850 $38,850 $0 $1,657,500 Apr-17 $5,587,000 $2,701,000 $2,701,000 $1,147,000 $251,600 $12,387,600
May-17 $1,800,050 $70,300 $247,900 $35,150 $0 $1,746,000 May-17 $6,105,000 $2,812,000 $2,738,000 $1,221,000 $259,000 $13,135,000
Jun-17 $1,872,200 $66,600 $251,600 $37,000 $0 $1,806,000 Jun-17 $5,513,000 $2,960,000 $2,664,000 $1,258,000 $303,400 $12,698,400
Jul-17 $1,679,800 $59,200 $260,850 $37,000 $0 $1,651,500 Jul-17 $5,402,000 $3,108,000 $2,479,000 $1,295,000 $296,000 $12,580,000
Aug-17 $1,446,700 $57,350 $275,650 $38,850 $0 $1,474,500 Aug-17 $5,143,000 $3,071,000 $2,257,000 $1,261,700 $333,000 $12,065,700
Sep-17 $1,209,900 $55,500 $242,350 $40,700 $0 $1,255,500 Sep-17 $5,032,000 $3,034,000 $2,216,300 $1,221,000 $370,000 $11,873,300
Oct-17 $1,111,850 $53,650 $181,300 $38,850 $0 $1,123,500 Oct-17 $4,958,000 $2,997,000 $2,072,000 $1,184,000 $377,400 $11,588,400
Nov-17 $974,950 $49,950 $142,450 $40,700 $0 $979,500 Nov-17 $4,588,000 $3,059,900 $2,035,000 $1,110,000 $407,000 $11,199,900
Dec-17 $995,300 $48,100 $79,550 $42,550 $0 $945,000 Dec-17 $4,081,100 $2,775,000 $1,924,000 $1,073,000 $421,800 $10,274,900
Jan-18 $1,179,900 $51,300 $76,000 $38,000 $0 $1,062,000 Jan-18 $4,750,000 $2,964,000 $1,824,000 $760,000 $421,800 $10,719,800
Feb-18 $1,525,700 $53,200 $142,500 $36,100 $0 $1,387,500 Feb-18 $5,890,000 $3,059,000 $1,987,400 $798,000 $459,800 $12,194,200
Mar-18 $1,622,600 $57,000 $184,300 $39,900 $950 $1,503,750 Mar-18 $6,916,000 $3,154,000 $2,128,000 $836,000 $467,400 $13,501,400
Apr-18 $1,732,800 $64,600 $248,900 $41,800 $3,040 $1,650,900 Apr-18 $7,638,000 $3,382,000 $2,166,000 $874,000 $456,000 $14,516,000
May-18 $1,818,300 $74,100 $239,400 $38,000 $4,180 $1,716,300 May-18 $8,474,000 $3,534,000 $2,242,000 $961,400 $494,000 $15,705,400
Jun-18 $1,943,700 $72,200 $235,600 $39,900 $4,940 $1,812,900 Jun-18 $9,462,000 $3,724,000 $2,280,000 $1,026,000 $516,800 $17,008,800
Jul-18 $1,820,200 $66,500 $247,000 $43,700 $2,660 $1,721,100 Jul-18 $9,272,000 $3,807,600 $2,204,000 $1,064,000 $509,200 $16,856,800
Aug-18 $1,459,200 $64,600 $237,500 $41,800 $2,850 $1,425,750 Aug-18 $8,869,200 $3,686,000 $2,166,000 $950,000 $501,600 $16,172,800
Sep-18 $1,305,300 $60,800 $229,900 $41,800 $2,090 $1,294,650 Sep-18 $8,322,000 $3,648,000 $2,090,000 $874,000 $520,600 $15,454,600
Oct-18 $1,126,700 $58,900 $184,300 $43,700 $570 $1,116,450 Oct-18 $7,904,000 $3,534,000 $2,014,000 $836,000 $494,000 $14,782,000
Nov-18 $999,400 $57,000 $123,500 $45,600 $190 $967,650 Nov-18 $7,790,000 $3,496,000 $1,964,600 $722,000 $528,200 $14,500,800
Dec-18 $917,700 $55,100 $57,000 $43,700 $0 $847,500 Dec-18 $7,615,200 $3,427,600 $1,862,000 $722,000 $497,800 $14,124,600
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started