aqua with sensitivity

6
Microsoft Excel 14.0 Answer Report Worksheet: [Book2]Sheet1 Report Created: 2/24/2015 9:47:29 AM Result: Solver found a solution. All Constraints and optimality conditions a Solver Engine Engine: Simplex LP Solution Time: 0 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automati Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1% Objective Cell (Max) Cell Name Original Value Final Value $D$5 Unit Profits Total profi 66100 66100 Variable Cells Cell Name Original Value Final Value Integer $B$4 Nuber to make Aqua Spas 122 122 Contin $C$4 Nuber to make Hydrolux 78 78 Contin Constraints Cell Name Cell Value Formula Status Slack $D$10 Tubing reqd Used 2712 $D$10<=$E$10 Not Binding 168 $D$8 Pumps reqd Used 200 $D$8<=$E$8 Binding 0 $D$9 Labour reqd Used 1566 $D$9<=$E$9 Binding 0

Upload: abdullahismail

Post on 20-Nov-2015

212 views

Category:

Documents


0 download

DESCRIPTION

v gud

TRANSCRIPT

Answer Report 1Microsoft Excel 14.0 Answer ReportWorksheet: [Book2]Sheet1Report Created: 2/24/2015 9:47:29 AMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0 Seconds.Iterations: 2 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic ScalingMax Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegativeObjective Cell (Max)CellNameOriginal ValueFinal Value$D$5Unit Profits Total profit6610066100Variable CellsCellNameOriginal ValueFinal ValueInteger$B$4Nuber to make Aqua Spas122122Contin$C$4Nuber to make Hydrolux7878ContinConstraintsCellNameCell ValueFormulaStatusSlack$D$10Tubing reqd Used2712$D$10