- Business
- Operations Management
- twenty days of demand data have been provided in the...
Question: twenty days of demand data have been provided in the...
Question details
Twenty days of demand data have been provided in the Excel worksheet, as well as a first forecast for day two. Please build an exponential smoothing forecasting model that will compute forecasts for days 3 to 21, and report your forecast for day 21 (to two decimal places). alpha 0.55 Day
|
alpha |
||
|
0.55 |
||
|
Day (t) |
Demand (Dt) |
Forecast (Ft) |
|
1 |
1420 |
|
|
2 |
1418 |
1420.00 |
|
3 |
1436 |
|
|
4 |
1441 |
|
|
5 |
1441 |
|
|
6 |
1457 |
|
|
7 |
1448 |
|
|
8 |
1439 |
|
|
9 |
1458 |
|
|
10 |
1448 |
|
|
11 |
1446 |
|
|
12 |
1460 |
|
|
13 |
1466 |
|
|
14 |
1467 |
|
|
15 |
1471 |
|
|
16 |
1478 |
|
|
17 |
1477 |
|
|
18 |
1492 |
|
|
19 |
1474 |
|
|
20 |
1455 |
|
|
21 |
Solution by an expert tutor
