Back to search

Virginia Commonwealth University

The Call Center Scheduling Problem using Spreadsheet Optimization and VBA

Abstract

dc:description.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.

Degree

thesis:*
Name thesis:degree_name
Master of Science
Level thesis:degree_level
Thesis
Discipline thesis:degree_discipline
Mathematical Sciences

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Perry, Katherine
Contributors dc:contributor
  • J. Paul Brooks

Subjects

dc:subject × 5

Rights

dc:rights
Statement dc:rights
  • © The Author

Identifiers

dc:identifier.*

Chain of custody

source
Harvested from
Virginia Commonwealth University
Base URL
scholarscompass.vcu.edu/do/oai/
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
citation

Perry, Katherine. The Call Center Scheduling Problem using Spreadsheet Optimization and VBA. Thesis thesis, https://doi.org/10.25772/E616-QM89