Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra With Applications

Authors: Gareth Williams

7th Edition

0763790923, 9780763790929

More Books

Students also viewed these Mathematics questions