Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Introduction To Management Science and Business Analytics A Modeling And Case Studies Approach With Spreadsheets

Authors: Frederick S. Hillier, Mark S. Hillier

7th Edition

1260716295, 9781260716290

More Books

Students also viewed these Accounting questions