# Constraints

Document Sample

```					            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
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

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

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