Consider the data given in Problem 11-17 for Blu-ray DVD player sales at Electronic Depot. (a) If
Question:
(a) If Electronic Depot decides to forecast sales by using a three-period weighted moving average, what are the optimal weights that minimize MAPE? What would be the week 13 forecast using these weights?
(b) If Electronic Depot decides to forecast sales by using exponential smoothing, what is the optimal value of a that minimizes MAPE? What would be the week 13 forecast using this procedure?
(c) Which of the methods analyzed here and in Problem would you use? Explain your answer.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Managerial Decision Modeling With Spreadsheets
ISBN: 9780136115830
3rd Edition
Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair
Question Posted: