Docstoc

Constraints

Document Sample
Constraints Powered By Docstoc
					            A            B       C      D         E       F         G
1    LP: Diet Problem (small version)                         R. Saltzman
2
3                                                        Total
4                    Milk    Fish Bread Spinach          Cost
5    Amount in Mix 0.151 0.000 0.000 0.971
6        Unit cost $ 3.15 $ 4.39 $ 2.50 $ 1.19 $ 1.63
7
8                                                                 (MDR)
9        Constraints                                      LHS       RHS
10        Vitamin A     6400      237        0   34000   33988      5000
11        Vitamin C       40        0        0      71      75        75
12              Iron      28        7       13       8      12        12
Microsoft Excel 11.0 Answer Report
Worksheet: [LP-Diet.xls]Diet-Formulation
Report Created: 10/4/2005 2:27:29 PM


Target Cell (Min)
       Cell       Name           Original Value   Final Value
     $F$6 Unit cost Cost          $        -    $           1.63


Adjustable Cells
      Cell       Name        Original Value       Final Value
    $B$5 Amount in Mix Milk      0.000               0.151
    $C$5 Amount in Mix Fish      0.000               0.000
    $D$5 Amount in Mix Bread     0.000               0.000
    $E$5 Amount in Mix Spinach   0.000               0.971


Constraints
      Cell       Name              Cell Value       Formula     Status    Slack
    $F$10 Vitamin A LHS              33988       $F$10>=$G$10 Not Binding 28988
    $F$11 Vitamin C LHS                75        $F$11>=$G$11  Binding      0
    $F$12 Iron LHS                     12        $F$12>=$G$12  Binding      0
Microsoft Excel 11.0 Sensitivity Report
Worksheet: [LP-Diet.xls]Diet-Formulation
Report Created: 10/4/2005 2:27:29 PM


Adjustable Cells
                                Final    Reduced   Objective Allowable    Allowable
   Cell         Name            Value     Cost     Coefficient Increase   Decrease
  $B$5    Amount in Mix Milk    0.151     0.000       3.15       1.015        2.4796
  $C$5    Amount in Mix Fish    0.000     3.651       4.39      1E+30         3.6512
  $D$5    Amount in Mix Bread 0.000       1.128        2.5      1E+30         1.1279
  $E$5    Amount in Mix Spinach 0.971     0.000       1.19     4.40125        0.2900

Constraints
                               Final      Shadow Constraint Allowable     Allowable
   Cell        Name            Value       Price   R.H. Side Increase     Decrease
  $F$10 Vitamin A LHS          33988         0       5000    28988.5          1E+30
  $F$11 Vitamin C LHS            75     0.00486811    75       31.5          53.6776
  $F$12 Iron LHS                 12     0.10554556    12       40.5           3.5493

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:1/28/2013
language:Unknown
pages:3