DOI
https://doi.org/10.25772/E616-QM89
Defense Date
2012
Document Type
Thesis
Degree Name
Master of Science
Department
Mathematical Sciences
First Advisor
J. Paul Brooks
Abstract
Finding the optimal solution for the call-center scheduling problem can be done by using Microsoft Excel with an integer programming software add-in. Utilizing VBA, we are able to vary start, break, and lunch times as well as number of employees. By creating a list of all possible schedules that follow these requirements, we use the optimization engine to solve for the best possible combination of individual schedules. Custom programs for optimization such as this are becoming a vital part of the world today as decisions need to be made quickly. This flexible and easy to use scheduling tool saves time and effort while creating peace of mind knowing that the best possible solution has been found. Using this tool, we are able to decrease the amount of time to create schedules from approximately 15 hours of manual work to 25.2 seconds. Additionally, we are able to improve the accuracy of meeting the forecast – guaranteeing all manpower demand is met with an efficient and reliable tool. Accuracy, efficiency, and reliability are traits that anyone could wish for, and this tool makes that possible.
Rights
© The Author
Is Part Of
VCU University Archives
Is Part Of
VCU Theses and Dissertations
Date of Submission
May 2012