Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
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
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.