Scribd Logo
Upload

Welcome to Scribd!

  • 91 views

    15 Feb Putter Partners

    Uploaded by

    Atri Roy
    The solver found an optimal solution that maximized profit at $6,602.86 while satisfying all constraints. The optimal values of the variable cells were can't miss at 34.2857, one putt at 50, and eagle at 128.5714. The constraints for finishing, titanium, and casting were binding at their limits, while constraints for beryllium and steel were not binding and had slack.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    15 Feb Putter Partners

    Uploaded by

    Atri Roy
    91 views7 pages
    The solver found an optimal solution that maximized profit at $6,602.86 while satisfying all constraints. The optimal values of the variable cells were can't miss at 34.2857, one putt at 50, and eagle at 128.5714. The constraints for finishing, titanium, and casting were binding at their limits, while constraints for beryllium and steel were not binding and had slack.

    Original Description:

    ghghghghg

    Copyright

    © Attribution Non-Commercial (BY-NC)

    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 at $6,602.86 while satisfying all constraints. The optimal values of the variable cells were can't miss at 34.2857, one putt at 50, and eagle at 128.5714. The constraints for finishing, titanium, and casting were binding at their limits, while constraints for beryllium and steel were not binding and had slack.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    91 views7 pages

    15 Feb Putter Partners

    Uploaded by

    Atri Roy
    The solver found an optimal solution that maximized profit at $6,602.86 while satisfying all constraints. The optimal values of the variable cells were can't miss at 34.2857, one putt at 50, and eagle at 128.5714. The constraints for finishing, titanium, and casting were binding at their limits, while constraints for beryllium and steel were not binding and had slack.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 7

    Microsoft Excel 15.

    0 Answer Report
    Worksheet: [15-Feb-Putter-Partners.xlsx]Sheet1
    Report Created: 2/15/2014 3:31:21 PM
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: GRG Nonlinear
    Solution Time: 0.016 Seconds.
    Iterations: 4 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 Bounds
    Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative
    Objective Cell (Max)
    Cell
    Name
    $E$4 profit

    Original Value
    0

    Final Value
    6585.714286

    Variable Cells
    Cell
    Name
    $B$5 can't miss
    $C$5 one putt
    $D$5 eagle

    Original Value
    0
    0
    0

    Final Value
    Integer
    34.28571429 Contin
    50 Contin
    128.5714286 Contin

    Constraints
    Cell
    Name
    $E$10 finishing
    $E$11 Be
    $E$12 Ti
    $E$13 Steel
    $E$14
    $E$15
    $E$9 casting

    Cell Value
    82.57142857
    13714.28571
    10000
    50000
    13
    -22.14285714
    40

    Formula
    $E$10<=$H$10
    $E$11<=$H$11
    $E$12<=$H$12
    $E$13<=$H$13
    $E$14>=$H$14
    $E$15<=$H$15
    $E$9<=$H$9

    Status
    Not Binding
    Not Binding
    Binding
    Binding
    Not Binding
    Not Binding
    Binding

    Slack
    17.42857143
    6285.714286
    0
    0
    13
    22.14285714
    0

    Microsoft Excel 15.0 Sensitivity Report


    Worksheet: [15-Feb-Putter-Partners.xlsx]Sheet1
    Report Created: 2/15/2014 3:31:21 PM

    Variable Cells
    Cell
    Name
    $B$5 can't miss
    $C$5 one putt
    $D$5 eagle

    Final
    Value
    34.28571429
    50
    128.5714286

    Reduced
    Gradient
    0
    0
    0

    Constraints
    Cell
    $E$10
    $E$11
    $E$12
    $E$13
    $E$14
    $E$15
    $E$9

    Name
    finishing
    Be
    Ti
    Steel

    casting

    Final
    Lagrange
    Value
    Multiplier
    82.57142857
    0
    13714.28571
    0
    10000 0.025714285
    50000 0.078571428
    13
    0
    -22.14285714
    0
    40
    60

    Microsoft Excel 15.0 Limits Report


    Worksheet: [15-Feb-Putter-Partners.xlsx]Sheet1
    Report Created: 2/15/2014 3:31:21 PM

    Objective
    Cell
    Name
    $E$4 profit

    Value
    6585.714286

    Variable
    Cell
    Name
    $B$5 can't miss
    $C$5 one putt
    $D$5 eagle

    Value
    34.28571429
    50
    128.5714286

    Lower
    Objective
    Limit
    Result
    19.84126984 6152.380952
    0 5335.714286
    84.28571429 5102.142857

    Upper
    Objective
    Limit
    Result
    34.28571429 6585.714286
    50 6585.714286
    128.5714286 6585.714286

    Microsoft Excel 15.0 Answer Report


    Worksheet: [15-Feb-Putter-Partners.xlsx]Sheet1
    Report Created: 2/15/2014 3:35:41 PM
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: Simplex LP
    Solution Time: 0.016 Seconds.
    Iterations: 5 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
    $E$4 profit

    Original Value
    6602.857143

    Final Value
    6602.857143

    Variable Cells
    Cell
    Name
    $B$5 can't miss
    $C$5 one putt
    $D$5 eagle

    Original Value
    34.28571429
    50
    128.5714286

    Final Value
    Integer
    34.28571429 Contin
    50 Contin
    128.5714286 Contin

    Constraints
    Cell
    Name
    $E$10 finishing
    $E$11 Be
    $E$12 Ti
    $E$13 Steel
    $E$14
    $E$15
    $E$9 casting

    Cell Value
    82.57142857
    13714.28571
    10000
    50000
    13
    -22.14285714
    40

    Formula
    $E$10<=$H$10
    $E$11<=$H$11
    $E$12<=$H$12
    $E$13<=$H$13
    $E$14>=$H$14
    $E$15<=$H$15
    $E$9<=$H$9

    Status
    Not Binding
    Not Binding
    Binding
    Binding
    Not Binding
    Not Binding
    Binding

    Slack
    17.42857143
    6285.714286
    0
    0
    13
    22.14285714
    0

    Microsoft Excel 15.0 Sensitivity Report


    Worksheet: [15-Feb-Putter-Partners.xlsx]Sheet1
    Report Created: 2/15/2014 3:35:41 PM

    Variable Cells
    Cell
    Name
    $B$5 can't miss
    $C$5 one putt
    $D$5 eagle

    Final
    Value
    34.28571429
    50
    128.5714286

    Reduced
    Cost

    Objective
    Coefficient
    0
    30.5
    0
    25
    0
    33.5

    Allowable
    Allowable
    Increase
    Decrease
    14.5
    30.5
    1E+30 4.971428571
    17.4
    27.4

    Constraints
    Cell
    $E$10
    $E$11
    $E$12
    $E$13
    $E$14
    $E$15
    $E$9

    Name
    finishing
    Be
    Ti
    Steel

    casting

    Final
    Shadow
    Constraint
    Allowable
    Allowable
    Value
    Price
    R.H. Side
    Increase
    Decrease
    82.57142857
    0
    100
    1E+30 17.42857143
    13714.28571
    0
    20000
    1E+30 6285.714286
    10000 0.024857143
    10000 6842.105263 9166.666667
    50000 0.078285714
    50000
    16250 12916.66667
    13
    0
    0
    13
    1E+30
    -22.14285714
    0
    0
    1E+30 22.14285714
    40
    61
    40 7.857142857 7.222222222

    Microsoft Excel 15.0 Limits Report


    Worksheet: [15-Feb-Putter-Partners.xlsx]Sheet1
    Report Created: 2/15/2014 3:35:41 PM

    Objective
    Cell
    Name
    $E$4 profit

    Value
    6602.857143

    Variable
    Cell
    Name
    $B$5 can't miss
    $C$5 one putt
    $D$5 eagle

    Value
    34.28571429
    50
    128.5714286

    Lower
    Objective
    Limit
    Result
    19.84126984 6162.301587
    0 5352.857143
    84.28571429 5119.285714

    Upper
    Objective
    Limit
    Result
    34.28571429 6602.857143
    50 6602.857143
    128.5714286 6602.857143

    profit

    casting
    finishing
    Be
    Ti
    Steel
    10%
    50%

    can't miss one putt eagle


    30.5
    25
    33.5 6602.857
    34.28571
    50 128.5714

    0.5
    0.7
    400

    0.9
    0.5

    0.2
    0.4
    200
    100
    -0.1
    0.5

    0.1
    40
    0.3 82.57143
    13714.29
    10000
    350
    50000
    -0.1
    13
    -0.5 -22.1429

    >=

    40
    100
    20000
    10000
    50000
    0
    0

    You might also like