Question: Problem 12-4 (Algo) Using the ice cream sales data given below, forecast demand using moving average with n=1, 4, and 8 and the exponential smoothing

Problem 12-4 (Algo) Using the ice cream sales
Problem 12-4 (Algo) Using the ice cream sales
Problem 12-4 (Algo) 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 135,6 for the beginning forecast on the first day. Day Day M T w Th F S Su M T W Th F s Su M T W Th F S Su Demand 135.6 141.1 161.2 142.7 191.4 193.5 181.7 146.4 131.0 155.4 161.2 226.7 198.2 214.6 159.7 186.9 166.8 183.3 229.2 254.0 256.6 M T W Th F s Su M T W Th F S Su Demand 177.9 189.5 190.3 216.5 286.9 354.9 283.9 229.9 155.8 190.4 216.7 279,4 345.3 328.3 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.) Moving Average Forecast no 1 na 4 n8 MFE MAD 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.) Exponential Smoothing Forecast a = 0.1 a=0.5 a = 0.9 MFE MAD 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.) Simple moving average with 1 Simple moving average with n=4 Simple moving average with = 8 Exponential smoothing model with alpha=0.5 Exponential smoothing model with alpha 01 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!