18154 13011 Uhe Viewer ward X x | 0 Actions maining Time: 1 hour, 22 minutes, 39 seconds. estion Completion Status 18 19 21 The Super Grain Corporation is facing a daunting challenge how to break into an already overly crowded breakfast cereal "Crunchy Start" market in a big way. The Management has has decided to design a nationwide promotional campaign that will achieve the largest possible exposure for Crunchy Start, Super Gran Corporation has identified the three most effective advertising media for this product: Television commercials on Saturday morning programs for children. Advertisements in food and family oriented magazines. Advertisements in Sunday supplements of major newspapers. Super Grain also decided on the the below limited resources/restrictions in the problem Advertising budget (54 million Planning budget ($1 million) Management would like to formulate a new management science module to identify at what level should they advertise Crunchy Start in each of the three media? Below are the expected Cost and Exposure Data for the Super Grain Corp. Costs Each TV Cost Category Commercial Each Magazine Ad Each Sunday Ad Ad Budget 300.000 $150.000 $100.000 Pagbudget 90.000 30.000 40.000 Exprecebe of 1.300.000 600.000 500.000 Use the Editor to build and formulate a linear programming model for this problem Make sure to cover the below points in your module The objective will be measured in terms of the expected number of exposures Identify the data cells Identify the changing cells Identify the constraints Enter the data cells in the spreadsheet as per the given data For the toolbar, press ALTO ALTHOME BI VS agraph Arial 10 A 2