Question
Excel Solver with binary. How can I use binary to solve this questions on excel? What are the step and what should i put in
Excel Solver with binary. How can I use binary to solve this questions on excel? What are the step and what should i put in my solver?
Note: All answers must be found using the "Simplex LP" solver setting in Excel Solver.
The following problem is adapted from 3-17 in the Balakrishnan, Render, and Stair textbook.
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.
Shift | Time (24-hr time scale) | Nurses needed |
1 | 1-5 | 4 |
2 | 5-9 | 13 |
3 | 9-13 | 17 |
4 | 13-17 | 10 |
5 | 17-21 | 12 |
6 | 21-1 | 5 |
- How should the hospital schedule the nurses so that the total staff required for one day's operation is minimized? Your answer should come from an optimization model rather than guess-and-check. Even though it's impossible to schedule half of a nurse, you don't need to make any of the variables integer. This is a special case where integer solutions happen automatically.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started