Problem $3-2($Algo$)$

References

National Scan, Incorporated, sells radio frequency inventory tags. Monthly sales for a seven$-$month period were as follows:

Click here for the Excel Data File

a$.$ Forecast September sales volume using each of the following:

The naive approach.

Naive approach

thousands

A five$-$month moving average.

Note: Round your answer to $2$ decimal places.

Moving average

thousands

A weighted average using $0\mathrm{.}50$ for August, $0\mathrm{.}20$ for July, and $0\mathrm{.}30$ for June.

Note: Round your answer to $2$ decimal places.

Weighted average

thousandsProblem $3-2($Algo$)$

References

National Scan, Incorporated, sells radio frequency inventory tags. Monthly sales for a seven$-$month period were as follows:

Click here for the Excel Data File

a$.$ Forecast September sales volume using each of the following:

The naive approach.

Naive approach

thousands

A five$-$month moving average.

Note: Round your answer to $2$ decimal places.

Moving average

thousands

A weighted average using $0\mathrm{.}50$ for August, $0\mathrm{.}20$ for July, and $0\mathrm{.}30$ for June.

Note: Round your answer to $2$ decimal places.

Weighted average

thousands Exponential smoothing with a smoothing constant equal to $0\mathrm{.}20,$ assuming a March forecast of $16(000).$

Note: Round your intermediate forecast values and final answer to $2$ decimal places.

Forecast

thousands

A linear trend equation.

Note: Round your intermediate calculations and final answer to $2$ decimal places.

$Y_t$

thousands