1. Business
  2. Operations Management
  3. 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
Blurred Solution
This question has been solved
Subscribe to see this solution