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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!