Labeled Acmelumberglueusage.xls. Cut and paste the data from this sheet into you OWN spreadsheet. Use this data to complete the forecasting assignment. 2. Perform a Forecast for February 1, 2005 using the 6 methods discussed in class: Nave, Simple Moving Average, Weighted Moving Average, Exponential Smoothing, Regression (including needed charts), and Regression Tool. 3. Create a summary sheet comparing the following methods: Nave, SMA, WMA, ES, ES with Solver, Regression. 4. On the summary sheet, include a recommendation of the method you would use along with justification. 5. Using Solver, an Excel tool, minimize the MAD cell in the ES forecast by changing the Alpha. (Remember the rules for Alpha?) 6. When you have completed the assignment submit it to the appropriate drop box on the course shell. Needed Information SMA: Perform the forecast for 5 periods WMA weights: W1=3.5, W2=2.5, W3=2, W4=1 ES: Alpha = .5 fx B D E F G H 1 Acme Lumber Products Wood Glue Usage (in pounds) 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1-Jan-2005 2-Jan-2005 3-Jan-2005 4-Jan-2005 5-Jan-2005 6-Jan-2005 7-Jan-2005 8-Jan-2005 9-Jan-2005 10-Jan-2005 11-Jan-2005 12-Jan-2005 13-Jan-2005 14-Jan-2005 15-Jan-2005 16-Jan-2005 17-Jan-2005 18-Jan-2005 19-Jan-2005 20-Jan-2005 21-Jan-2005 22-Jan-2005 23-Jan-2005 24-Jan-2005 25-Jan-2005 26-Jan-2005 27-Jan-2005 28-Jan-2005 29-Jan-2005 30-Jan-2005 31-Jan-2005 1-Feb-2005 2056 2014 1995 1875 2135 2098 2051 2198 1935 1899 2054 2130 2155 2065 2144 2130 2189 1972 2058 1981 2055 2002 2064 2113 2141 2059 2065 2005 2164 2122 2095 32 33 34 35 36 37 38 Labeled Acmelumberglueusage.xls. Cut and paste the data from this sheet into you OWN spreadsheet. Use this data to complete the forecasting assignment. 2. Perform a Forecast for February 1, 2005 using the 6 methods discussed in class: Nave, Simple Moving Average, Weighted Moving Average, Exponential Smoothing, Regression (including needed charts), and Regression Tool. 3. Create a summary sheet comparing the following methods: Nave, SMA, WMA, ES, ES with Solver, Regression. 4. On the summary sheet, include a recommendation of the method you would use along with justification. 5. Using Solver, an Excel tool, minimize the MAD cell in the ES forecast by changing the Alpha. (Remember the rules for Alpha?) 6. When you have completed the assignment submit it to the appropriate drop box on the course shell. Needed Information SMA: Perform the forecast for 5 periods WMA weights: W1=3.5, W2=2.5, W3=2, W4=1 ES: Alpha = .5 fx B D E F G H 1 Acme Lumber Products Wood Glue Usage (in pounds) 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1-Jan-2005 2-Jan-2005 3-Jan-2005 4-Jan-2005 5-Jan-2005 6-Jan-2005 7-Jan-2005 8-Jan-2005 9-Jan-2005 10-Jan-2005 11-Jan-2005 12-Jan-2005 13-Jan-2005 14-Jan-2005 15-Jan-2005 16-Jan-2005 17-Jan-2005 18-Jan-2005 19-Jan-2005 20-Jan-2005 21-Jan-2005 22-Jan-2005 23-Jan-2005 24-Jan-2005 25-Jan-2005 26-Jan-2005 27-Jan-2005 28-Jan-2005 29-Jan-2005 30-Jan-2005 31-Jan-2005 1-Feb-2005 2056 2014 1995 1875 2135 2098 2051 2198 1935 1899 2054 2130 2155 2065 2144 2130 2189 1972 2058 1981 2055 2002 2064 2113 2141 2059 2065 2005 2164 2122 2095 32 33 34 35 36 37 38