The table below shows the sales figures for a brand of shoe over the last 12 months.MonthsSalesJanuary69February75March86April92May95June100July108August115September125October131November140December150 Using the following, forecast the sales for the months up to January the following year:-A simple three month moving average. A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data.Exponential Smoothing when α= .6 and the forecast for March is 350. Determine which of the three forecasting technique is the most accurate using MAD.

The mean absolute deviation (MAD) is a measure of the accuracy of forecasts. It measures how far off…

Answered: Using the following, forecast the sales…

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 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Related questions

Question

The table below shows the sales figures for a brand of shoe over the last 12 months.

Months	Sales
January	69
February	75
March	86
April	92
May	95
June	100
July	108
August	115
September	125
October	131
November	140
December	150

Using the following, forecast the sales for the months up to January the following year:-
A simple three month moving average.
A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data.
Exponential Smoothing when α= .6 and the forecast for March is 350.
Determine which of the three forecasting technique is the most accurate using MAD.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions