Question: table [ [ Period , Actual Value ] , [ Quarter 1 , 2 9 4 ] , [ Quarter 2 , 4 9

\table[[Period,Actual Value],[Quarter 1,294],[Quarter 2,499],[Quarter 3,437],[Quarter 4,344],[Quarter 5,335],[Quarter 6,507],[Quarter 7,529],[Quarter 8,285],[Quarter 9,433],[Quarter 10,516],[Quarter 11,501],[Quarter 12,482],[Quarter 13,280],[Quarter 14,524],[Quarter 15,515],[Quarter 16,530]]
Generate a forecast using Exponential smoothing, using alpha =.7.
Assume forecast for Quarter ) was 294(i.e.,F=294).
a. What is the forecast for Quarter )=(17?
b. Find the MAD based on periods 5 through ,16).
What is the MAD?
c. Use nonlinear programming to find the alpha that minimizes MAD.
i. What is the alpha
ii. What is the MAD?
iii. What is the forecast for Quarter )=(17 using this alpha
 \table[[Period,Actual Value],[Quarter 1,294],[Quarter 2,499],[Quarter 3,437],[Quarter 4,344],[Quarter 5,335],[Quarter 6,507],[Quarter 7,529],[Quarter 8,285],[Quarter 9,433],[Quarter

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 Finance Questions!