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

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 19P: The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a...
icon
Related questions
Question

Please answer parts i, ii and iii of the below 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

 

  1. Using the following, forecast the sales for the months up to January the following year:-

i) A simple three month moving average.

ii) A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data.

iii) Exponential Smoothing when α= .6 and the forecast for March is 350.

Expert Solution
steps

Step by step

Solved in 2 steps with 6 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

-Please answer part iv. which is related to the three part question posted some moments ago that has been answered already. 

iv. Determine which of the three forecasting technique is the most accurate using
MAD.

-Also, please answer the below two parts to this new question.

The following table shows the number of televisions sold over the last ten years at a local electronic store.

Year TV Sales
1 150
2 300
3 480
4 600
5 630
6 640
7 700
8 825
9 900
10 980

i) Using trend projection, develop a formula to predict sales for years 11 and 12. 
You have to show all working. You will need to develop a table to calculate the slope and the intercept.

ii) Use that formula to forecast television sales for years 11 and 12. 

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Pricing
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,