Using Solver, minimize the Payroll$/$Week for the resort by changing the values in cells D$5$:D$11.$ Remember these points as you complete the Solver Parameters dialog box: The number of employee work days in the range F$13$:L$13$ must be greater than or equal to the demand $($range F$15$:L$15),$ so there are enough people working for that day's needs. The number of employees scheduled in D$5$:D$11$ must be $1.$