Mgts $352-$ Forecasting Lab Practice $-$ Learning Some Basic Excel Techniques

Listed below are some of the forecasting techniques we will go over. We will be using Excel to derive this appropriate values and estimates. Page $25$ of the text contains the key formulas will be entering into Excel.

Find SMA for $n=4$

a$.$ Calculate errors

b$.$ Calculate MAD

Calculate a WMA with the weight $0\mathrm{.}5$ applied to the most recent observation, $0\mathrm{.}3$ to the second most recent, then $0\mathrm{.}1$ to the third and $0\mathrm{.}1$ to the fourth.

a$.$ Calculate MAD

b$.$ Calculate MSE

Derive an ES model with an $=0\mathrm{.}5($initial assumption$)$

a$.$ Calculate MAD

b$.$ Calculate MAPE

c$.$ Calculate MSE

d$.$ Calculate CFE

Use solver to find the optimal $$ for the ES model

Use solver to find the optimal weights for the WMA

Derive a Trend Adjusted ES model. Initially assume $=0\mathrm{.}6$ and $=0\mathrm{.}4.$

Use solver to find the optimal smoothing constants for the trend adjusted ES model