Using the Simple Moving Average OR Weight moving average calculate sales forcast for the next period. 2. Comment on the appropriateness of this method

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%

1. Using the Simple Moving Average OR Weight moving average calculate sales forcast for the next period.

2. Comment on the appropriateness of this method

 

451
POINTS OF
SALE
454 605
790
840
901
991
1075
1125
1159
1,191
1,144
472
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
Transcribed Image Text:451 POINTS OF SALE 454 605 790 840 901 991 1075 1125 1159 1,191 1,144 472 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
Expert Solution
Step 1

A 3-period moving average is a type of forecasting technique that can be used to predict the future price of an asset. It is made up of a series of averages that are calculated over a number of periods.

The basic idea behind this technique is that the prices in the recent past are more relevant for predicting future prices than those in the distant past.

The 3-period moving average forecast is based on three time periods:

The most recent time period, which is called "t"

The second most recent time period, which is called "t-1"

And the third most recent time period, which is called "t-2

steps

Step by step

Solved in 3 steps with 2 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,
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.