Scribd Logo
Upload

Welcome to Scribd!

  • 12 views

    Bài 14, Quy Hoạch Tuyến Tính

    Uploaded by

    Phuc Hua

    Copyright:

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

    Bài 14, Quy Hoạch Tuyến Tính

    Uploaded by

    Phuc Hua
    12 views8 pages

    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
    12 views8 pages

    Bài 14, Quy Hoạch Tuyến Tính

    Uploaded by

    Phuc Hua

    Copyright:

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

    Microsoft Excel 16.

    0 Answer Report
    Worksheet: [Book1]Sheet1
    Report Created: 26/9/2023 9:34:14 PM
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: Simplex LP
    Solution Time: 0.062 Seconds.
    Iterations: 11 Subproblems: 0
    Solver Options
    Max Time Unlimited, Iterations Unlimited, Precision 0.000001
    Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

    Objective Cell (Max)


    Cell Name Original Value Final Value
    $N$26 hshmt hmt 0 57925

    Variable Cells
    Cell Name Original Value Final Value Integer
    $B$25 x11 0 0 Contin
    $C$25 x12 0 40 Contin
    $D$25 x13 0 100 Contin
    $E$25 x14 0 0 Contin
    $F$25 x21 0 40 Contin
    $G$25 x22 0 35 Contin
    $H$25 x23 0 0 Contin
    $I$25 x24 0 85 Contin
    $J$25 x31 0 140 Contin
    $K$25 x32 0 0 Contin
    $L$25 x33 0 0 Contin
    $M$25 x34 0 0 Contin

    Constraints
    Cell Name Cell Value Formula Status Slack
    $N$28 vt hmt 140 $N$28<=$O$28 Not Binding 20
    $N$29 hmt 160 $N$29<=$O$29 Binding 0
    $N$30 hmt 140 $N$30<=$O$30 Binding 0
    $N$31 hmt 180 $N$31=$O$31 Binding 0
    $N$32 hmt 75 $N$32=$O$32 Binding 0
    $N$33 hmt 100 $N$33=$O$33 Binding 0
    $N$34 hmt 85 $N$34=$O$34 Binding 0
    $B$25 x11 0 $B$25>=0 Binding 0
    $C$25 x12 40 $C$25>=0 Not Binding 40
    $D$25 x13 100 $D$25>=0 Not Binding 100
    $E$25 x14 0 $E$25>=0 Binding 0
    $F$25 x21 40 $F$25>=0 Not Binding 40
    $G$25 x22 35 $G$25>=0 Not Binding 35
    $H$25 x23 0 $H$25>=0 Binding 0
    $I$25 x24 85 $I$25>=0 Not Binding 85
    $J$25 x31 140 $J$25>=0 Not Binding 140
    $K$25 x32 0 $K$25>=0 Binding 0
    $L$25 x33 0 $L$25>=0 Binding 0
    $M$25 x34 0 $M$25>=0 Binding 0
    Assume NonNegative
    Microsoft Excel 16.0 Sensitivity Report
    Worksheet: [Book1]Sheet1
    Report Created: 26/9/2023 9:34:15 PM

    Variable Cells
    Final Reduced Objective Allowable Allowable
    Cell Name Value Cost Coefficient Increase Decrease
    $B$25 x11 0 -10 100 10 1E+030
    $C$25 x12 40 0 125 10 10
    $D$25 x13 100 0 115 1E+030 10
    $E$25 x14 0 -10 100 10 1E+030
    $F$25 x21 40 0 120 20 10
    $G$25 x22 35 0 135 10 10
    $H$25 x23 0 -10 115 10 1E+030
    $I$25 x24 85 0 120 1E+030 10
    $J$25 x31 140 0 155 1E+030 20
    $K$25 x32 0 -20 150 20 1E+030
    $L$25 x33 0 -20 140 20 1E+030
    $M$25 x34 0 -25 130 25 1E+030

    Constraints
    Final Shadow Constraint Allowable Allowable
    Cell Name Value Price R.H. Side Increase Decrease
    $N$28 vt hmt 140 0 160 1E+030 20
    $N$29 hmt 160 10 160 40 20
    $N$30 hmt 140 45 140 40 20
    $N$31 hmt 180 110 180 20 40
    $N$32 hmt 75 125 75 20 40
    $N$33 hmt 100 115 100 20 100
    $N$34 hmt 85 110 85 20 40
    Microsoft Excel 16.0 Limits Report
    Worksheet: [Book1]Sheet1
    Report Created: 26/9/2023 9:34:15 PM

    Objective
    Cell Name Value
    $N$26 hshmt hmt 57925

    Variable Lower Objective Upper Objective


    Cell Name Value Limit Result Limit Result
    $B$25 x11 0 0 57925 0 57925
    $C$25 x12 40 40 57925 40 57925
    $D$25 x13 100 100 57925 100 57925
    $E$25 x14 0 0 57925 0 57925
    $F$25 x21 40 40 57925 40 57925
    $G$25 x22 35 35 57925 35 57925
    $H$25 x23 0 0 57925 0 57925
    $I$25 x24 85 85 57925 85 57925
    $J$25 x31 140 140 57925 140 57925
    $K$25 x32 0 0 57925 0 57925
    $L$25 x33 0 0 57925 0 57925
    $M$25 x34 0 0 57925 0 57925
    x11 x12 x13 x14 x21 x22 x23 x24
    0 40 100 0 40 35 0 85
    hshmt 100 125 115 100 120 135 115 120

    vt 1 1 1 1 0 0 0 0
    0 0 0 0 1 1 1 1
    0 0 0 0 0 0 0 0
    1 0 0 0 1 0 0 0
    0 1 0 0 0 1 0 0
    0 0 1 0 0 0 1 0
    0 0 0 1 0 0 0 1

    Constraints
    Final Shadow ConstraintAllowableAllowable
    Cell Name Value Price R.H. Side Increase Decrease
    $N$28 vt hmt 140 0 160 1E+030 20
    $N$29 hmt 160 10 160 40 20
    $N$30 hmt 140 45 140 40 20
    $N$31 hmt 180 110 180 20 40
    $N$32 hmt 75 125 75 20 40
    $N$33 hmt 100 115 100 20 100
    $N$34 hmt 85 110 85 20 40
    x31 x32 x33 x34
    140 0 0 0 hmt
    155 150 140 130 57925
    vp
    0 0 0 0 140 160
    0 0 0 0 160 160
    1 1 1 1 140 140
    1 0 0 0 180 180
    0 1 0 0 75 75
    0 0 1 0 100 100
    0 0 0 1 85 85

    Objective Cell (Max)


    Allowable Cell Name Original Value Final Value
    $N$26 hshmt hmt 0 57925

    You might also like