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 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 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 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.

What was the forecast in Week 10 using a linear regression for trend forecast method? Please use the linear regression model you built with all demand data from Week 1 to 16. Round your answer to the closest whole number.

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