Please write the correct formula you should type in Excel to calculate the level for Week 17 using an exponential smoothing with trend forecast method, based on the data and parameters cells in the Excel file (the formula needs to be entered in a way that allows to calculate the forecasts for the other weeks as well). All references must refer to the exact cells in the file you downloaded for this exhibit.

ACADEMIC INTEGRITY By taking this exam, you understand that you are not allowed to access any resources other than the Midterm Exam 1 on Canvas and the Excel files provided within the exam. You understand that your actions on this computer are being recorded during the whole exam, and accessing any unauthorized resource (online, offline or outside of your computer) during the exam will lead to an unforgivable F for this course. Before continuing with the exam, please close all other applications and files on your computer.

Please forecast the demand for 2020 using a weighted moving average forecast method, based on the data indicated in the Excel file and the weights provided below. Round your answer to the closest whole number. Most recent period’s weight (W1) = 0.8 Second most recent period’s weight (W2) = 0.15 Third most recent period’s weight (W3) = 0.05

Please forecast the demand for 2018 using a weighted moving average forecast method, based on the data indicated in the Excel file and the weights provided below. Round your answer to the closest whole number. Most recent period’s weight (W1) = 0.6 Second most recent period’s weight (W2) = 0.3 Third most recent period’s weight (W3) = 0.1

Please write the correct formula you should type in Excel to calculate the forecast for 2019 using a simple moving average forecast method with five periods (the formula needs to be entered in a way that allows to calculate the forecasts for the other years as well). All references must refer to the exact cells in the file you downloaded for this exhibit.

Please forecast the demand for Day 28 using a weighted moving average forecast with the weights listed below and the data indicated in the Excel file. Round your answer to the closest whole number. Weight of the most recent period: 0.6 Weight of the other periods: 0.2

Please write the correct formula you should type in Excel to calculate the forecast for 2017 using a simple moving average forecast method with five periods (the formula needs to be entered in a way that allows to calculate the forecasts for the other years as well). All references must refer to the exact cells in the file you downloaded for this exhibit.

Please forecast the demand for 2011 using an average forecast method, based on the data indicated in the Excel file. Round your answer to the closest whole number.

Please forecast the demand for 2016 using a simple moving average forecast method with five periods, based on the data in the Excel file. Round your answer to the closest whole number.

Please forecast the demand for Week 15 using an exponential smoothing with trend forecast method, based on the data indicated in the Excel file, an alpha parameter of 0.55 and a beta parameter of 0.9. Use an initial forecast L1 = D1 and T1 = 2. Do not round the calculations in your Excel sheet, but round your final answer to the closest whole number.