1. Using the assumptions provided in Excel Spreadsheet, what is the total number of customers generated from this advertising? 2. If Dr. Corneal’s 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 Calculate the overall ROI and the ROI per advertising source. How do these number help you plan your advertising budget going forward? To answer this question, define ROI, explain how ROI is used (see your book), apply the numbers you have calculated and show how you would use these numbers for planning purposes. Note - ROI is expressed as a percent. ROI= (Revenue - Costs)/Costs
I need help answering the questions below...
1. Using the assumptions provided in Excel Spreadsheet, what is the total number of customers generated from this advertising?
2. If Dr. Corneal’s 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
Calculate the overall
Note - ROI is expressed as a percent. ROI= (Revenue - Costs)/Costs
Step by step
Solved in 5 steps with 3 images