Using Solver, minimize the Payroll/Week for the resort by changing the values in cells D6:D12. Remember these points as you complete the Solver Parameters dialog box: The number of employee work days in the range F14:L14 must be greater than or equal to the demand (range F16:L16), so there are enough people working for that day's needs. The number of employees scheduled in D6:D12 must be >=1. Solve this model using the Simplex LP method and keep the Solver solution. In the Part-Time Expenses sheet, insert into cell ES a formula to calculate the total annual part-time expense. The Benefit % is an estimate in the form of a percentage of total wages and needs to be added to the cost of wages based on the average part-time hours multiplied by the average hourly rate