Skip to content

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