Question
You have just started your internship with the XYZ consulting company located in Aston. One of the XYZs clients is Amazon who is interested in
You have just started your internship with the XYZ consulting company located in Aston. One of the XYZs clients is Amazon who is interested in getting information about future revenue. You have been given this task by your immediate supervisor, Mr. Tom Jones to improve XYZ forecasting method. XYZ currently is using exponential smoothing method with = 0.3 to forecast the future revenue. Mr. Jones asked you to come up with a different forecasting model and recommend the best model to the client for his/her use. He has provided the following data below. The deadline for the project is 10/21/2021, you must submit it on your course Blackboard. With this in mind, you need to provide a written report which includes appropriate graphs, Excel worksheets, your justification for your choice of models and the selection of the better model with the forecast of the next four quarters if feasible.
| Quarter | Year | Net revenue(billion) |
1 | Q3 | 2013 | 17.09 |
2 | Q4 | 2013 | 25.59 |
3 | Q1 | 2014 | 19.74 |
4 | Q2 | 2014 | 19.34 |
5 | Q3 | 2014 | 20.58 |
6 | Q4 | 2014 | 29.33 |
7 | Q1 | 2015 | 22.72 |
8 | Q2 | 2015 | 23.19 |
9 | Q3 | 2015 | 25.36 |
10 | Q4 | 2015 | 35.75 |
11 | Q1 | 2016 | 29.13 |
12 | Q2 | 2016 | 30.4 |
13 | Q3 | 2016 | 32.71 |
14 | Q4 | 2016 | 43.74 |
15 | Q1 | 2017 | 35.71 |
16 | Q2 | 2017 | 37.96 |
17 | Q3 | 2017 | 43.74 |
18 | Q4 | 2017 | 60.5 |
19 | Q1 | 2018 | 51.04 |
20 | Q2 | 2018 | 52.89 |
21 | Q3 | 2018 | 56.58 |
22 | Q4 | 2018 | 72.38 |
23 | Q1 | 2019 | 59.7 |
24 | Q2 | 2019 | 63.4 |
25 | Q3 | 2019 | 69.98 |
26 | Q4 | 2019 | 87.44 |
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