Use the Sensitivity Report for this LP model (shown in Screenshot 4-6) to answer the following questions.

Question:

Use the Sensitivity Report for this LP model (shown in Screenshot 4-6) to answer the following questions. Each question is independent of the others.

What is the impact on the audience coverage under the following scenarios?

(a) Management approves spending $200 more on radio advertising each week.

(b) The contractual agreement to place at least five radio spots per week is eliminated.

(c) The audience reached per ad increases to 3,100.

(d) There is some uncertainty in the audience reached per TV spot. For what range of values for this OFC will the current solution remain optimal?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Decision Modeling With Spreadsheets

ISBN: 718

3rd Edition

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

Question Posted: