Ok, I am not asking for someone to outright solve this for me, but if anyone has any ideas to steer me in the right direction, it would be greatly appreciated. I am racking my brain to come up with a good formula that will allow me to plug the constraints into solver, but none are coming to mind that actually make any sense or get me any valid results. Again, all I am looking for is a formula that will help me calculate this. Here is my scenario:
"A hospital emergency room is open 24 hours a day. Nurses report for duty at 1 a.m., 5 a.m., 9 a.m., 1 p.m., 5 p.m. or 9 p.m. and each works an 8-hour shift. Nurses are paid the same, regardless of the shift they work. The following table shows the minimum number of nurses needed during the six periods into which the day is divided. How should the hospital schedule the nurses so that the total staff required for one day's operation is minimized?"
Shift...Time..............Nurses
1.......1-5 a.m..........4
2.......5-9 a.m..........13
3.......9 a.m.-1 p.m...17
4.......1-5 p.m..........10
5.......5-9 p.m..........12
6.......9 p.m.-1 a.m....5
Bookmarks