Excel Online Structured Activity: Weighted Moving Average Forecast has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the four$-$period weighted moving average forecast and answer the following questions.

Open spreadsheet

Questions

$1.$ Calculate the forecast for the periods from $5$ to $13$ using a four$-$period weighted moving average. Do not round intermediate calculations. Round your answers to the nearest whole number.

$\backslash$begin$\{$tabular$\}\{$c$|$c$\}$

Period & Forecast $\backslash \backslash$

$\backslash$cline $\{1-1\}5$ & $\backslash \backslash$

$6$ & $\backslash \backslash$

$7$ & $\backslash \backslash$

$8$ & $\backslash \backslash$

$9$ & $\backslash \backslash$

$10$ & $\backslash \backslash$

$11$ & $\backslash \backslash$

$12$ & $\backslash \backslash$

$13$ &

$\backslash$end$\{$tabular$\}$

$2.$ Choose the correct graph for the four$-$period weighted moving average forecast.

The correct graph is $\backslash (\backslash$mid $\backslash )$ Weighted Moving Average Forecast $(4$ periods$)$

Period

$\backslash$begin$\{$tabular$\}\{|$r$|$r$|$r$|$r$|\}$

$\backslash$hline & Actual Demand & Forecast & Formulas $\backslash \backslash$

$\backslash$hline $1$ & $1,400$ & & $\backslash \backslash$

$\backslash$hline $2$ & $2,100$ & & $\backslash \backslash$

$\backslash$hline $3$ & $1,900$ & & $\backslash \backslash$

$\backslash$hline $4$ & $1,600$ & & $\backslash \backslash$

$\backslash$hline $5$ & $2,400$ & & $\backslash \backslash$

$\backslash$hline $6$ & $3,500$ & $\backslash \backslash$

$\backslash$hline $7$ & $3,000$ & $\backslash \backslash$

$\backslash$hline $8$ & $2,900$ & $\backslash \backslash$

$\backslash$hline $9$ & $3,900$ & $\backslash \backslash$

$\backslash$hline $10$ & $4,500$ & $\backslash \backslash$

$\backslash$hline $1$ & $4,100$ & $\backslash \backslash$

$\backslash$hline $1$ & $4,400$ & & $\backslash \backslash$

$\backslash$hline $13$ & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

$\backslash$#N$/$A

$\backslash$#N$/$A

$\backslash$#N$/$A

$\backslash$#N$/$A

$\backslash$#N$/$A

$\backslash$#N$/$A

$\backslash$#N$/$A

$\backslash$#N$/$A

$\backslash$#N$/$A