Excel 2019 Bible

Part IV: Managing and Analyzing Data

FIGURE 32.5

The Solver Parameters dialog box

FIGURE 32.6

The Add Constraint dialog box

5. To set the first constraint (that the total production capacity is 300 units),
   enter B6 as the Cell Reference value, choose less than or equal to (<=) from the
   drop-down list of operators, and enter 300 as the Constraint value.


6. Click Add, and enter the remaining constraints. Table 32.1 summarizes the con-
   straints for this problem.