Create a new worksheet to show the market share for each product(Mower and Tractor) and region(NA, SA, EUR, PAC) based on the PLE and industry sales data in the database

PLE Data

Year	Mower Price ($)	Tractor Price ($)
2010	150	3250
2011	175	3400
2012	180	3600
2013	185	3700
2014	190	3800

  

Transcribed Image Text:

28393 103729 121625 Industry Mower Total Sales Month NA SA Eur Pac World Jan-10 60000 571 13091 1045 74662 Feb-10 77184 611 17679 1111 96585 Mar-10 Аprг-10 May-10 Jun-10 77885 86190 1068 1237 102369 116171 126210 658 22759 27966 778 96117 97143 84757 79804 64800 27895 30566 29444 886 1313 1176 1359 129768 116409 110141 882 Jul-10 848 Aug-10 Sep-10 1238 1230 1215 735 28364 657 28393 95065 85500 24444 18000 Oct-10 59307 595 1154 52157 45049 Nov-10 553 71972 1262 1386 Dec-10 Jan-11 462 12453 59349 58627 553 12778 1443 73401 Feb-11 76200 615 18214 23889 29455 29464 1515 96545 Mar-11 82871 658 1373 108791 116584 Apr-11 May-11 84904 93100 784 1442 846 1215 124625 Jun-11 93000 83048 838 27414 1333 122585 Jul-11 763 27368 1415 112594 104464 104164 Aug-11 Sep-11 Oct-11 74854 694 27321 1296 29444 23774 60769 625 1402 92241 55619 48155 42647 57885 610 1468 81470 17308 12941 10962 1351 67386 57489 70892 Nov-11 571 Dec-11 Jan-12 512 1389 537 1509 77647 81845 Feb-12 Mar-12 Apr-12 May-12 Jun-12 595 15273 1402 94917 659 20556 1524 104583 86095 756 26786 1574 115211 1468 1560 91776 878 24828 118949 100680 825 24737 127801 Jul-12 86190 756 24828 1441 113216 71887 60000 Aug-12 Sep-12 Oct12 Nov-12 714 25179 1545 99325 651 24545 1667 86863 55566 643 19286 1698 1810 77193 50857 619 15273 68558 53982 Dec-12 42596 548 9107 1731 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 8571 13158 69135 91182 102486 58095 581 1887 1845 75566 614 80286 85140 90093 622 19655 727 826 1923 1981 1810 25179 113027 23103 24286 115832 95472 783 1942 122482 87308 74476 61698 57238 50673 51238 59712 Jul-13 681 24737 1961 114686 Aug-13 Sep-13 Oct-13 646 26607 2000 2075 103729 625 22982 87381 617 16897 2019 76771 Nov-13 587 13750 2095 67105 61797 Dec-13 591 7818 2150 Jan-14 7547 563 1852 69673 77961 13889 18302 Feb-14 571 1743 94165 83725 90297 104544 118250 118583 Mar-14 625 1892 Apr-14 May-14 Jun-14 723 25192 2037 90297 91143 1887 1944 848 24706 99320 792 25306 127363 Jul-14 93922 745 27083 2170 123919 Aug-14 Sep-14 Oct-14 73143 739 26042 2037 101961 2018 2072 66699 667 26304 95688 56476 660 22558 81766 Nov-14 51068 625 14773 2182 68648 Dec-14 46893 608 6977 2035 565 10 28393 103729 121625 Industry Mower Total Sales Month NA SA Eur Pac World Jan-10 60000 571 13091 1045 74662 Feb-10 77184 611 17679 1111 96585 Mar-10 Аprг-10 May-10 Jun-10 77885 86190 1068 1237 102369 116171 126210 658 22759 27966 778 96117 97143 84757 79804 64800 27895 30566 29444 886 1313 1176 1359 129768 116409 110141 882 Jul-10 848 Aug-10 Sep-10 1238 1230 1215 735 28364 657 28393 95065 85500 24444 18000 Oct-10 59307 595 1154 52157 45049 Nov-10 553 71972 1262 1386 Dec-10 Jan-11 462 12453 59349 58627 553 12778 1443 73401 Feb-11 76200 615 18214 23889 29455 29464 1515 96545 Mar-11 82871 658 1373 108791 116584 Apr-11 May-11 84904 93100 784 1442 846 1215 124625 Jun-11 93000 83048 838 27414 1333 122585 Jul-11 763 27368 1415 112594 104464 104164 Aug-11 Sep-11 Oct-11 74854 694 27321 1296 29444 23774 60769 625 1402 92241 55619 48155 42647 57885 610 1468 81470 17308 12941 10962 1351 67386 57489 70892 Nov-11 571 Dec-11 Jan-12 512 1389 537 1509 77647 81845 Feb-12 Mar-12 Apr-12 May-12 Jun-12 595 15273 1402 94917 659 20556 1524 104583 86095 756 26786 1574 115211 1468 1560 91776 878 24828 118949 100680 825 24737 127801 Jul-12 86190 756 24828 1441 113216 71887 60000 Aug-12 Sep-12 Oct12 Nov-12 714 25179 1545 99325 651 24545 1667 86863 55566 643 19286 1698 1810 77193 50857 619 15273 68558 53982 Dec-12 42596 548 9107 1731 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 8571 13158 69135 91182 102486 58095 581 1887 1845 75566 614 80286 85140 90093 622 19655 727 826 1923 1981 1810 25179 113027 23103 24286 115832 95472 783 1942 122482 87308 74476 61698 57238 50673 51238 59712 Jul-13 681 24737 1961 114686 Aug-13 Sep-13 Oct-13 646 26607 2000 2075 103729 625 22982 87381 617 16897 2019 76771 Nov-13 587 13750 2095 67105 61797 Dec-13 591 7818 2150 Jan-14 7547 563 1852 69673 77961 13889 18302 Feb-14 571 1743 94165 83725 90297 104544 118250 118583 Mar-14 625 1892 Apr-14 May-14 Jun-14 723 25192 2037 90297 91143 1887 1944 848 24706 99320 792 25306 127363 Jul-14 93922 745 27083 2170 123919 Aug-14 Sep-14 Oct-14 73143 739 26042 2037 101961 2018 2072 66699 667 26304 95688 56476 660 22558 81766 Nov-14 51068 625 14773 2182 68648 Dec-14 46893 608 6977 2035 565 10

Answer rating: 100% (QA)

Solution I will give you a guide for this question please see the belowattached images ... View the full answer