An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting industry tractor sales, 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.

Industry Tractor Total Sales

Month NA SA Eur Pac China World

Jan-14 8143 984 5091 987 278 15483

Feb-14 8592 1051 5310 1090 283 16325

Mar-14 8630 1016 6071 1127 285 17129

Apr-14 8947 1027 5856 1209 288 17327

May-14 8442 1057 5273 1221 286 16278

Jun-14 7500 1019 5315 1327 287 15448

Jul-14 6145 977 7170 1324 289 15905

Aug-14 5882 1057 5926 1268 290 14422

Sep-14 5595 1086 6075 1209 293 14258

Oct-14 5233 1045 6321 1168 295 14061

Nov-14 4494 1078 8381 1127 298 15378

Dec-14 3913 1029 7944 1085 301 14272

Jan-15 5938 1172 5688 1185 306 14289

Feb-15 6633 1273 7037 1286 302 16530

Mar-15 7327 1423 6981 1286 303 17320

Apr-15 8077 1612 7500 1346 307 18842

May-15 7830 1728 6571 1388 309 17826

Jun-15 7103 1815 6990 1449 312 17669

Jul-15 6239 1776 6667 1490 315 16487

Aug-15 6036 1685 6762 1449 318 16250

Sep-15 5664 1679 6635 1394 321 15692

Oct-15 5345 1618 6311 1256 315 14844

Nov-15 4831 1564 6476 1214 318 14402

Dec-15 4454 1522 6250 1171 320 13716

Jan-16 5299 1835 5922 1208 333 14597

Feb-16 6529 2115 6667 1214 313 16836

Mar-16 7120 2202 7228 1256 606 18412

Apr-16 7619 2151 8200 1311 571 19852

May-16 8387 2214 7941 1415 556 20513

Jun-16 8110 2278 7921 1520 526 20355

Jul-16 7752 2100 7677 1675 513 19716

Aug-16 6894 2128 7200 1584 769 18575

Sep-16 6015 2367 6735 1527 750 17394

Oct-16 5368 2211 6495 1422 732 16226

Nov-16 4964 2483 6061 1366 714 15587

Dec-16 4444 1986 5816 1262 698 14207

Jan-17 5000 2257 5051 1373 714 14394

Feb-17 6284 2353 6082 1436 1063 17218

Mar-17 7785 2457 6327 1478 1264 19310

Apr-17 9934 2517 7604 1512 1333 22901

May-17 10645 2612 7789 1642 1556 24244

Jun-17 9491 2749 7347 1667 1739 22993

Jul-17 9182 2887 6979 1733 1702 22483

Aug-17 8528 2833 6489 1700 1915 21465

Sep-17 8293 2789 6316 1642 2083 21123

Oct-17 8221 2765 5833 1576 2128 20523

Nov-17 7470 2746 5789 1493 2292 19789

Dec-17 6509 2534 5591 1450 2245 18329

Jan-18 7267 2635 5106 1010 2292 18311

Feb-18 8807 2703 5474 1045 2449 20477

Mar-18 10168 2795 6022 1106 2400 22489

Apr-18 11044 2997 6064 1150 2353 23607

May-18 12120 3131 6344 1244 2600 25439

Jun-18 13459 3311 6593 1357 2653 27374

Jul-18 13048 3390 6304 1421 2600 26764

Aug-18 12275 3277 6064 1263 2549 25428

Sep-18 11347 3232 5789 1173 2453 23995

Oct-18 10667 3131 5699 1128 2517 23142

Nov-18 10459 3087 5604 974 2541 22666

Dec-18 10082 3030 5444 979 2453 21989