An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers and tractors in each marketing region, as well as industry sales, to assess future changes in market share. She also wants to forecast future increases in production costs. Develop forecasting models for these data and prepare a report of your results with appropriate charts and output from Excel. Upload your Word document AND your Excel worksheet file to the Assignment drop box.

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