Reconsider the Super Grain Corp. case study as presented in Section 3.1.

The advertising firm, Giacomi & Jackowitz, now has suggested a fourth promising advertising mediumradio commercialsto promote the companys new breakfast cereal, Crunchy Start. Young children are potentially major consumers of this cereal, but parents of young children (the major potential purchasers) often are too busy to do much reading (so may miss the companys advertisements in magazines and Sunday supplements) or even to watch the Saturday morning programs for children where the companys television commercials are aired. However, these parents do tend to listen to the radio during the commute to and from work. Therefore, to better reach these parents, Giacomi & Jackowitz suggests giving consideration to running commercials for Crunchy Start on nationally syndicated radio programs that appeal to young adults during typical commuting hours.

Giacomi & Jackowitz estimates that the cost of developing each new radio commercial would be $50,000, and that the expected number of exposures per commercial would be 900,000. The firm has determined that 10 spots are available for different radio commercials, and each one would cost $200,000 for a normal run. Instructions: Develop an Excel spreadsheet models for on this worksheet, and run Excel Solver to obtain optimal solutions. Your model should be well organized with blue boxes (data), red boxes (decision variables), and black boxes (objective function values).