Question: Problem # 1 Here are the data for the past 2 1 months for actual sales of a particular product: Develop a forecast for the

Problem #1
Here are the data for the past 21 months for actual sales of a particular product:
Develop a forecast for the Month of October using
a)4-months moving average
b)12-months moving average
c)3-months weighted moving average. Weight the most recent month .5, the second most recent .25, and the third .25
d) Exponential smoothing and assuming alpha of .3 and forecast for September this year of 375.
e) Exponential smoothing with trend using same assumptions as in part D plus delta of .2 and September this year trend forecast of 30.
f) Linear regression
If the actual sales in October were 440, which model is the most accurate in predicting Octobers demand?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!