Microsoft Excel 14.0 Answer Report
Worksheet: [Book3]Sheet1
Report Created: 11/15/2016 1:56:35 PM
Result: Solver found a solution.
All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.016 Seconds.
Iterations: 3 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 NonNegativ
Objective Cell (Min)
Cell
Name
Original Value
Final Value
$C$10
Minimize: X1
0
350
Variable Cells
Cell
Name
Original Value
Final Value
Integer
$C$7
X1
0
250 Contin
$D$7
X2
0
50 Contin
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$C$14 LHS
300 $C$14>=$E$14 Binding
0
$C$15
LHS
550 $C$15>=$E$15
Not Binding
150
$C$16 LHS
750 $C$16>=$E$16 Binding
0
ve
Microsoft Excel 14.0 Sensitivity Report
Worksheet: [Book3]Sheet1
Report Created: 11/15/2016 1:56:36 PM
Variable Cells
Final
Reduced
Objective
Allowable
Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
$C$7
X1
250
0
1
1
0.2
$D$7
X2
50
0
2
0.5
1
Constraints
Final
Shadow
You've reached the end of your free preview.
Want to read all 7 pages?
- Fall '16
- Reginald Murra
- LHS
