v : X V fx Instructions: Develop an Excel spreadsheet models for problem 3.1 on page 106 (textbook 1) on this worksheet, and run Excel Solver to obtain optimal solutions. Your mod A B C D E F G H Problem 2: Page 106 Problem 3.1 Instructions: Develop an Excel spreadsheet models for problem 3.1 on page 106 (textbook 1) 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). 10 11 12 Problem 1 Problem 2 Problem 3-Model | Problem 3-Sensitivity Repo ... Ready 74OF KO 1 0 11:08 AM Mostly cloudy Q Search 6/12/2023 hp 4- 144 insert prt sc delete # & 2 4 9 O backspace nom Q W E R T U P A S F H K L enter pause Z X C V B N M T shift alt alt ctriProblems An asterisk on the problem number indicates that at least a partial answer is given in the back of the book. 3.1. 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 medium-radio commercials-to promote the company's 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 company's advertisements in magazines and Sunday supplements) or even to watch the Saturday morning programs for children where the company's 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 61 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 62 radio commercials, and each one would cost $200,000 for a normal run. a. Formulate and solve a spreadsheet model for the revised advertising-mix problem that includes this fourth advertising medium. Identify the data cells, the changing cells, and the objective cell. Also show the Excel equation for each 64 output cell expressed as a SUMPRODUCT function. 6. Indicate why this spreadsheet model is a linear programming model c. Express this model in algebraic form. 124 3.2. Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 3.2. Briefly describe how linear programming was applied in this study. Then list the various benefits that resulted from this study. 106 / 622 Search 11:09 AM 6/12/2023 hp 16 19 144 10 11 F11 DDI 12 insert port sc dele % & * 5 6 8 9 O backspace T Y U O P G H K L enter C