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). The first constraint is to be sure that you have enough (>=) employees (E11:Q11) to meet expected demand (E13:Q13) 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 97.00 hours and has 9 employees scheduled at 10:30 in the morning, which are 7 more than needed.

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!