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
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
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

You've reached the end of your free preview.

Want to read all 8 pages?

• Fall '08
• staff
• LHS