Stevens Institute Of Technology
BIA 650A
PROBLEM STATEMENT_1: 4. Suppose that General Flakes decides that it shouldn’t place any more than 10 ads on any given show. Modify the (original) advertising model appropriately to incorporate this constraint, and then reoptimize (with integer constraints on the numbers of ads). Finally, run SolverTable to see how sensitive the optimal so
...[Show More]
PROBLEM STATEMENT_1: 4. Suppose that General Flakes decides that it shouldn’t place any more than 10 ads on any given show. Modify the (original) advertising model appropriately to incorporate this constraint, and then reoptimize (with integer constraints on the numbers of ads). Finally, run SolverTable to see how sensitive the optimal solution is to the maximum number of ads per show allowed. You can decide on a reasonable range for the sensitivity analysis. DATA SOURCES: - Text book - Figure 4.1(Page 137) in textbook was used as reference to build the data in the excel sheet to solve the above problem statement. SOLUTION &SENSITIVITY ANALYSIS: 1)Using solver in excel to minimize the objective cell which is Total_cost Below is the screenshot of the solver used in my Excel sheet. T
[Show Less]