Using the "Oscm pro, the supply chain professional spreadsheet templates" (Google search this) : "5 Natural Gas Import Prices" template, complete the following:

a) Develop spreadsheet models for forecasting prices using simple moving aver-age and simple exponential smoothing. To compare results, first develop a 3-period moving average model and then a simple exponential smoothing model with a smoothing constant of 0.3.

b) Experiment with different smoothing constants in the exponential smoothing model and try to improve on results compared to the model used in part a. Use MSE or MAD to guide your search.