Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are back at PLE. Ms B. wants to forecast the sales of future mower units (use sheet Mower Unit Sales ). Separately for each
You are back at PLE.
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
Provide an Excel file (relevant sheets only!) as well as a professional report for Ms B.
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started