Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Session 08 - Order Fulfillment

    Uploaded by

    Lincoln

    Copyright:

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

    Session 08 - Order Fulfillment

    Uploaded by

    Lincoln
    5 views4 pages

    Original Title

    Session 08 - Order Fulfillment

    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
    5 views4 pages

    Session 08 - Order Fulfillment

    Uploaded by

    Lincoln

    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

    Order Fulfillment Problem

    Decision Region 1 Region 2 Total Profit


    Warehouse 1 0 20 860
    Warehouse 2 20 20
    Warehouse 3 30 0

    Revenue Part Total Revenue


    Region 1 Region 2 1300
    Margin ($) 10 20

    Cost Part Region 1 Region 2 Total Cost


    Warehouse 1 2 6 440
    Warehouse 2 2 8
    Warehouse 3 4 10

    Constraint Part Used


    Demand
    Region 1 1 1 1 50 <=
    Region 2 1 1 1 40 <=
    Supply
    Warehouse 1 1 1 20 <=
    Warehouse 2 1 1 40 <=
    Warehouse 3 1 1 30 <=
    Non-negative
    Available

    60
    40

    20
    40
    30
    Microsoft Excel 16.0 Answer Report
    Worksheet: [Session 08 - Order Fulfillment.xlsx]Model
    Report Created: 25/9/2024 6:11:32 pm
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: Simplex LP
    Solution Time: 0.015 Seconds.
    Iterations: 4 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
    $G$4 Warehouse 1 Total Profit 640 860

    Variable Cells
    Cell Name Original Value Final Value Integer
    $D$4 Warehouse 1 Region 1 20 0 Contin
    $E$4 Warehouse 1 Region 2 0 20 Contin
    $D$5 Warehouse 2 Region 1 0 20 Contin
    $E$5 Warehouse 2 Region 2 40 20 Contin
    $D$6 Warehouse 3 Region 1 0 30 Contin
    $E$6 Warehouse 3 Region 2 0 0 Contin

    Constraints
    Cell Name Cell Value Formula Status Slack
    $G$19 Region 1 Used 50 $G$19<=$I$19 Not Binding 10
    $G$20 Region 2 Used 40 $G$20<=$I$20 Binding 0
    $G$22 Warehouse 1 Used 20 $G$22<=$I$22 Binding 0
    $G$23 Warehouse 2 Used 40 $G$23<=$I$23 Binding 0
    $G$24 Warehouse 3 Used 30 $G$24<=$I$24 Binding 0
    Microsoft Excel 16.0 Sensitivity Report
    Worksheet: [Session 08 - Order Fulfillment.xlsx]Model
    Report Created: 25/9/2024 6:11:32 pm

    Variable Cells
    Final Reduced Objective Allowable Allowable
    Cell Name Value Cost Coefficient Increase Decrease
    $D$4 Warehouse 1 Region 1 0 -2 8 2 1E+030
    $E$4 Warehouse 1 Region 2 20 0 14 1E+030 2
    $D$5 Warehouse 2 Region 1 20 0 8 0 2
    $E$5 Warehouse 2 Region 2 20 0 12 2 0
    $D$6 Warehouse 3 Region 1 30 0 6 1E+030 0
    $E$6 Warehouse 3 Region 2 0 0 10 0 1E+030

    Constraints
    Final Shadow Constraint Allowable Allowable
    Cell Name Value Price R.H. Side Increase Decrease
    $G$19 Region 1 Used 50 0 60 1E+030 10
    $G$20 Region 2 Used 40 4 40 20 10
    $G$22 Warehouse 1 Used 20 10 20 10 20
    $G$23 Warehouse 2 Used 40 8 40 10 20
    $G$24 Warehouse 3 Used 30 6 30 10 30

    You might also like