Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    SMP BA Exercise08.1Bl - Par Amanguiton ZandroOKICT

    Uploaded by

    jintalan.jade

    Copyright:

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

    SMP BA Exercise08.1Bl - Par Amanguiton ZandroOKICT

    Uploaded by

    jintalan.jade
    2 views4 pages

    Original Title

    SMP-BA-Exercise08.1Bl_Par-Amanguiton-ZandroOKICT

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    SMP BA Exercise08.1Bl - Par Amanguiton ZandroOKICT

    Uploaded by

    jintalan.jade

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 4

    Microsoft Excel 14.

    0 Answer Report
    Worksheet: [SMP+BA Exercise08.1Bl_Par Amanguiton Zandro.xlsx]Data
    Report Created: 11/29/2017 10:43:22 AM
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: Simplex LP
    Solution Time: 0.062 Seconds.
    Iterations: 2 Subproblems: 0
    Solver Options
    Max Time 100 sec, Iterations 100, Precision 0.000001
    Max Subproblems 5000, Max Integer Sols 5000, Integer Tolerance 0%, Assume NonNegative

    Objective Cell (Max)


    Cell Name Original Value Final Value
    $B$16 Total Profit Standard $ 19.00 $ 7,668.00

    Variable Cells
    Cell Name Original Value Final Value Integer
    $B$14 Bags Produced Standard 1 540 Contin
    $C$14 Bags Produced Deluxe 1 252 Contin

    Constraints
    Cell Name Cell Value Formula Status Slack
    $B$19 Cutting and Dyeing Hours Used 630 $B$19<=$C$19 Binding 0
    $B$20 Sewing Hours Used 480 $B$20<=$C$20 Not Binding 120
    $B$21 Finishing Hours Used 708 $B$21<=$C$21 Binding 0
    $B$22 Inspection and Packaging Hours Used 117 $B$22<=$C$22 Not Binding 18

    •The answer report in Figure 11.5 contains three sections.


    •Objective Cell - It indicates that optimal value of final of total profit is $7,668.
    •Variable Cells - Indicates the optimal values of the decision cells and whether or not the variables are re
    •Constraints - It gives the left-hand side value for each constraint (hours used), the formula showing the
    •Binding constraint – One that holds as an equality at the optimal solution. They intersect to form
    •Slack value – Indicates the difference between the left-hand and right-hand values for a constrain
    •Binding constraints (cutting and dyeing, and finishing) have zero slack.
    •Consider for example the sewing department constraint. By adding a nonnegative slack va
    (1/2)S + (5/6)D ≤ 600
    (1/2)S + (5/6)D + slack(sewing) = 600
    slack(sewing) = 600 – (1/2)(540) + (5/6)(252) = 600 – 270 – 210 =120
    r or not the variables are required to be integer.
    ), the formula showing the constraint relationship, the status ( Binding or Not binding), and the Slack value.
    tion. They intersect to form the optimal point.
    t-hand values for a constraint.

    dding a nonnegative slack variable, we can make the constraint equality.


    A B C D
    1 Par, Inc.
    2 Parameters
    3 Production Time (Hours) Time Available
    4 Operation Standard Deluxe Hours
    5 Cutting and Dyeing 7/10 1 630
    6 Sewing 1/2 5/6 600
    7 Finishing 1 2/3 708
    8 Inspection and Packaging 1/10 1/4 135
    9 Profit Per Bag $10.00 $9.00
    10
    11 Model
    12
    13 Standard Deluxe
    14 Bags Produced 540 252
    15
    16 Total Profit $ 7,668.00
    17
    18 Operation Hours Used Hours Available
    19 Cutting and Dyeing 630 630
    20 Sewing 480 600
    21 Finishing 708 708
    22 Inspection and Packaging 117 135
    E
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13 =
    14
    15
    16
    17
    18
    19
    20
    21
    22

    You might also like