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 the new spreadsheet model. Make sure to usecolor-coding to differentiate between data cells, decision cells, and the main objectives.The Super Grain Corporation is facing a daunting challenge how to break into an already overly crowdedbreakfast cereal "Crunchy Start" market in a big way. The Management has has decided to design anationwide 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 levelshould they advertise Crunchy Start in each of the three media?Below are the expected Cost and Exposure Data for the Super Grain Corp.CostsEach TVCommercialCost CategoryEach Magazine AdEach Sunday AdS150000 Super Grain Corporation nas identiied the three moSt errective aavertising 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 levelshould they advertise Crunchy Start in each of the three media?Below are the expected Cost and Exposure Data for the Super Grain Corp.CostsEach TVCommercialCost CategoryEach Magazine AdEach Sunday AdAd budgetPlanning budget$300,00090,000$100,000$150,00030,00040,000Expected number of exposures1,300,000600,000500,000Use 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 constraintsEnter the data cells in the spreadsheet as per the given dataFor the toolbar, press Al Taf10 0

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 Cost Category Commercial Each Magazine Ad Each Sunday Ad Ad budget Planning budget $300,000 90,000 $100,000 40,000 $150,000 30,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

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 Cost Category Commercial Each Magazine Ad Each Sunday Ad Ad budget Planning budget $300,000 90,000 $100,000 40,000 $150,000 30,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

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section7.4: Advertising Response And Selection Models

Problem 20P

See similar textbooks

Similar questions

Ten different types of brownies are sold. You arethinking of developing a new brownie for sale.Brownies are rated on the basis of five qualities: price,chocolate flavor, chewiness, sweetness, and ease ofpreparation. You want to group the 10 brownies on themarket into three clusters. Each cluster should containbrownies that are relatively similar.a. Why would this be useful to you?b. How would you do it?
A Make-or-Buy DecisionTriple X Company manufactures and sells refrigerators. It makes some of the parts for the refrigerators and purchases others. The engineering department believes it might be possible to cut costs by manufacturing one of the parts currently being purchased for $8.25 each. The firm uses 100,000 of these parts each year. The accounting department compiles the following list of costs based on engineering estimates:Fixed costs will increase by $50,000.Labor costs will increase by $125,000.Factory overhead, currently running $500,000 per year, maybe expected to increase 12 percent.Raw materials used to make the part will cost $600,000.Given the preceding estimates, should Triple X make the part or continue to buy it?
Please no written by hand and no emage Kindly create a spreadsheet from the problem description. Find the optimal solution using Excel Solver (Please show working with steps on a spreadsheet) : The Heinrich Company manufactures two types of plastic hangerracks (Foldaways and Straightaways) especially suited for mountingnear clothes dryers. Because permanent press clothing must be hungon hangers immediately after removal from the dryer, these items havebeen especially popular. However, there is some concern that thePreppie movement (popularized by its own handbook) will extinguishpolyester clothing; Heinrich is terribly interested in doing the best withthe resources it has while its products are still in demand. The firsttype of hanger rack, the Foldaway, requires 10 ounces of plasticmaterial and 0.3 hours of labor. Plastic costs Heinrich 10 cents anounce; labor costs Heinrich $20 per hour. The second type of hangerrack, the Straightaway, requires 15 ounces of plastic and 0.175…
LINGO SOFTWARE Consider a production-mix problem where we are concerned with what mix of four products we should produce during the upcoming week. For each product, each unit produced requires a known amount of production time on each of the three machines. Each machine has a certain number of hours of production time available per week. Each product provides a certain profit per unit produced. Figure 3S1.2 shows three types of data: machine-related data, product-related data, and data related to combinations of a machine and product. The objective is to determine how much to produce for each product so that total profit is maximized while not exceeding the limited production capacity of each machine. Requirement: Solve this problem in LINGO software.
Finally, due to budget constraint, your inititial budget of $100,000 has been reduced to $75,000. SET YOUR CONSTRAINTS, DECIDE WHICH AREAS/TASKS BUDGET TO BE ADJUSTED AND USE EXCEL SOLVER TO CREATE YOUR FINAL BUDGET. Submit your plan and your reasoning behind the decisions and why your plan will make the event a success. Excel spreadsheet must show the distribution of your initial budget of $100,000 and your final budget of $75,000 with the constraints you set. Use the the excel spreadsheet image and show constraints.
Please do not give solution in image formate thanku. 7-16 A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days preceding the election. Two types of ads will be used: radio and television. Each radio ad costs $200 and reaches an estimated 3,000 people. Each television ad costs $500 and reaches an estimated 7,000 people. In planning the advertising campaign, the campaign manager would like to reach as many people as possible, but she has stipulated that at least 10 ads of each type must be used. Also, the number of radio ads must be at least as great as the number of television ads. How many ads of each type should be used? How many people will this reach?
I need help with everything, please. Formulate the problem and submit formulation - no need to solve. 1. An investment advisor at Shore Financial Services wants to develop a model that can be used to allocate investment funds among four alternatives: stocks, bonds, mutual funds, and cash. For the coming investment period, the company developed estimates of the annual rate of return and the associated risk for each alternative. Risk is measured using an index between 0 and 1, with higher risk values denoting more volatility and thus more uncertainty. Because cash is held in a money market fund, the annual return is lower, but it carries essentially no risk. The objective is to determine the portion of funds allocated to each investment alternative in order to maximize the total annual return for the portfolio subject to the risk level the client is willing to tolerate. Total risk is the sum of the risk for all investment alternatives. For instance, if 40% of a client’s funds are…
MaximizationProblems and Minimization problems ***When using the simplex method, what is the difference between maximizing and minimizing?
Is my solution correct and did I fully answer the questions? (see attachment for my solution) Question: There are three factories on Momiss River. Each emits two types of pollutants, labeled P1 and P2, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1,500 to process a ton of factory 1 waste, and each ton processed reduces the amount of P1 by 0.10 ton and the amount of P2 by 0.45 ton. It costs $2,500 to process a ton of factory 2 waste, and each ton processed reduces the amount of P1 by 0.20 ton and the amount of P2 by 0.25 ton. It costs $3,000 to process a ton of factory 3 waste, and each ton processed reduces the amount of P1 by 0.40 ton and the amount of P2 by 0.50 ton. The state wants to reduce the amount of P1 in the river by at least 125 tons and the amount of P2 by at least 175 tons. a. Use Solver to determine how to minimize the cost of reducing pollution by the desired amounts. Are the LP assumptions…
The campaign manager for a politician who is running for reelection to a political office is planning the campaign. Four ways to advertise have been selected: TV ads, radio ads, billboards, and social media advertising buys. The costs of these are $900 for each TV ad, $500 for each radio ad, $600 for a billboard for 1 month, and $180 for each buy on social media (approximately 40,000 unique impressions). The audience reached by each type of advertising has been estimated to be 40,000 for each TV ad, 32,000 for each radio ad, 34,000 for each billboard, and 17,000 for each social media buy. The total monthly advertising budget is $16,000. The following goals have been established and ranked: The number of people reached should be at least 1,500,000. The total monthly advertising budget should not be exceeded. Together, the number of ads on either TV or radio should be at least 6. No more than 10 ads/buys of any one type should be used. Formulate this as a goal programming problem. Solve…
(Please use the format of the speadsheet in the image) A rancher is mixing two types of foods, Brand X and Brand Y, for his cattle. Each serving for cattle is required to have 360 grams of protein and 360 grams of fat. Brand X has 5 grams of protein and 10 grams of fat. Brand Y has 10 grams of protein and 5 grams of fat. Rancher has found that Brand X costs $3.5 and brand Y costs $5 per unit. Find out how much of each type should be used by the rancher to minimize cost. Keep in mind that the rancher has to buy at least one unit of each brand. Moreover, the number of brand X has to be twice the number of brand Y. (Possible Answer: $216)
Develop a rich context model for increasing space capacity in refrigerators. Please be clear and detailed. See rich context model photo. Start by tailoring the generalized rich picture in the photo