Microsoft Excel 14.5 Answer Report
Worksheet: [Workbook1]Sheet1
Report Created: 9/30/2015 2:15:06 PM
Result:
Solver found a solution.
All constraints and optimality conditions are satisfied.
Solver Engine
Engine:
GRG Nonlinear
Solution Time:
1.356873
Seconds.
Iterations:
4
Subproblems:
0
Solver Options
Max Time
Unlimited ,
Iterations
Unlimited ,
Precision
1e-06,
Use Automatic Scaling
Convergence
0.0001,
Population Size
100,
Random Seed
0,
Derivatives Forward ,
Require Bounds
Max Subproblems
Unlimited ,
Max Integer Sols
Unlimited ,
Integer Tolerance
1%,
Assume NonNegative
Objective Cell
(Max)
Cell
Name
Original Value
Final Value
$B$4
Objective R
0
360000
Variable Cells
Cell
Name
Original Value
Final Value
Integer
$B$3
D.V. R
0
600 Contin
$C$3
D.V. M
0
300 Contin
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$D$10
Sales Req. Lhs
300 $D$10>=$E$10
Not Binding
100
$D$7
Underwriting Lhs
2400 $D$7<=$E$7
Binding
0
$D$8
Admin Lhs
300 $D$8<=$E$8
Not Binding
500
$D$9
Claims Lhs
1200 $D$9<=$E$9
Binding
0
Microsoft Excel 14.5 Sensitivity Report
Worksheet: [Workbook1]Sheet1
Report Created: 9/30/2015 2:15:07 PM
You've reached the end of your free preview.
Want to read all 8 pages?
- Fall '08
- staff
- LHS
