Return on investment (ROI) is profit divided by investment. In marketing, ROI is determined as incremental sales times gross margin minus marketing investment, all divided by marketing investment. Suppose that a company plans to spend $3 million to place search engine ads and expects $15 million in incremental sales. Its gross margin is estimated to be 45%. a. Develop a spreadsheet to compute the marketing ROI. b. Use the spreadsheet to predict how ROI will change if the incremental sales estimate is wrong (consider a range of values above and below the expected sales).
Return on investment (ROI) is profit divided by investment. In marketing, ROI is determined as incremental sales times gross margin minus marketing investment, all divided by marketing investment. Suppose that a company plans to spend $3 million to place search engine ads and expects $15 million in incremental sales. Its gross margin is estimated to be 45%. a. Develop a spreadsheet to compute the marketing ROI. b. Use the spreadsheet to predict how ROI will change if the incremental sales estimate is wrong (consider a range of values above and below the expected sales).
Chapter12: Balanced Scorecard And Other Performance Measures
Section: Chapter Questions
Problem 9EA: Classify each of the following performance measures into the balanced scorecard perspective to which...
Related questions
Question
please help with how to solve this thank you.

Transcribed Image Text:Return on investment (ROI) is profit divided by investment. In marketing, ROI is determined as incremental sales times gross margin minus marketing
investment, all divided by marketing investment. Suppose that a company plans to spend $3 million to place search engine ads and expects $15 million in
incremental sales. Its gross margin is estimated to be 45%.
a. Develop a spreadsheet to compute the marketing ROI.
b. Use the spreadsheet to predict how ROI will
change if the incremental sales estimate is wrong (consider a range of values above and below the expected sales).
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images

Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College

Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College

Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning