Assignment 2: Business Forecasting
tutor4helpyou
data.xlsxSheet1
| Month | 1990 | 1991 | 1992 |
| January | 2.3 | 2.54 | 3.3 |
| February | 2.6 | 2.8 | 3.31 |
| March | 2.75 | 3 | 3.78 |
| April | 2.85 | 3.43 | 4.2 |
| May | 3.25 | 3.85 | 4.2 |
| June | 3.37 | 3.9 | 5 |
| July | 3.25 | 3.8 | * |
| August | 3.37 | 3.9 | * |
| September | 3.2 | 3.6 | * |
| October | 3.2 | 3.55 | * |
| November | 2.75 | 3.25 | * |
| December | 2.65 | 3.2 | * |
&"Times New Roman,Regular"&12&A
&"Times New Roman,Regular"&12Page &P
Sheet2
| Year | Demand | 5-Year Moving Average | 3-Year Moving Average | Exponential Smoothing w = 0.9 | Exponential Smoothing w = 0.3 |
| 19X0 | 800 | - | - | - | ? |
| 19X1 | 925 | - | - | ? | ? |
| 19X2 | 900 | - | - | ? | ? |
| 19X3 | 1025 | - | ? | ? | ? |
| 19X4 | 1150 | - | ? | ? | ? |
| 19X5 | 1160 | ? | ? | ? | ? |
| 19X6 | 1200 | ? | ? | ? | ? |
| 19X7 | 1150 | ? | ? | ? | ? |
| 19X8 | 1270 | ? | ? | ? | ? |
| 19X9 | 1290 | ? | ? | ? | ? |
| 19X0 | ??? | ? | ? | ? | ? |
&"Times New Roman,Regular"&12&A
&"Times New Roman,Regular"&12Page &P
