Due in 24 hours.
You will 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.
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 12-point Times New Roman font, double-spaced. References and citations if sources are used must be provided on a separate page. Your report should be submitted in Word ( x) 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 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 End-User 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 A200 and your student number in A201 to receive credit for your Excel worksheets for this assignment.
5. Summarize your findings 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.
>Overview
accompanying spreadsheets provide the analysis.
2 0 1 2 3 4 5 1 0 2 North America 0 0 2 14 20 14 1 1 1 15 ope
1 2 6 0
ific
Rim
2 3 5 15 0 0 4 2 6 2 14 0 0 0 2 6 2 10 Rim 0 1 1 4 11 14 Totals 0 1 1 3 12 50 North America 1 1 2 4 22 0
South America 0 0 1 3 20 6 South America Europe This exercise gives students practice at copying, pasting, and manipulating data in spreadsheets. North America South America Europe 100 Pacific Rim 100 Totals North America Europe 100 Pacific Rim 37 36 100 Totals Europe Europe Pacific Rim 36 36 China 37 31 100 North America Pacific Rim 35 100 Pacific Rim China 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 25 26 30 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass 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 Pass Pass Pass Pass Pass Pass Pass 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 Fail 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 Pass Pass Pass Pass 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 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 Fail Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Fail Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass 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 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 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass 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 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 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass 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 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 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass 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 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 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 Fail 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 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 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 Fail 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 Pass Pass 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 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 Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Europe Pacific China Month NA SA Eur Pac China World 100 0 5
Jan-14 250 0 0 Feb-14 0 0
250 0 Mar-14 0 280 120 0 0
0
Apr-14 270 650 0 0 May-14 650 280 0 0
300 120 0 40
Jun-14 600 270 590 280 0 280 0 Jul-14 0 250 130 0 Aug-14 280 270 0 230 1590 130 0 Sep-14 290 650 263 0 0
220 0 120 0 Oct-14 280 0 990 130 0 Nov-14 290 240 0 140 0 Dec-14 280 850 230 0 210 140 0 Jan-15 320 620 250 0 240 1020 0 Feb-15 650 760 0 250 140 0 Mar-15 740 270 0 290 150 0 Apr-15 780 280 0 130 0 May-15 830 690 290 0 310 1590 140 0 Jun-15 760 300 0 290 1560 150 0 Jul-15 681 680 0 4
270 140 0 Aug-15 670 711 0 250 1590 150 0 Sep-15 640 460 695 290 0 250 0 Oct-15 620 440 650 260 0 240 900 150 0 0
Nov-15 570 680 250 0 210 660 150 0 0
Dec-15 420 657 240 0 220 570 160 0 Jan-16 620 510 250 10 0
250 840 150 0 Feb-16 792 590 680 250 12 270 160 0 Mar-16 890 610 730 260 20 310 170 0 Apr-16 960 600 270 22 360 160 0 May-16 620 810 290 20 330 170 0 Jun-16 640 310 24 9050 310 1440 160 0 Jul-16 590 760 340 20 7620 300 1410 170 0 Aug-16 600 720 320 31 280 180 0 Sep-16 670 660 30 270 180 0 Oct-16 730 630 630 290 37 260 840 0 Nov-16 710 280 32 2324 230 510 180 0 Dec-16 570 570 260 33 250 480 200 0 Jan-17 730 650 500 35 270 190 0 Feb-17 930 680 590 290 50 8430 280 0
200 0 10050 Mar-17 620 300 63 7
320 1410 210 0 Apr-17 730 730 310 68 0
190 0 May-17 1650 760 740 330 70 360 0
200 0 Jun-17 720 340 82 320 1410 200 0 Jul-17 840 670 350 80 310 1490 210 0 Aug-17 0
830 610 90 300 0
220 0 8370 Sep-17 820 599 330 100 290 980 210 0 Oct-17 810 560 320 102 270 220 0 Nov-17 550 300 110 7
260 430 230 0 Dec-17 750 290 114 270 400 200 0 Jan-18 780 480 200 111 280 750 190 0 Feb-18 210 3209 300 970 210 5 5
Mar-18 830 560 220 340 220 16 Apr-18 890 570 230 120 390 1260 200 22 May-18 930 590 130 10230 380 1240 210 26 6
Jun-18 980 600 270 136 350 230 14 Jul-18 1002 580 280 134 340 1250 220 15 Aug-18 970 570 250 132 320 220 11 Sep-18 960 550 230 310 970 230 3 Oct-18 2080 930 530 220 130 0
300 650 240 1 Nov-18 190 139 290 300 230 0 Dec-18 490 190 131 Month NA SA Europe Pacific China World Month NA SA Eur Pac China World Market Share Market Share 581 0 Jan-14 200 720 100 0 7020 Jan-14 Jan-14 7
Jan-14 570 250 560 212 0 1592 Jan-14 630 0 5
Feb-14 7950 220 990 120 0 Feb-14 Feb-14 Feb-14 611 270 600 230 0 Feb-14 0
1300 0 9
Mar-14 250 110 0 Mar-14 Mar-14 1500 215 Mar-14 630 260 680 240 0 1810 Mar-14 0 1
Apr-14 9050 280 1650 120 0 Apr-14 Apr-14 200 Apr-14 684 270 650 263 0 1867 Apr-14 5
0 10
May-14 310 1590 130 0 0
May-14 May-14 987 286 May-14 650 280 580 269 0 1779 May-14 0 Jun-14 300 1620 120 0 12240 Jun-14 Jun-14 287 Jun-14 600 270 590 280 0 Jun-14 0 Jul-14 280 1590 140 0 10740 Jul-14 Jul-14 Jul-14 512 264 760 290 0 1826 Jul-14 0 Aug-14 8140 250 1560 130 0 10080 Aug-14 Aug-14 290 Aug-14 500 280 645 270 0 Aug-14 0
657 0 Sep-14 6480 230 1590 130 0 8430 Sep-14 Sep-14 1209 Sep-14 478 290 650 263 0 Sep-14 595 0 Oct-14 220 1320 120 0 7650 Oct-14 Oct-14 Oct-14 455 280 670 258 0 1663 Oct-14 553 1262 0 Nov-14 5320 210 990 130 0 6650 Nov-14 Nov-14 1
1127 Nov-14 407 290 888 240 0 1825 Nov-14 0 Dec-14 180 660 140 0 5620 Dec-14 Dec-14 Dec-14 360 280 850 230 0 1720 Dec-14 553 0 Jan-15 210 690 140 0 7020 Jan-15 Jan-15 Jan-15 571 320 620 250 0 1761 Jan-15 0 Feb-15 7620 240 1020 150 0 9030 Feb-15 Feb-15 302 Feb-15 650 350 760 275 0 2035 Feb-15 658 0 Mar-15 8370 250 1290 140 0 10050 Mar-15 Mar-15 7
1
1286 Mar-15 740 390 742 270 0 2142 Mar-15 1442 0 Apr-15 290 1620 150 0 Apr-15 Apr-15 7500 307 Apr-15 840 440 780 280 0 Apr-15 1215 0 May-15 9310 330 1650 130 0 May-15 May-15 May-15 830 470 690 290 0 2280 May-15 838 0 Jun-15 10230 310 1590 140 0 12270 Jun-15 Jun-15 312 Jun-15 760 490 721 300 0 2271 Jun-15 0 Jul-15 8720 290 1560 150 0 10720 Jul-15 Jul-15 1490 315 Jul-15 681 481 680 312 0 Jul-15 0 Aug-15 270 140 0 9650 Aug-15 Aug-15 1449 Aug-15 670 460 711 305 0 2146 Aug-15 625 29444 0 Sep-15 6320 250 1590 150 0 8310 Sep-15 Sep-15 9
321 Sep-15 640 460 695 290 0 2085 Sep-15 19
610 0 Oct-15 5840 250 1260 160 0 Oct-15 Oct-15 315 Oct-15 620 440 650 260 0 Oct-15 571 0 Nov-15 240 900 150 0 6250 Nov-15 Nov-15 318 Nov-15 570 436 680 250 0 1936 Nov-15 512 0 Dec-15 4350 210 660 150 0 5370 Dec-15 Dec-15 6250 320 Dec-15 533 420 657 240 0 1850 Dec-15 537 0 Jan-16 6020 220 570 160 0 6970 Jan-16 Jan-16 1208 333 Jan-16 620 510 610 250 10 2000 Jan-16 595 3
1402 0 7
Feb-16 250 840 150 0 9160 Feb-16 Feb-16 6667 1214 313 Feb-16 792 590 680 250 12 2324 Feb-16 0 Mar-16 8430 270 1110 160 0 9970 Mar-16 Mar-16 2202 1256 Mar-16 890 610 730 260 20 2510 Mar-16 0 Apr-16 9040 310 1500 170 0 11020 Apr-16 Apr-16 571 Apr-16 960 600 820 270 22 2672 Apr-16 1468 0 May-16 9820 360 1440 160 0 11780 May-16 May-16 1415 556 May-16 1040 620 810 290 20 2780 May-16 825 1560 0 Jun-16 10370 330 1410 170 0 12280 Jun-16 Jun-16 526 Jun-16 1032 640 807 310 24 2813 Jun-16 0 216
Jul-16 9050 310 1440 160 0 10960 Jul-16 Jul-16 2100 513 Jul-16 1006 590 760 340 20 2716 Jul-16 9
0 Aug-16 7620 300 1410 170 0 9500 Aug-16 Aug-16 769 Aug-16 910 600 720 320 31 Aug-16 651 1667 0 Sep-16 6420 280 1350 180 0 8230 Sep-16 Sep-16 1527 750 4
Sep-16 803 670 660 313 30 2476 Sep-16 0 Oct-16 5890 270 1080 180 0 7420 Oct-16 Oct-16 732 Oct-16 730 630 630 290 37 2317 Oct-16 848 1810 0 Nov-16 5340 260 840 190 0 6630 Nov-16 Nov-16 714 Nov-16 699 710 603 280 32 2324 Nov-16 735 0 Dec-16 4430 230 510 180 0 5350 Dec-16 Dec-16 4444 1262 698 Dec-16 647 570 570 260 33 2080 Dec-16 657 1887 0 Jan-17 6100 250 480 200 0 7030 Jan-17 Jan-17 5000 1373 714 Jan-17 730 650 500 287 35 2202 Jan-17 595 1845 0 Feb-17 8010 270 750 190 0 9220 Feb-17 Feb-17 2
Feb-17 930 680 590 290 50 2540 Feb-17 553 0 Mar-17 8430 280 200 0 10050 Mar-17 Mar-17 Mar-17 1160 724 620 300 63 Mar-17 462 25179 132 Apr-17 9110 320 1410 210 0 11050 Apr-17 Apr-17 2517 Apr-17 1510 730 730 310 68 3348 Apr-17 553 1810 167 May-17 9730 380 1340 190 0 11640 May-17 May-17 May-17 1650 760 740 330 70 May-17 615 150 Jun-17 10120 360 1360 200 0 12040 Jun-17 Jun-17 9491 1667 1739 Jun-17 1490 800 720 340 82 3432 Jun-17 658 24737 230 Jul-17 9080 320 1410 200 0 11010 Jul-17 Jul-17 Jul-17 1460 840 670 350 80 Jul-17 784 2000 122 Aug-17 7820 310 1490 210 0 9830 Aug-17 Aug-17 Aug-17 830 610 341 90 3261 Aug-17 625 56 Sep-17 6540 300 1310 220 0 8370 Sep-17 Sep-17 2789 1642 Sep-17 1360 820 599 330 100 3209 Sep-17 8
617 10 Oct-17 6010 290 980 210 0 7490 Oct-17 Oct-17 2128 Oct-17 1340 810 560 320 102 3132 Oct-17 587 0 Nov-17 5270 270 770 220 0 6530 Nov-17 Nov-17 Nov-17 1240 827 550 300 110 3027 Nov-17 0 Dec-17 5380 260 430 230 0 6300 Dec-17 Dec-17 Dec-17 1103 750 520 290 114 2777 Dec-17 0 Jan-18 6210 270 400 200 0 7080 Jan-18 Jan-18 1010 2292 Jan-18 1250 780 480 200 111 2821 Jan-18 571 0 Feb-18 8030 280 750 190 0 9250 Feb-18 Feb-18 1045 Feb-18 1550 805 523 210 121 3209 Feb-18 625 0 Mar-18 8540 300 970 210 5 Mar-18 Mar-18 Mar-18 1820 830 560 220 123 Mar-18 723 236 Apr-18 9120 340 1310 220 16 11006 Apr-18 Apr-18 2353 Apr-18 2010 890 570 230 120 3820 Apr-18 848 1887 May-18 9570 390 1260 200 22 May-18 May-18 May-18 2230 930 590 253 130 4133 May-18 792 Jun-18 10230 380 1240 210 26 Jun-18 Jun-18 Jun-18 2490 980 600 270 136 4476 Jun-18 1386 Jul-18 9580 350 1300 230 14 11474 Jul-18 Jul-18 2600 Jul-18 2440 1002 580 280 134 4436 Jul-18 739 2037 1193 Aug-18 7680 340 1250 220 15 9505 Aug-18 Aug-18 6064 Aug-18 2334 970 570 250 132 4256 Aug-18 667 2018 421 Sep-18 6870 320 1210 220 11 8631 Sep-18 Sep-18 5789 2453 Sep-18 2190 960 550 230 137 4067 Sep-18 660 56 Oct-18 5930 310 970 230 3 7443 Oct-18 Oct-18 3131 2517 Oct-18 2080 930 530 220 130 3890 Oct-18 625 0 Nov-18 300 650 240 1 6451 Nov-18 Nov-18 Nov-18 2050 920 517 190 139 3816 Nov-18 608 2035 0 Dec-18 4830 290 300 230 0 5650 Dec-18 Dec-18 979 2453 Dec-18 2004 902 490 190 131 3717 Dec-18 Totals 113 Totals Totals Five Year Market Share
2
The
Students should summarize these in a coherent written report.
Dealer Satisfaction
Dealer Satisfaction
This would best be done with PivotTables or Sort procedures that are covered in the next chapter.
This exercise gives students practice at copying, pasting, and manipulating data in spreadsheets.
Survey Scale:
0
1
3
4
5
Sample
North America
Size
Region
Year
20
14
1
6
22
11
52
20
15
50
South America
20
16
8
36
62
Eur
201
7
12
34
45
10
Pac
20
18
44
56
1
25
Totals
North America
South America South America
2014
Europe
2015
Pacific
2016
31
20
17
33
2018
60
9
Europe
Europe Pacific Rim
2014 0 0 1 3 7 4 15
China
2015 0 1 1 2 8 4 16 Totals
2016 0 0 1 2 15 7 25 North America
2017
30
2018 0 0 1 4 17 8 30 Europe
Pacific Rim
Pacific Rim China
2014 0 0 1 2 2 0 5 Totals
2015 0 0 1 1 3 5 10 North America
2016 0 0 1 1 3 1 6 South America
2017 0 0 1 3 6 3
13
2018 0 0 1 2 7 2 12 Pacific Rim
China
China Totals
2016 0 0 0 1 0 0 1
2017 0 0 1 4 3 0 8
2018 0 0 1 5 8 2 16
End-User Satisfaction
End-User Satisfaction This would best be done with PivotTables or Sort procedures that are covered in the next chapter.
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 30
38
93
2015 1 2 4 18
35
40
100
2016 1 2 5 15 34
41
98
2017 0 2 4 15 33
46
2018 0 2 3 15 31
49
South America South America 2014 1 2 7 18 36 38
102
2015 1 3 6 17 36
37
2016 0 2 6
19
2017 0 2 5 20 37 36 100 North America
2018 0 2 5 19 37 37 100 South America
`
2014 1 2 5
21
101
2015 1 2 5 21 34 37 100 Totals
2016 1 1 4
26
2017 1 1 3 17 41 37 100 South America
2018 0 1 2 19 45 33 100 Europe
Pacific Rim China 2014 2 4 5 15 41 34 101 Totals
2015 1 2 7 15 41 34 100 North America
2016 1 2 5 16 40 36 100 South America
2017 0 2 4 17 40 37 100 Europe
2018 0 1 3 19
42
China Totals 2016 0 3 4 6 20 10
43
2017 1 5 2 3 30 11 52
2018 0 1 2 3 31 14
51
Mower Test
Mower Test Functional Performance
Number of failures
Sample
Observation
23
24
27
28
29
1
Pass
Fail
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 Fail 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 Fail Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Fail 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 Fail Pass Pass Pass Pass Pass Pass Fail Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
32
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
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
48
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
54
55
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
58
59
60 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
61
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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
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
95
96
97
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
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
Gross Revenues
Prices for PLE products for the past 5 years:
Year
Mower Price
Tractor Price
2014
$165
$3,
250
2015
$
170
$3,
300
2016
$181
$3,345
2017
$183
$3,
651
2018
$193
$3,
850
Mower Unit Sales
Tractor Unit Sales
Month
NA
SA
World
Jan-14
5555
200
720
657
570
560
212
1592
Feb-14
7950
220
990
120
9
280
611
270
600
230
1
711
Mar-14
810
1
320
110
9
780
630
260
680
240
1810
Apr-14
9050
1
650
111
684
263
1867
May-14
9
900
310
1
590
130
11
930
580
269
1779
Jun-14
1020
1
620
122
1
740
Jul-14
8
730
1590
140
10740
512
264
760
290
1826
Aug-14
8140
1560
10080
500
645
1
695
Sep-14
6
480
8
430
478
1
681
Oct-14
599
132
7650
455
670
258
1663
Nov-14
5320
210
6650
407
888
1
825
Dec-14
4
640
180
660
5620
360
1720
Jan-15
5
980
690
7020
571
1761
Feb-15
7620
150
9030
350
275
2035
Mar-15
8370
1290
10050
390
742
2142
Apr-15
8
830
1620
10
890
840
440
2
340
May-15
9310
330
1650
11
420
470
2280
Jun-15
10230
12270
490
721
2271
Jul-15
8720
10720
481
312
215
Aug-15
7
710
1
530
9650
460
305
2146
Sep-15
6320
8310
2085
Oct-15
5840
1260
160
7
510
1
970
Nov-15
4
960
625
436
1936
Dec-15
4350
537
533
1850
Jan-16
6020
6970
610
2000
Feb-16
792
9160
2324
Mar-16
8430
1110
9970
2510
Apr-16
9040
1500
11020
820
2672
May-16
9820
1440
11780
1040
2780
Jun-16
10370
1410
12280
1032
807
2813
Jul-16
10960
1006
2716
Aug-16
9500
910
2
581
Sep-16
6420
1350
8230
803
313
2476
Oct-16
5890
1080
7420
2317
Nov-16
5340
190
6630
699
603
Dec-16
4430
5350
647
2080
Jan-17
6100
7030
287
2202
Feb-17
8010
750
9220
2540
Mar-17
114
1160
724
286
Apr-17
9110
11050
1510
3348
May-17
9730
380
134
11640
3
550
Jun-17
10120
136
12040
1490
800
3432
Jul-17
9080
1
1010
1460
3
400
Aug-17
7820
9830
139
341
3261
Sep-17
6540
131
1360
3209
Oct-17
6010
7490
1340
3132
Nov-17
5270
770
6530
1240
827
302
Dec-17
5380
6300
1103
520
2777
Jan-18
6210
7080
1250
2821
Feb-18
8030
9250
1550
805
523
121
Mar-18
8540
1002
1820
123
3
553
Apr-18
9120
1310
11006
2010
3820
May-18
9570
1
1442
2230
253
4133
Jun-18
1208
2490
4476
Jul-18
9580
1300
11474
2440
4436
Aug-18
7680
9505
2334
4256
Sep-18
6870
1210
8631
2190
137
4067
Oct-18
5930
7443
3890
Nov-18
526
6451
2050
920
517
3816
Dec-18
4830
5650
2004
902
3717
Gross Revenues Mowers
Gross Revenues Tractors
Jan-14 Jan-14
Feb-14 Feb-14
Mar-14 Mar-14
Apr-14 Apr-14
May-14 May-14
Jun-14 Jun-14
Jul-14 Jul-14
Aug-14 Aug-14
Sep-14 Sep-14
Oct-14 Oct-14
Nov-14 Nov-14
Dec-14 Dec-14
Jan-15 Jan-15
Feb-15 Feb-15
Mar-15 Mar-15
Apr-15 Apr-15
May-15 May-15
Jun-15 Jun-15
Jul-15 Jul-15
Aug-15 Aug-15
Sep-15 Sep-15
Oct-15 Oct-15
Nov-15 Nov-15
Dec-15 Dec-15
Jan-16 Jan-16
Feb-16 Feb-16
Mar-16 Mar-16
Apr-16 Apr-16
May-16 May-16
Jun-16 Jun-16
Jul-16 Jul-16
Aug-16 Aug-16
Sep-16 Sep-16
Oct-16 Oct-16
Nov-16 Nov-16
Dec-16 Dec-16
Jan-17 Jan-17
Feb-17 Feb-17
Mar-17 Mar-17
Apr-17 Apr-17
May-17 May-17
Jun-17 Jun-17
Jul-17 Jul-17
Aug-17 Aug-17
Sep-17 Sep-17
Oct-17 Oct-17
Nov-17 Nov-17
Dec-17 Dec-17
Jan-18 Jan-18
Feb-18 Feb-18
Mar-18 Mar-18
Apr-18 Apr-18
May-18 May-18
Jun-18 Jun-18
Jul-18 Jul-18
Aug-18 Aug-18
Sep-18 Sep-18
Oct-18 Oct-18
Nov-18 Nov-18
Dec-18 Dec-18
Market Share
Market Share
Industry Mower Total Sales
PLE Mower Unit Sales
Industry Tractor Total Sales
PLE Tractor Unit Sales
Month NA SA Eur Pac China World Month NA SA Europe Pacific China World Month NA SA Europe Pacific China World Month NA SA Eur Pac China World Month NA SA Eur Pac China World Month NA SA Europe Pacific China World
Jan-14
5
5000
12555
1165
74662
6000
7800
1025
6500
987
365
1
667
Feb-14
77184
16500
1200
9
658
9280
6215
785
4
587
1090
321
12998
1711
Mar-14
76000
661
2100
10
236
8100
1320
9780
8512
6910
1127
18264
Apr-14
86190
778
18015
1654
11
617
11100
6415
1458
4500
1209
13782
May-14
96117
886
2789
1313
1262
9900
1193
8442
5273
1221
16208
Jun-14
96000
882
30566
1176
129768
10200
7500
1019
5
315
1327
15448
1740
Jul-14
84757
848
29444
1359
116409
8730
6145
977
7170
1324
289
15905
Aug-14
79804
735
28364
1238
110141
5882
1057
5926
1268
14422
1695
Sep-14
6480
28393
1215
95065
5
595
1086
6075
293
14258
1681
Oct-14
59
307
2
4444
1154
85500
5990
5233
1045
6321
1168
295
14061
Nov-14
52157
18000
71972
4494
1078
838
298
15378
Dec-14
45049
462
1
2453
1386
59349
4640
3913
1029
7944
1085
301
14272
Jan-15
58627
12778
1443
73401
5980
5938
1172
5688
1185
306
14289
Feb-15
76200
615
18214
1515
96545
6633
1273
7037
1286
16530
Mar-15
82871
23889
1373
108791
732
1423
698
303
17320
Apr-15
84904
784
29455
116584
8830
10890
8077
1612
1346
18842
2340
May-15
93100
846
29464
124625
11420
7830
1728
6571
1388
309
17826
Jun-15
93000
27414
1
333
122585
7103
1815
6990
1449
17669
Jul-15
83048
763
27368
1415
112594
6239
1776
6667
16487
2154
Aug-15
74854
694
27321
1296
104164
7710
1530
6036
1685
6762
318
1
6250
Sep-15
60
769
1402
92241
5664
167
6635
1394
15692
Oct-15
556
23774
1468
81470
7510
5345
1618
6311
1256
14844
1970
Nov-15
48155
17308
1351
67386
4960
4831
1564
6476
1214
14402
Dec-15
42647
12941
1389
57489
4454
1522
1171
13716
Jan-16
57885
10962
1509
70892
5299
1835
5922
14597
Feb-16
77647
1527
9491
7920
6529
2115
16836
Mar-16
8
1845
659
20556
1524
104583
7120
7228
606
18412
Apr-16
86095
756
26786
1574
115211
7619
2151
8200
1311
19852
May-16
91776
878
24828
118949
8387
2214
7941
20
513
Jun-16
100680
24737
127801
8110
2278
7921
1520
20355
Jul-16 86190 756 24828
1441
113
7752
7677
1675
19716
Aug-16
7
1887
714
2517
1545
99325
6894
2128
7200
1584
18575
2581
Sep-16
60000
24545
86863
6015
2367
6735
1
739
Oct-16
55566
643
19286
1698
77193
5368
2211
6495
1422
16226
Nov-16
50857
15273
68558
4964
2483
6061
1366
15587
Dec-16
42596
9107
1731
53982
1986
5816
14207
Jan-17
58095
8571
69135
2257
5051
14394
Feb-17
75566
13158
91182
6284
2353
608
1436
1063
17218
Mar-17
80286
19655
1923
102486
1140
7785
2457
6327
1478
1264
19310
2867
Apr-17
85140
1981
11
3027
9934
7604
1512
1333
22901
May-17
90093
23103
115832
10645
2612
7789
1642
1556
24244
3550
Jun-17
95472
24286
1942
122482
2749
7347
22993
Jul-17
87308
1961
114686
9182
2887
6
979
1733
1702
22483
3400
Aug-17
74476
26607
103729
8528
2833
6489
1700
1915
21465
1390
Sep-17
61698
22982
2075
87381
8293
6316
2083
21123
Oct-17
5
723
16897
2019
76771
8221
2765
5833
1576
20523
Nov-17
50673
13750
2095
67105
7470
2746
5789
1493
2292
19789
Dec-17
51238
591
7818
2150
61797
6509
2534
5591
1450
2245
18329
Jan-18
59712
563
7547
1852
69673
7267
2635
5106
18311
Feb-18
77961
13889
1743
94165
8807
2703
5474
2449
20477
Mar-18
83725
18302
1892
104544
10025
10168
2795
6022
1106
2400
22489
3553
Apr-18
90297
25192
2037
118250
11044
2997
6064
1150
23607
May-18
91143
24706
542
118583
11442
12120
3131
6344
1244
2600
25439
Jun-18
99320
25306
1944
875
127363
12086
13459
3311
6593
1357
2653
27374
Jul-18
93922
745
27083
2170
123919
13048
3390
6304
1
421
26764
Aug-18
73143
26042
101961
12275
3277
1263
2549
25428
Sep-18
66699
26304
95688
11347
3232
1173
23995
Oct-18
56476
22558
2072
81766
10667
5699
1128
23142
Nov-18
51068
14773
2182
68648
5260
10459
3087
5604
974
2541
22666
Dec-18
46893
6977
56510
10082
3030
5444
21989
Totals
4346826
40395
1253779
98551
5576
5760250
452540
16940
68940
10350
548883
458206
126196
386338
79364
64160
1114264
64502
35901
38878
16331
2799
158411
Five Year Market Share
