Microsoft Office Tutorials and References

In Depth Information

**TROUBLESHOOTING SOLVER**

FIGURE D-50

Solver could not find a feasible solution because not enough vehicles were available

Setting a Constraint to a Single Amount

Sometimes you may want to enter an exact amount into a constraint, as opposed to a number in a range. For

example, if you wanted to assign exactly 11 trucks in the CV Fitness problem instead of a maximum of 12,

you would select the equals (

) operator in the Change Constraint dialog box, as shown in Figure D-51.

ΒΌ

FIGURE D-51

Constraining a value to a specific amount

Setting Changing Cells to Integers

Throughout the tutorial, you were directed to set the Changing Cells to integers in the Solver constraints. In

many business situations, there is a logical reason for demanding integer solutions, but this approach does

have disadvantages. Forcing integers can sometimes increase the amount of time Solver needs to find a

feasible solution. In addition, Solver sometimes can find a solution using real numbers in the Changing Cells

instead of integers. If Solver cannot find a feasible solution or reports that it has reached its calculation