Scribd Logo
Upload

Welcome to Scribd!

  • 17 views

    Cell Name Original Value Final Value

    Uploaded by

    Reza Pria Utama
    The solver found a solution that satisfied all constraints and optimality conditions. It took 0.015 seconds to solve with 0 iterations and subproblems. The optimal solution had charging cell production of 24 hockey sticks and 4 chess sets for a total profit of $64. All resource constraints for the three machines were satisfied without slack.

    Copyright:

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

    Cell Name Original Value Final Value

    Uploaded by

    Reza Pria Utama
    17 views6 pages
    The solver found a solution that satisfied all constraints and optimality conditions. It took 0.015 seconds to solve with 0 iterations and subproblems. The optimal solution had charging cell production of 24 hockey sticks and 4 chess sets for a total profit of $64. All resource constraints for the three machines were satisfied without slack.

    Original Description:

    opm

    Original Title

    Linear Programming

    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 0.015 seconds to solve with 0 iterations and subproblems. The optimal solution had charging cell production of 24 hockey sticks and 4 chess sets for a total profit of $64. All resource constraints for the three machines were satisfied without slack.

    Copyright:

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

    Cell Name Original Value Final Value

    Uploaded by

    Reza Pria Utama
    The solver found a solution that satisfied all constraints and optimality conditions. It took 0.015 seconds to solve with 0 iterations and subproblems. The optimal solution had charging cell production of 24 hockey sticks and 4 chess sets for a total profit of $64. All resource constraints for the three machines were satisfied without slack.

    Copyright:

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

    Microsoft Excel 14.

    0 Answer Report
    Worksheet: [Book1]Sheet1
    Report Created: 10/11/2016 15.49.53
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: GRG Nonlinear
    Solution Time: 0,015 Seconds.
    Iterations: 0 Subproblems: 0
    Solver Options
    Max Time Unlimited, Iterations Unlimited, Precision 0,000001, Use Automatic Scaling
    Convergence 0,0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bound
    Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNeg
    Objective Cell (Max)
    Cell
    Name
    $D$5 Profit Total

    Original Value Final Value


    $
    64 $
    64

    Variable Cells
    Cell
    Name
    Original Value Final Value
    Integer
    $B$4 Charging Cells Hocket Stick
    24
    24 Contin
    $C$4 Charging Cells Chess Sets
    4
    4 Contin

    Constraints
    Cell
    $D$10 Machine
    $D$11 Machine
    $D$12 Machine

    Name
    A Resources Used
    B Resources Used
    C Resources Used

    Cell Value
    Formula
    Status Slack
    120 $D$10<=$E$10Binding
    0
    72 $D$11<=$E$11Binding
    0
    4 $D$12<=$E$12Not Binding
    6

    tions are satisfied.

    atic Scaling
    rward, Require Bounds
    1%, Assume NonNegative

    Slack

    Microsoft Excel 14.0 Sensitivity Report


    Worksheet: [Book1]Sheet1
    Report Created: 10/11/2016 15.49.54

    Variable Cells
    Final
    Cell
    Name
    Value
    $B$4 Charging Cells Hocket Stick
    24
    $C$4 Charging Cells Chess Sets
    4

    Reduced
    Gradient
    0
    0

    Constraints
    Final Lagrange
    Cell
    Name
    Value Multiplier
    $D$10 Machine A Resources Used
    120 0.3333333284
    $D$11 Machine B Resources Used
    72 0.3333333234
    $D$12 Machine C Resources Used
    4
    0

    Microsoft Excel 14.0 Limits Report


    Worksheet: [Book1]Sheet1
    Report Created: 10/11/2016 15.49.55

    Objective
    Cell
    Name
    $D$5 Profit Total

    Value
    $ 64

    Variable
    Cell
    Name
    Value
    $B$4 Charging Cells Hocket Stic
    24
    $C$4 Charging Cells Chess Sets
    4

    LowerObjective
    Limit Result
    0
    16
    0
    48

    Upper Objective
    Limit Result
    24
    64
    4
    64

    Objective

    Hocket Stick Chess Sets


    Charging Cells
    24
    4
    Profit
    $
    2 $
    4 $

    Machine A
    Machine B
    Machine C

    Total
    28
    64

    Hockey StocksChees SetsResources Used Capacity


    4
    6
    120
    120
    2
    6
    72
    72
    0
    1
    4
    10

    You might also like