Consider the data given in Problem 11-15 for Nilgiris Convenience Store. (a) If the store wants to

Question:

Consider the data given in Problem 11-15 for Nilgiris Convenience Store.
(a) If the store wants to use exponential smoothing to forecast the sales volume, what is the optimal value of a that would minimize MAPE? What is the forecast for day 11 using this model?
(b) If the store wants to use linear trend analysis to forecast the sales volume, what is the linear equation that best fits the data? What is the fore-cast for day 11 using this model?
(c) Which of the methods analyzed here and in Problem 11-15 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: