Go to the Schedule worksheet, which provides a sample schedule for employees working five consecutive days with two days off. Enzo wants to find the best schedule for these employees that provides enough staff while minimizing payroll costs.

In Solver, use the weekly payroll $($cell C$15,$ named Weekly$\_$payroll$)$ as the objective cell in the Solver model, with the goal of determining the minimum value for that cell. Use the number of staff on each schedule $($range C$4$:C$10)$ as the changing variable cells. Enter the constraints based on the information provided in Table $2.$

Use Simplex LP as the solving method to find a global optimal solution. Save the Solver model in cell B$18.$ Solve the model, keeping the Solver solution.