Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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 thousands

Explanation / 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