Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 20P: The file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year...
icon
Related questions
Question
100%

Following table shows the monthly sales of X-box consoles at a retail store in Kuwait:

 

Answer the following questions based on the data given above. Show your calculations.

a. What is the expected sales for the 8th month based on 3 period moving average?

b. What is the expected sales for the 8th month based on exponential smoothing with α =0.2?

c. Which of the above two forecasting method is better based on MSE?

Month
Number of
Forecast
Error
Forecast
Error
using
exponential
smoothing
(with a =0.2)
products Sold
using 3
period
moving
average
173
1
117
131
129
163
181
7
189
8
23456 00
Transcribed Image Text:Month Number of Forecast Error Forecast Error using exponential smoothing (with a =0.2) products Sold using 3 period moving average 173 1 117 131 129 163 181 7 189 8 23456 00
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Forecasting methods
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,