Question: PLEASE give me a clear answer, dont just upload excel sheet and all the calculations. Give me please the exact answers in each box. Thank

PLEASE give me a clear answer, dont just uploadPLEASE give me a clear answer, dont just uploadPLEASE give me a clear answer, dont just upload excel sheet and all the calculations. Give me please the exact answers in each box.

Thank you!

Media Selection Problem Description The marketing manager of a chain of jewelry stores would like to determine the best way to allocate a weekly advertising budget of $8,000 among different advertising media. The media types and some associated attributes are listed in the following table. The manager wants to place at least five radio spots per week and wants no more than $1,800 to be spent on radio advertising each week. Formulate a linear programming model that the manager can use to determine how he should allocate his advertising budget in order to reach the maximum audience. After formulating the LP model, build the model in Excel and use Solver to find the optimal solution. You will answer questions about the model and the solution on Blackboard. Now, let's get serious. Of course we cannot buy partial ads!! We need to ensure that the values of the decision variables are integer. You can do that by adding a set of constraints that force each decision variable to be an integer (hint: look in the Solver window for this option). With the new requirement added to the model, the optimal allocation (in number of ads) that maximizes the audience reach is TV spots ads in newspaper spots on radio in prime time spots on radio in the afternoon The maximum audience reached is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!