Question: please include the formulas to type in excel. thanks! Tor period 13 using the 0.35 0.40 11 Problem 4 (25 Points) For the given demand
please include the formulas to type in excel. thanks!
Tor period 13 using the 0.35 0.40 11 Problem 4 (25 Points) For the given demand data, the smoothing constant (a 0.30), and the starting forecast (F.) - 55, find the forecast for period 13 using the exponential smoothing forecasting technique. Compute the MAD for the technique to one decimal accuracy. Make a one-way table showing the changes in MAD value with varying values of the starting forecast. What is the best value for the starting forecast? Make a 2-way table showing changes in MAD value with varying values of the starting forecast and the smoothing constant. Which combination of F, and a gives the best MAD? 0.30 t D F D-F 10-F1 0.20 0.25 0.30 Time Demand ES Error Error 30 30 1 40 55.0 40 40 2 50 50 50 3 30 60 60 4 60 70 70 5 50 80 80 6 60 90 90 7 30 8 40 Best, Best F, and a combination: F, 9 45 10 55 11 30 12 50 13 23 MAD
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
