Question: Burnside Marketing By Changing Variable Cells: W Set Objective: scsssl I To: 0 Max 0 Min 0 Value Of: 0 Subject to the Constraints: El

Burnside Marketing By Changing Variable Cells: W Set Objective: scsssl I To: 0 Max 0 Min 0 Value Of: 0 Subject to the Constraints: El 35 35 8 11 40 10 7 14 20 30 15 18 20 35 18 14 35 30 9 16 40 40 20 11 QUESTION A (Re'encing pages 682-683) I:| max (objective functio y1+y2+y3+y4+y5+y6+y7 W s.t 1511 1+35121+30112+40122+25132+15113+912375y 121 Add Change Delete Reset All 30111+20121+40112+35122+25132+8113+1112375y221 35111+30121+25112+20122+30132+15113+1812375y421 25111+40121+40112+20122+35132+18113+1412375y 521 Select a Solving Method: 20111+25121+20112+35122+30132+9113+1612375y621 Make Unconstrained Variables Non-Negative Load/ Save GRG Nonlinear Options 30111+15121+25112+40122+40132+20113+1112375y721 solving Method smooth. Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems. and select the Evolutionary engine for Solver problems that are non Close Solve Answer A linear program model is a mathematical model with a linear objective function, a set of linear constraints, and nonnegative variables. Let " equal 1 if level * is chosen for attribute, 0 otherwise and equal 1 if child k prefers the new cereal design, 0 otherwise. Max yi+ y2+y3+y4 +y5 +y6 + y7 s.t 15/11 + 35/21 + 30/12 + 40122 + 25132 + 15/13 + 9/23-75y1 2 1 30/11 + 20/21 + 40/12 + 35122 + 25132 + 8/13 + 11/23-7592 2 1 40/11 + 25/21 + 20/12 + 40122 + 10132 + 7/13 + 14123-75y3 2 1 35/11 + 30121 + 25/12 + 20122 + 30132 + 15/13 + 18123-75y4 2 1 25/11 + 40/21 + 40/12 + 20122 + 35132 + 18/13 + 14123-75y5 2 1 20/11 + 25/21 + 20/12 + 35/22 + 30132 + 9/13 + 16123-75y6 2 1 30/11 + 15/21 + 25/12 + 40122 + 40132 + 20/13 + 11/23-7597 2 1 In + 21 = 1 I12 + 122 + 132 = 1 I13 + 123 = 1 Use EXCEL to solve for the optimal solution report using the following steps. 1. Select Solver from the Analysis Group in the Data Ribbon 2. Enter the proper values for the constraints and the objective function The first constraint should be to set the decision variable, ",= integer 3. Select Simplex LP 4. Click the checkbox for Make Unconstrained Variables Non-negative 5. Click on the Options button Set the Integer Optimality (%) under the All Methods tab to zero 6. Click Solve The optimal solution is /11 = 1, 132 = 1, /13 = 1, y4 = 1, ys = 1, 97 = 1 , and the other variables equal O. This indicates that a cereal with low wheat/corn ratio, artificial sweetener, and no flavor bits will maximize the share of choices and 3 of the 7 children will prefer this cereal

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

A B D E F G H 8 You have been asked to choose which investments, of those listed in the table below, should be implemented given the following resource 9 constraints: there are only 90 units of input...

1. DeShawn Washington runs the Florida office of Training, a corporate training firm in Tampa. He is using an Excel workbook to analyze the company's financials and asks for your help in correcting...

Please help with questions 14 to 24 thank you! Step Instructions 16 17 18 19 20 Make the Direct Marketing 2 worksheet active. Create a scenario named Best Case, using Number of Ads and click Rate....

You are the digital marketing director for High West fashions, a regional clothing company that specializes in custom t-shirts. Your company has decided to launch an online advertising campaign that...

Today is March 30, 2020, and you have just started your new job with a financial planning firm. You have been asked to review a portion of a clients stock portfolio to determine the risk/return...

The University of Iowa is experimenting with a blend of soil amendments to be used in an analysis of variance study of the response of tomatoes to various amounts of sunlight. To perform this study,...

Please answer the following: The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize prots. Producing these...

Please help with the attached three questions based off the data provided. The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce...

Please answer the attached question: The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize prots....

Please answer the following question. Just one below: The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to...

Bleezer's Budgeting Assignment 2022: Use the details below to complete the Bleezer Budget spreadsheet. Upload your spreadsheet to Moodle by the due date above. Note: There will not be spreadsheet...

International Communications Research (ICR) conducted the 2008 Spring Cleaning Survey for the Soap and Detergent Association. ICR questioned 777 American adults who spring-clean about which...

If an employer fals to file an employment tas return on the doe debe, a peraity based on a certain percereage of the amsurk of tax required to be reported may be added to the tax. True Folse

Describe an innovation in technology, business, or culture that had a major economic impact in your lifetime. What can be done to promote innovation and adaptability within the organisations?