Create a new worksheet to show the market share for each product(Mower and Tractor) and region(NA, SA,
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Solution I will give you a guide for this question please see the belowattached images ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
How do you figure out the market share for each product and region by month based on the sales date and the average market share by region over 5 years in excel? Can you tell me steps to follow in...
-
The following table indicates the market share for LCD televisions in the fourth quarter of 2011. Brand Market Share % Samsung .. 23.6 Vizio . 15.4 LG . 12.4 Sony 8.0 Toshiba . 7.8 Construct a...
-
These data summarize the market share for artificial sweeteners held by the major brands in 2002 and 2005. Prepare a chart that shows the shares each year and the brands that gained the most share...
-
Q8 Question: 9 A small particle of mass m moving inside a heavy, hollow and straight tube along the tube axis undergoes elastic collision at two ends. The tube has no friction and it is closed at one...
-
Solve for the predicted values of y and the residuals for the data in Problem 12.6. The data are provided hereagain: 2 9 2 2 5 2 2
-
Determine the power required for a 2000-kg car to climb a 100-m-long uphill road with a slope of 30° (from horizontal) in 10 s (a) At a constant velocity, (b) From rest to a final velocity of 30...
-
Techmart Corporation is a young start-up firm that produces components for high-resolution televisions. During the last two years, sales have grown dramatically. Currently, Techmart is experiencing a...
-
On January 1, 2009, Plank Company purchased 80% of the outstanding capital stock of Scoba Company for $53,000. At that time, Scobas stockholders equity consisted of capital stock, $55,000; other...
-
Ashley Kolar Technology expects growth of 30 percent each of the next 3 years, then 15 percent growth each year thereafter .The last dividend paid was $0.50 per share.The required rate of return for...
-
Ryan Ross (111-11-1112), Oscar Omega (222-22-2222), Clark Carey (333-33-3333), and Kim Kardigan (444-44-4444) are equal active members in ROCK the Ages LLC. ROCK serves as agents and managers for...
-
Given is a decision payoff table. Alternatives. Small Facility Medium Facility Large Facility Low 52 50 -15 bod I Future Demand Moderate 42 49 38 High 43 49 51 a) The best decision under uncertainty...
-
In Example 5.4, what is the probability that the oldest child and the youngest child are of the same gender? Example 5.4 Computing probabilities A family has three children. Denoting a boy by B and a...
-
What are the properties of instantaneous centre?
-
Differentiate between a mechanism and a machine.
-
Define kinematic link, kinematic pair and a kinematic chain.
-
What is a resistant body?
-
1. Award: 0.25 out of 0.25 points Hagar Industrial Systems Company (HISC) is trying to decide between two different conveyor belt systems. System A costs $360,000, has a 4-year life, and requires...
-
(a) As Section 17.3 discusses, high-frequency sound waves exhibit less diffraction than low-frequency sound waves do. However, even high-frequency sound waves exhibit much more diffraction under...
-
How do we determine whether a firm is making zero economic profits?
-
How do we determine whether a firm is experiencing an economic loss?
-
How do we determine whether a firm is generating an economic profit?
Study smarter with the SolutionInn App