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
Get step-by-step solutions from verified subject matter experts
