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.
Garcia, Jorge; Shah, Kshiti; Singla, Puniti; Yilmaz, Selen; and Sengupta, Sowmini, "Optimization of Staffing Schedule
At SHARC" (2013). Engineering and Technology Management Student Projects. 458.