Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Aqua With Sensitivity

    Uploaded by

    AbdullahIsmail
    The solver found a solution that satisfied all constraints and optimality conditions. It took 2 iterations and 0 seconds to solve. The objective cell aimed to maximize total profits of $66,100 by making 122 Aqua Spas and 78 Hydrolux, within constraints on required tubing, pumps, and labor. Shadow prices and allowable increases/decreases were reported for variables and constraints.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Aqua With Sensitivity

    Uploaded by

    AbdullahIsmail
    21 views7 pages
    The solver found a solution that satisfied all constraints and optimality conditions. It took 2 iterations and 0 seconds to solve. The objective cell aimed to maximize total profits of $66,100 by making 122 Aqua Spas and 78 Hydrolux, within constraints on required tubing, pumps, and labor. Shadow prices and allowable increases/decreases were reported for variables and constraints.

    Original Description:

    v gud

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The solver found a solution that satisfied all constraints and optimality conditions. It took 2 iterations and 0 seconds to solve. The objective cell aimed to maximize total profits of $66,100 by making 122 Aqua Spas and 78 Hydrolux, within constraints on required tubing, pumps, and labor. Shadow prices and allowable increases/decreases were reported for variables and constraints.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    21 views7 pages

    Aqua With Sensitivity

    Uploaded by

    AbdullahIsmail
    The solver found a solution that satisfied all constraints and optimality conditions. It took 2 iterations and 0 seconds to solve. The objective cell aimed to maximize total profits of $66,100 by making 122 Aqua Spas and 78 Hydrolux, within constraints on required tubing, pumps, and labor. Shadow prices and allowable increases/decreases were reported for variables and constraints.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 7

    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 are satisfied.
    Solver Engine
    Engine: Simplex LP
    Solution Time: 0 Seconds.
    Iterations: 2 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 NonNegati

    Objective Cell (Max)


    Cell
    Name
    $D$5 Unit Profits Total profit

    Original Value
    66100

    Final Value
    66100

    Variable Cells
    Cell
    Name
    $B$4 Nuber to make Aqua Spas
    $C$4 Nuber to make Hydrolux

    Original Value
    122
    78

    Final Value
    Integer
    122 Contin
    78 Contin

    Constraints
    Cell
    Name
    $D$10 Tubing reqd Used
    $D$8 Pumps reqd Used
    $D$9 Labour reqd Used

    Cell Value
    Formula
    Status
    2712 $D$10<=$E$10 Not Binding
    200 $D$8<=$E$8
    Binding
    1566 $D$9<=$E$9
    Binding

    ns are satisfied.

    %, Assume NonNegative

    Slack
    168
    0
    0

    +
    Worksheet: [Book2]Sheet1
    Report Created: 2/24/2015 9:47:29 AM

    Variable Cells
    Cell
    $B$4
    $C$4

    Name
    Nuber to make Aqua Spas
    Nuber to make Hydrolux

    Final
    Value
    122
    78

    Reduced
    Cost

    Objective Allowable
    Coefficient Increase
    0
    350
    100
    0
    300
    50

    Constraints
    Cell
    Name
    $D$10 Tubing reqd Used
    $D$8 Pumps reqd Used
    $D$9 Labour reqd Used

    Final
    Shadow
    Constraint Allowable
    Value
    Price
    R.H. Side
    Increase
    2712
    0
    2880 1.000E+030
    200
    200
    200
    7
    1566 16.666666667
    1566
    234

    Allowable
    Decrease
    50
    66.666666667

    Allowable
    Decrease
    168
    26
    126

    Microsoft Excel 14.0 Limits Report


    Worksheet: [Book2]Sheet1
    Report Created: 2/24/2015 9:47:29 AM

    Objective
    Cell
    Name
    $D$5 Unit Profits Total profit

    Variable
    Cell
    Name
    $B$4 Nuber to make Aqua Spas
    $C$4 Nuber to make Hydrolux

    Value
    66100

    Value
    122
    78

    Lower Objective
    Limit
    Result
    0
    23400
    0
    42700

    Upper
    Limit
    122
    78

    Objective
    Result
    66100
    66100

    Nuber to make
    Unit Profits
    Constraints
    Pumps reqd
    Labour reqd
    Tubing reqd

    Aqua Spas
    122
    350

    Hydrolux
    78 Total profit
    300
    66100
    Used

    1
    9
    12

    1
    6
    16

    Available
    200
    200
    1566
    1566
    2712
    2880

    You might also like