U Problem Statement (Forecast Methods) You are tasked with forecasting demand for a product in July, 2020. The Time Series of historical demand in the most recent 6 months is provided in the table: Month-Year(t) Demand (DE) January-20 160,700 February-20 122,800 March-20 410.000 April-20 405,000 May-20 410,155 June-20 280,000 In the following questions, you are asked to forecast demand in July, 2020 using various methods. Please conduct your forecasting in MS Excel, report your results in the following questions, and upload the Excel file with your work for verification. For your convenience, the data and an MS Excel template is available here: Forecast Methods handout.xlsx You are asked to forecast demand in July, 2020 using the Weighted Moving Average method with the "lookback" window of size n=6. Suppose that you are using the follow weight distribution: w5 w4 w3 w2 0.07 0.08 0.1 0.2 0.25 0.3 1 w1 wo SUM "Your demand forecast is: (Hint: please round your answer to the closest whole number.) You are asked to forecast demand in July, 2020 using the Exponential Smoothing method with the "smoothing factor" =0.153. Prior forecast for demand in June, 2020 was 514,771, and you observed the true demand to be 280,000. Your demand forecast is: (Hint: please round your answer to the closest whole number.)