Question: THE QUESTIONS I NEED HELP WITH ARE IN RED BELOW 2. National Scan, Inc., sells radio frequency inventor tags. Monthly sales for a seven-month period

THE QUESTIONS I NEED HELP WITH ARE IN RED BELOW

THE QUESTIONS I NEED HELP WITH ARE IN RED BELOW

THE QUESTIONS I NEED HELP WITH ARE IN RED BELOW

THE QUESTIONS I NEED HELP WITH ARE IN RED BELOW

2. National Scan, Inc., sells radio frequency inventor tags. Monthly sales for a seven-month period were as follows: a. Plot the monthly data on a sheet of graph paper. b. Forecast September sales volume using each of the following: 1) The nave approach Nave approach is the last period's actuals are used as the current period without any adjustment. Previous actual value = present forecast value August Actual value =21 September Forecast =20 2) A five-month moving average Moving average =( Af 1, at 2, At, At 4Al5)/5 At-, August, at-2=July, at-3=June, at-4=may, at-5=April (20+22+18+20+15)/5 95/5 September Forecast =19 3) A weighted average using .60 for august, .30 for July, and .10 for June At-1=August, At 2= July, At-3=June (0.620)+(0.322)+(0.118) September Forecast =20.4 4) Exponential smoothing with a smoothing constant equal to .20 assuming a a March forecast of 19(000) NEED HELP WITH THIS ONE 5) A linear trend equation Y=a+bx Y=16.86+0.5x 16.86+0.50(8)=20.86 September Forecast =20.86 c. Which method seems least appropriate? Why? (hint refer to your plot from part a. d. Why does use of the term sales rather than demand presume

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!