Question: 10. Go to the Schedule worksheet, which provides a sample schedule for employees working five consecutive days with two days off. Enzo wants to find
10. 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 C15, 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 C4:C10) 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 B18. Solve the model, keeping the Solver solution
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
