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?
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 now
This is a popular solution!
Step by step
Solved 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?