Question: Solver for Option 1 , in which you want the objective ( Cell D 1 6 ) to have the minimum ( Min ) number

Solver for Option 1, in which you want the objective (Cell D16) to have the
minimum (Min) number of employees scheduled by changing the number of
employees (D4:D9). Make sure to add the constraints below:
a. The first constraint is to be sure that you have enough (>=) employees
(E11:Q11) to meet expected demand (E13:Q13)
b. The second constraint is to be sure that only whole numbers are used for the Employees (D4:D9)(because you cannot schedule part of a person to work).

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!