Question: Solver for Option 1 , in which you want the objective ( Cell D 1 6 ) to have the minimum ( Min ) number
Solver for Option in which you want the objective Cell D to have the minimum Min number of employees scheduled by changing the number of employees D:D The first constraint is to be sure that you have enough employees E:Q to meet expected demand E:Q and the second constraint is to be sure that only whole numbers are used because you cannot schedule part of a person to work This solution used hours and has employees scheduled at : in the morning, which are more than needed.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
