dolution

The chart below shows last year’s sales data on widgets adjusted for the number of sale days in the month. Believing there is no seasonal variation, the company has used the previous month’s sales as forecasting data. On the first day of each month, the demand manager compiles last month’s sales figures and forecast sales for the new month.(200 POINTS)

a. What would the October sales forecast have been using a four-month moving average?

b. What would the November sales forecast have been using a four-month moving average?

c. What would the October sales forecast have been using a four-month weighting scale of 0.40, 0.30, 0.20, and 0.10?

d. Using exponential smoothing with a (+0.40), what would the sales forecast have been for October if the September forecast had been 380.

e. What would the November forecast have been using exponential smoothing?

1. Month	Sales	Month	Sales
   January	360	July	378
   February	360	August	375
   March	355	September	385
   April	365	October	390
   May	375	November	380
   June	370	December	370