Please read the case study attached. I am not sure how to develop a model? I can put the info into an excel sheet, but need help getting started.
1. Develop an appropriate forecast model for the bookstore manager to use to forecast computer demand for tne next fall semester. Show work for the following forecast techniques:
a. Moving average ( n=3)
b. Moving average (n=5)
c. Linear trend line
d. Exponential smoothing (alpha = .3)
e. Exponential smoothing (alpha = .5)
f. Exponential smoothing (alpha = .3, beta = .4)
g. Exponential smoothing (alpha = .4 , beta = .5)
This posting provides solution to forecasting problems on computer demand using moving average, linear trend line and exponential smoothing techniques.