Consider the Super Grain Corp. case study as presented in Section 3.1, including the spreadsheet in Figure 3.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.
FIGURE 3.1
The spreadsheet model for the Super Grain problem (Section 3.1), including the objective cell Total Exposures (H13) and the other output cells Budget Spent (F8:F9), as well as the specifications needed to set up Solver. The changing cells Number of Ads (C13:E13) show the optimal solution obtained by Solver.
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?
Enjoy 24/7 customer support for any queries or concerns you have.
Phone: +1 213 3772458
Email: support@gradeessays.com