Problems:

Using the numbers in the chart below, calculate the following:

Your Answers

$1.$ Three$-$period moving average:

$2.$ Four$-$period weighted moving average $($weights: p$1=\mathrm{.}1,$ p$2=\mathrm{.}2,$ p$3=\mathrm{.}3,$ p$4=\mathrm{.}4)$:

$3.$ Smoothed forecast for Period $6($use an $=\mathrm{.}3)$:

$4.$ Mean Squared Error for Periods $1-5$:

$5.$ Mean Absolute Deviation for Periods $1-5$:

$6.$ Average percent error for Periods $1-5$:

Period Actual Demand Forecast Demand Error

$($You must calculate$)$ Squared Error

$($You must calculate$)$ Absolute Deviation

$($You must calculate$)$ Percent Error

$($You must calculate$)$

$14852\mathrm{.}69$

$24548\mathrm{.}97$

$34745\mathrm{.}82$

$44546\mathrm{.}76$

$54045\mathrm{.}36$