Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

YearMower Price ($)Tractor Price ($)
20101503250
20111753400
20121803600
20131853700
20141903800

Industry Mower Total Sales 126210 Aug 10 85500 116584 93100 Feb 12 81845 Apr 12 115211 Month NA SA Eur Pac World Jan-10 60000

Industry Tractor Total Sales May-10 Aug-10 14272 Month NA Jan-10 8143 Feb-10 8592 Mar-10 8630 Apr-10 8947 8442 4444 Jun-10 75  

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

Step by Step Solution

3.34 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

Solution I will give you a guide for this question please see the belowattached images ... 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_2

Step: 3

blur-text-image_3

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

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, And Terry D. Warfield

13th Edition

9780470374948, 470423684, 470374942, 978-0470423684

More Books

Students also viewed these Accounting questions

Question

=+ What are the subjects?

Answered: 1 week ago