List step by$-$step instructions on how to perform this in excel using data analysis and answer parts a$-$c$.$

Period Demand

$1$

$2$

$3$

$4$

$5$

$6$

$13$

$14$

$16$

Use the provided data to calcuate Period $7$ Forecast to one decimal place

a$)($SMA$)$ Three Month Moving Average:

b$)($WMA$)$ Three Month Weighted Moving Average:

$($Most recent period weight $=\mathrm{.}5$; weight for prior period to most recent $=\mathrm{.}3$; weight for period prior $=\mathrm{.}2)$

$17$

$19$

c$)$ Linear Trend using Regression:

Note: A forecasted value for Period $7$ is required for all three a$,$ b & c$.$

$20$