please answer $3,4,5$Homework: Forecasting Assignment $($i$)$

Saved

Help

Save & Exit

Submit

$1$

Check my work

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

$\backslash$table$[[$Month$,\backslash$table$[[$Sales$],[(000)$ Units$]]],[$Feb$.,18],[$Mar$.,16],[$Apr$.,15],[$May$.,18],[$Jun$.,20],[$Jul$.,21],[$Aug$.,23]]$

Click here for the Excel Data File

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

$(1)$ The naive approach.

Naive approach

$23$ thousands

References

$(2)$ A five$-$month moving average. $($Round your answer to $2$ decimal places.$)$

Moving average

$19\mathrm{.}40$ thousands

$(3)$ A weighted average using $0\mathrm{.}65$ for August, $0\mathrm{.}15$ for July, and $0\mathrm{.}20$ for June. $($Round your answer to $2$ decimal places.$)$

Weighted average

thousands

Mc

Graw

Prev

$1$ of $5$

Next