Historical demand for the product is:
Month Demand
January 12
February 11
March 15
April 12
May 16
June 15
Using Weighted average with weights of 60% for last, 30% second last, and 10% for the third last month, find the July forecast.
Weighted Forecast =
Using a sample three-month moving average, find the July forecast.
Moving Average Forecast =
If the July demand is 17, Using Weighted average with weights of 60% for last, 30% second last, and 10% for the third last month, find the August forecast.
Weighted Forecast =
Using a sample three-month moving average, find the August forecast.
Moving Average Forecast =