Question: Show me the steps to solve I need help with the excel formulas for the exponential smoothing for June thru September. 1 . National Scan,
Show me the steps to solve
I need help with the excel formulas for the exponential smoothing for June thru September.
National Scan, Inc sells radio frequency inventory tags. Monthly sales for a sevenmonth period were as follows:
Month Sales units
Feb.
Mar.
Apr.
May
Jun.
Jul.
Aug.
a Plot the monthly data on a sheet of graph paper.
b Forecast September sales volume using each of the following:
The naive approach
A five month moving average
A weighted average using for August, for July, and for June
Exponential smoothing with a smoothing constant equal to assuming a a March forecast of
A linear trend equation
c Which method seems least appropriate? Why? Hint: Refer to your plot from part a
d What 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
