Discuss the below:
Q1. What are the shadow prices for each resource? Interpret.
Q2. What are the reduced costs? Interpret them in this context.
Q3. Compute and interpret the ranges of optimality.
Q4. Compute and interpret the ranges of feasibility.
Max 4X1 + 5X2 + 6X3
s.t.
X1 + X2 + X3 = 85(Production capacity)
X1 + 4X2 + X3 =280(Material A requirements)
X1 + 4X2 + 4X3 =320(Material B requirements)
|
Cell
|
|
Name
|
Final
Value
|
Reduced
Cost
|
Objective
Coefficient
|
Allowable
Increase
|
Allowable
Decrease
|
|
|
|
|
|
|
|
|
|
$B$8
|
|
X1
|
0
|
1.5
|
4
|
1E + 30
|
1.5
|
|
$C$8
|
|
X2
|
80
|
0
|
5
|
1
|
5
|
|
$D$8
|
|
X3
|
0
|
1
|
6
|
1E + 30
|
1
|
|
|
|
|
|
|
|
|
Constraints
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cell
|
|
Name
|
Final
Value
|
Shadow
Price
|
Constraint
R.H. Side
|
Allowable
Increase
|
Allowable
Decrease
|
|
|
|
|
|
|
|
|
|
$B$13
|
|
Production Capacity
|
80
|
0
|
85
|
1E+30
|
5
|
|
$B$14
|
|
Material A
|
320
|
0
|
280
|
40
|
1E+30
|
|
$B$15
|
|
Material B
|
320
|
1.25
|
320
|
20
|
40
|