Using the dress data above, calculate the following 1. Using the above data forecast year 3 using a simple 3 period moving average 2. Using years 1 and 2 data forecast year 3, using weighted moving average, with weights of 0.6, 0.25, and 0.15 from the most recent the oldest period. 3. Using the above data forecast year 3 Calculate a forecast using the exponential smoothing method. Assume a = 0.20 4. (a) Using the information you have for years 1 & 2, calculate a monthly index. And then (b) using year 1 and 2 data Determine the slope and intercept of line equation using linear regression. Then calculate the new annual demand and forecast the monthly demand 5. Using the actual Year-3 numbers to check your forecast accuracy, by using the forecasting error to calculate CFE. MSE. MAD. MAPE 6. Determine which forecasting method is best for this problem. Using the actual Year-3 numbers to check your forecast accuracy. Please show work and accurate answers.