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

Please show how you find the answer

DATA

Tractor Unit Sales

Month NA SA Eur Pacific China World

Jan-14 570 250 560 212 0 1592

Feb-14 611 270 600 230 0 1711

Mar-14 630 260 680 240 0 1810

Apr-14 684 270 650 263 0 1867

May-14 650 280 580 269 0 1779

Jun-14 600 270 590 280 0 1740

Jul-14 512 264 760 290 0 1826

Aug-14 500 280 645 270 0 1695

Sep-14 478 290 650 263 0 1681

Oct-14 455 280 670 258 0 1663

Nov-14 407 290 888 240 0 1825

Dec-14 360 280 850 230 0 1720

Jan-15 571 320 620 250 0 1761

Feb-15 650 350 760 275 0 2035

Mar-15 740 390 742 270 0 2142

Apr-15 840 440 780 280 0 2340

May-15 830 470 690 290 0 2280

Jun-15 760 490 721 300 0 2271

Jul-15 681 481 680 312 0 2154

Aug-15 670 460 711 305 0 2146

Sep-15 640 460 695 290 0 2085

Oct-15 620 440 650 260 0 1970

Nov-15 570 436 680 250 0 1936

Dec-15 533 420 657 240 0 1850

Jan-16 620 510 610 250 10 2000

Feb-16 792 590 680 250 12 2324

Mar-16 890 610 730 260 20 2510

Apr-16 960 600 820 270 22 2672

May-16 1040 620 810 290 20 2780

Jun-16 1032 640 807 310 24 2813

Jul-16 1006 590 760 340 20 2716

Aug-16 910 600 720 320 31 2581

Sep-16 803 670 660 313 30 2476

Oct-16 730 630 630 290 37 2317

Nov-16 699 710 603 280 32 2324

Dec-16 647 570 570 260 33 2080

Jan-17 730 650 500 287 35 2202

Feb-17 930 680 590 290 50 2540

Mar-17 1160 724 620 300 63 2867

Apr-17 1510 730 730 310 68 3348

May-17 1650 760 740 330 70 3550

Jun-17 1490 800 720 340 82 3432

Jul-17 1460 840 670 350 80 3400

Aug-17 1390 830 610 341 90 3261

Sep-17 1360 820 599 330 100 3209

Oct-17 1340 810 560 320 102 3132

Nov-17 1240 827 550 300 110 3027

Dec-17 1103 750 520 290 114 2777

Jan-18 1250 780 480 200 111 2821

Feb-18 1550 805 523 210 121 3209

Mar-18 1820 830 560 220 123 3553

Apr-18 2010 890 570 230 120 3820

May-18 2230 930 590 253 130 4133

Jun-18 2490 980 600 270 136 4476

Jul-18 2440 1002 580 280 134 4436

Aug-18 2334 970 570 250 132 4256

Sep-18 2190 960 550 230 137 4067

Oct-18 2080 930 530 220 130 3890

Nov-18 2050 920 517 190 139 3816

Dec-18 2004 902 490 190 131 3717