Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Burlington has tracked daily sales of coats for the three locations below: Date Chicago Seasonal Relatives for Chicago Sales California New York 1/4/18 152 0.3

Burlington has tracked daily sales of coats for the three locations below:

Date

Chicago

Seasonal Relatives for Chicago Sales

California

New York

1/4/18

152

0.3

640

456

1/5/18

195

0.4

586

650

1/6/18

653

1.5

420

543

1/7/18

187

0.5

645

632

1/8/18

240

0.6

507

546

1/9/18

207

0.8

623

531

1/10/18

311

0.9

511

544

1/11/18

373

1.2

500

639

1/12/18

225

0.5

576

570

1/13/18

276

0.3

540

544

1/14/18

475

0.7

475

674

1/15/18

755

1.1

645

711

1/16/18

732

1.4

534

594

1/17/18

975

2.2

511

564

1/18/18

170

0.3

650

693

1/19/18

203

0.7

699

645

1/20/18

288

0.8

580

570

1/21/18

378

0.9

520

456

1/22/18

400

1.3

546

609

1/23/18

798

1.6

576

585

1/24/18

1111

1.9

649

609

1/25/18

176

0.5

657

480

1/26/18

213

0.6

600

544

1/27/18

240

0.9

703

560

1/28/18

311

0.7

657

476

1/29/18

456

1

546

656

1/30/18

Question Set 1. 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. (3pts)

3. Twelve-day moving average forecasts for January 16th through January 30th. (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.

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

The Wealthtech Book The FinTech Handbook For Investors Entrepreneurs And Finance Visionaries

Authors: Susanne Chishti, Thomas Puschmann

1st Edition

1119362156, 978-1119362159

More Books

Students also viewed these Finance questions

Question

What assets constitute property, plant and equipment?

Answered: 1 week ago

Question

Assess three steps in the selection process.

Answered: 1 week ago

Question

Identify the steps in job analysis.

Answered: 1 week ago