Question: 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

Old MathJax webview

Old MathJax webview This is the PLE chart This is the question

This is the PLE chart

This is the Mower Unit Sales below This is the Tractor Unit

This is the question

This is the Mower Unit Sales below

Sales below This is the Mower Unit Sales below This is the

Tractor Unit Sales below 3. Next, Elizabeth has provided you with prices

This is the Tractor Unit Sales below

for PLE products for the past five years: Prices for PLE products

for the past five years Year Mower Price Tractor Price 2014 $150

This is the Mower Unit Sales below

$3,250 2015 $175 $3,400 2016 $180 $3,600 2017 $185 $3.700 2018 $190

$3,800 1. gross revenues by month and region, as well as worldwide

This is the Tractor Unit Sales below

totals, for each product using the data in Mower Unit Sales and

Tractor Unit Sales. Create a new worksheet titled "Gross Profit". Using the

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 1. 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 titled "Gross Profit". Using the information in the table above combined with the sales information from the data in the "Mower Unit Sales" and "Tractor Unit Sales" calculate gross profit for each month for each region and the world. 1 Mover Unit Sales China Vorld 0 0 0 7020 9280 9780 11100 11930 0 0 0 12240 0 0 0 0 0 0 0 0 0 0 0 0 3 Month NA SA Jan-14 6000 5 Feb-14 7950 6 Mar 14 Apr-14 9050 May-14 9900 Jun-14 10200 Jul-14 8730 1 Aug-14 8140 Sep-14 6480 Oct-14 5990 13 Nov-14 Dec-14 4640 16 Jan-15 5980 Feb 15 - 7620 18 Nar 15 Apr-15 8830 May-15 9310 Jun 15 10230 Jul 15 8720 Aug-15 7710 Sep-15 Oct 15 5840 Nov-15 4960 Dec 15 4350 28 Jan-16 6020 29 Feb-16 7920 Mar 16 31 Apr-16 9040 May-16 9820 Jun-16 10370 Jul-16 9050 Aug-16 7620 36 Sep-16 6420 Oct-16 5890 Hov-16 5340 38 Dec-16 4430 10 Jan-17 6100 41 Feb-17 8010 42 Mar-17 8430 46 Apr-17 44 May-17 8730 45 Jun-17 10120 46 Jul-17 8080 0 10740 10080 8430 7650 6650 5620 7020 9030 10050 10890 11420 12270 10720 9650 8310 Europe Pacific 200 100 220 1990 120 250 1320 110 280 1650 120 310 1590 130 300 1620 120 280 1590 140 250 1560 130 230 1590 130 1320 120 210 990 130 180 660 140 210 690 140 240 1020 150 250 1290 140 290 1620 150 330 1650 130 310 1590 140 290 1560 150 270 1530 140 250 1590 150 250 1260 160 240 900 150 210 660 150 220 570 160 250 840 150 270 1110 160 310 1500 170 360 1440 160 330 14 10 170 310 1440 160 300 1410 170 280 1350 180 270 180 260 840 190 230 510 180 250 480 200 270 750 190 280 1140 200 320 1410 210 380 1340 190 360 1360 200 320 1410 200 7510 0 0 0 0 0 0 0 00 0 0 6250 5370 6970 9160 9970 11020 11780 12280 10960 9500 8230 7420 6680 5850 7030 9220 10050 11050 11640 0 1080 0 0 0 U 0 0 0 0 12040 11010 Com MAW slee Tarton galas Indust E F H 7820 310 9830 1310 210 7490 6580 0 0 230 5270 5380 6210 8030 8540 9120 53 190 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 430 400 750 970 1810 1260 5 10025 16 11442 12086 9580 350 210 230 26 14 15 9505 11 1250 1210 970 650 240 1 7443 6451 5650 230 1 Tractor Unit Sales SA Eur China Vorld 250 270 Pacific 560 600 680 650 580 230 570 611 630 684 650 600 512 260 0 0 0 0 0 1592 1711 1810 1867 1779 590 268 269 280 290 270 280 270 264 280 290 280 0 500 760 645 650 670 889 850 0 0 0 0 0 0 455 258 240 230 360 571 250 650 760 275 270 0 0 740 840 280 320 350 390 440 470 490 481 460 460 280 290 300 312 0 0 760 681 670 305 3 Month NA Jan-14 5 Feb-14 Mar-14 1 Apr-14 S May-14 9 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 13 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 23 Aug-15 Sep-15 Bet-15 Noy-15 - Bee 15 Jan-16 Feb-16 Mar-16 3 Apr-16 May-16 Jun 16 Jul-16 Aug-16 Sep-16 Get-16 Nov 16 Bec-16 Jan-17 Feb-17 4.2 Mar-17 Apr-17 May-17 Jun-17 Jul-17 0 640 620 1826 1895 1681 1668 1825 1720 1761 2035 2142 2340 2280 2271 2154 2146 2085 1970 1936 1850 2000 2324 2510 2672 2780 2813 2716 2581 2476 2317 2824 2080 440 0 570 742 780 690 721 680 711 695 650 680 657 610 680 730 820 810 807 760 720 O 533 420 0 510 590 610 290 260 250 240 250 250 260 270 290 310 340 620 792 890 960 1040 1032 1006 910 12 22 20 24 20 803 313 660 630 608 30 37 290 600 620 640 590 600 670 630 710 570 650 680 724 730 760 800 840 570 730 699 647 730 930 1160 1510 1650 1490 1460 33 500 590 620 ] 730 740 720 670 1280 260 287 290 300 310 330 340 350 50 63 678 TO 812 80 2540 2867 3648 3550 3432 3400 10 42 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 100 102 110 121 5 Mar-18 123 130 186 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 132 137 130 139 B c O LIN G m Moser Unit Sales 3 Month NA SA China World 6000 7950 --- 7020 9280 9780 9050 9900 10200 8780 11930 2240 10740 10080 12 13 6480 5990 5320 4640 5980 210 15 16 17 oooooooooooo0000000000000000 18 8370 8830 19 Europe Pacific 200 720 220 250 1320 1650 1590 BO 7620 120 1590 140 250 1560 130 7590 130 1320 120 990 130 140 140 240 150 1290 140 290 1620 150 1650 130 1590 290 1560 150 270 1530 140 250 1590 150 250 1260 160 240 900 150 210 660 150 220 570 160 250 840 150 1110 160 310 1500 170 360 1440 160 330 1410 170 310 1440 160 300 1410 170 280 1350 180 270 1080 180 260 840 190 230 180 250 480 200 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Har-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct 16 Nov-16 Dec-16 Jan-17 20 21 22 23 24 25 7650 6650 5620 7020 9030 10050 10890 11420 12270 10720 9650 8310 7510 6250 5370 6970 9160 9970 11020 11780 12280 10960 9500 8230 7420 6630 5350 7030 26 27 28 29 10230 8720 7710 6320 5840 4960 4350 6020 7920 8430 9040 9820 10370 9050 7620 6420 5890 5340 4430 6100 30 270 0 37 POOOOOOO 40 x F H H OOOO 270 280 320 380 360 320 310 300 290 0 0 0 0 0 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 270 8010 8430 9110 9730 10120 9080 7820 6540 6010 5270 5380 6210 8030 8540 9120 9570 10230 9580 7680 6870 5930 5260 4830 G 9220 10050 11050 11640 12040 11010 9830 8370 7490 6530 6300 7080 D 750 1140 1410 1340 1360 1410 1490 1310 980 770 430 400 750 970 1310 1260 1240 1300 1250 1210 970 650 300 260 270 280 300 340 390 380 350 340 E 190 200 210 190 200 200 210 220 210 220 230 200 190 210 220 200 210 230 220 220 230 240 230 5 16 26 14 15 11 3 O-Q=ONG DOO 10025 11006 11442 12086 11474 9505 8631 7443 6451 5650 310 300 290 Y11 X fo E D G H c B 1 Tractor Unit Sales 2 3 Month NA SA 4 *** 570 5 *** 611 630 2 *** 684 8 ### 650 9 **** 10 Jul-14 512 11 500 478 ***** 5 *** *** 571 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 200 850 320 25 742 World 1592 1711 0 1810 0 1867 1779 1740 1826 1695 1681 1663 1825 7720 1761 2035 2142 240 290 490 721 680 2280 2271 2154 2 Jul-15 681 670 312 305 290 OOOOO000000000000000e98s8385868883 460 2085 1850 28 260 270 24 23 Jul 16 760 2324 2510 2672 2780 2813 2716 2581 2476 2317 2324 2080 2202 620 640 590 600 670 630 710 570 650 320 31 30 730 699 647 730 603 570 500 290 280 260 287 35 Dealer Satisfaction End-User Satisfaction Customer Surve Ready 11 B C F ESU CI 42 # FS 4 E 25 300 310 330 24 61 7180 760 800 840 SG 620 730 740 CD) ETU F10 599 SEO 46 | 47 48 330 100 50 750 51 90 1160 1510 1650 1490 1460 EED 1340 1240 1250 1820 2010 2230 2490 2440 2334 2190 2080 2050 2004 ST 200 114 iii 1 2540 2867 3348 3550 3432 3400 3261 3209 3132 3027 2821 3209 3553 SSD 4133 TE 44b 4256 JUST TEST) 3816 480 5 830 560 570 590 Em 580 570 8 Jul- ### 61 2 68 64 930 980 1002 970 960 930 920 902 253 20 280 250 230 220 190 190 120 130 736 154 132 G 130 139 131 550 530 517 490 517 65 IEEE DE 69 CD 4 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 1. 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 titled "Gross Profit". Using the information in the table above combined with the sales information from the data in the "Mower Unit Sales" and "Tractor Unit Sales" calculate gross profit for each month for each region and the world. 1 Mover Unit Sales China Vorld 0 0 0 7020 9280 9780 11100 11930 0 0 0 12240 0 0 0 0 0 0 0 0 0 0 0 0 3 Month NA SA Jan-14 6000 5 Feb-14 7950 6 Mar 14 Apr-14 9050 May-14 9900 Jun-14 10200 Jul-14 8730 1 Aug-14 8140 Sep-14 6480 Oct-14 5990 13 Nov-14 Dec-14 4640 16 Jan-15 5980 Feb 15 - 7620 18 Nar 15 Apr-15 8830 May-15 9310 Jun 15 10230 Jul 15 8720 Aug-15 7710 Sep-15 Oct 15 5840 Nov-15 4960 Dec 15 4350 28 Jan-16 6020 29 Feb-16 7920 Mar 16 31 Apr-16 9040 May-16 9820 Jun-16 10370 Jul-16 9050 Aug-16 7620 36 Sep-16 6420 Oct-16 5890 Hov-16 5340 38 Dec-16 4430 10 Jan-17 6100 41 Feb-17 8010 42 Mar-17 8430 46 Apr-17 44 May-17 8730 45 Jun-17 10120 46 Jul-17 8080 0 10740 10080 8430 7650 6650 5620 7020 9030 10050 10890 11420 12270 10720 9650 8310 Europe Pacific 200 100 220 1990 120 250 1320 110 280 1650 120 310 1590 130 300 1620 120 280 1590 140 250 1560 130 230 1590 130 1320 120 210 990 130 180 660 140 210 690 140 240 1020 150 250 1290 140 290 1620 150 330 1650 130 310 1590 140 290 1560 150 270 1530 140 250 1590 150 250 1260 160 240 900 150 210 660 150 220 570 160 250 840 150 270 1110 160 310 1500 170 360 1440 160 330 14 10 170 310 1440 160 300 1410 170 280 1350 180 270 180 260 840 190 230 510 180 250 480 200 270 750 190 280 1140 200 320 1410 210 380 1340 190 360 1360 200 320 1410 200 7510 0 0 0 0 0 0 0 00 0 0 6250 5370 6970 9160 9970 11020 11780 12280 10960 9500 8230 7420 6680 5850 7030 9220 10050 11050 11640 0 1080 0 0 0 U 0 0 0 0 12040 11010 Com MAW slee Tarton galas Indust E F H 7820 310 9830 1310 210 7490 6580 0 0 230 5270 5380 6210 8030 8540 9120 53 190 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 430 400 750 970 1810 1260 5 10025 16 11442 12086 9580 350 210 230 26 14 15 9505 11 1250 1210 970 650 240 1 7443 6451 5650 230 1 Tractor Unit Sales SA Eur China Vorld 250 270 Pacific 560 600 680 650 580 230 570 611 630 684 650 600 512 260 0 0 0 0 0 1592 1711 1810 1867 1779 590 268 269 280 290 270 280 270 264 280 290 280 0 500 760 645 650 670 889 850 0 0 0 0 0 0 455 258 240 230 360 571 250 650 760 275 270 0 0 740 840 280 320 350 390 440 470 490 481 460 460 280 290 300 312 0 0 760 681 670 305 3 Month NA Jan-14 5 Feb-14 Mar-14 1 Apr-14 S May-14 9 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 13 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 23 Aug-15 Sep-15 Bet-15 Noy-15 - Bee 15 Jan-16 Feb-16 Mar-16 3 Apr-16 May-16 Jun 16 Jul-16 Aug-16 Sep-16 Get-16 Nov 16 Bec-16 Jan-17 Feb-17 4.2 Mar-17 Apr-17 May-17 Jun-17 Jul-17 0 640 620 1826 1895 1681 1668 1825 1720 1761 2035 2142 2340 2280 2271 2154 2146 2085 1970 1936 1850 2000 2324 2510 2672 2780 2813 2716 2581 2476 2317 2824 2080 440 0 570 742 780 690 721 680 711 695 650 680 657 610 680 730 820 810 807 760 720 O 533 420 0 510 590 610 290 260 250 240 250 250 260 270 290 310 340 620 792 890 960 1040 1032 1006 910 12 22 20 24 20 803 313 660 630 608 30 37 290 600 620 640 590 600 670 630 710 570 650 680 724 730 760 800 840 570 730 699 647 730 930 1160 1510 1650 1490 1460 33 500 590 620 ] 730 740 720 670 1280 260 287 290 300 310 330 340 350 50 63 678 TO 812 80 2540 2867 3648 3550 3432 3400 10 42 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 100 102 110 121 5 Mar-18 123 130 186 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 132 137 130 139 B c O LIN G m Moser Unit Sales 3 Month NA SA China World 6000 7950 --- 7020 9280 9780 9050 9900 10200 8780 11930 2240 10740 10080 12 13 6480 5990 5320 4640 5980 210 15 16 17 oooooooooooo0000000000000000 18 8370 8830 19 Europe Pacific 200 720 220 250 1320 1650 1590 BO 7620 120 1590 140 250 1560 130 7590 130 1320 120 990 130 140 140 240 150 1290 140 290 1620 150 1650 130 1590 290 1560 150 270 1530 140 250 1590 150 250 1260 160 240 900 150 210 660 150 220 570 160 250 840 150 1110 160 310 1500 170 360 1440 160 330 1410 170 310 1440 160 300 1410 170 280 1350 180 270 1080 180 260 840 190 230 180 250 480 200 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Har-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct 16 Nov-16 Dec-16 Jan-17 20 21 22 23 24 25 7650 6650 5620 7020 9030 10050 10890 11420 12270 10720 9650 8310 7510 6250 5370 6970 9160 9970 11020 11780 12280 10960 9500 8230 7420 6630 5350 7030 26 27 28 29 10230 8720 7710 6320 5840 4960 4350 6020 7920 8430 9040 9820 10370 9050 7620 6420 5890 5340 4430 6100 30 270 0 37 POOOOOOO 40 x F H H OOOO 270 280 320 380 360 320 310 300 290 0 0 0 0 0 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 270 8010 8430 9110 9730 10120 9080 7820 6540 6010 5270 5380 6210 8030 8540 9120 9570 10230 9580 7680 6870 5930 5260 4830 G 9220 10050 11050 11640 12040 11010 9830 8370 7490 6530 6300 7080 D 750 1140 1410 1340 1360 1410 1490 1310 980 770 430 400 750 970 1310 1260 1240 1300 1250 1210 970 650 300 260 270 280 300 340 390 380 350 340 E 190 200 210 190 200 200 210 220 210 220 230 200 190 210 220 200 210 230 220 220 230 240 230 5 16 26 14 15 11 3 O-Q=ONG DOO 10025 11006 11442 12086 11474 9505 8631 7443 6451 5650 310 300 290 Y11 X fo E D G H c B 1 Tractor Unit Sales 2 3 Month NA SA 4 *** 570 5 *** 611 630 2 *** 684 8 ### 650 9 **** 10 Jul-14 512 11 500 478 ***** 5 *** *** 571 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 200 850 320 25 742 World 1592 1711 0 1810 0 1867 1779 1740 1826 1695 1681 1663 1825 7720 1761 2035 2142 240 290 490 721 680 2280 2271 2154 2 Jul-15 681 670 312 305 290 OOOOO000000000000000e98s8385868883 460 2085 1850 28 260 270 24 23 Jul 16 760 2324 2510 2672 2780 2813 2716 2581 2476 2317 2324 2080 2202 620 640 590 600 670 630 710 570 650 320 31 30 730 699 647 730 603 570 500 290 280 260 287 35 Dealer Satisfaction End-User Satisfaction Customer Surve Ready 11 B C F ESU CI 42 # FS 4 E 25 300 310 330 24 61 7180 760 800 840 SG 620 730 740 CD) ETU F10 599 SEO 46 | 47 48 330 100 50 750 51 90 1160 1510 1650 1490 1460 EED 1340 1240 1250 1820 2010 2230 2490 2440 2334 2190 2080 2050 2004 ST 200 114 iii 1 2540 2867 3348 3550 3432 3400 3261 3209 3132 3027 2821 3209 3553 SSD 4133 TE 44b 4256 JUST TEST) 3816 480 5 830 560 570 590 Em 580 570 8 Jul- ### 61 2 68 64 930 980 1002 970 960 930 920 902 253 20 280 250 230 220 190 190 120 130 736 154 132 G 130 139 131 550 530 517 490 517 65 IEEE DE 69 CD 4

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!

EXECEL Performance Lawn Equipment (PLE) - Read the file description in pages 31-32 and answer the following questions.Your manager, Elizabeth Burke, has received several questions from other managers...

Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database. CHAPTER 2: Elizabeth Burke has asked you to do some preliminary analysis of the...

Dealer Satisfaction End-User Satisfaction Customer S Dealer Satisfaction 0 1 2 3 4 Survey Scale: North America 2014 2015 2016 2017 2018 1 0 1 1 2 NOO 2 2 1 6 14 14 8 12 15 22 20 34 34 44 5 Sample...

PLE, headquartered in St. Louis, Missouri, is a privately owned designer and producer of traditional lawn mowers used by homeowners. In the past 10 years, PLE has added another key product, a...

Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database. First, she would like you to edit the worksheets Dealer Satisfaction and End-User...

I'm Just looking for help on Part 1, question A. I have uploaded the information above. CASE: PERFORMANCE LAWN EQUIPMENT Part 1: PLE originally produced lawn mowers, but a significant portion of...

I JUST NEED QUESTION PART 3, PLEASE! Part 1: PLE originally produced lawn mowers, but a significant portion of sales volume over recent years has come from the growing small- tractor market. As we...

Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment Database.xlsx. First, she would like you to edit the worksheets Dealer Satisfaction and...

Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database. First, she would like you to edit the worksheets Dealer Satisfaction and End-...

The Repo 105 transactions reduced Lehmans net leverage ratio from 17.8 to 16.1 at the end of fiscal 2007. Do you believe that was a material difference? Why or why not?

An automobile dealership offers to fill the four tires of your new car with 100% nitrogen for a cost of $20. The dealership claims that nitrogen-filled tires run cooler than those filled with...

Which of the following statements is NOI correct? Investors can interpret a stock repurchase program as a signal that the firm's managers believe the stock is undervalued. Companies can repurchase...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...