How does the solution change when a constraint is added

Assignment Help Operation Management

Reference no: EM131851554

Linear Programming: What-if (Sensitivity) Analysis

So far we have focused on finding an optimal solution to a linear programming model. It is important, but it is not the only information available or needed by management. Management also needs sensitivity information, or information about what happens when data values are changed.

Previously, in order to formulate a problem as a linear programming model in Excel, we had to take the data for granted or assumed that it was certain and we made decisions based on that data.

In real life problems, this assumption or certainty is questionable; the data might be inaccurate. Linear programming has capability in terms of sensitivity analysis to address these uncertainties.

Sensitivity analysis is a systematic study of how sensitive solutions are to small changes in the data. There are three basic areas that sensitivity analysis provides answers:

1. How does the solution change when the objective function changes?

2. How does the solution change when resources available change?

3. How does the solution change when a constraint is added to the problem?

All these questions can be answered by the "Sensitivity Report" generated by Excel Solver. Let's see how to create and analyze a sensitivity report through an example. The example we choose is the Wyndor Glass Co. case study we solved in Module 1. See page 163 in the Introduction to Management Science textbook for details regarding the Solver sensitivity report.

Reference no: EM131851554

Questions Cloud

What are the external environment view : Some like Michael Porter propose that strategy is driven mostly by the external environment. Review Porter's Five-Forces Model and see if you agree.

How hr managers could go about to ensure successful : List of how HR managers could go about to ensure successful development and implementation of policies and procedures in a healthcare organization ?

Describe a procedure suitable for computer coding : Describe a procedure suitable for computer coding that will find, directly on the reduced matrix, the maximum number of independent zero cells.

Design application logic for a company that wants a report : Design the application logic for a company that wants a report containing a breakdown of payroll by department.

How does the solution change when a constraint is added : How does the solution change when the objective function changes? How does the solution change when resources available change?

Reflect on your purchasing behavior : How do you rely on blogs, feedback, and recommendations from your past customers in making your own purchasing decisions?

Explanation of the creative problem-solving techniques : Just like with NFL quarterbacks, when supervisors make mistakes "on the playing field," by Monday morning everyone has second guessed their decisions.

Show the feasible region and label constraints on graphs : Solve the problem. Show work. What is the optimal "A" and "B" values? What is the optimal objective function value?

Design logic for an application that allows a user to ordere : Design the logic for an application that allows a user to enter an ordered item continuously until a sentinel value is entered.

User Account

All Pages