solution

The college director of global activities was hopeful that the print ads in the school newspaper and 30 second spots on the campus radio station would spur some interest in the array of study tour and study abroad options he had secured. The communications director for the college had other ideas; she favored a social media campaign consisting of tweets and Facebook postings. “This is the most ridiculous thing I ever heard of,” he whined to the dean.
The communications director’s market research revealed the following:

Medium Exposure Cost
Newspaper 5,000 $500
Radio 3,000 $250
Twitter 700 $25
Facebook 200 $15

The advertising budget is $3500, but there is no requirement that all the money be spent. The newspaper has only four issues before the end of the semester, but the radio is a 24/7 operation and has two dozen 30 second slots available. Facebook postings must be alternated with the rest of the mindless drivel posted on the college page; thus there is space for only three postings before the end of the semester. Twitter is complicated by the 140-character requirement. The communications director feels she needs five tweets to convey a single message about tours and semesters abroad, so for one message, the cost would be $25 for each of the five components of the single ad. Due to thumb fatigue, she feels that she has only 2800 characters left in her thumbs before the end of the semester. (A side note – During the intersession period, she plans to embark on a strict regimen of thumb yoga to prepare for the coming semester.)
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?

Cell Name Final
Value
Reduced
Cost
Objective
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

17.76

42,080

8,900

cannot be determined from the sensitivity report

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"