Ms B. wants to forecast the sales of future mower units (use sheet Mower Unit Sales). Separately
Fantastic news! We've Found the answer you've been seeking!
Question:
Ms B. wants to forecast the sales of future mower units (use sheet Mower Unit Sales). Separately for each region as well as for the world:
- Select the appropriate forecasting model
- Build the chosen forecasting model over the course of the observed period of time
- Predict future sales for a every month up to a year after the latest observed date
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
Expert Answer:
To forecast the sales of future mower units for each region and the world you can use a time series forecasting model such as the ARIMA AutoRegressive ... View the full answer
Posted Date:
