Document Type

Closed Project

Publication Date

Winter 2013


Timothy Anderson

Course Title

Operations Research

Course Number

ETM 540/640


Scheduling employee’s staff is a crucial part of the operations of any organization. The organization must be efficiently schedule the staff to meet the continuous and potentially changing business demands. Staff scheduling becomes challenging when the need to balance various personnel shifts and try to accommodate their preferences. In our report, we have attempted to address the lifeguard scheduling problem at Shute Park Aquatic and Recreation Center (SHARC). The aquatic center offers a variety of classes all year around for all age groups. The lifeguards and swim instructors are part-time employees and mostly students, over 16 years of age. The primary metrics used to schedule lifeguard staff are availability of personnel, avoid double booking when already working in other areas of SHARC, gender diversity, performance, and assessment by supervisor based on previous history. There are situations of last minute cancellations and thus a substitute has to be scheduled for those emergency situations. Currently the SHARC manager uses Microsoft Word for scheduling lifeguards. This paper attempts to propose a scheduling tool based on excel to cope with the emergency substitute scheduling of the lifeguards and document the process rather than relying on a person’s memory. Through this paper we attempt the following: 1) To address the issue of last minute scheduling and find a reliable person to cover. 2) To develop a model that be used for automation of life guard scheduling process. 3) To provide an Excel based program replacing the current word based for automated scheduling at no extra cost. 4) To achieve scheduling of personnel at least cost.


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