A portion of the variable cells section of the sensitivity report in Excel appears in the table below. How many potential customers will be reached by the optimal advertising campaign?
Final Reduced Objective
Cell Name Value Cost Coefficient
$C$2 Newspaper 0 -1000 5000
$D$2 Radio 13.76 0 3000
$E$2 Twitter 0 -800 700
$F$2 Facebook 4 0 200
A) 17.76
B) 8,900
C) 42,080
D) cannot be determined from the sensitivity report
Answer: C
You might also like to view...
A fixed price is essential to the creation of a binding sales contract.
Answer the following statement true (T) or false (F)
Turnover intentions and turnover are forms of ______.
A. motivation B. employee withdrawal C. performance D. work-related attitudes
The balance sheet equation maintains equality by reporting the financial statement effects of each event and transaction in a dual manner, or what are termed the dual effects of transactions
Indicate whether the statement is true or false
When looking at financials for your venture investors are also looking for a(an):
a. Exit Potential b. Executive Summary c. Organization Structure d. Marketing Strategy