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 appropriately and completed the first forecasting model correctly Data use appropriately and completed the second forecasting model correctly Appropriate technique is used correctly to identify the better model 25 15 MGT 415R Fall 2021 Forecasting Project Due: 11:59 PM 10/21/2021 Name: You have just started your internship with the XYZ consulting company located in Aston. One of the XYZ's 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 a = 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 Net revenue (Million) 1 01 2 02 2014 11355 3 03 11139 4 10161 501 10827 The forecast correctly provided 10 PROFESSIONALISM -Written summary, organization, presentation, etc. 10 Year TOTAL 100 0 2014 9995 2 3 2014 04 2014 2015 9827 6 02 2015 7 03 2015 10706 8 04 2015 9630 Q1 2016 9435 9 9 10 02 2016 10363 11 03 2016 10594 12 04 2016 9750 01 2017 9820 13 14 02 2017 11227 03 2017 10965 04 2017 15 16 17 18 10610 10401 01 2018 02 2018 11643 19 03 2018 11559 04 2018 10938 20 21 01 2019 10584 22 02 2019 11960 03 2019 11911 23 24 04 2019 11313 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 appropriately and completed the first forecasting model correctly Data use appropriately and completed the second forecasting model correctly Appropriate technique is used correctly to identify the better model 25 15 MGT 415R Fall 2021 Forecasting Project Due: 11:59 PM 10/21/2021 Name: You have just started your internship with the XYZ consulting company located in Aston. One of the XYZ's 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 a = 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 Net revenue (Million) 1 01 2 02 2014 11355 3 03 11139 4 10161 501 10827 The forecast correctly provided 10 PROFESSIONALISM -Written summary, organization, presentation, etc. 10 Year TOTAL 100 0 2014 9995 2 3 2014 04 2014 2015 9827 6 02 2015 7 03 2015 10706 8 04 2015 9630 Q1 2016 9435 9 9 10 02 2016 10363 11 03 2016 10594 12 04 2016 9750 01 2017 9820 13 14 02 2017 11227 03 2017 10965 04 2017 15 16 17 18 10610 10401 01 2018 02 2018 11643 19 03 2018 11559 04 2018 10938 20 21 01 2019 10584 22 02 2019 11960 03 2019 11911 23 24 04 2019 11313