An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers in each marketing region, to assess future changes in market share. .Develop forecasting models for these data and prepare a report of your results with appropriate charts and output from Excel.

Please show me how you get the answer. Thank you

DATA

Mower Unit Sales

Month NA SA Europe Pacific China World

Jan-14 6000 200 720 100 0 7020

Feb-14 7950 220 990 120 0 9280

Mar-14 8100 250 1320 110 0 9780

Apr-14 9050 280 1650 120 0 11100

May-14 9900 310 1590 130 0 11930

Jun-14 10200 300 1620 120 0 12240

Jul-14 8730 280 1590 140 0 10740

Aug-14 8140 250 1560 130 0 10080

Sep-14 6480 230 1590 130 0 8430

Oct-14 5990 220 1320 120 0 7650

Nov-14 5320 210 990 130 0 6650

Dec-14 4640 180 660 140 0 5620

Jan-15 5980 210 690 140 0 7020

Feb-15 7620 240 1020 150 0 9030

Mar-15 8370 250 1290 140 0 10050

Apr-15 8830 290 1620 150 0 10890

May-15 9310 330 1650 130 0 11420

Jun-15 10230 310 1590 140 0 12270

Jul-15 8720 290 1560 150 0 10720

Aug-15 7710 270 1530 140 0 9650

Sep-15 6320 250 1590 150 0 8310

Oct-15 5840 250 1260 160 0 7510

Nov-15 4960 240 900 150 0 6250

Dec-15 4350 210 660 150 0 5370

Jan-16 6020 220 570 160 0 6970

Feb-16 7920 250 840 150 0 9160

Mar-16 8430 270 1110 160 0 9970

Apr-16 9040 310 1500 170 0 11020

May-16 9820 360 1440 160 0 11780

Jun-16 10370 330 1410 170 0 12280

Jul-16 9050 310 1440 160 0 10960

Aug-16 7620 300 1410 170 0 9500

Sep-16 6420 280 1350 180 0 8230

Oct-16 5890 270 1080 180 0 7420

Nov-16 5340 260 840 190 0 6630

Dec-16 4430 230 510 180 0 5350

Jan-17 6100 250 480 200 0 7030

Feb-17 8010 270 750 190 0 9220

Mar-17 8430 280 1140 200 0 10050

Apr-17 9110 320 1410 210 0 11050

May-17 9730 380 1340 190 0 11640

Jun-17 10120 360 1360 200 0 12040

Jul-17 9080 320 1410 200 0 11010

Aug-17 7820 310 1490 210 0 9830

Sep-17 6540 300 1310 220 0 8370

Oct-17 6010 290 980 210 0 7490

Nov-17 5270 270 770 220 0 6530

Dec-17 5380 260 430 230 0 6300

Jan-18 6210 270 400 200 0 7080

Feb-18 8030 280 750 190 0 9250

Mar-18 8540 300 970 210 5 10025

Apr-18 9120 340 1310 220 16 11006

May-18 9570 390 1260 200 22 11442

Jun-18 10230 380 1240 210 26 12086

Jul-18 9580 350 1300 230 14 11474

Aug-18 7680 340 1250 220 15 9505

Sep-18 6870 320 1210 220 11 8631

Oct-18 5930 310 970 230 3 7443

Nov-18 5260 300 650 240 1 6451

Dec-18 4830 290 300 230 0 5650