Document Type

Closed Project

Publication Date

Winter 2003


Timothy Anderson

Course Title

Operations Research

Course Number

EMGT 540/640



Kaiser Permanente is America's largest not-for-profit health maintenance organization, serving 8.1 million members in 9 states and the District of British Columbia. One of the main challenges of such organizations is the scheduling of nurses at their various locations in a way that matches the patient needs and the staffing of the nursing personnel. This has to be done in a way that it promotes quality and appropriateness of care within budgetary boundaries. Because the nursing salaries make up the largest single element in hospital costs, effective scheduling of nursing is very important in order to control the health care cost at same time satisfying the patient needs. Our report explains the Nurse Scheduling project that was for Kaiser Sunnyside Medical Center. We mainly focus on the Intensive Care Unit (ICU). We review their current model and then come up with a new model which if implemented could result in considerable saving for KSMC, while also satisfying their constraints and requirements. The model is also flexible and efficient in its implementation compared to the earlier manual process. We have used the Solver tool from Microsoft Excel spreadsheet program for the implementation of our project.


In Copyright. URI: This Item is protected by copyright and/or related rights. You are free to use this Item in any way that is permitted by the copyright and related rights legislation that applies to your use. For other uses you need to obtain permission from the rights-holder(s).


This project is only available to students, staff, and faculty of Portland State University

Persistent Identifier