You have been given this task by your immediate supervisor, Mr Tom Jones, to forecast using the data provided below He asked you to come up with two different forecasting models and recommend the best model to the client for his her use Using seasonality and regression, you will need to provide a written report which includes appropriate graphs, Excel worksheets (required), and your justification for your choice of models and the selection of the better model with the forecast of the next four quarters Quarter Year Net revenue(billion) 1 01 2013 16 07 202 2013 15 7 3 Q3 2013 17 09 2013 25 59 4 Q4 5 01 2014 19 74 602 2014 19 34 7 Q3 2014 20 58 2014 29 33 8104 9101 2015 22 72 10 Q2 2015 23 19 2015 25 36 11 Q3 12 04 2015 35 75 1301 2016 29 13 2016 30 4 14 Q2 15 Q3 2016 32 71 16 Q4 2016 43 74 17101 2017 35 71 2017 37 96 2017 43 74 18 Q2 19 Q3 2004 21 Q1 2017 60 5 2018 51 04 22 Q2 2018 52 89 2018 56 58 2018 72 38 2019 59 7 23 Q3 24 Q4 25 01 26 Q2 27 Q3 28 Q4 2019 63 4 2019 69 98 2019 87 44 29 01 2020 75 45 2020 88 91 30 Q2 31 Q3 2020 96 15

The Answer is in the image, click to view ...

Question: You have been given this task by your immediate supervisor, Mr. Tom Jones, to forecast using the data provided below. He asked you to come

You have been given this task by your immediate supervisor, Mr. Tom Jones, to forecast using the data provided below. He asked you to come up with two different forecasting models and recommend the best model to the client for his/her use. Using seasonality and regression, you will need to provide a written report which includes appropriate graphs, Excel worksheets (required), and your justification for your choice of models and the selection of the better model with the forecast of the next four quarters. You have been given this task by your immediate

Quarter Year Net revenue(billion) 1/01 2013 16.07 202 2013 15.7 3 Q3 2013 17.09 2013 25.59 4 Q4 5 01 2014 19.74 602 2014 19.34 7|Q3 2014 20.58 2014 29.33 8104 9101 2015 22.72 10 Q2 2015 23.19 2015 25.36 11|Q3 12/04 2015 35.75 1301 2016 29.13 2016 30.4 14 Q2 15|Q3 2016 32.71 16|Q4 2016 43.74 17101 2017 35.71 2017 37.96 2017 43.74 18 Q2 19 Q3 2004 |21|Q1 2017 60.5 2018 51.04 22 Q2 2018 52.89 2018 56.58 2018 72.38 2019 59.7 23 Q3 24|Q4 25/01 26 Q2 |27|Q3 28|Q4 2019 63.4 2019 69.98 2019 87.44 29 01 2020 75.45 2020 88.91 30 Q2 31 Q3 2020 96.15

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

You have been giving this task by your immediate supervisor, Mr. Tom Jones, to forecast using the data provided below. He asked you to come up with two different forecasting models and recommend the...

please show how to do the forecasting in excel, written reports not needed You havejust started your intemship with the XYZ consulting company located in Aston. One of the XYZ's clients is Amazon...

You have just started your internship with the XYZ consulting company located in Aston. One of the XYZs clients is Amazon interested in getting information about the future revenues. You have been...

You have just started your internship with the XYZ consulting company located in Aston. One of the XYZ's clients is Amazon interested in getting information about the future revenues. You have been...

FORECASTING IS SEASONALITY AND REGRESSION, PLEASE DO THAT IN EXCEL. WRITTEN PORTION NOT NEEDED. You havejust started your intemship with the XYZ consulting company located in Aston. One of the XYZ's...

Grading: Criteria Points Available Points Earned FORECASTING - demonstrates understanding of: : 15 25 Clearly identifies two potential furcating models for data using time series plot. Data use...

Project 1.2 esign Layout References Mailings Review View Tell me V - ALT 12 - A | Aav | Po ab x x ADA AaBbccbdbe Aabb cxde AaBbCcDc Aa Bb CODE AaBb Aabbccdde Normal No Spacing Heading 1 Heading 2...

Heading Title You have just started your internship with the Bellevue University. Bellevue accepts new students into its program year-round on a tri-semester schedule (Fall, Spring, and Summer)....

5. Suppose that typical CPI basket for consumers contains 3 goods: 3 burgers, 3 cans of baked beans, and 3 cans of Dr. Pepper. The prices of the goods in 2019 and 2020 are listed in the table below....

A coagulation treatment plant with a flow rate of 0.5 m 3 /s is dosing alum at 23.0 mg/L. No other chemicals are being added. The raw water suspended solids concentration is 37 mg/L. The effluent...

Over the last three reporting periods, the amount of cash FedEx paid for treasury stock: a . decreased b . increased c . did not change d . cannot be determined

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...