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
Business
You might also like to view...
Marie and Chris wanted to buy an investment property using as little of their own money as possible, and borrowing the rest. This is an example of:
a. tight money b. disintermediation c. leverage d. discounting
Business
Which is an example of a vertical merger?
A) Southwest Airlines merging with United Airlines B) Microsoft merging with The Home Depot C) Mrs. Fields merging with Oakhurst Dairy D) Random House merging with Barnes & Noble E) Norwegian Cruise Line merging with Royal Caribbean
Business