New Exercise Bank Content Qu$.04-23$e

The Andes Mining Company mines and ships copper ore. The company's sales manager, Juanita Valdes, has been using the moving$-$average method based on the last three years of sales to forecast the demand for the next year. However, she has become dissatisfied with the inaccurate forecasts being provided by this method. The annual demands $($in tons of copper ore$)$ over the past $10$ years are $382,405,398,421,426,415,443,451,446,464.$

Click here for the Excel Data File

Determine what the forecasts would have been for the past $10$ years if the exponential smoothing method had been used instead with an initial estimate of $380$ and a smoothing constant of $=0\mathrm{.}5.$