Get your original paper written from scratch starting at just $10 per page with a plagiarism report and free revisions included!
The following table contains the demand from the last 10 months: |
MONTH | ACTUAL DEMAND |
1 | 29 |
2 | 32 |
3 | 33 |
4 | 38 |
5 | 42 |
6 | 36 |
7 | 45 |
8 | 47 |
9 | 48 |
10 | 45 |
a. |
Calculate the single exponential smoothing forecast for these data using anaof 0.20 and an initial forecast (F1) of 29.(Round your answers to 2 decimal places.) |
Month | Exponential Smoothing |
1 | |
2 | |
3 | |
4 | |
5 | |
6 | |
7 | |
8 | |
9 | |
10 | |
b. |
Calculate the exponential smoothing with trend forecast for these data using anaof 0.20, adof 0.30, an initial trend forecast (T1) of 1.00, and an initial exponentially smoothed forecast (F1) of 28.(Round your answers to 2 decimal places.) |
Month | FITt |
1 | |
2 | |
3 | |
4 | |
5 | |
6 | |
7 | |
8 | |
9 | |
10 | |
c-1. |
Calculate the mean absolute deviation (MAD) for the last nine months of forecasts.(Round your answers to 2 decimal places.) |
MAD | |
Single exponential smoothing forecast | |
Exponential smoothing with trend forecast | |
c-2. | Which is best? | ||||
|