Following table shows weekly profits of small company $($in hundreds of $$).$

Apply two forecasting methods, $4-$week moving average and exponential smoothing forecasting

with $\backslash$alpha $=0\mathrm{.}4.$ Round everything to $3$ decimal places.

Show complete calculations in two separate tables, find MSE for both methods, state clearly

which one is more accurate and using chosen method find a forecast for W$8.$

week Weekly

profit

Forecast using concrete method Forecast error Squared

forecast error

$15$

$27$

$38$

$48$

$510$

$613$

$717$