Page 22 - Métodos Cuantitativos para Negocios 2
P. 22

Example 1






                   Range of Feasibility






         Adjustable Cells

                                     Final        Reduced             Objective              Allowable               Allowable

            Cell       Name Value                     Cost           Coefficient               Increase              Decrease
          $B$8            X1              5.0               0.0                       5                     2       0.33333333

          $C$8            X2              3.0               0.0                       7                  0.5                         2




         Constraints

                                     Final         Shadow             Constraint             Allowable                Allowable

            Cell       Name Value                     Price            R.H. Side               Increase                Decrease

          $B$13           #1                  5                0                      6             1E+30                             1

          $B$14           #2                19                 2                    19                       5                        1

          $B$15           #3                  8                1                      8     0.33333333               1.66666667












                                                                                                                          Lámina       22
   17   18   19   20   21   22   23   24   25   26   27