Download and review Forecasting Lecture Excel Tutorial2.pdf for step-by-step instructions. The pdf file below will walk you through each step in the assignment. You will be re-creating the tables from the class lecture notes in Excel. 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).

This Excel assignment will demonstrate forecasting in Excel. A forecast can help you predict things like future sales, inventory requirements, or consumer trends.

For this assignment, complete the following:

1. Download and review Forecasting Lecture Excel Tutorial2.pdf for step-by-step instructions. The pdf file below will walk you through each step in the assignment. You will be re-creating the tables from the class lecture notes in Excel. 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).
2. Open a the Microsoft Excel file Forecasting Excel assignment.xlsx. You will need to input the data from the instructions document into this blank Excel file. You will need to use a Windows based computer.
3. Save and Submit your Excel spreadsheet. Note that you must use Excel formulas to receive full credit (that is, do not type in the numbers in the images, but rather each cell must contain a formula). You must include all of the rows and columns in the instructions document to receive full credit, as well as the tracking signal graph.