Question: Using the ice cream sales data given below, forecast demand using moving average with n = 1, 4, and 8 and the exponential smoothing model
Using the ice cream sales data given below, forecast demand using moving average with n = 1, 4, and 8 and the exponential smoothing model with alpha = 0.1, 0.5, and 0.9 and using 126.3 for the beginning forecast on the first day.
| Day | Demand | Day | Demand |
| M | 126.3 | M | 197.2 |
| T | 148.7 | T | 187.5 |
| W | 162.2 | W | 206.8 |
| Th | 140.4 | Th | 232.1 |
| F | 195.1 | F | 287.0 |
| S | 194.6 | S | 350.3 |
| Su | 186.8 | Su | 278.0 |
| M | 157.6 | M | 202.9 |
| T | 146.8 | T | 148.0 |
| W | 150.1 | W | 183.7 |
| Th | 151.5 | Th | 225.7 |
| F | 227.8 | F | 283.7 |
| S | 190.9 | S | 268.7 |
| Su | 204.7 | Su | 285.9 |
| M | 163.6 | ||
| T | 182.6 | ||
| W | 154.1 | ||
| Th | 176.5 | ||
| F | 215.5 | ||
| S | 259.4 | ||
| Su | 247.0 | ||
a. Beginning with the errors calculated in period 9 (the second Tuesday in the list), calculate MFE and MAD for moving average forecast model. (Round your intermediate calculations and final answers to 1 decimal place.)
b. Beginning with the errors calculated in period 9 (the second Tuesday in the list), calculate MFE and MAD for exponential smoothing forecast model. (Round your intermediate calculations and final answers to 1 decimal place.)
c. Which one moving average model and which one exponential smoothing model performed best with respect to MAD? (You may select more than one answer. Click the box with a check mark for the correct answer and click to empty the box for the wrong answer.) check all that apply
- Simple moving average with n = 1
- Simple moving average with n = 4
- Simple moving average with n = 8
- Exponential smoothing model with alpha = 0.5
- Exponential smoothing model with alpha = 0.1
- Exponential smoothing model with alpha = 0.9
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
