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?

D Super Grain Corp. Advertising-Mix Problem TV Spots SS Ads Magazine Ads 3 Exposures per Ad 1,300 600 500 (thousands) Budget Budget Cost per Ad (Sthousands) Spent Available Ad Budget 4,000 300 150 100 4,000 Planning Budget 1,000 90 30 40 1,000 10 11 Total Exposures TV Spots 12 Magazine Ads SS Ads (thousands) 13 Number of Ads 20 10 17,000 14 Max TV Spots 15 Solver Parameters Set Objective Cell: TotalExposures To: Max 6. Budget By Changing Variable Cells: NumberOfAds Spent Subject to the Constraints: BudgetSpent