Click here for the Excel Data File

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

$(1)$ The naive approach.

Naive approach

$27$ thousands

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

decimal places.$)$

Moving average

$21\mathrm{.}00$

thousands

$(3)$ A weighted average using $0\mathrm{.}55$ for August, $0\mathrm{.}10$ for July, and

$0\mathrm{.}35$ for June. $($Round your answer to $2$ decimal places.$)$National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven$-$month period were as follows:

Month Sales

$(000)$Units

Feb. $15$

Mar. $18$

Apr. $12$

May. $20$

Jun. $23$

Jul. $23$

Aug. $27$

Click here for the Excel Data File

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

$(1)$ The naive approach.

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

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

$(4)$ Exponential smoothing with a smoothing constant equal to $0\mathrm{.}25,$ assuming a March forecast of $17(000).($Round your intermediate forecast values and final answer to $2$ decimal places.$)$

$(5)$ A linear trend equation. $($Round your intermediate calculations and final answer to $2$ decimal places.$)$