Microsoft Excel 15.16 Sensitivity Report
Worksheet: [Workbook5.xlsx]Sheet1
Report Created: 2/20/2019 10:38:22 PM
Variable Cells
Final
Reduced
Objective
Allowable Allowable
Cell
Name Value
Cost
Coefficient
Increase
Decrease
$C$2
X1
200
0
2
2
2
$D$2
X2
300
0
3
2 1.00E+030
$E$2
X3
0
2
5 1.00E+030
2
$F$2
Y1
100
0
9
2
2
$G$2
Y2
0
2
12 1.00E+030
2
$H$2
Y3
300
0
10
2 1.00E+030
Constraints
Final
Shadow
Constraint
Allowable Allowable
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
$D$12 LHS
500
-7
500
100
0
$D$13 LHS
400
0
400 1.00E+030
0
$D$14 LHS
300
9
300
0
100
$D$15 LHS
300
10
300
0
100
$D$16 LHS
300
10
300
0
300
Microsoft Excel 15.16 Answer Report
Worksheet: [Workbook5.xlsx]Sheet1
Report Created: 2/20/2019 10:38:38 PM
Result: Solver found a solution.
All constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.367974 Seconds.
Iterations: 6 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative
Objective Cell (Min)
Cell
Name
You've reached the end of your free preview.
Want to read all 5 pages?
- Spring '14
- Management, Variable Cells, Max Integer Sols Unlimited, Iterations Unlimited
