For the given demand data, the smoothing constant (α=0.30), and
the starting forecast (F1) = 60, 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 F1 and α gives the best MAD?
*Please show with excel and formulas used in excel*
1 (150.8 KiB) Viewed 26 times
AutoSave OF AAP 2G ... Final-1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Calibri (Body! v 20 ~ Al A a Wras Text Number v SB Σν ) V X [G V v Paste B B1 Uv - A - Merge & Center v $ % , Insert Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data C11 fx T 2 9 s т 1 Problem 4 (25 Points) 0.35 0.40 9 15 13 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 a the smoothing constant. Which combination of F, and a gives the best MAD? a= a 0.30 t D F. D-F, ID-FI 0.20 0.25 0.30 Time Demand ES Error Error 30 30 1 40 60.0 40 40 z 50 50 50 3 30 60 60 4 60 70 70 5 50 80 80 6 60 90 90 7 30 8 40 Best F1- Best F, and a combination: F1 = 9 45 a 10 55 11 30 12 13 14 15 11 13 11 Q= 15 12 50 33 13 34 24 MAD 29 2 23 Problem 1 Problem 2 Problem 3 Problem 4 + Ready # B - 77%
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!