Question: Create a new worksheet in the database to compute gross revenues by month and region, as well as worldwide totals, for each product using the

Create a new worksheet in the database 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.

Create a new worksheet in the database to compute gross revenues by

month and region, as well as worldwide totals, for each product using

Mower Unit Sales 0 11100 011930 010080 08430 Nov-10 5320 210 06650 05620 Dec-10 4640 180 O 7020 09030 Mav-11 9310 012270 9160 9970 Month NA SA Europe Pacific China World Jan-10 6000 200 720 100 0 7020 Feb-10 7950 220 990 120 0 9280 Mar-10 8100 250 1320 110 0' 9780 Apr-10 9050 280 1650 120 May-10 9900 310 1590 130 1000 Jun-10 10200 300 1620 120 012240 Jul-10 8730 280 1590 140 010740 Aug-10 8140 250 1560 130 1304 10 Sep-10 6480 230 1590 130 Toy Oct-10 5990 220 1320 120 120 07650 990 130 930 15U 660 140 DOU 140 Jan-11 5980 210 690 10 690 140 Feb-11 7620 240 1020 150 150 Mar-11 8370 250 1290 1290 140 0 10050 Apr-11 8830 290 1620 150 0 10890 330 1660 130 1650 130 0 11420 Jun-11 10230 310 1590 140 Jul-11 8720 290 1560 16 150 010720 Aug-11 7710 270 Arad 1530 occo 140 09650 Sep-11 6320 250 1590 150 0 8310 5840 250 1260 160 0 7510 Nov-11 4960 240 900 150 0 6250 Dec 11 4350 210 660 150 0 5370 Jan-12 6020 220 570 160 0 6970 Feb-12 7920 250 840 150 0 Mar-12 8430 270 1110 160 0 Apr-12 9040 310 1500 170 011020 May-12 9820 360 4448 18 1440 160 0 11780 Jun-12 10370 330 120 1410 170 012280 Jul-12 9050 310 wu 1440 160 0 10960 Aug- 7620 300 1410 170 0 9500 19 Sep-12 6420 280 1350 180 0 8230 Oct-12 5890 270 1080 180 07420 Nov-12 5340 260 840 190 0 6630 Dec-12 4430 230 510 180 0 5350 Jan-13 6100 250 480 100 200 0 7030 Feb-13 8010 270 750 190 0 9220 w Mar-13 8430 280 1140 200 200 010050 Apr-13 9110 320 1410 210 210 May-139730 380 1340 190 100 0 11640 Jun-13 10120 360 1360 200 1410 200 200 Aug-13 7820 310 1490 210 210 Sep-13 6540 300 1310 220 n Oct-13 6010 290 980 210 980 210 0 7490 7490 Nov-13 5270 270 220 770 220 o 6530 0 6530 Dec-13 5380 260 430 230 Jan-14 6210 270 400 200 07080 Feb-14 8030 280 750 190 0 9250 Mar-14 8540 300 970 210 010020 Apr-14 9120 340 1310 220 5 10995 May-14 9570 390 1260 200 16 11436 Jun-14 10230 380 1240 210 22 12082 Jul 14 9580 350 1300 230 26 11486 Aug-14 7680 340 1250 220 14' 9504 Sep-14 6870 320 1210 220 15 8635 Oct-14 5930 310 970 230 117451 Nov-14 5260 300 650 240 3' 6453 Dec-14 4830 290 300 230 1 5651 011050 012040 Jul-13 9080 320 011010 09830 08370 0' 6300 Tractor Unit Sales 240 0' 0 Month NA SA Eur Pac China World Jan-10 570 250 560 212 0 1592 Feb-10 611 270 600 230 01 1711 Mar-10 630 260 680 240 01 1810 Apr-10 684 270 650 263 0 1867 May-10 650 280 580 269 09 1779 Jun-10 600 270 590 280 0 1740 Jul-10 512 264 760 290 0 1826 Aug-10 500 280 645 270 200 0 219 1695 1099 Sep-10 478 234 290 650 263 01 1681 Oct-10 455 280 670 258 01 1663 Nov-10 407 290 888 0 U 1825 Dec-10 360 JOU 280 850 230 0 1720 Jan-11 Jan 11 571 320 620 620 250 0 U 1761 1761 Feb-11 650 350 350 760 275 0 2035 U 2035 Mar-11 740 390 742 270 0 2142 Apr-11 840 440 780 280 0 2340 2340 820 May-11 470 830 470 690 290 n 0 2280 Jun-11 760 2074 490 721 300 0 2271 Jul-11 681 481 680 312 0 01 2154 Aug-11 670 460 711 305 0 2146 146 ie Sep-11 640 460 695 290 moor 0 2085 Oct-11 620 440 650 260 1970 MO Nov-11 570 436 680 250 0 1936 Dec-11 533 420 657 240 1850 Jan-12 620 510 610 250 10 2000 Feb-12 792 590 680 250 121 2324 Mar-12 890 610 730 260 20 2510 Apr-12 960 600 820 270 22 2672 May-12 1040 040 620 810 290 20 2780 40 Jun-12 1032 640 207 807 310 2813 Jul-12 1006 590 760 340 2716 Aug-12 910 600 720 320 2581 245 Sep-12 803 670 660 302 313 30 2476 Oct-12 730 630 12 290 We 630 wa 371 2317 Nov-12 2011 699 710 603 280 32 2324 26 Dec-12 647 570 570 260 331 2080 Jan-13 730 650 287 500 wo 35 2202 Feb-13 930 680 590 290 50 2540 Mar-13 1160 724 620 300 JVU 63 O. 2867 Apr-13 1510 730 730 310 12 68 3348 00 May-13 1650 760 330 1034 740 00 70 3550 Jun-13 1490 1430 800 720 340 340 82' 3432 Jul-13 1460 840 670 350 80 OU 3400 Au.13 Aug-13 1390 830 830 610 610 341 90 3261 Sep-13 1360 820 599 330 100 3209 Oct-13 1340 810 560 220 102 320 3130 3132 Nov-13 ECO 2007 827 1240 110 550 300 110 3027 Dec 13 1103 750 44 520 290 2777 114 2777 Jan-14 700 1250 780 200 2821 Feb-14 1550 805 523 210 121 3209 Mar-14 1820 830 560 220 1237 3553 Apr-14 2010 890 570 230 3820 May-14 2230 930 590 253 130 4133 Jun-14 2490 980 600 4476 Jul-14 2440 1002 580 280 4436 Aug-14 2334 970 570 250 4256 Sep-14 2190 960 550 230 4067 Oct-14 2080 930 530 220 1307 3890 Nov-14 2050 920 517 190 1397 3816 Dec-14 2004 902 490 190 131' 3717 24 201 31 480 1111 120 136 270 134 132 137) Mower Unit Sales 0 11100 011930 010080 08430 Nov-10 5320 210 06650 05620 Dec-10 4640 180 O 7020 09030 Mav-11 9310 012270 9160 9970 Month NA SA Europe Pacific China World Jan-10 6000 200 720 100 0 7020 Feb-10 7950 220 990 120 0 9280 Mar-10 8100 250 1320 110 0' 9780 Apr-10 9050 280 1650 120 May-10 9900 310 1590 130 1000 Jun-10 10200 300 1620 120 012240 Jul-10 8730 280 1590 140 010740 Aug-10 8140 250 1560 130 1304 10 Sep-10 6480 230 1590 130 Toy Oct-10 5990 220 1320 120 120 07650 990 130 930 15U 660 140 DOU 140 Jan-11 5980 210 690 10 690 140 Feb-11 7620 240 1020 150 150 Mar-11 8370 250 1290 1290 140 0 10050 Apr-11 8830 290 1620 150 0 10890 330 1660 130 1650 130 0 11420 Jun-11 10230 310 1590 140 Jul-11 8720 290 1560 16 150 010720 Aug-11 7710 270 Arad 1530 occo 140 09650 Sep-11 6320 250 1590 150 0 8310 5840 250 1260 160 0 7510 Nov-11 4960 240 900 150 0 6250 Dec 11 4350 210 660 150 0 5370 Jan-12 6020 220 570 160 0 6970 Feb-12 7920 250 840 150 0 Mar-12 8430 270 1110 160 0 Apr-12 9040 310 1500 170 011020 May-12 9820 360 4448 18 1440 160 0 11780 Jun-12 10370 330 120 1410 170 012280 Jul-12 9050 310 wu 1440 160 0 10960 Aug- 7620 300 1410 170 0 9500 19 Sep-12 6420 280 1350 180 0 8230 Oct-12 5890 270 1080 180 07420 Nov-12 5340 260 840 190 0 6630 Dec-12 4430 230 510 180 0 5350 Jan-13 6100 250 480 100 200 0 7030 Feb-13 8010 270 750 190 0 9220 w Mar-13 8430 280 1140 200 200 010050 Apr-13 9110 320 1410 210 210 May-139730 380 1340 190 100 0 11640 Jun-13 10120 360 1360 200 1410 200 200 Aug-13 7820 310 1490 210 210 Sep-13 6540 300 1310 220 n Oct-13 6010 290 980 210 980 210 0 7490 7490 Nov-13 5270 270 220 770 220 o 6530 0 6530 Dec-13 5380 260 430 230 Jan-14 6210 270 400 200 07080 Feb-14 8030 280 750 190 0 9250 Mar-14 8540 300 970 210 010020 Apr-14 9120 340 1310 220 5 10995 May-14 9570 390 1260 200 16 11436 Jun-14 10230 380 1240 210 22 12082 Jul 14 9580 350 1300 230 26 11486 Aug-14 7680 340 1250 220 14' 9504 Sep-14 6870 320 1210 220 15 8635 Oct-14 5930 310 970 230 117451 Nov-14 5260 300 650 240 3' 6453 Dec-14 4830 290 300 230 1 5651 011050 012040 Jul-13 9080 320 011010 09830 08370 0' 6300 Tractor Unit Sales 240 0' 0 Month NA SA Eur Pac China World Jan-10 570 250 560 212 0 1592 Feb-10 611 270 600 230 01 1711 Mar-10 630 260 680 240 01 1810 Apr-10 684 270 650 263 0 1867 May-10 650 280 580 269 09 1779 Jun-10 600 270 590 280 0 1740 Jul-10 512 264 760 290 0 1826 Aug-10 500 280 645 270 200 0 219 1695 1099 Sep-10 478 234 290 650 263 01 1681 Oct-10 455 280 670 258 01 1663 Nov-10 407 290 888 0 U 1825 Dec-10 360 JOU 280 850 230 0 1720 Jan-11 Jan 11 571 320 620 620 250 0 U 1761 1761 Feb-11 650 350 350 760 275 0 2035 U 2035 Mar-11 740 390 742 270 0 2142 Apr-11 840 440 780 280 0 2340 2340 820 May-11 470 830 470 690 290 n 0 2280 Jun-11 760 2074 490 721 300 0 2271 Jul-11 681 481 680 312 0 01 2154 Aug-11 670 460 711 305 0 2146 146 ie Sep-11 640 460 695 290 moor 0 2085 Oct-11 620 440 650 260 1970 MO Nov-11 570 436 680 250 0 1936 Dec-11 533 420 657 240 1850 Jan-12 620 510 610 250 10 2000 Feb-12 792 590 680 250 121 2324 Mar-12 890 610 730 260 20 2510 Apr-12 960 600 820 270 22 2672 May-12 1040 040 620 810 290 20 2780 40 Jun-12 1032 640 207 807 310 2813 Jul-12 1006 590 760 340 2716 Aug-12 910 600 720 320 2581 245 Sep-12 803 670 660 302 313 30 2476 Oct-12 730 630 12 290 We 630 wa 371 2317 Nov-12 2011 699 710 603 280 32 2324 26 Dec-12 647 570 570 260 331 2080 Jan-13 730 650 287 500 wo 35 2202 Feb-13 930 680 590 290 50 2540 Mar-13 1160 724 620 300 JVU 63 O. 2867 Apr-13 1510 730 730 310 12 68 3348 00 May-13 1650 760 330 1034 740 00 70 3550 Jun-13 1490 1430 800 720 340 340 82' 3432 Jul-13 1460 840 670 350 80 OU 3400 Au.13 Aug-13 1390 830 830 610 610 341 90 3261 Sep-13 1360 820 599 330 100 3209 Oct-13 1340 810 560 220 102 320 3130 3132 Nov-13 ECO 2007 827 1240 110 550 300 110 3027 Dec 13 1103 750 44 520 290 2777 114 2777 Jan-14 700 1250 780 200 2821 Feb-14 1550 805 523 210 121 3209 Mar-14 1820 830 560 220 1237 3553 Apr-14 2010 890 570 230 3820 May-14 2230 930 590 253 130 4133 Jun-14 2490 980 600 4476 Jul-14 2440 1002 580 280 4436 Aug-14 2334 970 570 250 4256 Sep-14 2190 960 550 230 4067 Oct-14 2080 930 530 220 1307 3890 Nov-14 2050 920 517 190 1397 3816 Dec-14 2004 902 490 190 131' 3717 24 201 31 480 1111 120 136 270 134 132 137)

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 Finance Questions!