To complete this assignment, open up a the following Excel file: Forecasting Excel assignment.xlsx and Word tutorial: Forecasting Lecture Excel Tutorial2.pdf

Re-create the tables from the class lecture notes. You must use Excel formulas to receive full credit (that is, do not type in the numbers in the image below, but rather each cell must contain a formula). You must include all of the rows and columns in the image below to receive full credit (as well as the tracking signal graph that is not included in the image below).

Submit your Excel file.

Note the following:

Pretend that we are in the year 2018 and that the data is coming in over time (you will start forecasting January 2018 until December 2018) and need to use 2017 data and 2018 data (as 2018 unfolds).