A manufacturer has experienced the following monthly demand for one of their products.
Month Actual demand (in cases)
February 1500
March 2860
April 2950
May 3490
June 3000
a. Using a three month moving average, what would the forecast and MAD be for July?
b. What would the three-month weighted moving average (using .4, .4, .2) and MAD be for July?
c. What would the MAD be using a regression?
d. Which forecasting method would you recommend? Why?