Question: 3. Using only the Seattle sales data: 1. Forecast sales for January 5 th through January 30 th using exponential smoothing with alpha set to

3. Using only the Seattle sales data:

1. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to 0.6. Assume the sales forecast for January 4th was 456. (6pts)

2. Using your forecasts from Q3.1, find the mean absolute deviation of the sales forecasts for January 5th through January 29th. Again, you should not include the forecast for January 30th since there is no corresponding sales figure for that date. (4pts)

3. Using your forecasts from Q3.1, find the mean squared error of the sales forecasts for January 5th through January 29th. (4pts)

Date

Chicago

Seasonal Relatives for Chicago Sales

Nashville

Seattle

1/4/21

272

0.4

659

456

1/5/21

388

0.5

493

672

1/6/21

622

1.3

483

584

1/7/21

605

1.7

579

609

1/8/21

222

1.4

652

596

1/9/21

222

1.6

535

529

1/10/21

302

0.9

399

612

1/11/21

338

1.2

423

683

1/12/21

239

0.5

619

565

1/13/21

283

0.3

567

559

1/14/21

505

0.7

548

785

1/15/21

829

1.1

766

783

1/16/21

686

1.4

479

599

1/17/21

893

2.2

435

711

1/18/21

184

0.6

651

756

1/19/21

188

0.7

650

712

1/20/21

290

0.8

491

512

1/21/21

369

0.9

549

447

1/22/21

395

1.3

463

574

1/23/21

846

1.5

595

654

1/24/21

961

1.9

829

552

1/25/21

193

0.5

886

470

1/26/21

193

0.8

639

596

1/27/21

245

0.8

645

562

1/28/21

317

0.9

627

454

1/29/21

480

1

459

800

1/30/21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!