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!
please include the formulas to type in excel.
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 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!