Homework SourseQuestion 1802 Actual sales for January through April are sho
Question 18.02}
Actual sales for January through April are shown below.
| Observation | Month | Actual Sales (A) | Forecasted Sales (F) |
| 1 | January | 18 | ___________ |
| 2 | February | 23 | ___________ |
| 3 | March | 20 | ___________ |
| 4 | April | 16 | ___________ |
| 5 | May | ___________ |
Solution
excel is used to compute the forecasted values.
| t | Data | Smoothed | Forecast |
| 18.0 | * | ||
| 1 | 18 | 18.0 | 18 |
| 2 | 23 | 19.0 | 18 |
| 3 | 20 | 19.2 | 19 |
| 4 | 16 | 18.6 | 19 |
| 19 |
