Handy, Inc., produces a solar-powered electronic calculator that has experiencedthe following monthly sales history for the first four months of the year, inthousands of units:January 23.3 March 30.3February 72.3 April 15.5a. If the forecast for January was 25, determine the one-step-ahead forecasts forFebruary through May using exponential smoothing with a smoothing constant of a=.15.b. Repeat the calculation in part (a) for a value of a= .40. What difference in theforecasts do you observe?c. Compute the MSEs for the forecasts you obtained in parts (a) and (b) forFebruary through April. Which value of a gave more accurate forecasts, basedon the MSE?
Handy, Inc., produces a solar-powered electronic calculator that has experiencedthe following monthly sales history for the first four months of the year, inthousands of units:January 23.3 March 30.3February 72.3 April 15.5a. If the forecast for January was 25, determine the one-step-ahead forecasts forFebruary through May using exponential smoothing with a smoothing constant of a=.15.b. Repeat the calculation in part (a) for a value of a= .40. What difference in theforecasts do you observe?c. Compute the MSEs for the forecasts you obtained in parts (a) and (b) forFebruary through April. Which value of a gave more accurate forecasts, basedon the MSE?
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...
Related questions
Question
Handy, Inc., produces a solar-powered electronic calculator that has experienced
the following monthly sales history for the first four months of the year, in
thousands of units:
January 23.3 March 30.3
February 72.3 April 15.5
a. If the
February through May using exponential smoothing with a smoothing constant of a=.15.
b. Repeat the calculation in part (a) for a value of a= .40. What difference in the
forecasts do you observe?
c. Compute the MSEs for the forecasts you obtained in parts (a) and (b) for
February through April. Which value of a gave more accurate forecasts, based
on the MSE?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
Knowledge Booster
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.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing