Question: I am not sure how to do solve this problem Next, Elizabeth has provided you with prices for PLE products for the past five years:
I am not sure how to do solve this problem
Next, Elizabeth has provided you with 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 |
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.
Tractor Unit Sales
| Month | NA | SA | Eur | Pacific | China | World |
| 1-14 | 570 | 250 | 560 | 212 | 0 | 1592 |
| 2-14 | 611 | 270 | 600 | 230 | 0 | 1711 |
| 3-14 | 630 | 260 | 680 | 240 | 0 | 1810 |
| 4-14 | 684 | 270 | 650 | 263 | 0 | 1867 |
| 5-14 | 650 | 280 | 580 | 269 | 0 | 1779 |
| 6-14 | 600 | 270 | 590 | 280 | 0 | 1740 |
| 7-14 | 512 | 264 | 760 | 290 | 0 | 1826 |
| 8-14 | 500 | 280 | 645 | 270 | 0 | 1695 |
| 9-14 | 478 | 290 | 650 | 263 | 0 | 1681 |
| 10-14 | 455 | 280 | 670 | 258 | 0 | 1663 |
| 11-14 | 407 | 290 | 888 | 240 | 0 | 1825 |
| 12-14 | 360 | 280 | 850 | 230 | 0 | 1720 |
| 1-15 | 571 | 320 | 620 | 250 | 0 | 1761 |
| 2-15 | 650 | 350 | 760 | 275 | 0 | 2035 |
| 3-15 | 740 | 390 | 742 | 270 | 0 | 2142 |
| 4-15 | 840 | 440 | 780 | 280 | 0 | 2340 |
| 5-15 | 830 | 470 | 690 | 290 | 0 | 2280 |
| 6-15 | 760 | 490 | 721 | 300 | 0 | 2271 |
| 7-15 | 681 | 481 | 680 | 312 | 0 | 2154 |
| 8-15 | 670 | 460 | 711 | 305 | 0 | 2146 |
| 9-15 | 640 | 460 | 695 | 290 | 0 | 2085 |
| 10-15 | 620 | 440 | 650 | 260 | 0 | 1970 |
| 11-15 | 570 | 436 | 680 | 250 | 0 | 1936 |
| 12-15 | 533 | 420 | 657 | 240 | 0 | 1850 |
| 1-16 | 620 | 510 | 610 | 250 | 10 | 2000 |
| 2-16 | 792 | 590 | 680 | 250 | 12 | 2324 |
| 3-16 | 890 | 610 | 730 | 260 | 20 | 2510 |
| 4-16 | 960 | 600 | 820 | 270 | 22 | 2672 |
| 5-16 | 1040 | 620 | 810 | 290 | 20 | 2780 |
| 6-16 | 1032 | 640 | 807 | 310 | 24 | 2813 |
| 7-16 | 1006 | 590 | 760 | 340 | 20 | 2716 |
| 8-16 | 910 | 600 | 720 | 320 | 31 | 2581 |
| 9-16 | 803 | 670 | 660 | 313 | 30 | 2476 |
| 10-16 | 730 | 630 | 630 | 290 | 37 | 2317 |
| 11-16 | 699 | 710 | 603 | 280 | 32 | 2324 |
| 12-16 | 647 | 570 | 570 | 260 | 33 | 2080 |
| 1-17 | 730 | 650 | 500 | 287 | 35 | 2202 |
| 2-17 | 930 | 680 | 590 | 290 | 50 | 2540 |
| 3-17 | 1160 | 724 | 620 | 300 | 63 | 2867 |
| 4-17 | 1510 | 730 | 730 | 310 | 68 | 3348 |
| 5-17 | 1650 | 760 | 740 | 330 | 70 | 3550 |
| 6-17 | 1490 | 800 | 720 | 340 | 82 | 3432 |
| 7-17 | 1460 | 840 | 670 | 350 | 80 | 3400 |
| 8-17 | 1390 | 830 | 610 | 341 | 90 | 3261 |
| 9-17 | 1360 | 820 | 599 | 330 | 100 | 3209 |
| 10-17 | 1340 | 810 | 560 | 320 | 102 | 3132 |
| 11-17 | 1240 | 827 | 550 | 300 | 110 | 3027 |
| 12-17 | 1103 | 750 | 520 | 290 | 114 | 2777 |
| 1-18 | 1250 | 780 | 480 | 200 | 111 | 2821 |
| 2-18 | 1550 | 805 | 523 | 210 | 121 | 3209 |
| 3-18 | 1820 | 830 | 560 | 220 | 123 | 3553 |
| 4-18 | 2010 | 890 | 570 | 230 | 120 | 3820 |
| 5-18 | 2230 | 930 | 590 | 253 | 130 | 4133 |
| 6-18 | 2490 | 980 | 600 | 270 | 136 | 4476 |
| 7-18 | 2440 | 1002 | 580 | 280 | 134 | 4436 |
| 8-18 | 2334 | 970 | 570 | 250 | 132 | 4256 |
| 9-18 | 2190 | 960 | 550 | 230 | 137 | 4067 |
| 10-18 | 2080 | 930 | 530 | 220 | 130 | 3890 |
| 11-18 | 2050 | 920 | 517 | 190 | 139 | 3816 |
| 12-18 | 2004 | 902 | 490 | 190 | 131 | 3717 |
| Mower Unit Sales |
| Month | NA | SA | Europe | Pacific | China | World |
| 1-14 | 6000 | 200 | 720 | 100 | 0 | 7020 |
| 2-14 | 7950 | 220 | 990 | 120 | 0 | 9280 |
| 3-14 | 8100 | 250 | 1320 | 110 | 0 | 9780 |
| 4-14 | 9050 | 280 | 1650 | 120 | 0 | 11100 |
| 5-14 | 9900 | 310 | 1590 | 130 | 0 | 11930 |
| 6-14 | 10200 | 300 | 1620 | 120 | 0 | 12240 |
| 7-14 | 8730 | 280 | 1590 | 140 | 0 | 10740 |
| 8-14 | 8140 | 250 | 1560 | 130 | 0 | 10080 |
| 9-14 | 6480 | 230 | 1590 | 130 | 0 | 8430 |
| 10-14 | 5990 | 220 | 1320 | 120 | 0 | 7650 |
| 11-14 | 5320 | 210 | 990 | 130 | 0 | 6650 |
| 12-14 | 4640 | 180 | 660 | 140 | 0 | 5620 |
| 1-15 | 5980 | 210 | 690 | 140 | 0 | 7020 |
| 2-15 | 7620 | 240 | 1020 | 150 | 0 | 9030 |
| 3-15 | 8370 | 250 | 1290 | 140 | 0 | 10050 |
| 4-15 | 8830 | 290 | 1620 | 150 | 0 | 10890 |
| 5-15 | 9310 | 330 | 1650 | 130 | 0 | 11420 |
| 6-15 | 10230 | 310 | 1590 | 140 | 0 | 12270 |
| 7-15 | 8720 | 290 | 1560 | 150 | 0 | 10720 |
| 8-15 | 7710 | 270 | 1530 | 140 | 0 | 9650 |
| 9-15 | 6320 | 250 | 1590 | 150 | 0 | 8310 |
| 10-15 | 5840 | 250 | 1260 | 160 | 0 | 7510 |
| 11-15 | 4960 | 240 | 900 | 150 | 0 | 6250 |
| 12-15 | 4350 | 210 | 660 | 150 | 0 | 5370 |
| 1-16 | 6020 | 220 | 570 | 160 | 0 | 6970 |
| 2-16 | 7920 | 250 | 840 | 150 | 0 | 9160 |
| 3-16 | 8430 | 270 | 1110 | 160 | 0 | 9970 |
| 4-16 | 9040 | 310 | 1500 | 170 | 0 | 11020 |
| 5-16 | 9820 | 360 | 1440 | 160 | 0 | 11780 |
| 6-16 | 10370 | 330 | 1410 | 170 | 0 | 12280 |
| 7-16 | 9050 | 310 | 1440 | 160 | 0 | 10960 |
| 8-16 | 7620 | 300 | 1410 | 170 | 0 | 9500 |
| 9-16 | 6420 | 280 | 1350 | 180 | 0 | 8230 |
| 10-16 | 5890 | 270 | 1080 | 180 | 0 | 7420 |
| 11-16 | 5340 | 260 | 840 | 190 | 0 | 6630 |
| 12-16 | 4430 | 230 | 510 | 180 | 0 | 5350 |
| 1-17 | 6100 | 250 | 480 | 200 | 0 | 7030 |
| 2-17 | 8010 | 270 | 750 | 190 | 0 | 9220 |
| 3-17 | 8430 | 280 | 1140 | 200 | 0 | 10050 |
| 4-17 | 9110 | 320 | 1410 | 210 | 0 | 11050 |
| 5-17 | 9730 | 380 | 1340 | 190 | 0 | 11640 |
| 6-17 | 10120 | 360 | 1360 | 200 | 0 | 12040 |
| 7-17 | 9080 | 320 | 1410 | 200 | 0 | 11010 |
| 8-17 | 7820 | 310 | 1490 | 210 | 0 | 9830 |
| 9-17 | 6540 | 300 | 1310 | 220 | 0 | 8370 |
| 10-17 | 6010 | 290 | 980 | 210 | 0 | 7490 |
| 11-17 | 5270 | 270 | 770 | 220 | 0 | 6530 |
| 12-17 | 5380 | 260 | 430 | 230 | 0 | 6300 |
| 1-18 | 6210 | 270 | 400 | 200 | 0 | 7080 |
| 2-18 | 8030 | 280 | 750 | 190 | 0 | 9250 |
| 3-18 | 8540 | 300 | 970 | 210 | 5 | 10025 |
| 4-18 | 9120 | 340 | 1310 | 220 | 16 | 11006 |
| 5-18 | 9570 | 390 | 1260 | 200 | 22 | 11442 |
| 6-18 | 10230 | 380 | 1240 | 210 | 26 | 12086 |
| 7-18 | 9580 | 350 | 1300 | 230 | 14 | 11474 |
| 8-18 | 7680 | 340 | 1250 | 220 | 15 | 9505 |
| 9-18 | 6870 | 320 | 1210 | 220 | 11 | 8631 |
| 10-18 | 5930 | 310 | 970 | 230 | 3 | 7443 |
| 11-18 | 5260 | 300 | 650 | 240 | 1 | 6451 |
| 12-18 | 4830 | 290 | 300 | 230 | 0 | 5650 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
