Question: Please help me understand and solve this assignment! Thanks! The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36
Please help me understand and solve this assignment! Thanks!
The following table contains the demand from the last 10 months:
| MONTH | ACTUAL DEMAND |
|---|---|
| 1 | 36 |
| 2 | 35 |
| 3 | 36 |
| 4 | 39 |
| 5 | 41 |
| 6 | 40 |
| 7 | 41 |
| 8 | 43 |
| 9 | 40 |
| 10 | 40 |
a. Calculate the single exponential smoothing forecast for these data using an of 0.30 and an initial forecast ( F11 ) of 36.
| 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 an of 0.30, a of 0.20, an initial trend forecast ( T11 ) of 1.00, and an initial exponentially smoothed forecast ( F11 ) of 35.
| 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.
Note: Round your intermediate calculations and answers to 2 decimal places.
| MAD | |
| Single exponential smoothing forecast | |
| Exponential smoothing with trend forecast |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
