Opening book details…
Can I read Excel Solver Nurse Scheduling Report on EtoBox?
Excel Solver Nurse Scheduling Report by Surya Teja is a document available to read on EtoBox.
What is Excel Solver Nurse Scheduling Report about?
The Solver found an optimal solution to minimize total nurse staffing costs in a hospital scheduling problem. It assigned nurses to 5 shifts to satisfy constraints on minimum nurse requirements across 10 time periods while minimizing total costs. The optimal solution assigned 48, 31, 39, 43, and 15 nurses to shifts 1 through 5 respectively with a total minimum cost of $35,010.
- Author
- Surya Teja
- Language
- EN