After reviewing the expected results from the model developed by the consulting firm, Super Grain would like to investigate additional advertising options (in addition to the ones listed above) with the goal of increasing the total number of exposures. The option is to also buy advertising time on the radio. The consulting firm estimates that the fee for developing each new radio commercial would be $50,000 and that the expected number of exposures per commercial would be 900,000. The firm has determined that 10 spots are available for different radio commercials, and each one would cost $200,000.
(4.) Define the decision variables for the new option and write the mathematical linear programming model which can be used to solve the problem.
(5.) Solve the new problem using Excel Solver. What are the values of the decision variables and the total expected number of exposures for the optimal solution?
(6.) Generate a sensitivity report for this problem.