Read the below marketing problem carefully, Then build and formulate a linear programming model for this problem using the editor and insert a table to represent www.pread of model. Make sure to use color-coding to differentiate between data colls, decision cells, and the main objectives, 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 (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 Commercial 1900.000 Each Sunday Ad $100.000 Cost Category Ad budget Each Magazine Ad 3150.000 30.000 00009 oposes 300.000 . . . 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 (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 Psarning budget 90,000 30,000 40.000 Expected number of exposure 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 - . Super Grain Corp. Costs Each TV Cost Category Commercial Each Magazine Ad Each Sunday Ad Ad budget $300,000 $150,000 $100,000 Planning budget 90.000 30,000 40.000 Expected number of exposures 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 . . C For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIVS Paragraph Arial 10pt ili MI! > AZIX