Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    3 Constrict Orrrrrrrrrr

    Uploaded by

    jishnu
    The solver found an optimal solution that maximized profit within the constraints. It took 2 iterations over 0.016 seconds to determine the optimal values of 4 for variable DV x and 2 for variable DV y, resulting in a maximum profit of 260. The solution satisfied all constraints, with the capital constraint binding and the labour constraint not binding.

    Copyright:

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

    3 Constrict Orrrrrrrrrr

    Uploaded by

    jishnu
    16 views5 pages
    The solver found an optimal solution that maximized profit within the constraints. It took 2 iterations over 0.016 seconds to determine the optimal values of 4 for variable DV x and 2 for variable DV y, resulting in a maximum profit of 260. The solution satisfied all constraints, with the capital constraint binding and the labour constraint not binding.

    Original Description:

    or

    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 an optimal solution that maximized profit within the constraints. It took 2 iterations over 0.016 seconds to determine the optimal values of 4 for variable DV x and 2 for variable DV y, resulting in a maximum profit of 260. The solution satisfied all constraints, with the capital constraint binding and the labour constraint not binding.

    Copyright:

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

    3 Constrict Orrrrrrrrrr

    Uploaded by

    jishnu
    The solver found an optimal solution that maximized profit within the constraints. It took 2 iterations over 0.016 seconds to determine the optimal values of 4 for variable DV x and 2 for variable DV y, resulting in a maximum profit of 260. The solution satisfied all constraints, with the capital constraint binding and the labour constraint not binding.

    Copyright:

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

    Microsoft Excel 16.

    0 Answer Report
    Worksheet: [Book2]Sheet1
    Report Created: 8/1/2017 2:20:30 PM
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: Simplex LP
    Solution Time: 0.016 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
    $H$8 Profit total

    Original Value
    0

    Final Value
    260

    Variable Cells
    Cell
    Name
    $F$7
    DV x
    $G$7 DV y

    Original Value
    0
    0

    Final Value

    Constraints
    Cell
    Name
    $H$9 capital total
    $H$10 storage total
    $H$11 labour total

    Cell Value

    Integer
    4 Contin
    2 Contin

    Formula
    Status
    32 $H$9<=$I$9
    Binding
    20 $H$10<=$I$10 Binding
    38 $H$11<=$I$11 Not Binding

    Slack
    0
    0
    4

    are satisfied.

    Assume NonNegative

    Microsoft Excel 16.0 Sensitivity Report


    Worksheet: [Book2]Sheet1
    Report Created: 8/1/2017 2:20:32 PM

    Variable Cells
    Cell
    $F$7
    $G$7

    Name
    DV x
    DV y

    Final Reduced Objective Allowable Allowable


    Value
    Cost
    Coefficient Increase Decrease
    4
    0
    40
    60
    15
    2
    0
    50
    30
    30

    Constraints
    Cell
    Name
    $H$9 capital total
    $H$10 storage total
    $H$11 labour total

    Final Shadow Constraint Allowable Allowable


    Value
    Price
    R.H. Side
    Increase Decrease
    32
    5
    32
    6
    12
    20
    5
    20
    4.8
    12
    38
    0
    42 1.000E+030
    4

    x
    DV
    Profit
    capital
    storage
    labour

    4
    40
    4
    4
    6

    total
    2
    50
    8
    2
    7

    max capacity
    260
    32
    20
    38

    32
    20
    42

    You might also like