Microsoft Office Tutorials and References
In Depth Information
Exhibit 9.7 Solver answer report
3) Constraints section: information relating to the constraints and the amount of
resource consumed by the optimal solution.
The information relating to constraints comes in the form of a constraint desig-
nation found in the Status section, as either Not Binding or Binding . You can see
that there are 11 items in the Constraint section corresponding to the formulation’s
11 constraints. The first constraint is the resource A usage. This constraint is Not
Binding and has a slack of 61.81. What does this mean? If we sum the Slack and
the Cell Value , the result is 800 hours, which are the maximum available hours for
resource A. Thus, we can interpret this result as follows: the optimal solution con-
sumed 738.19 hours of resource A and therefore had 61.81 hours of unused capacity,
or Slack . The next constraint is for resource B hours, and the Status of the constraint
is Binding . For this constraint all the available capacity, 900 hours, is consumed
and there is no unused capacity, so Slack is 0. The same analysis can be applied to
the decision variable maximum limits, e.g. X 1
30, etc. Project type 1,
which can be found in cell D28, has a value of 5.3. This is less than the maximum
25, X 2
Search JabSto ::

Custom Search