1) Show your calculation on Bob's ROI Calculation

2) Prepare a Table 3 that shows the Average weekly total traffic from Google for Weeks 1-9 and Weeks 10-12 and provide the % of reduction on ads

3) Prepare a Table 4 that shows the Average weekly total traffic from Bing for Weeks 1-9 and Weeks 10-12 and provide the % of reduction on ads

4) Prepare a Table 5 that shows the Actual and Projected Weekly Average Total Traffic in weeks 1-9 and 10-12 and provide the difference between those two values for Google and Bing. It should be one %

The average cost per click for a sponsored click $0.60

12 Table 1: Weekly traffic from Google by origin of click Week 1 2 Sponsored 32,269 31,951 32,143 Organic 127,876 128,169 125,717) 4 31,417 126,264 5 31,194 123,871 6 31,576 124,053 30,951 126,105 8 30,611 123,064 9 30,401 121,637 10 0 150,188 11 0 148,658 0 146,584 Table 2: Weekly traffic from Bing by origin of click Week 1 2 3 Sponsored 3,965 3,984 3,960 Organic 15,805 15,964 15,8151 4 3,952 15,810 5 3,874 15,633 3,932 15,797 3,890 15,462) 8 3,883 15,309 9 3,843 15,499 10 3,815 15,185 11 3,754 15,159) 12 3,754 15,036 12 Table 1: Weekly traffic from Google by origin of click Week 1 2 Sponsored 32,269 31,951 32,143 Organic 127,876 128,169 125,717) 4 31,417 126,264 5 31,194 123,871 6 31,576 124,053 30,951 126,105 8 30,611 123,064 9 30,401 121,637 10 0 150,188 11 0 148,658 0 146,584 Table 2: Weekly traffic from Bing by origin of click Week 1 2 3 Sponsored 3,965 3,984 3,960 Organic 15,805 15,964 15,8151 4 3,952 15,810 5 3,874 15,633 3,932 15,797 3,890 15,462) 8 3,883 15,309 9 3,843 15,499 10 3,815 15,185 11 3,754 15,159) 12 3,754 15,036