Variable Cells Final Reduced Cell Name Value Gradient B3 DV R 600 C3 DV M 300

Variable cells final reduced cell name value gradient

This preview shows page 2 - 5 out of 8 pages.

Variable Cells Final Reduced Cell Name Value Gradient $B$3 D.V. R 600 0 $C$3 D.V. M 300 0 Constraints Final Lagrange Cell Name Value Multiplier $D$10 Sales Req. Lhs 300 0 $D$7 Underwriting Lhs 2400 100 $D$8 Admin Lhs 300 0 $D$9 Claims Lhs 1200 100
Image of page 2
Microsoft Excel 14.5 Limits Report Worksheet: [Workbook1]Sheet1 Report Created: 9/30/2015 2:15:16 PM Objective Cell Name Value $B$4 Objective R 360000 Variable Lower Objective Upper Objective Cell Name Value Limit Result Limit Result $B$3 D.V. R 600 0 60000 600 360000 $C$3 D.V. M 300 200 340000 300 360000
Image of page 3
Microsoft Excel 14.5 Answer Report Worksheet: [Workbook1]Sheet1 Report Created: 9/30/2015 2:19:23 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.838344 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 NonNegative Objective Cell (Max) Cell Name Original Value Final Value $B$4 Objective R 360000 360100 Variable Cells Cell Name Original Value Final Value Integer $B$3 D.V. R 600 600 Contin $C$3 D.V. M 300 300.5 Contin Constraints Cell Name Cell Value Formula Status Slack $D$10 Sales Req. Lhs 300.5 $D$10>=$E$10
Image of page 4
Image of page 5

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