Just explain the steps on how I wpuld go about this in Excel if you had the data in front of you. Thank you

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 2ndDay 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 entirecustomer base containing special offers. July sales data are detailed below, and the e-mail drop dates are highlighted in blue.

A) Please Create 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!