Make the forecast using the following techniques for the first six months of 2021: 3-month moving average 3-month weighted moving average (weights are 3,2,1 : the highest for the most recent past month data)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 5P: Management of a home appliance store wants to understand the growth pattern of the monthly sales of...
icon
Related questions
Question

Phillip Cane, the managing editor of Your Life Magazine, needs to develop a forecasting system for monthly newsstand sales in order to schedule press runs. Sales in thousands of copies for the last eight months of 2020 (the first year of publication) were:

 

Month (2020)                          Sales

     May                                       50

     June                                       45

     July                                         60

     August                                    52

     September                             69

     October                                 60

     November                              47

     December                              53

 

Make the forecast using the following techniques for the first six months of 2021:

  1. 3-month moving average
  2. 3-month weighted moving average (weights are 3,2,1 : the highest for the most recent past month data)

 

Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
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,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing