forecast actual demand error

$2$Q $2022215$

$3$Q $2022210$

$4$Q $2022220$

$1$Q $2023255$

$2$Q $2023245$

$3$Q $2023240$

$4$Q $2023280$

$1$Q $2024260$

$2$Q $2024$

$1.$ Using the $4-$quarter moving average: What is the forecast for $3$Q $2023,4$Q $2023,1$Q $2024,$ and $2$Q $2024$

$2.$ Compute the forecast for $3$Q $2023,4$Q $2023,1$Q $2024,$ and $2$Q $2024$ using exponential smoothing $($start with $3$Q $2023)$ with a smoothing factor of $\mathrm{.}6.$

$3.$ Which forecast method provides a more accurate forecast? The $4-$quarter moving average produces the most accurate forecast as the errors are

$4.$ Compute the forecast for $3$Q $2023,4$Q $2023,1$Q $2024,$ and $2$Q $2024$

using a weighted moving average technique. The most recent period is weighted at $\mathrm{.}45,$ second most recent at $\mathrm{.}3,$ and $3$rd most recent at $\mathrm{.}2$ and $4$th most recent at $\mathrm{.}05.$

$5.$ Compare the results from $4$ to the results from $1$ and $2.$ Now which forecast provides the more accurate forecast?

$6.$ If the exponential smoothing is calculated using a smoothing factor of $\mathrm{.}8$ will the forecast error be smaller or larger?