Question 18 Read the below marketing problem carefully. Then build and formulate a linear programming model for this problem usin spreadsheet model. 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 Grain 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 ($4 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 Commercial $300.000 90.000 Cost Category Ad budget Planning budget Expected number if exposure Each Magazine Ad $150.000 30.000 Each Sunday Ad $100,000 40,000 500 000 300.000 600000 blom Question Completion Status: Management would like to formulate a new management science module to identify at what leve 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 Cost Category Ad budget Planning budget Expected number of exposures Each TV Commercial $300,000 90.000 Each Magazine Ad $150.000 30.000 Each Sunday Ad $100,000 40.000 '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 . TT Tf Paragraph Arial 3 (12pt) Question 18 Read the below marketing problem carefully. Then build and formulate a linear programming model for this problem usin spreadsheet model. 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 Grain 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 ($4 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 Commercial $300.000 90.000 Cost Category Ad budget Planning budget Expected number if exposure Each Magazine Ad $150.000 30.000 Each Sunday Ad $100,000 40,000 500 000 300.000 600000 blom Question Completion Status: Management would like to formulate a new management science module to identify at what leve 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 Cost Category Ad budget Planning budget Expected number of exposures Each TV Commercial $300,000 90.000 Each Magazine Ad $150.000 30.000 Each Sunday Ad $100,000 40.000 '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 . TT Tf Paragraph Arial 3 (12pt)