Excel Spreadsheet Is complete. Need Help w/ Questions Below

1. Using the assumptions provided in Excel Spreadsheet, what is the total number of customers generated from this advertising?

2. If Dr. Corneals customers spend $300 on average, what is the total revenue generated from this advertising?

3. The cost to purchase the advertising is as follows:

Google Ads: $5,000

Newspapers: $3,000

Magazines: $6,000

Radio: $1,000

Using these costs and the revenue generated from each ad source, calculate the overall ROI and the ROI per advertising source. How do these numbers help you plan your advertising budget going forward? Assume Dr. Corneal doesn't know anything about ROI. What is your recommendation to her regarding the use of her budget for the next year. Use the numbers in this assignment to provide your recommendation. (See your textbook for help.)

Note - ROI is expressed as a percent. ROI= (Revenue - Costs)/Costs x 100

Dr. Corneal's Projected Sales Funnel Opportunities Customers \begin{tabular}{|l|r|r|} \hline 96 & 21 & 38 \\ \hline \end{tabular} Total Customers 160 Assumptions: 5,000 people live within 15 miles of Dr. Corneal's store 90% use Google regularly, 50% read newspaper, 60% read magazines, 20% listen to radio Based on medical data,on average 75% of the population needs glasses Radio listeners are older, have more eye issues, 90% need glasses 10% of people don't need glasses but like fashion sunglasses Average Call To Action Response Rates \begin{tabular}{|l|r|} \hline Google & 5% \\ \hline Newspapers & 2% \\ \hline Magazines & 3% \\ \hline Radio & 1% \\ \hline \end{tabular} Average conversion rate from Opportunity to Customer - 50%