Consider the data given in Problem 11-17 for Blu-ray DVD player sales at Electronic Depot. (a) If

Question:

Consider the data given in Problem 11-17 for Blu-ray DVD player sales at Electronic Depot.
(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  book-img-for-question

Managerial Decision Modeling With Spreadsheets

ISBN: 9780136115830

3rd Edition

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

Question Posted: