Mathematical optimization -- Applications to shift scheduling, System analysis -- Mathematical models, Portland State University. Office of Information Technology -- Management, Operations research
A significant challenge for businesses of any size, is generating a work schedule that ensures adequate personnel coverage to ensure all aspects of the business are properly staffed, while preventing waste produced from having an excess number of employees working at a given time. The decision to manually create spreadsheets and work schedules that take into account availability, staffing requirements, and cost efficiency can become overwhelming and labor intensive. For Portland State University's Office of Information Technology (OIT), there is a significant challenge in scheduling student workers, while ensuring staffing requirements are met, student work hour restrictions are observed, and class schedules are accounted for. In order to better facilitate the scheduling and organization of work schedules for OIT, we have created a schedule optimization model, which will improve schedule generation efficiency, ensure staffing needs are met, allow for staff members to set their availability based on class schedules, and optimize the staffing costs of the OIT department. This model is intended to improve the flexibility, accuracy and efficiency in managing the OIT workforce and identify methods to reduce operating costs for the OIT department.
Ebramsyah, Agam; Joy, Aishwarya; Miller, Cody; Stevens, Jake; and Patil, Priyanka, "Optimizing Student Workforce Scheduling at PSU Office of Information Technology (OIT)" (2017). Engineering and Technology Management Student Projects. 1170.