Old MathJax webview

This is mower unit sales below

This is tractor unit sales below

what is missing everything is there. what else do I need???

3. Next, Elizabeth has provided you with prices for PLE products for the past five years: Prices for PLE products for the past five years 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. NO 6 1 Mower Unit Sales 2 3 Month NA SA Europe Pacific China World 4 Jan-14 6000 #4 720 100 0 7020 5 Feb-14 7950 ## 990 120 0 9280 Mar-14 8100 ## 1320 110 0 9780 7 Apr-14 9050 ## 1650 120 0 8 May-14 9900 ## 1590 130 0 9 Jun-14 *** 1620 120 0 10 Jul-14 8730 1590 140 0 Aug-14 8140 ## 1560 130 0 12 Sep-14 6480 1590 130 0 8430 Oct-14 5990 1320 120 0 7650 14 Noy-14 5320 ## 990 130 0 6650 15 Dec-14 4640 ## 660 140 0 5620 16 Jan-15 5980 ## 690 140 0 7020 17 Feb-15 7620 ## 1020 150 0 9030 18 Mar-15 8370 1290 140 0 19 Apr-15 8830 1620 150 0 20 May-15 9310 ## 1650 130 0 21 Jun-15 ## 1590 140 0 150 0 23 0 9650 1560 1530 1590 1260 900 140 150 24 0 8310 160 26 150 0 7510 0 6250 0 5370 660 150 570 840 0 6970 0 9160 0 9970 0 Jul-15 8720 ## Aug-15 7710 ## Sep-15 6320 ## Oct-15 5840 ## Nov-15 4960 ## Dec-15 4350 ## Jan-16 6020 ## Feb-16 7920 ## Mar-16 8430 ## Apr-16 9040 May-16 9820 Jun-16 #### Jul-16 9050 Aug-16 7620 ## Sep-16 6420 ## Oct-16 5890 ## Noy-16 5340 ## Dec-16 4430 ## Jan-17 6100 ## Feb-17 8010 ## Mar-17 8430 ## 0 0 1110 1500 1440 1410 1440 1410 1350 1080 840 510 480 750 1140 160 150 160 170 160 170 160 170 180 180 190 180 200 190 200 38 0 0 9500 0 8230 0 7420 0 6630 0 5350 0 7030 0 9220 0 39 40 41 42 44 1410 1340 1360 45 46 1410 1490 1310 980 48 4 49 5 HP 770 OT 430 LD Apr-17 9110 ## May-17 9730 ## Jun-17 ## Jul-17 9080 ## Aug-17 7820 ## Sep-17 6540 ## Oct-17 6010 ## Nov-17 5270 ## Dec-17 5380 ## Jan-18 6210 ## Feb-18 8030 ## Mar-18 8540 ## Apr-18 9120 ## May-18 9570 ## Jun-18 #### Jul-18 9580 ## Aug-18 7680 ## Sep-18 6870 ## Oct-18 5930 ## Nov-18 5260 ## Dec-18 4830 ## 210 0 190 0 200 0 200 0 ## 210 0 9830 220 0 8370 210 0 7490 220 0 6530 230 0 6300 200 0 7080 190 0 9250 210 220 16 200 22 ### 210 26 # 230 14 ## 220 15 9505 220 11 8631 230 37443 240 1 6451 230 0 5650 53 54 10025 # 2 LO 400 750 970 1310 1260 1240 1300 1250 1210 970 650 300 LO 58 59 5 60 61 62 63 BA 1 Tractor Unit Sales IND 4 2 3 Month NA SA Eur Pacific China World Jan-14 570 250 560 212 0 1592 5 Feb-14 611 270 600 230 0 1711 6 Mar-14 630 260 680 240 0 1810 7 Apr-14 684 270 650 263 0 1867 8 May-14 650 280 580 269 0 1779 9 Jun-14 600 270 590 280 0 1740 10 Jul-14 512 264 760 290 1826 11 Aug-14 500 280 645 270 1695 12 Sep-14 478 290 650 263 0 1681 13 Oct-14 455 280 670 258 0 1663 14 Nov-14 407 290 888 240 0 1825 15 Dec-14 360 280 850 230 0 1720 16 Jan-15 571 320 620 250 0 1761 17 Feb-15 650 350 760 275 0 2035 18 Mar-15 740 390 742 270 0 2142 19 Apr-15 840 440 780 280 0 2340 20 May-15 830 470 690 290 0 2280 21 Jun-15 760 490 721 300 0 2271 481 312 0 2154 681 670 0 2146 305 290 0 640 620 460 460 440 436 420 260 0 0 570 533 0 620 510 250 240 250 250 260 10 12 792 890 680 711 695 650 680 657 610 680 730 820 810 807 760 720 660 630 603 570 20 270 A 22 Jul-15 23 Aug-15 24 Sep-15 25 Oct-15 26 Noy-15 27 Dec-15 28 Jan-16 29 Feb-16 30 Mar-16 31 Apr-16 32 May-16 33 Jun-16 34 Jul-16 35 Aug-16 36 Sep-16 37 Oct-16 38 Nov-16 39 Dec-16 40 Jan-17 41 Feb-17 42 Mar-17 22 20 960 1040 1032 1006 910 803 730 699 647 730 930 1160 590 610 600 620 640 590 600 670 630 710 570 650 680 724 290 310 340 320 313 290 280 260 287 290 300 2085 1970 1936 1850 2000 2324 2510 2672 2780 2813 2716 2581 2476 2317 2324 2080 2202 2540 2867 24 20 31 30 37 32 33 35 50 500 590 620 310 730 760 730 740 720 800 330 340 350 840 670 830 341 820 810 330 320 300 43 Apr-17 1510 44 May-17 1650 45 Jun-17 1490 46 Jul-17 1460 47 Aug-17 1390 48 Sep-17 1360 49 Oct-17 1340 50 Nov-17 1240 51 Dec-17 1103 52 Jan-18 1250 53 Feb-18 1550 54. Mar-18 1820 55 Apr-18 2010 56 May-18 2230 57 Jun-18 2490 58 Jul-18 2440 59 Aug-18 2334 60 Sep-18 2190 61 Oct-18 2080 62 Nov-18 2050 63 Dec-18 2004 827 750 780 805 830 890 930 980 1002 970 960 930 920 902 610 599 560 550 520 480 523 560 570 590 600 580 570 550 530 517 490 290 200 210 220 230 253 270 280 250 230 220 190 190 68 3348 70 3550 82 3432 80 3400 90 3261 100 3209 102 3132 110 3027 114 2777 111 2821 121 3209 123 3553 120+ 3820 130 4133 136 4476 134 4436 132 4256 137 4067 130 3890 139 3816 131 3717 CA 3. Next, Elizabeth has provided you with prices for PLE products for the past five years: Prices for PLE products for the past five years 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. NO 6 1 Mower Unit Sales 2 3 Month NA SA Europe Pacific China World 4 Jan-14 6000 #4 720 100 0 7020 5 Feb-14 7950 ## 990 120 0 9280 Mar-14 8100 ## 1320 110 0 9780 7 Apr-14 9050 ## 1650 120 0 8 May-14 9900 ## 1590 130 0 9 Jun-14 *** 1620 120 0 10 Jul-14 8730 1590 140 0 Aug-14 8140 ## 1560 130 0 12 Sep-14 6480 1590 130 0 8430 Oct-14 5990 1320 120 0 7650 14 Noy-14 5320 ## 990 130 0 6650 15 Dec-14 4640 ## 660 140 0 5620 16 Jan-15 5980 ## 690 140 0 7020 17 Feb-15 7620 ## 1020 150 0 9030 18 Mar-15 8370 1290 140 0 19 Apr-15 8830 1620 150 0 20 May-15 9310 ## 1650 130 0 21 Jun-15 ## 1590 140 0 150 0 23 0 9650 1560 1530 1590 1260 900 140 150 24 0 8310 160 26 150 0 7510 0 6250 0 5370 660 150 570 840 0 6970 0 9160 0 9970 0 Jul-15 8720 ## Aug-15 7710 ## Sep-15 6320 ## Oct-15 5840 ## Nov-15 4960 ## Dec-15 4350 ## Jan-16 6020 ## Feb-16 7920 ## Mar-16 8430 ## Apr-16 9040 May-16 9820 Jun-16 #### Jul-16 9050 Aug-16 7620 ## Sep-16 6420 ## Oct-16 5890 ## Noy-16 5340 ## Dec-16 4430 ## Jan-17 6100 ## Feb-17 8010 ## Mar-17 8430 ## 0 0 1110 1500 1440 1410 1440 1410 1350 1080 840 510 480 750 1140 160 150 160 170 160 170 160 170 180 180 190 180 200 190 200 38 0 0 9500 0 8230 0 7420 0 6630 0 5350 0 7030 0 9220 0 39 40 41 42 44 1410 1340 1360 45 46 1410 1490 1310 980 48 4 49 5 HP 770 OT 430 LD Apr-17 9110 ## May-17 9730 ## Jun-17 ## Jul-17 9080 ## Aug-17 7820 ## Sep-17 6540 ## Oct-17 6010 ## Nov-17 5270 ## Dec-17 5380 ## Jan-18 6210 ## Feb-18 8030 ## Mar-18 8540 ## Apr-18 9120 ## May-18 9570 ## Jun-18 #### Jul-18 9580 ## Aug-18 7680 ## Sep-18 6870 ## Oct-18 5930 ## Nov-18 5260 ## Dec-18 4830 ## 210 0 190 0 200 0 200 0 ## 210 0 9830 220 0 8370 210 0 7490 220 0 6530 230 0 6300 200 0 7080 190 0 9250 210 220 16 200 22 ### 210 26 # 230 14 ## 220 15 9505 220 11 8631 230 37443 240 1 6451 230 0 5650 53 54 10025 # 2 LO 400 750 970 1310 1260 1240 1300 1250 1210 970 650 300 LO 58 59 5 60 61 62 63 BA 1 Tractor Unit Sales IND 4 2 3 Month NA SA Eur Pacific China World Jan-14 570 250 560 212 0 1592 5 Feb-14 611 270 600 230 0 1711 6 Mar-14 630 260 680 240 0 1810 7 Apr-14 684 270 650 263 0 1867 8 May-14 650 280 580 269 0 1779 9 Jun-14 600 270 590 280 0 1740 10 Jul-14 512 264 760 290 1826 11 Aug-14 500 280 645 270 1695 12 Sep-14 478 290 650 263 0 1681 13 Oct-14 455 280 670 258 0 1663 14 Nov-14 407 290 888 240 0 1825 15 Dec-14 360 280 850 230 0 1720 16 Jan-15 571 320 620 250 0 1761 17 Feb-15 650 350 760 275 0 2035 18 Mar-15 740 390 742 270 0 2142 19 Apr-15 840 440 780 280 0 2340 20 May-15 830 470 690 290 0 2280 21 Jun-15 760 490 721 300 0 2271 481 312 0 2154 681 670 0 2146 305 290 0 640 620 460 460 440 436 420 260 0 0 570 533 0 620 510 250 240 250 250 260 10 12 792 890 680 711 695 650 680 657 610 680 730 820 810 807 760 720 660 630 603 570 20 270 A 22 Jul-15 23 Aug-15 24 Sep-15 25 Oct-15 26 Noy-15 27 Dec-15 28 Jan-16 29 Feb-16 30 Mar-16 31 Apr-16 32 May-16 33 Jun-16 34 Jul-16 35 Aug-16 36 Sep-16 37 Oct-16 38 Nov-16 39 Dec-16 40 Jan-17 41 Feb-17 42 Mar-17 22 20 960 1040 1032 1006 910 803 730 699 647 730 930 1160 590 610 600 620 640 590 600 670 630 710 570 650 680 724 290 310 340 320 313 290 280 260 287 290 300 2085 1970 1936 1850 2000 2324 2510 2672 2780 2813 2716 2581 2476 2317 2324 2080 2202 2540 2867 24 20 31 30 37 32 33 35 50 500 590 620 310 730 760 730 740 720 800 330 340 350 840 670 830 341 820 810 330 320 300 43 Apr-17 1510 44 May-17 1650 45 Jun-17 1490 46 Jul-17 1460 47 Aug-17 1390 48 Sep-17 1360 49 Oct-17 1340 50 Nov-17 1240 51 Dec-17 1103 52 Jan-18 1250 53 Feb-18 1550 54. Mar-18 1820 55 Apr-18 2010 56 May-18 2230 57 Jun-18 2490 58 Jul-18 2440 59 Aug-18 2334 60 Sep-18 2190 61 Oct-18 2080 62 Nov-18 2050 63 Dec-18 2004 827 750 780 805 830 890 930 980 1002 970 960 930 920 902 610 599 560 550 520 480 523 560 570 590 600 580 570 550 530 517 490 290 200 210 220 230 253 270 280 250 230 220 190 190 68 3348 70 3550 82 3432 80 3400 90 3261 100 3209 102 3132 110 3027 114 2777 111 2821 121 3209 123 3553 120+ 3820 130 4133 136 4476 134 4436 132 4256 137 4067 130 3890 139 3816 131 3717 CA