Answer Happy

There is one problem to be solved. You are not required
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.
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