Question: Can you help me with the steps needed to do this in excel? C D E F G B 1 Mower Unit Sales 190 140

Can you help me with the steps needed to do this in excel?

C D E F G B 1 Mower Unit Sales 190 140 COU 3 Month NA SA Europe Pacific China World Jan-14 6000 200 720 100 0 7020 Feb-14 7950 220 990 120 0 9280 Mar-14 8100 250 1320 110 0 9780 Apr-14 9050 280 1650 120 0 11100 May-14 9900 310 1590 130 0 11930 Jun-14 10200 300 1620 120 0 12240 Jul-14 8730 280 1590 10740 Aug-14 8140 250 1560 130 10080 Sep-14 6480 230 1590 130 0 8430 Oct-14 5990 220 1320 120 0 7650 Nov-14 5320 210 990 130 0 6650 Dec-14 4640 180 660 140 0 5620 Jan-15 5980 210 690 140 0 7020 Feb-15 7620 240 1020 150 0 9030 Mar-15 8370 250 1290 140 0 10050 Apr-15 8830 290 1620 0 10890 May-15 9310 330 1650 130 0 11420 Jun-15 10230 310 1590 140 0 12270 Jul-15 8720 290 1560 150 10720 Aug-15 7710 270 1530 140 9650 Sep-15 6320 250 1590 150 8310 Oct-15 5840 250 1260 160 7510 Nov-15 4960 240 900 150 6250 OZU 150 s ss 180 A B C D E F bec-15 4350 2106601500 Jan-16 6020 220 570 | 160 Feb-167920 250 840 150 Mar-168430 270 1110 160 Apr-169040 310 1500 170 May-169820 360 1440 160 Jun-16 10370 330 1410 170 Jul-169050 310 1440 160 Aug-16 76203001410 170 sep-166420 280 1350 ct-165890 270 1080 180 Now-165340 260 | 840 190 bec-16 4430 230 510 180 Jan-17 6100 250 480 200 Feb-17 8010 270 750 190 Mar-17 8430 280 1140 200 Apr79110 320 1410 2100 May-179730 380 1340 190 Jun-17 10120 360 1360 200 Jul-179080320 1410 200 Aug-17 7820 310 1490 210 0 sep-76540 300 1310220 ct-76010 290980 2100 Nov-17 5270 270 770 220 0 Dec-17 5380 260430 230 0 G 5370 6970 9160 9970 11020 11780 12280 10960 9500 8230 7420 6630 5350 7030 9220 10050 11050 11640 12040 11010 9830 8370 7490 6530 6300 0 I0 49 400 54 970 1310 1260 1240 56 57 Jan-18 6210 270 Feb-18 8030 280 Mar-18 8540 300 Apr-18 9120 340 May-18 9570 390 Jun-18 10230 380 Jul-18 9580 350 Aug-18 7680 340 Sep-18 6870 320 Oct-18 5930 310 Nov-18 5260 300 Dec-18 4830 290 200 0 190 0 2105 220 16 200 22 210 26 230 14 220 15 220 11 230 3 240 1 230 0 7080 9250 10025 11006 11442 12086 11474 9505 8631 7443 6451 5650 58 59 60 61 1210 970 650 300 62 63 C D E F . A B 1 Tractor Unit Sales 0 0 3 Month NA Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 12 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 SA 570 611 630 684 650 600 512 500 478 455 407 360 10 Eur Pacific China 250 560 212 270 600 230 260 680 240 270 650 263 280 580 269 270 590 280 264 760 290 280 645 270 290 650 263 280 670 258 290 888 240 280 850 230 320 620 250 350 760 275 390 742 270 440 780 280 470 690 290 490 721 300 481 680 312 460 711 305 460 695 290 440 650 260 436 250 World 1592 1711 1810 1867 1779 1740 1826 1695 1681 1663 1825 1720 1761 2035 2142 2340 2280 2271 2154 2146 2085 1970 1936 571 650 740 840 830 760 681 670 640 0 620 570 680 0 10 12 240 250 250 260 270 290 20 22 310 340 20 24 20 31 30 37 32 33 27 Dec-15 28 Jan-16 Feb-16 30 Mar-16 31 Apr-16 32 May-16 33 Jun-16 34 Jul-16 Aug-16 36 Sep-16 37 Oct-16 38 Nov-16 39 Dec-16 40 Jan-17 Feb-17 42 Mar-17 43 Apr-17 44 May-17 45 Jun-17 46 Jul-17 Aug-17 48 Sep-17 Oct-17 Nov-17 51 Dec-17 52 Jan-18 533 620 792 890 960 1040 1032 1006 910 803 730 699 647 730 930 1160 1510 1650 1490 1460 1390 1360 1340 1240 1103 1250 420 510 590 610 600 620 640 590 600 670 630 710 570 650 680 724 730 760 800 840 830 820 810 827 750 780 657 610 680 730 820 810 807 760 720 660 630 603 570 500 590 620 730 740 720 670 610 599 560 550 520 480 1850 2000 2324 2510 2672 2780 2813 2716 2581 2476 2317 2324 2080 2202 2540 2867 3348 3550 3432 3400 3261 3209 3132 3027 2777 2821 35 320 313 290 280 260 287 290 300 310 330 340 350 341 330 320 300 290 200 41 50 63 68 70 82 47 49 50 80 90 100 102 110 114 111 121 123 54 56 53 Feb-18 Mar-18 Apr-18 May-18 57 Jun-18 58 Jul-18 Aug-18 60 Sep-18 Oct-18 Nov-18 63 Dec-18 120 130 136 1550 1820 2010 2230 2490 2440 2334 2190 2080 2050 2004 805 830 890 930 980 1002 970 960 930 523 560 570 590 600 580 570 550 530 517 490 210 220 230 253 270 280 250 230 220 190 134 132 137 130 139 131 3209 3553 3820 4133 4476 4436 4256 4067 3890 3816 3717 920 902 190 190 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 Create a new worksheet 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Create charts to better understand data sets. For cross-sectional data, use a scatter chart. For time series data, use a line chart. Linear y = a + bx Logarithmic y = ln(x) Polynomial (2nd order) y =...

Instructions: Please provide your discussion and stepbystep howto guide on the problems below. Work must be presented on a Word File but you need an excel file to show work. Use Illustrations from...

Dealer Satisfaction North America Scale 0 2010 2011 2012 2013 2014 Scale 1 1 0 1 1 2 Scale 2 0 0 1 2 3 2 2 1 6 5 Scale 3 Scale 4 Scale 5 Sample 14 22 11 50 14 20 14 50 8 34 15 60 12 34 45 100 15 44...

Old MathJax webview This is the PLE chart This is the question This is the Mower Unit Sales below This is the Tractor Unit Sales below This is the Mower Unit Sales below This is the Tractor Unit...

Part 1: The Performance Lawn Equipment database contains data needed to develop a pro forma income statement. Dealers selling PLE products all receive 18 percent of sales revenue for their part of...

Please help me understand the formulas in excel to create the below: Part 1: The Performance Lawn Equipment database contains data needed to develop a pro forma income statement. Dealers selling PLE...

Part 1: The Performance Lawn Equipment database contains data needed to develop a pro forma income statement. Dealers selling PLE products all receive 18 percent of sales revenue for their part of...

Excel File Edit View Insert Format Tools Data Window Help Q 8 Sun Jul 16 7:02 PM plus.pearson.com o. . AutoSave O OFF ~ A 9 ? . C ... Case Study 1 ~ Home Home Insert Draw Page Layout Formulas Data...

Explain the causes of the global financial and economic crisis that started in the U.S. in 2007. What effect did it have on the global economy? How did the global economy recover? What kind of fiscal...

Ford Motor Companys 2011 financial statements revealed that it has extensive equity method investments. In total, the balance sheet showed equity investments of $2,569 million at December 31, 2010,...

6 Explain why programmers find library routines useful when writing programs. Include in your answer with two examples of library routines that programmers frequently use.

12# Please answer using STAT Use the 95%95% rule and the fact that the summary statistics come from a distribution that is symmetric and bell-shaped to find an interval that is expected to contain...