Question: Please just put the answer in the boxes, I want a clear answer, don't just submit excel sheet and all the calculations. Put the final


Please just put the answer in the boxes, I want a clear answer, don't just submit excel sheet and all the calculations.
Put the final answer, the exact answers in the boxes.
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. The optimal allocation (in number of ads) that maximizes the audience reach is (please round your answers to two decimals. Yes, this does not make sense, but we will deal with this in the next question). TV spots ads in newspaper spots on radio in prime time spots on radio in the afternoon The maximum audience reached is (please round to the nearest integer)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
