Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using only the Chicago sales data, generate the following sales forecasts: 1. Nave forecasts (using the deseasonalized sales data) for January 5th through January 30

Using only the Chicago sales data, generate the following sales forecasts:

1. Nave forecasts (using the deseasonalized sales data) for January 5th through January 30th. You will need to adjust the sales data to remove the seasonality effects. (6pts)

2. Four-day moving average forecasts for January 8th through January 30th using the original (seasonalized) sales data. (3pts)

3. Twelve-day moving average forecasts for January 16th through January 30th using the original (seasonalized) sales data. (3pts)

Note that, for example, you will not be able to make a four-day moving average forecast for January 7th since four previous sales figures are required.

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Advanced Accounting in Canada

Authors: Hilton Murray, Herauf Darrell

8th edition

1259087557, 1057317623, 978-1259087554

Students also viewed these Accounting questions