Refer to the Draft TV Commercials case. Review the problem statement and influence chart that was generated for this case in conjunction with the corresponding exercises in Chapter 2. (If this has not yet been done, develop the problem statement and influence chart as preliminary steps.) Design a spreadsheet to determine the impact on quality of paying for three draft commercials.

DRAFT TV COMMERCIALS" Your client directs TV advertising for a large corporation that currently relies on a single outside advertising agency. For years, ads have been created using the same plan: The agency creates a draft commercial and, after getting your client's approval, completes production and arranges for it to be aired. has to spend on airing commercials. He will have to pay up front for all of the draft commercials before he has a chance to evaluate them. The standard technique for evaluating a draft commercial involves showing it to a trial audience and asking what they remembered about it later (this is known as "next day recall"). Ads with higher next day recall are generally those with higher effectiveness in the marketplace, but the correla- tion is far from perfect. A standard method for assessing the effectiveness of a commercial after it has been aired is to survey those who watched the show and estimate "retained impressions." Retained impressions are the number of view- ers who can recall the essential features of the ad. Ads with Your client's budget is divided between creating and airing commercials. Typically, about 5 percent of the budget is devoted to creating commercials and 95 percent to airing them. Lately the client has become dissatisfied with the quality of the ads being created. Along with most advertising people, he believes that the ultimate profitability of an advertising campaign is much more strongly influenced by the content of the advertisement than by the level of expenditure on airing or the media utilized (assuming rea- sonable levels of expenditure). Thus, he is considering increasing the percentage of his budget devoted to the first, "creative" part of the process. One way to do this is to commission multiple ad agencies to each independently develop a draft commercial. He would then select the one for completion and airing that he determines would be most effective in promoting sales. Of course, since his budget is essentially fixed, the more money he spends on creating draft commercials the less he higher retained impressions are usually more effective in generating sales, but again the correlation is not perfect. Both the effectiveness of a commercial (the number of retained impressions it creates) and the exposure it receives (the number of times it is aired) will influence sales. How would you advise your client on the budget split between creating and airing a commercial? "Source: O'Conner, G. C., T.R. Willemain, and J. MacLachlau, 1996. "The value of competition among agencies in developing ad com- paigns: Revisiting Gross's model." Journal of Advertising 25:51-63.