Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Three advertising media are being considered for the promotion of a product. Radio ads cost $387 each, newspaper ads cost $443 each, and Twitter
Three advertising media are being considered for the promotion of a product. Radio ads cost $387 each, newspaper ads cost $443 each, and Twitter ads cost $580. The total budget is $48,500 per week. The total number of ads should be at least 35, with a max of 7 newspaper ads. Each newspaper ad reaches 10,500 people, each radio ad reaches 9,000, and Twitter reaches 13,000 people. Let R = # of radio ads Let P = # of newspaper ads Let T = # of Twitter ads (Must Solve using Solver) Questions: 1. The company wishes to reach as many people as possible while meeting all the constraints stated; what is maximum reach? (round your answer to 2 decimal points) 2. How many ads of each type should be placed? (round your answer to 2 decimal points, for example, r = 89.26) 3. If we decrease the RHS of the # of newspaper ads by one less, what is the objective function's new value and each variable's value? (This step requires you to re-run Solver to get a new sensitivity report) Write your responses to the questions in the space provided and upload your Excel spreadsheet and sensitivity report.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started