Docstoc

Sun Oil

Document Sample
Sun Oil Powered By Docstoc
					Microsoft Excel 11.0 Answer Report
Worksheet: [Sun Oil.xls]Sheet1
Report Created: 6/18/2007 11:15:11 AM


Target Cell (Min)
    Cell           Name                 Original Value    Final Value
  $B$31 Cost= N. America                              0          23751


Adjustable Cells
    Cell              Name              Original Value    Final Value
  $B$14 N. America N. America                         0             0
  $C$14 N. America S. America                         0             0
  $D$14 N. America Europe                             0             0
  $E$14 N. America Asia                               0             0
  $F$14 N. America Africa                             0             0
  $G$14 N. America Plants (1= Open)                   0             0
  $H$14 N. America Plants (1= Open)                   0    2.6241E-11
  $B$15 S. America N. America                         0            12
  $C$15 S. America S. America                         0             8
  $D$15 S. America Europe                             0             0
  $E$15 S. America Asia                               0             0
  $F$15 S. America Africa                             0             0
  $G$15 S. America Plants (1= Open)                   0             0
  $H$15 S. America Plants (1= Open)                   0             1
  $B$16 Europe N. America                             0             0
  $C$16 Europe S. America                             0             0
  $D$16 Europe Europe                                 0             0
  $E$16 Europe Asia                                   0             0
  $F$16 Europe Africa                                 0             0
  $G$16 Europe Plants (1= Open)                       0             0
  $H$16 Europe Plants (1= Open)                       0             0
  $B$17 Asia N. America                               0             0
  $C$17 Asia S. America                               0             0
  $D$17 Asia Europe                                   0             4
  $E$17 Asia Asia                                     0            16
  $F$17 Asia Africa                                   0             0
  $G$17 Asia Plants (1= Open)                         0             0
  $H$17 Asia Plants (1= Open)                         0             1
  $B$18 Africa N. America                             0             0
  $C$18 Africa S. America                             0             0
  $D$18 Africa Europe                                 0   9.999999998
  $E$18 Africa Asia                                   0             0
  $F$18 Africa Africa                                 0             7
  $G$18 Africa Plants (1= Open)                       0             0
  $H$18 Africa Plants (1= Open)                       0             1


Constraints
   Cell              Name                 Cell Value       Formula       Status   Slack
$B$22   N. America Excess Capacity     5.2482E-10   $B$22>=0       Binding                 0
$B$23   S. America Excess Capacity              0   $B$23>=0       Binding                 0
$B$24   Europe Excess Capacity                  0   $B$24>=0       Binding                 0
$B$25   Asia Excess Capacity          2.48349E-10   $B$25>=0       Binding                 0
$B$26   Africa Excess Capacity        3.000000002   $B$26>=0       Not Binding   3.000000002
$B$28   Unused Demands N. America               0   $B$28=0        Not Binding             0
$C$28   Unused Demands S. America               0   $C$28=0        Not Binding             0
$D$28   Unused Demands Europe         2.04086E-09   $D$28=0        Not Binding             0
$E$28   Unused Demands Asia                     0   $E$28=0        Not Binding             0
$F$28   Unused Demands Africa                   0   $F$28=0        Not Binding             0
$B$14   N. America N. America                   0   $B$14>=0       Binding                 0
$C$14   N. America S. America                   0   $C$14>=0       Binding                 0
$D$14   N. America Europe                       0   $D$14>=0       Binding                 0
$E$14   N. America Asia                         0   $E$14>=0       Binding                 0
$F$14   N. America Africa                       0   $F$14>=0       Binding                 0
$G$14   N. America Plants (1= Open)             0   $G$14>=0       Binding                 0
$H$14   N. America Plants (1= Open)    2.6241E-11   $H$14>=0       Binding                 0
$B$15   S. America N. America                  12   $B$15>=0       Not Binding            12
$C$15   S. America S. America                   8   $C$15>=0       Not Binding             8
$D$15   S. America Europe                       0   $D$15>=0       Binding                 0
$E$15   S. America Asia                         0   $E$15>=0       Binding                 0
$F$15   S. America Africa                       0   $F$15>=0       Binding                 0
$G$15   S. America Plants (1= Open)             0   $G$15>=0       Binding                 0
$H$15   S. America Plants (1= Open)             1   $H$15>=0       Not Binding             1
$B$16   Europe N. America                       0   $B$16>=0       Binding                 0
$C$16   Europe S. America                       0   $C$16>=0       Binding                 0
$D$16   Europe Europe                           0   $D$16>=0       Binding                 0
$E$16   Europe Asia                             0   $E$16>=0       Binding                 0
$F$16   Europe Africa                           0   $F$16>=0       Binding                 0
$G$16   Europe Plants (1= Open)                 0   $G$16>=0       Binding                 0
$H$16   Europe Plants (1= Open)                 0   $H$16>=0       Binding                 0
$B$17   Asia N. America                         0   $B$17>=0       Binding                 0
$C$17   Asia S. America                         0   $C$17>=0       Binding                 0
$D$17   Asia Europe                             4   $D$17>=0       Not Binding             4
$E$17   Asia Asia                              16   $E$17>=0       Not Binding            16
$F$17   Asia Africa                             0   $F$17>=0       Binding                 0
$G$17   Asia Plants (1= Open)                   0   $G$17>=0       Binding                 0
$H$17   Asia Plants (1= Open)                   1   $H$17>=0       Not Binding             1
$B$18   Africa N. America                       0   $B$18>=0       Binding                 0
$C$18   Africa S. America                       0   $C$18>=0       Binding                 0
$D$18   Africa Europe                 9.999999998   $D$18>=0       Not Binding   9.999999998
$E$18   Africa Asia                             0   $E$18>=0       Binding                 0
$F$18   Africa Africa                           7   $F$18>=0       Not Binding             7
$G$18   Africa Plants (1= Open)                 0   $G$18>=0       Binding                 0
$H$18   Africa Plants (1= Open)                 1   $H$18>=0       Not Binding             1
$G$14   N. America Plants (1= Open)             0   $G$14=binary   Binding                 0
$H$14   N. America Plants (1= Open)    2.6241E-11   $H$14=binary   Binding                 0
$G$15   S. America Plants (1= Open)             0   $G$15=binary   Binding                 0
$H$15   S. America Plants (1= Open)             1   $H$15=binary   Binding                 0
$G$16   Europe Plants (1= Open)                 0   $G$16=binary   Binding                 0
$H$16   Europe Plants (1= Open)                 0   $H$16=binary   Binding                 0
$G$17   Asia Plants (1= Open)                   0   $G$17=binary   Binding                 0
$H$17 Asia Plants (1= Open)     1 $H$17=binary Binding   0
$G$18 Africa Plants (1= Open)   0 $G$18=binary Binding   0
$H$18 Africa Plants (1= Open)   1 $H$18=binary Binding   0
Inputs - Costs, Capacities, Demands
                   Demand Region - Production & transportation costs per 1,000,000 units     Fixed
Supply Region N. America       S. America      Europe           Asia            Africa       Cost
N. America           81.00        92.00        101.00          130.00          115.00       6000.00
S. America          117.00        77.00        108.00           98.00          100.00       4500.00
Europe              102.00       105.00         95.00          119.00          111.00       6500.00
Asia                115.00       125.00         90.00           59.00           74.00       4100.00
Africa              142.00       100.00        103.00          105.00           71.00       4000.00
Demand               12.00         8.00         14.00           16.00            7.00

Decision Variables
                   Demand Region - Production & transportation costs per 1,000,000 units   Plants (1=
Supply Region     N. America S. America        Europe           Asia            Africa       Open)
N. America            0.00       0.00            0.00            0.00            0.00         0.00
S. America           12.00       8.00            0.00            0.00            0.00         0.00
Europe                0.00       0.00            0.00            0.00            0.00         0.00
Asia                  0.00       0.00            4.00           16.00            0.00         0.00
Africa                0.00       0.00           10.00            0.00            7.00         0.00

Constraints
Supply Region Excess Capacity
N. America         0.00
S. America         0.00
Europe             0.00
Asia               0.00
Africa             3.00
               N. America  S. America            Europe          Asia          Africa
Unused Demands     0.00        0.00               0.00           0.00           0.00

Objective Function
Cost=              23751.00



Sun Oil - The Capacitated Plant Location Model

Sunil Chopra Chapter 5 page 110
  Low         Fixed     High
Capacity      Cost     Capacity
 10.00       9000.00    20.00
 10.00       6750.00    20.00
 10.00       9750.00    20.00
 10.00       6150.00    20.00
 10.00       6000.00    20.00



Plants (1=
  Open)
   0.00
   1.00
   0.00
   1.00
   1.00

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:9/1/2012
language:Latin
pages:5