Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Math In Plain English Literacy Strategies For The Mathematics Classroom

Authors: Amy Benjamin

1st Edition

1317926757, 9781317926757

More Books

Students also viewed these Mathematics questions

Question

What are the various types of benchmarking?

Answered: 1 week ago

Question

Define budget. How are budgets used in planning? LO1

Answered: 1 week ago