Chapter 5 Sensitivity Analysis [Complete]
Chapter 5 Sensitivity Analysis [Complete]
Page 1 of 54
Chapter 5: Sensitivity Analysis
Because of spoilage and the nature of the production process, any materials not used
for current production are useless and must be discarded. The accounting department
analyzed the production figures, assigned all relevant costs, and arrived at prices for
both products that will result in a profit contribution of $40 for every ton of fuel
additive produced and $30 for every ton of solvent base produced.
The linear programming model to determine the number of tons of fuel additive and
the number of tons of solvent base to produce in order to maximize total profit
contribution is given below:
Page 2 of 54
Chapter 5: Sensitivity Analysis
Page 3 of 54
Chapter 5: Sensitivity Analysis
Suppose that a further price reduction causes the profit contribution for the fuel
additive to be reduced to $20 per ton. That is, the objective function in the linear
program changes to 10𝐹 + 30𝑆. Would there be any change in the optimal solution
and the total profit contribution?
2. If the change in the objective function coefficient is small, the optimal solution
may remain the same. If the change in the objective function coefficient is
large enough, the optimal solution will change.
Page 4 of 54
Chapter 5: Sensitivity Analysis
Finding the objective coefficient range for the variable 𝐹 is the same as answering
the question:
Similarly, finding the objective coefficient range for the variable 𝑆 is the same as
answering the question:
Page 5 of 54
Chapter 5: Sensitivity Analysis
To answer these, notice that 𝑃4 is the intersection point between the constraint lines
0.4𝑆 + 0.5𝑆 = 20 (𝑙1 ) and 0.6𝐹 + 0.3𝑆 = 21 (𝑙2 ). Hence, as long as the slope of
the objective function line is between the slopes of the two constraint lines 𝒍𝟏
and 𝒍𝟐 , the optimal solution will remain at 𝑷𝟒 (provided that the feasible region
remains the same).
Page 6 of 54
Chapter 5: Sensitivity Analysis
Page 7 of 54
Chapter 5: Sensitivity Analysis
The objective coefficient range can also be obtained from the sensitivity analysis
report generated by Excel’s solver.
The figure below shows the sensitivity analysis report for the RMC problem.
The “Allowable Increase” and “Allowable Decrease” indicate how much the
current value of the objective function coefficient can decrease or increase without
changing the optimal solution.
Allowable Decrease = Current Obj Coef – Lower Limit of Obj Coef Range
Allowable Increase = Upper Limit of Obj Coef Range - Current Obj Coef
Page 8 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Compute the objective coefficient range for each variable in the LP below.
Max 5𝑥1 + 7𝑥2
s.t.
𝑥1 ≤ 6
2𝑥1 + 3𝑥2 ≤ 19
𝑥1 + 𝑥2 ≤ 8
𝑥1 , 𝑥2 ≥ 0
Page 9 of 54
Chapter 5: Sensitivity Analysis
Page 10 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Compute the objective coefficient range of the following LP.
Max 2𝐴 + 3𝐵
s.t.
𝐴 + 3𝐵 ≤ 6
5𝐴 + 3𝐵 ≤ 15
𝐴, 𝐵 ≥ 0
Page 11 of 54
Chapter 5: Sensitivity Analysis
Page 12 of 54
Chapter 5: Sensitivity Analysis
Suppose that only one objective coefficient is changed and all other aspects of a
linear program remain the same.
What would happen to the optimal solution
and the optimal objective function value?
The new objective coefficient is Optimal solution would remain the same. The
within the objective coefficient new optimal objective function value can be
range. computed by substituting the current optimal
solution into the new objective function.
The new objective coefficient is Optimal solution would change. Need to solve
outside the objective coefficient the revised linear program to determine the
range. new optimal solution and the optimal
objective function value.
Example:
Analyze each of the following changes based on the sensitivity analysis report
for the RMC problem given above.
Page 13 of 54
Chapter 5: Sensitivity Analysis
Page 14 of 54
Chapter 5: Sensitivity Analysis
Page 15 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Again, consider the RMC problem in which the objective is to maximize the total
profit contribution 40F + 30S. Suppose that after the company reviews both the price
and cost data for the two products, the profit contribution for the fuel additive is
increased to $48 per ton and the profit contribution for the solvent base is decreased
to $27 per ton.
Determine whether the optimal solution would change, and compute the total profit
contribution if the optimal solution remains. (Answer based on the sensitivity
analysis report given below.)
Page 16 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Suppose that the profit contribution for the fuel additive decreases from $40 per ton
to $20 per ton, and the profit contribution for the solvent base decreases from $30
per ton to $27 per ton.
Determine whether the optimal solution would change, and compute the total profit
contribution if the optimal solution remains.
Page 17 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Suppose that the profit contribution for the fuel additive increases from $40 per ton
to $400 per ton, and the profit contribution for the solvent base increases from $30
per ton to $300 per ton.
Determine whether the optimal solution would change, and compute the total profit
contribution if the optimal solution remains.
Page 18 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
(a) Suppose the RHS of constraint 3 is first increased to 22 and then to 23. Draw the
new feasible region. Determine whether the optimal solution and the optimal
objective function value remain the same after each change. What do you observe
about the changes in the optimal objective function value?
Page 19 of 54
Chapter 5: Sensitivity Analysis
Solution:
22 40 (
250
) + 30 (
160
)=
14800
9 9 9
23 40 (
275
) + 30 (
140
)=
15200
9 9 9
For every 1 unit increase in the RHS of constraint 3, the optimal objective
function value increases by ________ . So, the shadow price of constraint 3
is _________.
The shadow price remains the same as long as the intersection point between
the lines of constraint 1 and constraint 3 remains feasible. So, the RHS
range of constraint 1 is _________.
Page 20 of 54
Chapter 5: Sensitivity Analysis
(b) Consider the case in which the RHS of constraint 1 is increased by 1 and another
case in which the RHS of constraint 1 is decreased by 1. For each case, determine
whether the optimal solution and the optimal objective function value remain the
same after each change. What do you observe about the changes in the optimal
objective function value?
Solution:
RHS of constraint 1 increases by 1 RHS of constraint 1 decreases by 1
19 80 50
40 ( ) + 30 ( ) =
4700
3 3 3
Page 21 of 54
Chapter 5: Sensitivity Analysis
the optimal objective function value decreases by ______. So, the shadow
price of constraint 1 is ______.
The shadow price remains the same as long as the intersection point between
the lines of constraint 1 and constraint 3 remains feasible. So, the RHS
range of constraint 1 is _________.
(c) Consider the case in which the RHS of constraint 2 is increased to 6 and then to
7, and another case in which the RHS of constraint 2 is decreased to 4 and then
to 3. Determine whether the optimal solution and the optimal objective function
value remain the same after each change. What do you observe about the changes
in the optimal objective function value?
Solution:
RHS of constraint 2 increases to 6 and RHS of constraint 2 decreases to 4 and
then to 7. then to 3.
Page 22 of 54
Chapter 5: Sensitivity Analysis
7
6 𝑃4 =(25,20) 40(25) + 30(20) = 1600
5 (original)
4
3 𝑃 =(27.5,15) 40(27.5) + 30(15) = 1550
When the RHS of constraint 2 increases by 1, the optimal objective function value
_________________________. So, the shadow price of constraint 2 is ________.
The shadow price remains applicable as long as the current optimal solution
remains feasible. So, the RHS range of constraint 2 is _______________.
Page 23 of 54
Chapter 5: Sensitivity Analysis
Example:
Constraints 1 and 3 are binding,
because the lines corresponding to
the two constraints contain the
optimal solution 𝑃4 . Hence, a change
on the RHS of either of these
constraints would change the
optimal solution and thus affect the
optimal objective function value. So,
the shadow prices of these two
constraints are non-zero, as shown
in Example [Link] (a) and (b).
Constraint 2 is non-binding,
because the corresponding constraint
line does not contain the optimal
solution 𝑃4 . Hence, a change on the
RHS of constraint 2 would not
change the optimal solution and the
optimal objective function value,
unless the change causes the
constraint to become binding. So,
constraint 2 has zero shadow price,
as shown in Example [Link] (c).
Page 24 of 54
Chapter 5: Sensitivity Analysis
Page 25 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
The “Allowable Increase” and “Allowable Decrease” for each constraint indicate
how much the current value of the constraint RHS can decrease or increase without
changing the shadow price. These values are computed as follows:
Allowable Decrease = Current RHS – Lower Limit of RHS range
Allowable Increase = Upper Limit of RHS range - Current RHS
Analyze each of the following changes based on the sensitivity analysis report
for the RMC problem given above.
Change What would happen to the optimal solution and the
total profit contribution?
The amount of Material 3 Since the new RHS of Material 3 constraint is
available is increased to within the RHS range [18.75,30], the current
25 tons. shadow price 44.44 would remain valid. Since the
shadow price is nonzero, the optimal solution and
the total profit contribution would change. The
new total profit contribution would be 1600 +
(25 − 21)(44.44) = $1777.76. The new optimal
solution can
not be determined based on the report.
Page 26 of 54
Chapter 5: Sensitivity Analysis
Page 27 of 54
Chapter 5: Sensitivity Analysis
We can also determine the slack or surplus value for a constraint based on a
sensitivity analysis report.
The “Final Value” column in the “Constraints” section indicates the values
obtained by substituting the optimal solution into the constraints’ LHS.
Slack for a ≤ constraint: RHS-LHS Surplus for a ≥ constraint: LHS-RHS
A constraint with zero slack or zero surplus is a binding constraint.
For example, the constraints for the RMC problem are all ≤ constraints. Material 1
and Material 3 constraints have zero slack, whereas Material 2 constraint has a
slack of 1. This means that at the optimal solution, all the available amount of
Material 1 and Material 3 are used up, and there is 1 ton of Material 2 that is
unused.
Page 28 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
M&D Chemicals produces two products that are sold as raw materials to companies
manufacturing bath soaps and laundry detergents. Based on an analysis of current
inventory levels and potential demand for the coming month, M&D’s management
has specified that the combined production for products A and B must total at least
350 gallons. Separately, a major customer’s order for 125 gallons of product A must
also be satisfied. Product A requires 2 hours of processing time per gallons while
product B requires 1 hour of processing time per gallon, and for the coming month,
600 hours of processing time are available. M&D’s objective is to satisfy these
requirements at a minimum total production cost. Production costs are $2 per gallon
for product A and $3 per gallon for product B.
Based on the sensitivity analysis report given above, answer the following questions.
Page 29 of 54
Chapter 5: Sensitivity Analysis
(a) Find the optimal solution and the minimum total production cost.
Solution:
Optimal solution:
Minimum total production cost:
(b) What is the slack or surplus value for each constraint? Interpret the values.
Solution:
Constraint 1 has a surplus of 125. This means that at the optimal solution, the
major customer’s demand for product A is exceeded by 125 gallons.
Constraint 2 has zero surplus. This means that at the optimal solution, the
combined production of products A and B does not exceed the minimum
requirement of 350 gallons.
Constraint 3 has zero slack. This means that the optimal solution uses up all the
processing hours available.
Solution:
(d) Find and interpret the objective coefficient range for each variable.
Solution:
Objective coefficient range for variable 𝐴:
Interpretation:
In this problem, the objective coefficient of 𝐴 represents _________________
_______________________________________________________________.
Thus, the optimal solution will remain at 𝐴 = 250 and 𝐵 = 100, provided that
________________________________________________________________
and all other aspects of the problem remain unchanged.
Page 30 of 54
Chapter 5: Sensitivity Analysis
(e) Find and interpret the shadow price and RHS range for each constraint.
Solution:
Constraint 1 has a shadow price of ____, with a RHS range of ____________.
This indicates that ________________________________________________
_______________________________________________________________,
provided that ____________________________________________________
________________________________________________________________
and all other aspects of the problem remain unchanged.
Page 31 of 54
Chapter 5: Sensitivity Analysis
IMPORTANT: Note that the 100 percent rule does not say that the shadow prices
will change if the sum of the percentages is greater than 100%. All we can say is that
if the sum of the percentages is greater than 100%, different shadow prices may exist.
Thus whenever the sum of the percentage changes is greater than 100%, a revised
problem must be solved in order to determine the new shadow prices, optimal
solution and optimal objective function value.
Page 32 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Refer to the M&D Chemicals problem in Example [Link]. Suppose that the company
decides to purchase an additional 0.5 tons of material 1, an additional 7 tons of
material 2, and an additional 4.5 tons for material 3. Determine whether the optimal
solution and the total profit contribution would change.
Solution:
Constraint Original New RHS Change Allowable Percentage of allowable
RHS change change
1
2
3
Page 33 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Refer to the M&D Chemicals problem in Example [Link]. Suppose the major
customer’s demand for Product A decreases by 50 gallons, the minimum required
total production of Products A and B increases by 10 gallons, and the available
processing time increases by 40 hours. Determine whether the optimal solution and
the minimum total cost would change.
Solution:
Constraint Original New RHS Change Allowable Percentage of allowable
RHS change change
1
2
3
Page 34 of 54
Chapter 5: Sensitivity Analysis
Let’s consider the RMC problem with 3 variables to illustrate this concept.
Example 5.5.1
Say we have another variable C (cleaning fluid) added to the original RMC problem.
The linear program for the modified problem is as follows:
The sensitivity analysis report for this problem is given in the following figure.
Page 35 of 54
Chapter 5: Sensitivity Analysis
(a) What is the optimal solution and the maximum total profit contribution?
Solution:
Optimal solution:
Total profit contribution:
(b) Find and interpret the reduced cost for each decision variable.
Solution:
The reduced costs for variables 𝐹 and 𝐶 are zero. This is because these
variables already have positive values in the optimal solution.
The reduced cost for 𝑆 is -12.5. This is the same as the shadow price of the
non-negativity constraint 𝑆 ≥ 0. So, for every ton of solvent base produced,
the total profit contribution will decrease by $12.5. Hence, the profit
contribution for the solvent base would have to increase by at least $12.5
before the variable 𝑆 could take a positive value in the optimal solution. In
other words, unless the profit contribution for solvent base increases to at least
$30-(-$12.5)=$42.5, the value of 𝑆 will remain at zero in the optimal solution.
Remark: If the profit contribution for solvent base increases by exactly $12.5,
then there are alternative optimal solutions.
• The current optimal solution (𝐹 = 27.5, 𝑆 = 0, 𝐶 = 15) is still optimal
(since the increase of 12.5 in the objective coefficient for 𝑆 is within the
allowable increase). The maximum profit attained by this solution is
27.5(40) + 0(30 + 12.5) + 15(50) = $1850.
Page 36 of 54
Chapter 5: Sensitivity Analysis
(c) The figure below shows the sensitivity analysis report obtained when the
profit contribution of solvent base is increased by $12.501. What is the new
optimal solution? What is the new total profit contribution? Compare to the
original optimal solution and total profit contribution.
Page 37 of 54
Chapter 5: Sensitivity Analysis
Solution:
The new optimal solution is 𝐹 = 25, 𝑆 = 20, 𝐶 = 0.
Before the change, no solvent base is produced at the optimal solution (𝑆 = 0).
After the change, 20 tons of solvent base are produced at the optimal solution
(𝑆 = 20).
(d) Refer to the problem described in the beginning of this example. Suppose that
the management decides to add the requirement that S must be at least 25% of
F. The sensitivity analysis report for this revised problem is given in the figure
below. Write down the new constraint, and interpret its shadow price.
Solution:
New constraint:
The shadow price for the new constraint is _________. This indicates that
_____________________________________________________________
_____________________________________________________________,
provided that __________________________________________________
__________________ and all other aspects of the problem remain unchanged.
Page 38 of 54
Chapter 5: Sensitivity Analysis
(e) Suppose that another new constraint is added: the management states that the
amount of cleaning fluid produced must not exceed 20% of total production.
This type of constraint is known as a percentage or ratio constraint which
frequently occurs in linear programming models. The sensitivity analysis
report for this revised problem is given in the figure below. Write down the
new constraint, and interpret its shadow price.
Solution:
New constraint:
The shadow price for the new constraint is _________. This indicates that
________________________________________________________________
__________________________________________________________,
provided that ___________________________________________________
________________________________________________________________
and all other aspects of the problem remain unchanged.
Page 39 of 54
Chapter 5: Sensitivity Analysis
Page 40 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Find the dual of the following LP.
Example [Link]
Find the dual of the following LP.
Example [Link]
Find the dual of the following LP.
Page 41 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Find the dual of the following LP.
Example [Link]
Find the dual of the following LP.
Page 42 of 54
Chapter 5: Sensitivity Analysis
Page 43 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Find the dual of the following LP.
Example [Link]
Find the dual of the following LP.
Page 44 of 54
Chapter 5: Sensitivity Analysis
Example [Link]
Find the dual of the following LP.
Example [Link]
Find the dual of the following LP.
Page 45 of 54
Chapter 5: Sensitivity Analysis
Scenario You are the owner of the Dakota You are an entrepreneur who
Furniture Company. You need to wants to purchase all of the
determine the number of each type resources of Dakota company.
of furniture to make in order to You need to determine the
maximize the total revenue. price to pay for buying each
unit of resources listed by
Dakota Company to minimize
the total purchase cost.
Decision
variables
Objective
function
Page 46 of 54
Chapter 5: Sensitivity Analysis
Constraints Limited availability of each The total price to pay for the
resource. resources required for each
type of furniture must be no
less than Dakota’s selling
price of the furniture in order
to induce Dakota to sell.
Page 47 of 54
Chapter 5: Sensitivity Analysis
Scenario You are a friend of Lisa who wants You are a salesperson who
to help her minimize the total cost wants to sell nutrients
of purchasing the food while still (calories, chocolate, sugar, fat)
meeting her nutritional to Gina. You want to determine
requirements. the price to charge for each
nutrient to maximize the
revenue.
Decision
variables
Objective
function
Page 48 of 54
Chapter 5: Sensitivity Analysis
Page 49 of 54
Chapter 5: Sensitivity Analysis
Page 50 of 54
Chapter 5: Sensitivity Analysis
Example 5.7.1
Recall the Dakota furniture problem in Example [Link]. From the perspective of the
entrepreneur interested in purchasing all of Dakota’s resources, the linear program
and its sensitivity analysis report is as follows.
where y1 = price to pay for 1 board feet of lumber, y2 = price to pay for 1 finishing
hour, y3 = price to pay for 1 carpentry hour.
The dual of this problem represents the perspective of the Dakota company’s
owner who seeks to determine the optimal production quantities of each type of
furniture in order to maximize the total revenue.
Page 51 of 54
Chapter 5: Sensitivity Analysis
Maximum total revenue: 60x1 + 30x2 + 20x3 = 60(2) + 30(0) + 20(8) = $280
Ans: Since the reduced cost of x_2 is -5, this means that every table produced will decrease
the original total revenue by $5. So, to cover the reduced cost, we should increase the selling price
of each table by at least $5 (or increase the selling price of each table to $35 or above).
(c) Find and interpret the shadow price and RHS range for each constraint.
The lumber constraint has a shadow price of ____, 0 with a RHS range of
____________.
[24, ∞) This indicates that _________________________________
the total revenue and optimal solution
would remain the same
_____________________________________________________________,
the total amount of lumber available is at least 24 board feet
provided that __________________________________________________
_____________________________________________________________
and all other aspects of the problem remain unchanged.
Page 52 of 54
Chapter 5: Sensitivity Analysis
The finishing hour constraint has a shadow price of ____,10 with a RHS range
[16,24]
of ____________. every additional finishing hour available
This indicates that _______________________________
will increase the total revenue by $10
_____________________________________________________________,
provided that __________________________________________________
the total finishing time available is within 16 to 24 hours
_____________________________________________________________
and all other aspects of the problem remain unchanged.
(d) If 18 finishing hours were available, what would happen to the optimal
solution and the total revenue?
(e) If 30 board feet of lumber were available, what would happen to the optimal
solution and the total revenue?
Page 53 of 54
Chapter 5: Sensitivity Analysis
(f) If 9 carpentry hours were available, what would happen to the optimal solution
and the total revenue?
(g) If 30 carpentry hours were available, what would happen to the optimal
solution and the total revenue?
Page 54 of 54
Extra questions
h) Which constraints are binding, and which are nonbinding?
Interpret them in the context of the dual problem.
i) If the selling price of each desk were increased to $70, what would happen to the
optimal solution and the total revenue?
l) Would you recommend that the company buy additional amount of lumber?
m) Suppose that overtime can be scheduled for finishing or carpentry at a cost of $20 per hour.
Would you recommend that the company schedule overtime?
n) Suppose that overtime can be scheduled for finishing or carpentry at a cost of $8 per hour.
Would you recommend that the company schedule overtime?
Answers to extra questions
The finishing constraint and the carpentry constraint are binding because they have zero slack.
The lumber constraint is nonbinding because it has a slack of 24.
This means that, at the optimal solution, all the available finishing hours and carpentry hours
are used up, but there are 24 board feet of lumber not used.
i) If the selling price of each desk were increased to $70, what would happen to the
optimal solution and the total revenue?
8
The increase of 68-60=8 in the objective coefficient of x_1 is 20 × 100% = 40%
of the allowable increase.
The decrease of 30-10=20 in the objective coefficient of x_2 is 20 × 100% = 0%
∞
of the allowable decrease.
The decrease of 20-18=2 in the objective coefficient of x_3 is 2 × 100% = 40%
5
of the allowable decrease.
Since the sum of the percentages (40%+0%+40%=80%) is less than 100%,
the optimal solution would remain the same.
After the change, the total revenue would be 68(2)+10(0)+18(8)=$280,
which is same as the original total revenue.
If 1 hour of finishing is used for carpentry instead, then the available finishing hour
would decrease by 1 and the available carpentry hour would increase by 1.
The decrease of 1 in the RHS of the finishing constraint is 1 × 100% = 25%
4
of the allowable decrease.
The increase of 1 in the RHS of the carpentry constraint is 1 × 100% = 50%
2
of the allowable increase.
Since the sum of the percentages (25%+50%=75%) is less than 100%,
the shadow price of each constraint would remain valid.
The change in total revenue would be 10(-1)+10(1)=0.
Since the total revenue would remain the same, the optimal solution would also
remain the same.
l) Would you recommend that the company buy additional amount of lumber?
Since the lumber constraint has zero shadow price and the allowable increase for the
constraint RHS is infinity, this means that no matter how much the amount of lumber
available is increased, the optimal solution and total revenue would remain the same.
Hence, not recommended (in the sense that additional amount of lumber will not
increase the total revenue).
m) Suppose that overtime can be scheduled for finishing or carpentry at a cost of $20 per hour.
Would you recommend that the company schedule overtime?
Every additional hour available for finishing or carpentry will increase the total revenue
by $10. Since the cost of an additional hour is higher than the increase of revenue the
additional hour can bring, it is not recommended.
n) Suppose that overtime can be scheduled for finishing or carpentry at a cost of $8 per hour.
Would you recommend that the company schedule overtime?
Every additional hour available for finishing or carpentry will increase the total revenue
by $10. Since the cost of an additional hour is lower than the increase of revenue the
additional hour can bring, it is recommended.