Finding optimal solution to linear programming model

Assignment Help Operation Management
Reference no: EM131400012

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.

Remember, before solving the problem we have the figure below.

Reference no: EM131400012

Warehouse and distribution must measure its performance

What are some of the reasons that a warehouse/distribution must measure its performance? How does a manager know that he/she is measuring the correct things within their organ

Upper control limit

Boxes of Honey-Nut Oatmeal are produced to contain 16.0 ounces, with a standard deviation of 0.20 ounce. For a sample size of 49, the 3-sigma x-bar chart control limits are: U

Outsourcing jobs to lower wage countries

Some people believe that outsourcing jobs to lower wage countries will benefit the U.S. economy in the long run because the price of the goods will be lower. Do you agree with

Benefits to the consumer of adopting business processes

Use Proctor and Gamble (P&G) as an example to explain the benefits to the consumer of adopting a business processes perspective. Why might a traditional functional prospective

Speed of getting the vaccine to patients

How should the government and producers balance safety - i.e. carefully assessing the vaccine so that few unintended consequences occur - versus speed of getting the vaccine

How many units should be shipped from each plant

Houston has 850 air conditioners available each month, Phoenix has 650, and Memphis has 300. The shipping cost per unit from Houston to Dallas is $8, to Atlanta is $12, and

Describe an incident-possibly involving yourself

Describe an incident, possibly involving yourself, in which bypassing occurred. Analyze specifically why it occurred, what might have been done to prevent its occurrence, and

Describe the relevance of the eps chart

Discuss, in a two-page APA formatted paper, how the product positioning is aligned with McDonald's corporate strategy. Identify potential gaps in the product line or weaknes


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd