ATTENTION: The software behind KU ScholarWorks is being upgraded to a new version. Starting July 15th, users will not be able to log in to the system, add items, nor make any changes until the new version is in place at the end of July. Searching for articles and opening files will continue to work while the system is being updated.
If you have any questions, please contact Marianne Reed at mreed@ku.edu .
Staffing Optimization Tools for a 24 x 7 Telecommunications Control Center Environment
dc.contributor.author | Woster, Jonathan | |
dc.date.accessioned | 2011-08-15T16:04:00Z | |
dc.date.available | 2011-08-15T16:04:00Z | |
dc.date.issued | 2011-07-29 | |
dc.identifier.uri | http://hdl.handle.net/1808/7948 | |
dc.description.abstract | This research explored optimization techniques to assist in personnel scheduling in a telecommunications environment. A survey of personnel was conducted to help determine basic employee priorities and two models were implemented in Microsoft Excel Solver to assist in providing data to support employee scheduling. The first model is linear and, given the number of people required during each hour of the week, determines the optimal number of personnel that should be working each of the available shift types, with an objective of minimizing cost. This tool includes the option to include or exclude particular shifts depending on employee and management preference. This model is found to be a useful tool in learning about the cost implications of various shifts and is suitable for assisting in shift scheduling. The second model designed is nonlinear and minimizes variance in the hourly utilization rate of personnel. Given a fixed number of people, the model seeks to determine the optimal number of personnel that should be working each of the available shift types, with an objective of balancing capacity to demand across each hour of the week. Microsoft Excel Solver is found to be insufficient in handling the number of constraints in this nonlinear model. Implementation of this methodology within a more powerful software package is suggested for future research. | |
dc.language.iso | en_US | |
dc.title | Staffing Optimization Tools for a 24 x 7 Telecommunications Control Center Environment | |
dc.type | Project | |
kusw.oastatus | na | |
kusw.oapolicy | This item does not meet KU Open Access policy criteria. | |
dc.rights.accessrights | openAccess |