Scribd Logo
Upload

Welcome to Scribd!

  • 489 views

    SunOil Example - Figures 5-3 Thru 5-7

    Uploaded by

    Akshay Kumar M
    The document provides input data for an optimization model that determines the optimal allocation of production across supply regions to meet demand regions at minimum cost. The data includes production and transportation costs, supply and demand amounts, plant capacities, and the decision variables of production allocation amounts. The optimization is subject to constraints of meeting demand, not exceeding supply capacity, and variables being non-negative. The optimal solution allocates production across supply regions to meet all demands at a minimum total cost of $23,751.

    Copyright:

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

    SunOil Example - Figures 5-3 Thru 5-7

    Uploaded by

    Akshay Kumar M
    489 views6 pages
    The document provides input data for an optimization model that determines the optimal allocation of production across supply regions to meet demand regions at minimum cost. The data includes production and transportation costs, supply and demand amounts, plant capacities, and the decision variables of production allocation amounts. The optimization is subject to constraints of meeting demand, not exceeding supply capacity, and variables being non-negative. The optimal solution allocates production across supply regions to meet all demands at a minimum total cost of $23,751.

    Original Description:

    sun oil

    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 document provides input data for an optimization model that determines the optimal allocation of production across supply regions to meet demand regions at minimum cost. The data includes production and transportation costs, supply and demand amounts, plant capacities, and the decision variables of production allocation amounts. The optimization is subject to constraints of meeting demand, not exceeding supply capacity, and variables being non-negative. The optimal solution allocates production across supply regions to meet all demands at a minimum total cost of $23,751.

    Copyright:

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

    SunOil Example - Figures 5-3 Thru 5-7

    Uploaded by

    Akshay Kumar M
    The document provides input data for an optimization model that determines the optimal allocation of production across supply regions to meet demand regions at minimum cost. The data includes production and transportation costs, supply and demand amounts, plant capacities, and the decision variables of production allocation amounts. The optimization is subject to constraints of meeting demand, not exceeding supply capacity, and variables being non-negative. The optimal solution allocates production across supply regions to meet all demands at a minimum total cost of $23,751.

    Copyright:

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

    Inputs - Costs, Capacities, Demands

    Demand Region
    Production and Transportation Cost per 1,000,000 Units
    Fixed
    Low Fixed
    Supply Region N. America S. America Europe
    Asia
    Africa
    Cost ($) Capacity Cost ($)
    N. America
    81
    92
    101
    130
    115
    6,000
    10 9,000
    S. America
    117
    77
    108
    98
    100
    4,500
    10 6,750
    Europe
    102
    105
    95
    119
    111
    6,500
    10 9,750
    Asia
    115
    125
    90
    59
    74
    4,100
    10 6,150
    Africa
    142
    100
    103
    105
    71
    4,000
    10 6,000
    Demand
    12
    8
    14
    16
    7
    Decision Variables
    Demand Region - Production Allocation (1000 Units)
    Supply Region N. America S. America Europe
    Asia
    Africa
    N. America
    0
    0
    0
    0
    S. America
    12
    8
    0
    0
    Europe
    0
    0
    0
    0
    Asia
    0
    0
    4
    16
    Africa
    0
    0
    10
    0

    Plants
    Plants
    (1=open) (1=open)
    0
    0
    0
    0
    0
    1
    0
    0
    0
    0
    0
    1
    7
    0
    1

    Constraints
    Supply Region
    N. America
    S. America
    Europe
    Asia
    Africa

    Excess Capacity
    0
    0
    0
    0
    3
    N. America S. America Europe
    Asia
    Unmet Demand
    0
    0
    0
    Objective Function
    Cost =
    $ 23,751

    Africa
    0

    High
    Capacity
    20
    20
    20
    20
    20

    Microsoft Excel 15.0 Answer Report


    Worksheet: [SunOil example - figures 5-3 thru 5-7.xlsx]Sheet2
    Report Created: 2/6/2015 1:14:21 PM
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: GRG Nonlinear
    Solution Time: 1.109 Seconds.
    Iterations: 1 Subproblems: 6
    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%
    Objective Cell (Min)
    Cell
    $B$31

    Name
    Cost = N. America

    Original Value
    $
    -

    Variable Cells
    Cell
    $B$14
    $C$14
    $D$14
    $E$14
    $F$14
    $G$14
    $H$14
    $B$15
    $C$15
    $D$15
    $E$15
    $F$15
    $G$15
    $H$15
    $B$16
    $C$16
    $D$16
    $E$16
    $F$16
    $G$16
    $H$16
    $B$17
    $C$17
    $D$17
    $E$17
    $F$17
    $G$17
    $H$17
    $B$18
    $C$18
    $D$18
    $E$18
    $F$18

    Name
    N. America N. America
    N. America S. America
    N. America Europe
    N. America Asia
    N. America Africa
    N. America (1=open)
    N. America (1=open)
    S. America N. America
    S. America S. America
    S. America Europe
    S. America Asia
    S. America Africa
    S. America (1=open)
    S. America (1=open)
    Europe N. America
    Europe S. America
    Europe Europe
    Europe Asia
    Europe Africa
    Europe (1=open)
    Europe (1=open)
    Asia N. America
    Asia S. America
    Asia Europe
    Asia Asia
    Asia Africa
    Asia (1=open)
    Asia (1=open)
    Africa N. America
    Africa S. America
    Africa Europe
    Africa Asia
    Africa Africa

    Original Value Final Value


    Integer
    0
    0 Contin
    0
    0 Contin
    0
    0 Contin
    0
    0 Contin
    0
    0 Contin
    0
    0 Binary
    0
    0 Binary
    0
    12 Contin
    0
    8 Contin
    0
    0 Contin
    0
    0 Contin
    0
    0 Contin
    0
    0 Binary
    0
    1 Binary
    0
    0 Contin
    0
    0 Contin
    0
    0 Contin
    0
    0 Contin
    0
    0 Contin
    0
    0 Binary
    0
    0 Binary
    0
    0 Contin
    0
    0 Contin
    0
    4 Contin
    0
    16 Contin
    0
    0 Contin
    0
    0 Binary
    0
    1 Binary
    0
    0 Contin
    0
    0 Contin
    0
    10 Contin
    0
    0 Contin
    0
    7 Contin

    Final Value
    $
    23,751

    $G$18
    $H$18

    Africa (1=open)
    Africa (1=open)

    0
    0

    0 Binary
    1 Binary

    Constraints
    Cell
    $B$22
    $B$23
    $B$24
    $B$25
    $B$26
    $B$28
    $C$28
    $D$28
    $E$28
    $F$28
    $B$14
    $C$14
    $D$14
    $E$14
    $F$14
    $G$14
    $H$14
    $B$15
    $C$15
    $D$15
    $E$15
    $F$15
    $G$15
    $H$15
    $B$16
    $C$16
    $D$16
    $E$16
    $F$16
    $G$16
    $H$16
    $B$17
    $C$17
    $D$17
    $E$17
    $F$17
    $G$17
    $H$17
    $B$18
    $C$18
    $D$18
    $E$18
    $F$18
    $G$18
    $H$18
    $G$14:$H$18=Binary

    Name
    N. America Excess Capacity
    S. America Excess Capacity
    Europe Excess Capacity
    Asia Excess Capacity
    Africa Excess Capacity
    Unmet Demand N. America
    Unmet Demand S. America
    Unmet Demand Europe
    Unmet Demand Asia
    Unmet Demand Africa
    N. America N. America
    N. America S. America
    N. America Europe
    N. America Asia
    N. America Africa
    N. America (1=open)
    N. America (1=open)
    S. America N. America
    S. America S. America
    S. America Europe
    S. America Asia
    S. America Africa
    S. America (1=open)
    S. America (1=open)
    Europe N. America
    Europe S. America
    Europe Europe
    Europe Asia
    Europe Africa
    Europe (1=open)
    Europe (1=open)
    Asia N. America
    Asia S. America
    Asia Europe
    Asia Asia
    Asia Africa
    Asia (1=open)
    Asia (1=open)
    Africa N. America
    Africa S. America
    Africa Europe
    Africa Asia
    Africa Africa
    Africa (1=open)
    Africa (1=open)

    Cell Value

    Formula
    0 $B$22>=0
    0 $B$23>=0
    0 $B$24>=0
    0 $B$25>=0
    3 $B$26>=0
    0 $B$28=0
    0 $C$28=0
    0 $D$28=0
    0 $E$28=0
    0 $F$28=0
    0 $B$14>=0
    0 $C$14>=0
    0 $D$14>=0
    0 $E$14>=0
    0 $F$14>=0
    0 $G$14>=0
    0 $H$14>=0
    12 $B$15>=0
    8 $C$15>=0
    0 $D$15>=0
    0 $E$15>=0
    0 $F$15>=0
    0 $G$15>=0
    1 $H$15>=0
    0 $B$16>=0
    0 $C$16>=0
    0 $D$16>=0
    0 $E$16>=0
    0 $F$16>=0
    0 $G$16>=0
    0 $H$16>=0
    0 $B$17>=0
    0 $C$17>=0
    4 $D$17>=0
    16 $E$17>=0
    0 $F$17>=0
    0 $G$17>=0
    1 $H$17>=0
    0 $B$18>=0
    0 $C$18>=0
    10 $D$18>=0
    0 $E$18>=0
    7 $F$18>=0
    0 $G$18>=0
    1 $H$18>=0

    Status
    Slack
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Not Binding
    3
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Not Binding
    12
    Not Binding
    8
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Not Binding
    4
    Not Binding
    16
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Binding
    0
    Not Binding
    10
    Binding
    0
    Not Binding
    7
    Binding
    0
    Binding
    0

    Inputs - Costs, Capacities, Demands


    Demand Region
    Production and Transportation Cost per 1,000,000 Units
    Fixed
    Low Fixed
    Supply Region N. America S. America Europe
    Asia
    Africa
    Cost ($) Capacity Cost ($)
    N. America
    81
    92
    101
    130
    115
    6,000
    10 9,000
    S. America
    117
    77
    108
    98
    100
    4,500
    10 6,750
    Europe
    102
    105
    95
    119
    111
    6,500
    10 9,750
    Asia
    115
    125
    90
    59
    74
    4,100
    10 6,150
    Africa
    142
    100
    103
    105
    71
    4,000
    10 6,000
    Demand
    12
    8
    14
    16
    7
    Decision Variables
    Demand Region - Production Allocation (1000 Units)
    Supply Region N. America S. America Europe
    Asia
    Africa
    N. America
    0
    0
    0
    0
    S. America
    12
    8
    0
    0
    Europe
    0
    0
    0
    0
    Asia
    0
    0
    4
    16
    Africa
    0
    0
    10
    0

    Plants
    Plants
    (1=open) (1=open)
    0
    0
    0
    0
    0
    1
    0
    0
    0
    0
    0
    1
    7
    0
    1

    Constraints
    Supply Region
    N. America
    S. America
    Europe
    Asia
    Africa

    Excess Capacity
    0
    0
    0
    0
    3
    N. America S. America Europe
    Asia
    Unmet Demand
    0
    0
    0
    Objective Function
    Cost =
    $ 23,751

    Africa
    0

    High
    Capacity
    20
    20
    20
    20
    20

    You might also like