Please run the solver analysis and attach output of the solution with new constraint. What are the values of decision variables in the optimal solution The Beaver Creek Pottery CompanyProducts:Profit per unit:Resourceslabor (hrunit)clay (lb/unit)packaging(hr/unit)Production:Bowls =20Mugs10Profit= 1300Bowl40140.2Mug50230.1Usage401105Constraints Availablecu40<=120<=5Left over0100

For the given data, I would perform a solver analysis, The solver sheet is prepared below, Formulas…

Answered: Please run the solver analysis and…

Please run the solver analysis and attach output of the solution with new constraint. What are the values of decision variables in the optimal solution

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Bugs Bunny and Daffy Duck are contestants on a game show called Split or Steal. On the show, Bugs and Daffy have to pick one of two cards and decide to split the prize money of $100,000 or steal it from the other contestant. The decisions are made simultaneously so neither player knows what the other will do. The table below represents the result of the contestants’ choices. See attached What should a rational player do in this game? Is this a zero-sum game?
Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. Both models use the same electronic components. After reviewing the components required and the profit for each model, the firm found the following linear optimization model for profit, where L is the number of LaserStop models produced and S is the number of SpeedBuster models produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints, and verify the values of the slack variables. Maximize Profit = 123 L+ 139 S 18 L 11 S≤ 3000 5 L+9 S≤2500 L≥ 0 and S≥ 0 (Availability of component A) (Availability of component B) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce LaserStop models and possible profit, SpeedBuster models. This solution gives the which is $ (Type integers or decimals…
What is a "corner point"? Explain why solutions to linear programming problems focus on cornerp points.
PROBLEM 7 Eyewitness News is shown on channel 5 Monday through Friday evenings from 5:00 P.M. to 6:00 P.M. During the hour-long broadcast, 18 minutes are allocated to commercials. The remaining 42 minutes of airtime are allocated to single or multiple time segments for local news and features, national news, sports, and weather. The station has learned through several viewer surveys that viewers do not consistently watch the entire news program; they focus on some segments more closely than others. For example, they tend to pay more attention to the local weather than the national news (because they know they will watch the network news following the local broadcast). As such, the advertising revenues generated for commercials shown during the different broadcast segments are $850 per minute for local news and feature segments, $600 per minute for national news, $750 per minute for sports, and $1,000 per minute for the weather. The production cost for local news is…
Set up the objective function and enumerate all the constraints, Define the decision variables of the IP Programming problem
Variable Cells Model Variable Constraints E S D Constraint Number 1 E 2 3 S D S D Name Economy Models Standard Models Deluxe Models Name Total Profit: $ Fan Motors Cooling Coils Manufacturing Time Optimal Solution Constraints Fan motors Cooling coils Final Value 80.000 120.000 0.000 Final Value 200.000 320.000 2080.000 a. Identify the range of optimality for each objective function coefficient. If there is no lower or upper limit, then enter the text "NA" as your answer. If required, round your answers to one decimal place. Objective Coefficient Range Variable lower limit upper limit E Reduced Cost 0.000 0.000 -24.000 Manufacturing time. AUTO Shadow Price 31.000 32.000 0.000 Right-Hand-Side-Range lower limit upper limit Objective Coefficient 63.000 95.000 135.000 b. Suppose the profit for the economy model is increased by $6 per unit, the profit for the standard model is decreased by $2 per unit, and the profit for the deluxe model is increased by $4 per unit. What will the new optimal…