Problem:
Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:
|
Month
|
Sales
(000)Units
|
|
Feb
|
18
|
|
Mar
|
19
|
|
Apr
|
12
|
|
May
|
26
|
|
Jun
|
20
|
|
Jul
|
21
|
|
Aug
|
22
|
Required:
Question 1) A linear trend equation. (Round your intermediate calculations and final answer to 2 decimal places.)
Questin 2) A five-month moving average. (Round your answer to 2 decimal places.)
Question 3) Exponential smoothing with a smoothing constant equal to .30, assuming a March forecast of 17(000). (Round your intermediate calculations and final answer to 2 decimal places.)
Question 4) A weighted average using .70 for August, .10 for July, and .20 for June. (Round your answer to 2 decimal places.) Solve the problem and show all work.