Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Economic Growth In Latin America And The Impact Of The Global Financial Crisis

Authors: Mauricio Garita

1st Edition

1522549811,152254982X

More Books

Students also viewed these Finance questions