Respond to each of the items using the following time series data.
Period | Demand |
1 | 20 |
2 | 46 |
3 | 20 |
4 | 9 |
5 | 17 |
6 | 8 |
7 | 19 |
8 | 34 |
9 | 39 |
10 | 4 |
11 | 32 |
12 | 23 |
13 | 10 |
14 | 27 |
b. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (α) of 0.3. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
Period | Demand |
Exponential Smooth |
Error | Absolute Error |
1 | 20 | |||
2 | 46 | |||
3 | 20 | |||
4 | 9 | |||
5 | 17 | |||
6 | 8 | |||
7 | 19 | |||
8 | 34 | |||
9 | 39 | |||
10 | 4 | |||
11 | 32 | |||
12 | 23 | |||
13 | 10 | |||
14 | 27 | |||
15 |
c. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (α) of 0.7. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
Respond to each of the items using the following time series data.
Period | Demand | Exponential Smooth | Error | Absolute Error |
1 | 20 | |||
2 | 46 | |||
3 | 20 | |||
4 | 9 | |||
5 | 17 | |||
6 | 8 | |||
7 | 19 | |||
8 | 34 | |||
9 | 39 | |||
10 | 4 | |||
11 | 32 | |||
12 | 23 | |||
13 | 10 | |||
14 | 27 | |||
15 |
d. Compute the MADs for each forecast model. (Round your answers to 3 decimal places.)
e. Which forecast model would you choose? Why?
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 3 images
Respond to each of the items using the following time series data.
Period | Demand |
1 | 20 |
2 | 46 |
3 | 20 |
4 | 9 |
5 | 17 |
6 | 8 |
7 | 19 |
8 | 34 |
9 | 39 |
10 | 4 |
11 | 32 |
12 | 23 |
13 | 10 |
14 | 27 |
Click here for the Excel Data File
b. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (α) of 0.3. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
c. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (α) of 0.7. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
d. Compute the MADs for each forecast model. (Round your answers to 3 decimal places.)
e. Which forecast model would you choose? Why?
Respond to each of the items using the following time series data.
Period | Demand |
1 | 20 |
2 | 46 |
3 | 20 |
4 | 9 |
5 | 17 |
6 | 8 |
7 | 19 |
8 | 34 |
9 | 39 |
10 | 4 |
11 | 32 |
12 | 23 |
13 | 10 |
14 | 27 |
Click here for the Excel Data File
b. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (α) of 0.3. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
c. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (α) of 0.7. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
d. Compute the MADs for each forecast model. (Round your answers to 3 decimal places.)
e. Which forecast model would you choose? Why?
- Consider the following data: Month Jan-14 Feb-14 Profit ($) 16,113 16,263 Monthly Profit of an Auto Repair Shop Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 15,055 17,117 18,763 17,210 19,141 18,468 20,254 Step 3 of 4: Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.35. If necessary, round your answer to one decimal place.arrow_forwardPlease answer part earrow_forwardThe following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 31 2 34 3 33 4 35 5 37 6 36 7 38 8 40 9 40 10 41 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast ( F1�1 ) of 31. Note: Round your intermediate calculations and answers to 2 decimal places. b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.30, a δ of 0.30, an initial trend forecast ( T1�1 ) of 1, and an initial exponentially smoothed forecast ( F1�1 ) of 30. Note: Round your intermediate calculations and answers to 2 decimal places. c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. Note: Round your intermediate calculations and answers to 2 decimal places. c-2. Which is best? multiple choice Exponential smoothing with trend forecast Single exponential smoothing forecastarrow_forward
- 1 - A simple exponential smoothing model has a current mean of 156.8. Assuming demand for next period is 170, update the value of the smoothing statistic. Let a = 0.1. 2- An electronics company has sold 145, 157, 124, 169,179, 201, 197, and 230 units of a certain stereo system quarterly for the past two years. Plot the data and fit an appropriate model. Forecast sales for the next two quarters.arrow_forwardA 18.2% B 15.7% C 22.2% D 4.4%arrow_forwardThe figure below illustrates monthly data over 10 years. What method would you expect would perform the best at forecasting the data series in period 121? Explain the (i) strengths of your selected method for this data and the (ii) weaknesses of alternative methods for this data. Consider the concepts of level, seasonality, trend, and noise in your answer.arrow_forward
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman