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. Table 2: Solver Constraints Constraint Cell or Range The number of employees must be greater than or equal 2 C4:C10 The number of employees must be less than or equal 8 C4:C10 The number of employees must be an integer C4:C10 Employees working each day must be greater than or equal to the staff needed D11:J11 and D12:J12
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
