Sensitivity Report

Information

Objective Cell

Decision Variable Cells

Constraints

$8\mathrm{.}14.*$ Consider the Super Grain Corp. case study as presented in $$ Section $6\mathrm{.}1,$ including the spreadsheet in $$ Figure $6\mathrm{.}1$ showing its

formulation and optimal solution. Use Solver to generate the sensitivity report. Then use this report to independently address each of the

following questions.

a$.$ How much could the total expected number of exposures be increased for each additional $$1,000$ added to the advertising

budget?

b$.$ Your answer in part a would remain valid for how large of an increase in the advertising budget?

c$.$ How much could the total expected number of exposures be increased for each additional $$1,000$ added to the planning budget?

d$.$ Your answer in part $c$ would remain valid for how large of an increase in the planning budget?

$e.$ Would your answers in parts a and $c$ definitely remain valid if both the advertising budget and planning budget were increased by

$$100,000$ each?

f$.$ If only $$100,000$ can be added to either the advertising budget or the planning budget, where should it be added to do the most

good?

g$.$ If $$100,000$ must be removed from either the advertising budget or the planning budget, from which budget should it be removed

to do the least harm?