Problem $3-2($Algo$)$

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

Month Sales

$(000)$Units

Feb. $17$

Mar. $17$

Apr. $14$

May. $19$

Jun. $21$

Jul. $22$

Aug. $29$

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{.}65$ for August, $0\mathrm{.}20$ for July, and $0\mathrm{.}15$ for June. $($Round your answer to $2$ decimal places.$)$

$(4)$ Exponential smoothing with a smoothing constant equal to $0\mathrm{.}10,$ 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.$)$