Chapter $15$ The University Bookstore Student Computer Purchase Program Case

$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 $=\mathrm{.}3$

$2.$ Adjusted exponential smoothing $($alpha $=\mathrm{.}3,$ beta $=\mathrm{.}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.$ You can use Excel, Excel QM or QM for Windows.

$4.$ Identify the forecast technique with the lowest MAD.