Question: EXCEL HELP!!!--- Solver for Option 1, in which you want the objective (Cell D16) to have the minimum (Min) number of employees scheduled by changing

EXCEL HELP!!!---

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. Keep this solution, and solver for Option 2 by adding an additional constraint that allows no more than two employees to be scheduled for the first shift, (Hint: D4 Now, I have the first part for option 1 figured out but I am stuck on option 2. Please see below what I have so far. Also i put in bold specifically what i need help with.

EXCEL HELP!!!--- Solver for Option 1, in which

F 10:00 10:30 0 Olo 0 OOOO 0 0 Oo Oolo E G H J M N o P 2 Servers Hours 10:30 - 11:00 - 12:00 - 1:00 - 2:00-3:00 - 4:00 - 5:00 - 6:00 - 7:00 - 8:00 - 9:00 - 3 Start Time End Time Worked Employees 11:00 12:00 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 4 10:30 AM 2:00 PM 3.5 9 1 1 1 1 0 0 0 0 0 0 5 11:00 AM 3:00 PM 4 1 0 1 1 1 1 0 0 0 0 0 6 12:00 PM 4:00 PM 4 2 0 0 1 1 1 1 0 0 0 0 0 7 4:00 PM 8:00 PM 4 3 0 0 0 0 1 1 1 0 0 8 5:00 PM 9:00 PM 4 7 0 0 0 0 1 1 1 1 0 9 6:00 PM 10:30 PM 4.5 3 0 0 0 0 0 0 1 1 1 1 10 11 Employees Scheduled 25 9 10 12 12 3 3 10 13 13 10 3 12 13 Employees Needed 2 6 12 10 3 2 3 8 12 12 10 3 14 Surplus or (Shortage) 7 4 0 0 0 0 2 1 1 0 0 15 16 Total Hours 97.00 17 ololo 0 0 1 9 3 3 1 3 3 N 2 7 NI 1 1

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!