1 Acme Lumber Products 2 Wood Glue Usage (in pounds) 3 4 5 6 7 1-Jan-2005...

Transcribed Image Text:

1 Acme Lumber Products 2 Wood Glue Usage (in pounds) 3 4 5 6 7 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 19 16-Jan-2005 20 17-Jan-2005 21 18-Jan-2005 22 19-Jan-2005 23 20-Jan-2005 24 21-Jan-2005 25 22-Jan-2005 26 23-Jan-2005 27 24-Jan-2005 28 25-Jan-2005 29 26-Jan-2005 30 27-Jan-2005 31 28-Jan-2005 32 29-Jan-2005 33 30-Jan-2005 34 31-Jan-2005 35 1-Feb-2005 8 9 10 11 12 13 14 15 16 17 18 36 37 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 1. In the Week 3 module you will find a file Labeled Homework 1 forecasting.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: Naïve, Simple Moving Average, Weighted Moving Average, Exponential Smoothing, Regression (including needed charts), and Regression Tool. 3. Create a summary sheet comparing the following methods: Naïve, 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 1 Acme Lumber Products 2 Wood Glue Usage (in pounds) 3 4 5 6 7 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 19 16-Jan-2005 20 17-Jan-2005 21 18-Jan-2005 22 19-Jan-2005 23 20-Jan-2005 24 21-Jan-2005 25 22-Jan-2005 26 23-Jan-2005 27 24-Jan-2005 28 25-Jan-2005 29 26-Jan-2005 30 27-Jan-2005 31 28-Jan-2005 32 29-Jan-2005 33 30-Jan-2005 34 31-Jan-2005 35 1-Feb-2005 8 9 10 11 12 13 14 15 16 17 18 36 37 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 1. In the Week 3 module you will find a file Labeled Homework 1 forecasting.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: Naïve, Simple Moving Average, Weighted Moving Average, Exponential Smoothing, Regression (including needed charts), and Regression Tool. 3. Create a summary sheet comparing the following methods: Naïve, 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

Answer rating: 100% (QA)

Formula D5 C4 Naive forecast E9 AVERAGEC4C8 SMA forecast F8 C735C625C52C4352521 WMA forecast G5 G4C4... View the full answer