Discuss the below:
Q1. Develop an appropriate forecast model for the bookstore manager to use to forecast computer demand for the 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)
Q2. Complete all above forecast techniques using MS Excel
a. Label everything appropriately. You do not need to make each forecast technique a separate tab on the sheet. However, please label columns correctly.
b. Place your name in the document
3. Use the forecast technique with the lowest MAD to determine the most appropriate model.
4. Solve the forecast model for the lowest MAD and indicate how accurate it appears to be.
Attachment:- computer purchase program.rar