PLEASE AS SOON AS POSSIBLE

L27 CH X & fx A D G H M N 1 2 Problem 2. Use the space be meno 3 Read the Super Grain Corp case study as presented in Section 3.1 on page 75 of the E-Book. The advertising firm now has suggested 4 a fourth promising advertising medium-radio commercials-to promote the company's new breakfast cereal, Crunchy Start. Young 5 children are potentially major consumers of this cereal, but parents of young children (the major potential purchasers) often are to 6 busy to do much reading (so may miss the company's advertisements in magazines and Sunday supplements) or even to watch the 7 Saturday morning programs for children where the company's television commercials are aired. However, these parents do tend to 8 listen to the radio during the commute to and from work. Therefore, to better reach these parents, the firm will consider running 9 commercials for Crunchy Start on nationally syndicated radio programs that appeal to young adults during typical commuting hours. 10 The firm estimates that the cost of developing each new radio commercial would be $50,000, and that the expected number of 11 exposures per commercial would be 900,000. The firm has determined that 10 spots are available for different radio commercials, 12 and each one would cost $200,000 for a normal run. 13 a. Express this model in algebraic and spreadsheet format. 15 b. Solve the spreadsheet model for the revised advertising-mix problem that includes this fourth advertising medium. C. Comment on the obtained results using your own words, 17 Make sure that all formulas and Solver parameters are saved in this worksheet before submission, 18 19 20 14 16