Microsoft Excel 14.4 Answer Report
Worksheet: [Workbook12]Sheet1
Report Created: 10/31/2014 10:13:16 AM
Result:
Solver found a solution.
All constraints and optimality conditions are satisfied.
Solver Engine
Engine:
Simplex LP
Solution Time:
0.657025
Seconds.
Iterations:
7
Subproblems:
0
Solver Options
Max Time
Unlimited ,
Iterations
Unlimited ,
Precision
1e-06
Max Subproblems
Unlimited ,
Max Integer Sols
Unlimited ,
Integer Tolerance
1%,
Solve Without Integer Constraints ,
Assume NonNegative
Objective Cell
(Max)
Cell
Name
Original Value
Final Value
$G$14
Max Profit: Player
0
69400
Variable Cells
Cell
Name
Original Value
Final Value
Integer
$G$12
3M+4S+4T+3B <= 4700 Player
0
0 Contin
$H$12
3M+4S+4T+3B <= 4700 Radio Tuner
0
380 Contin
$I$12
3M+4S+4T+3B <= 4700 TV
0
0 Contin
$J$12
3M+4S+4T+3B <= 4700 DVD Player
0
1060 Contin
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$F$17 LHS
4700 $F$17<=$H$17 Binding
0
$F$18
LHS
3940 $F$18<=$H$18
Not Binding
560
$F$19 LHS
2500 $F$19<=$H$19 Binding
0
$F$20 LHS
0 $F$20>=$H$20 Binding
0
$F$21
LHS
380 $F$21>=$H$21
Not Binding
380
$F$22 LHS
0 $F$22>=$H$22 Binding
0
$F$23
LHS
1060 $F$23>=$H$23
Not Binding
1060
Microsoft Excel 14.4 Sensitivity Report
You've reached the end of your free preview.
Want to read all 6 pages?
- Fall '13
- DVD, Blu-ray Disc, LHS
