Complete the spreadsheet below and use it to answer the questions that follow.

This activity is important because marketing managers need to know how to calculate and understand ROMI in order to optimize their investments in various marketing communications channels.

The goal of this activity is to test your understanding of ROMI by considering this example.

Using the spreadsheet above, enter the information provided above on the revenues and cost associated with each marketing campaign. What is the value of new revenue generated by the television marketing campaign?

$($Click to select$)$

What is the ROMI of the social media campaign?

$($Click to select$)$

Which marketing campaign had the lowest ROMI?

$($Click to select$)$

Fill out the mini$-$spreadsheet shown and use it to answer the following question: Your boss tells you that the company will not invest in another marketing campaign unless the ROMI is $1\mathrm{.}40$ or greater. Determine what the minimum amount of new revenue generated will need to be in order to meet an ROMI target of $1\mathrm{.}40.$

$($Click to select$)$

Use the information originally presented and the mini spreadsheet shown here to answer this question: What would the minimal television campaign cost have be in order to have a ROMI of $1\mathrm{.}60?$