In the solution to the advertising selection model in Example 7.6, we indicated that the women 36 to 55 group is a bottleneck in the sense that the company needs to spend a lot more than it would otherwise have spent to meet the constraint for this group. Use SolverTable to see how much this group’s exposure constraint is costing the company. Vary the required exposures to this group from 30 to 60 in increments of 5, and keep track of the total advertising cost. Comment on your results.
EXAMPLE 7.6 ADVERTISING SELECTION WITH NONLINEAR RESPONSE FUNCTIONS
I n this example, we revisit the problem faced by the General Flakes Company in Example 4.1 of Chapter 4. The company must decide how many ads to place on each of several television shows to meet exposure constraints for each of six groups of customers. (Refer to Figure 7.26 and the file Advertising Selection.xlsx for the specific inputs.) The difference now is that each combination of television show and customer group has its own advertising response function of the form in Equation (7.4). That is, there are constants a and b of the response function for each such combination. (These constants appear in rows 5 to 10 and 14 to 19 of the file.) The company wants to find the selection of ads that minimizes its total cost of meeting all exposure requirements.
Objective To use a nonlinear model to find a minimum-cost way of meeting all exposure requirements.
WHERE DO THE NUMBERS COME FROM?
We already discussed where many of the inputs come from in Example 4.1 of Chapter 4. The new inputs, the parameters of the various response functions, come from fitting response functions, exactly as in the previous example, for each combination of television show and customer group. Of course, this assumes the company has enough historical data to carry out this procedure. The numbers used here are for illustration only, although they are reasonable.