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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!