Consider the Super Grain Corp. case study as presented in Section 3.1, including the spreadsheet in Figure

Question:

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.

D Н Super Grain Corp. Advertising-Mix Problem TV Spots SS Ads Magazine Ads 3 Exposures per Ad 1,300 600 500 (thousands)

Solver Parameters Set Objective Cell: TotalExposures To: Max 6. Budget By Changing Variable Cells: NumberOfAds Spent Sub

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?