Background Forecasting refers to predicting a future event or trend Relationships are connections found within the data Ad Copy is the main text of an adverstisement designed to get the reader to respond or take action Tagline refers to a headline (ex. "Just Do It") Scenario Joe, the VitaPath CEO, has asked you to review the July data and present him with expectations for August VitaPath is a vitamin chain throughout Canada All orders are shipped FedEx Overnight or 2nd Day on the date requested by the customer VitaPath acquires new customers with daily spots on the Health Network, and also enjoys a brisk repeat business Three times each month, VitaPath sends an e-mail to its entire customer base containing special offers July sales data are detailed below, and the e-mail drop dates are highlighted in blue Questions A) Create a forecast for August daily orders, shipments, new customers, and repeat orders in the below table. Do not rely on the forecast and trend functions for your answer. B) Please explain all of the relationships you discovered and analysis you performed. Try to find relationships between the different columns of data. (ex. list form) C) Draft a response to Joe, the CEO. Be sure to include: 1. The relationships found in July 2. Expectations for August 3. A sample of copy to use for the end of August e-mail blast. Include a tagline or offer text and be creative! 1-Jul 2-Ju 3-Jul Shipments 3,364 3,201 4-Jul 5-Jul 1,364 726 6-Jul New Customers 659 506 333 213 286 196 310 837 959 851 686 403 265 338 915 Orders 2,258 1,594 1,078 605 843 619 883 3,094 3,559 2,502 2,041 1,306 719 981 3,531 4,003 2,627 2,114 1,556 739 916 2,276 2,248 2,130 1,876 1,301 661 830 3,370 3,898 2,803 3,359 2,664 2,857 3,156 989 719 Repeat Orders 1,599 1,088 745 392 557 423 573 2.257 2,600 1,651 1,355 903 454 643 2,616 3,209 1,776 1,392 1,038 499 626 1,535 1,465 1,354 1,249 886 434 3,463 3,018 2,981 3,496 1,068 762 290 741 783 776 3,060 2,306 2,285 2,894 960 538 627 415 227 278 790 790 858 552 3,147 2,882 3,229 2,580 3,108 1,945 7-Jul 8-Jul 9-Jul 10-Jul 11-Jul 12-Jul 13-Jul 14-Jul 15-Jul 16-Jul 17-Jul 18-Jull 19-Jul 20-Jul 21-Jul 22-Jul 23-Jul 24-Juil 25-Jul 26-Jul 27-Jul 28-Jul 29-Jul 30-Jul 31-Jul 1-Aug 2-Aug 3-Aug 4-Aug 5-Aug 6-Aug 7-Aug 8-Aug 9-Aug 10-Aug 11-Aug 12-Aug 13-Aug 14-Aug 15-Aug 16-Aug 17-Aug 18-Aug 19-Aug 20-Aug 21-Aug 22-Aug 23-Aug 24-Aug 25-Aug 26-Aug 27-Aug 28-Aug 29-Aug 30-Aug 31-Aug Background Forecasting refers to predicting a future event or trend Relationships are connections found within the data Ad Copy is the main text of an adverstisement designed to get the reader to respond or take action Tagline refers to a headline (ex. "Just Do It") Scenario Joe, the VitaPath CEO, has asked you to review the July data and present him with expectations for August VitaPath is a vitamin chain throughout Canada All orders are shipped FedEx Overnight or 2nd Day on the date requested by the customer VitaPath acquires new customers with daily spots on the Health Network, and also enjoys a brisk repeat business Three times each month, VitaPath sends an e-mail to its entire customer base containing special offers July sales data are detailed below, and the e-mail drop dates are highlighted in blue Questions A) Create a forecast for August daily orders, shipments, new customers, and repeat orders in the below table. Do not rely on the forecast and trend functions for your answer. B) Please explain all of the relationships you discovered and analysis you performed. Try to find relationships between the different columns of data. (ex. list form) C) Draft a response to Joe, the CEO. Be sure to include: 1. The relationships found in July 2. Expectations for August 3. A sample of copy to use for the end of August e-mail blast. Include a tagline or offer text and be creative! 1-Jul 2-Ju 3-Jul Shipments 3,364 3,201 4-Jul 5-Jul 1,364 726 6-Jul New Customers 659 506 333 213 286 196 310 837 959 851 686 403 265 338 915 Orders 2,258 1,594 1,078 605 843 619 883 3,094 3,559 2,502 2,041 1,306 719 981 3,531 4,003 2,627 2,114 1,556 739 916 2,276 2,248 2,130 1,876 1,301 661 830 3,370 3,898 2,803 3,359 2,664 2,857 3,156 989 719 Repeat Orders 1,599 1,088 745 392 557 423 573 2.257 2,600 1,651 1,355 903 454 643 2,616 3,209 1,776 1,392 1,038 499 626 1,535 1,465 1,354 1,249 886 434 3,463 3,018 2,981 3,496 1,068 762 290 741 783 776 3,060 2,306 2,285 2,894 960 538 627 415 227 278 790 790 858 552 3,147 2,882 3,229 2,580 3,108 1,945 7-Jul 8-Jul 9-Jul 10-Jul 11-Jul 12-Jul 13-Jul 14-Jul 15-Jul 16-Jul 17-Jul 18-Jull 19-Jul 20-Jul 21-Jul 22-Jul 23-Jul 24-Juil 25-Jul 26-Jul 27-Jul 28-Jul 29-Jul 30-Jul 31-Jul 1-Aug 2-Aug 3-Aug 4-Aug 5-Aug 6-Aug 7-Aug 8-Aug 9-Aug 10-Aug 11-Aug 12-Aug 13-Aug 14-Aug 15-Aug 16-Aug 17-Aug 18-Aug 19-Aug 20-Aug 21-Aug 22-Aug 23-Aug 24-Aug 25-Aug 26-Aug 27-Aug 28-Aug 29-Aug 30-Aug 31-Aug