Table 15.3 Demand for personal computers

Period	Month	Demand
1	January	37
2	February	40
3	March	41
4	April	37
5	May	45
6	June	50
7	July	43
8	August	47
9	September	56
10	October	52
11	November	55
12	December	54

1. 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. Weighted Moving average (50%, 30%, 20%, starting with most recent period)

D. Linear trend line

E. Exponential smoothing (alpha = .3

2. Adjusted exponential smoothing (alpha = .3, beta = .4)

A. Complete all above forecast techniques using MS Excel, QM for Windows or Excel QM

B. Label everything appropriately. You do not need to make each forecast technique a separate tab on the sheet. However, please label columns correctly. C. Place your name in the document

3. Identify the forecast technique with the lowest MAD.

PLEASE SHOW ME THE FORMULAS TO USE IN EXCEL.