Use solver to find the combination of procedures that will result in the maximum possible profit per week in cell b7. use the range name optimal as the variable cells. add these constraints in order: 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 values in the named range maxallowed. run solver and accept the solution.