Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Atwitter The college director of global activities was hopeful that the print ads in the school newspaper and 30 second spotsg7 on the campus radio

Atwitter The college director of global activities was hopeful that the print ads in the school newspaper and 30 second spotsg7 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 $3600, 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 14.16 0 3000 $E$2 Twitter 0 -800 700 $F$2 Facebook 4 0 200 42,080

39,080

43,280

cannot be determined from the sensitivity report

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions