to submit any answer report or sensitivity report for question.
Define your decision variables clearly.
The LP formulation and corresponding Excel Sensitivity Report
for a media selection problem are provided below.
T = number of commercials on TV
M = number of advertisements in magazines
R = number of commercials on radio
I = number of advertisements on Instagram
Maximize Exposures = 1200T + 600M + 900R + 600I subject to
300T + 155M + 200R + 160I ≤ 5,000 (ad budget)
100T + 45M + 60R + 40I ≤ 2,000 (planning budget)
600M + 600I ≥ 12,000 (min. requirement of exposure from Magazine
and Instagram ads)
T ≥ 3 (min TV spots) R ≤ 10 (max Radio spots T, M, R, I ≥ 0.
- There Is One Problem To Be Solved You Are Not Required To Submit Any Answer Report Or Sensitivity Report For Question 1 (26.64 KiB) Viewed 12 times
magazine ads increases by 50 units, will the optimal solution
change? What about the value of the objective
function?
b. What should be the objective function coefficient of
Instagram ads so that it can be part of the optimal
solution?
c. We can decrease the exposure requirement by 200 units
while increasing the ad budget by 4 units. Is it worth the effort?
Find the impact on total exposure.
d. If the objective function coefficient of radio
spots decreases by 50 units and the objective function coefficient
of magazine ads increases by 40 units, what will be the impact on
total exposure?
Variable Cells Cell Name SBS14 Number of TV Spots SCS14 Number of Magazine Ads SDS14 Number of Radio Spots SES14 Number of Instagram Ads Constraints Cell Name SFS6 Ad Budget SFS7 Planning Budget SFS8 Exposure Requirement SFS9 Min TV Spots SFS10 Max Radio Spots Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 3 0 1200 150 20 0 600 97.5 5 0 900 1E+30 0 -22.50 600 22.5 Final Shadow Constraint Allowable Value Price R.H. Side Increase 4.5 0 -0.1625 -150 0 5000 1500 12000 3 5 5000 2000 12000 3 10 1000 1E+30 3870.97 3.33 1E+30 1E+30 22.5 100 1E+30 Allowable Decrease 1000 500 3870.97 3 5