In the Data Ribbon Tab in the Analyze Ribbon Group, you clicked the Solver button. Inside the Solver Parameters dialog, you typed B7 in the Set Objective input, typed Optimal in the By Changing Variable Cells input, and clicked the Add button. Inside the Add Constraint dialog, you typed Optimal in the Cell Reference input, typed Max in the Constraint input, clicked the Add button, and typed Optimal in the Cell Reference input. Inside the Add Constraint dialog in the Operator drop-down, you selected int. Inside the Add Constraint dialog, you clicked the Add button, typed Procedures in the Cell Reference input, typed MaxAllowed in the Constraint input, and clicked the OK button. Inside the Solver Parameters dialog, you clicked the Solve button. Inside the Solver Constraints dialog, you clicked the OK button. Explanation: The goal of this problem is to find the combination of procedures that will result in the maximum possible profit per week. To do this, we will use Solver to find the values in the named range Optimal that will maximize the value in cell B7. We will add the following constraints to Solver: values in the named range Optimal are less than or equal to the values in the named range Max; values in the named range Optimal are whole numbers; values in the named range Procedures are less than or equal to the values in the named range MaxAllowed. We will then run Solver and accept the solution.