BMGT 434 9:30 - Microsoft Excel 14.5 Answer Report Worksheet[Workbook1]Sheet1 Report Created 2:15:06 PM Result Solver found a solution All constraints

BMGT 434 9:30 - Microsoft Excel 14.5 Answer Report...

This preview shows page 1 - 3 out of 8 pages.

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
Image of page 1
Microsoft Excel 14.5 Sensitivity Report Worksheet: [Workbook1]Sheet1 Report Created: 9/30/2015 2:15:07 PM
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '08
  • staff
  • LHS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture