Extra Credit
Homework
Put your answers on a
single Excel Workbook with your name in the file name. No credit will be given for anything else.
Email your answers to
aloerch@gmail.com They are due
Problem 1. Use Exponential Smoothing to make
the forecasts for 2005 and 2006. Find the best values for alpha and beta.
|
Year |
Sales |
|
1985 |
283 |
|
1986 |
288 |
|
1987 |
336 |
|
1988 |
388 |
|
1989 |
406 |
|
1990 |
412 |
|
1991 |
416 |
|
1992 |
435 |
|
1993 |
428 |
|
1994 |
435 |
|
1995 |
462 |
|
1996 |
452 |
|
1997 |
474 |
|
1998 |
476 |
|
1999 |
497 |
|
2000 |
487 |
|
2001 |
523 |
|
2002 |
528 |
|
2003 |
532 |
|
2004 |
552 |
Problem 2. Make the forecast for the four quarters of 2004.
|
Year |
Quarter |
Time |
Units Sold |
|
2001 |
1 |
1 |
23 |
|
|
2 |
2 |
25 |
|
|
3 |
3 |
36 |
|
|
4 |
4 |
31 |
|
2002 |
1 |
5 |
26 |
|
|
2 |
6 |
28 |
|
|
3 |
7 |
48 |
|
|
4 |
8 |
36 |
|
2003 |
1 |
9 |
31 |
|
|
2 |
10 |
42 |
|
|
3 |
11 |
53 |
|
|
4 |
12 |
43 |