Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started