Please answer the steps National Scan, Inc., sells radio frequency inventory tag
ID: 3144046 • Letter: P
Question
Please answer the steps
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: b. Forecast September sales volume using each of the following: A linear trend equation.(Round your Intermediate calculations and final answer to 2 decimal places.) Yt thousands A five-month moving average. (Round your answer to 2 decimal places.) Moving average thousands Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 14(000). (Round your Intermediate forecast values and final answer to 2 decimal places) Forecast thousands The naive approach. Naive approach thousands A weighted average using .65 for August, 05 for July, and .30 for June. (Round your answer to 2 decimal places.) Weighted average thousandsExplanation / Answer
a) 20.2 = 1/5*(sum of demand of last 5 month)
b) 27.14286 {11.39286 + 1.75*9}
c) 19.950976 {using expoential method}
d) 30 {demand of august)
e) 26.1 { = 0.65 *Aug + 0.05 *july + 0.30* jun}
Please